Query editor
WITH bridge AS (SELECT b."from" AS address,b.accAddress AS hex_address,c.accAddress AS dydx_chain_address,b.amount / 1e18 AS amountFROM dydx_ethereum.WrappedEthereumDydxToken_evt_Bridge bLEFT JOIN dune.cbergz.dataset_dydx_bridge_events c ON b."from" = c."from" AND b.evt_tx_hash = c.evt_tx_hashWHERE DATE(evt_block_time) >= DATE('2023-09-26')AND b."from" IN (0x01a9b6c6bce7cb729b0383cad2cd8b8a5cd1b767,0xac9878183dda3d9e38b0a84c4bebfaee36692ac0,0x13e9ede7bf66fa0e3e369facea39673e93aac1b3,0xEbC7D306b2a085125b7868a18fF5e387721b1b9e,0xcF217477798A05e409d8193348334E998c82909E,0x76596f3fd7655a2cfa8605981baa46676718b5d5,0x6dd7829ce680aa3371184dcd85e21652cd823237,0x5aa6a4ffeca0ac490c4f2e0b12341c988610ac67,0x4385D35D6C2668a481EcCA73553d15AEfF30a979,0x383d8ebcd2ca72ebc6a5a627b1c9d17af84ec710,0x390f76272c69a42c4ceb5e7270b368c4e255ed81,0x3ecc07c75fcd5a93509e2a56f7123f85b9fc5aee,0x4621b8138830982d080b5eb337c3793065377635,0x764d16c451a71ce521a1b6df9bcb886a2b8dac48,0x81aa284df8a40c0011e608d3c3fa7c3bf7b65705,0xa511221bbdef5de5b5ff757d6acc1d4dc3b62269,0xb96eecf2b77bd21b16a7cd4d73771e67148b23f1,0xcd375b6dc34c66f14a00b0c75e7897b31106f6fe,0xce2d12d17bc1f818f4b6f9b81cd2c6b38ceacadf,0xcfb78a4d0a063ee02f7ab49a67daf32da17fe865,0xd7ec2398980102d2e1994263777333491536ccee,0xe630682b202e215eaed81b583a3e70fb56155e3f,0x2d88d1d3ba2fb5271c65778e3d9ab491dd65cf14,0xcb3a453602c6f0d5ef70e4abeb5b383b0203e412,0x7134abfc8ff09fa71dc1c23bfdf77586f27c289e,0x75dc9a12bf02565136ddf3e27fcbcc1c4231cded,0x39ad99e33ab7ee85818741dd6076112188bc2611,0x331750acd2bd053f473e42baf873b3353d6b3338,0x3e6e9efb0a677a24f47093a22044dc5451a028cf,0xA03D3cd7c02417893e144161a71654EEdC578000,0xcba0074a77a3ad623a80492bb1d8d932c62a8bab,0xa337321a3b9909aec6e7053ef8e8fdb24e4614f2,0xcef2d0c7d89c3dcc7a8e8af561b0294bcd6e9ebd,0x606ae39bbced0048fbd5a7426a8d3bb87b9fb0ff,0xd4ff4a18b5001bac4c45b87fc6c9d1dada071536,0xe940cab818cedeeeb963ed88e612fcdc00282854,0x12c06b0da8eee08debae80b1d20121eaba72aee5,0xcae3bc2b15551c0162012c9ef32e75bef75f1229,0x814745697df12db9838466daa9b4a5ca2fda2e44,0x21eeb87ae28150a7e637bb3227192d17170bfc6e,0x841da54376b89fff364421fb8db1b8a0db7add10,0xef3d512ff1fdd303ab0831bb0423538a5477fc42,0xbee28f360950ec729444b24e1ce854f70887eb8e,0x7d8eb2f8017e2b0b895df8eb9aa334ec124e8068,0x933ee7a1ce07ef206abd794dfc8a23dd3e77f00f,0xafa64cca337efee0ad827f6c2684e69275226e90,0xab5a3689bfae1779643d3c06f0465c071ce534ff,0x1c527b85f3632e0b597a825c20d303fe75ac76ff,0x0d1e12b6e999835b4f495314f4d22b2e388f9ad3,0xbe65399f54dd0174b099bc1cf979514cf70fc23d,0xd830e0f2cf957dd8b91bd513837e36d6020cc273,