bh2smith

Verifying my identity on Peepeth.com 0x7f01d9b227593e033bf8d6fc86e634d27aa85568

bh2smith

warning: long literal lacking separators
   --> src/contract.rs:227:43
    |
227 |             options.gas = Some(U256::from(5000000));
    |                                           ^^^^^^^ help: consider: `5_000_000`
    |
    = note: #[warn(clippy::unreadable_literal)] on by default
    = help: for further information visit https://rust-lang.github.io/rust-clippy/master/index.html#unreadable_literal

warning: unneeded return statement

bh2smith

bh2smith

alias	brackets	threshold
xdai_OWL_USDT	0x404475124bFD465c93e6E501a2E2EAbf19342217,0x9335e92c0FFC2462f595b8734C5F2A2d4DC8fF60,0x3EAeaEe2abE3Edc3aef95Dc962b13B92F4a38Bf5,0x0ed697D48fedBEe30776877aeA74d94FC46aC253,0x2890b0677D46826F7eA60840bA260ecE12eAB51D,0xE7158521c598d721F534718303937747351Fab08,0x568ab74a3226011922F0f10daFEdA561971923E1,0x8ec7FB2ff9b5E8DE165700d55f14329513Fb09c9,0xE478865547C7eA6a31730914696aF66F4FBDf417,0x2D8EAC7Fb9B39d48f30f602240484Be9448719B8	1
xdai_OWL_STAKE	0xF3960C7705D25907F81999bd3B31EB4e18105927,0xF5B40dd9cEB22d14c06bd1Ea59C1769c8D276521,0x2a35C901E5d03b71DC0ab8F38b331B8c38869E96,0x311be2B3905A0eD8E921FeE755A7981700418067,0x1f3bb2B6afF5aAE967AfdcC9479c33E0f5a1d19c,0xFC238F174fd1f6cc55691D18eB6510574ECd745F,0x7553244AFA2a33Fe1A6Ac22B985862881A52ee76,0x9AC1607e36df821D7A594cB9fb4f73454693bA03,0xF888243aacb5626b520D0028371baD672a477Fd8,0xC2D9C507c40F7fb9dCEf6e7223d2AAaBddCE9A12,0x4ab8b6D38E99F262bC8E7D0C212183B1AE397467,0x83FF7c9A5269840fe978258e009177b014AC5A4e,0x2Ec14A40294223555CEc

bh2smith

0x064523df9bf2d9b907f20bbec50150d2ddd5721e66bd751c1f42447e96421bab

bh2smith

-- Dune Query for relevant views (postgres): https://dune.com/queries/1582621

-- Below is a HiveSQL (pseudo code) schema with corresponding postgres types:

-- TABLE 1: Order Rewards
-- Update schedule: hourly
-- Size: Currently 20k records this table will have approximately the same dimensions as number of trades on cow_prococol.

-- The first three columns are on-chain verifyable, 
-- the json data field contains data from our orderbook DB.

bh2smith

with solutions as (
  select 
    (json -> 'solutions' ->> -1)::jsonb as winning_solution
  from solver_competitions
  where id >= 4929771  -- The first batch containing the field `uninternalizedCallData`
)

select 100.0 * sum(case when winning_solution -> 'uninternalizedCallData' is null then 1 else 0 end) / count(*) as proportion_uninternalized
from solutions

bh2smith

Curl Requests made as follows JSON files will be provided per section

 export ARCHIVE_NODE_URL=
 export JSON_FILE_PATH=
curl $ARCHIVE_NODE_URL -X POST -H "Content-Type: application/json" --data $JSON_FILE_PATH | jq

bh2smith

Arak Quickstart

Arak is a very simple ethereum log indexing program found on github at: https://github.com/cowprotocol/arak

Create Postgres Instance

docker pull postgres

docker run --name erc721 -p 5432:5432 -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=postgres -e POSTGRES_DB=postgres -d postgres

bh2smith

#!/bin/bash

# Space separated Array of Ethereum block numbers to fetch timestamps for
blockNumbers=(18562256 18562257)

ethRpc="https://rpc.ankr.com/eth"

for blockNumber in "${blockNumbers[@]}"
do
  data="{\"jsonrpc\":\"2.0\",\"method\":\"eth_getBlockByNumber\",\"params\":[\"0x$(printf '%x\n' $blockNumber)\", false],\"id\":1}"