samUntitled Query
Updated 2022-09-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
/*
select * from ethereum.core.fact_event_logs
where tx_hash in (
select tx_hash from ethereum.core.ez_dex_swaps
where platform = 'balancer' and block_timestamp::date = '2022-08-01' limit 30)
*/
--select * from ethereum.core.ez_dex_swaps
--where tx_hash = '0x1de7d7dba4573bf402d2af30fd362858d01b70784b12f97d0d3bfa4c1062dba4'
select * from ethereum.core.ez_eth_transfers
where tx_hash = '0xb522be57f2152dcec75e9b0b7771614c6241cb8cdd5c62950c3e41b0b8582dee'
-- where block_timestamp::date = '2022-09-01'
-- and origin_function_signature = '0xa9059cbb' -- transfer
and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
limit 100
-- where from_address = lower('0x4b0EB8616d596AC785A403b111bF971Bda0Ae851')
-- where from_address = lower ('0x66d5E2840Abb97FebA4b471ee877E750dFb8271e')
--tx_hash = '0x1de7d7dba4573bf402d2af30fd362858d01b70784b12f97d0d3bfa4c1062dba4'
Run a query to Download Data