freemartianUntitled Query
Updated 2022-12-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- select * from ethereum.core.fact_traces
-- where tx_hash = '0x6ff88a0e8bd352aa9a188ac965277e8ae980f215fb8859e5b80c33c54dd24e8c'
-- select distinct ORIGIN_FUNCTION_SIGNATURE from ethereum.core.fact_event_logs
-- where origin_to_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
-- and event_name = 'Transfer'
select
avg(CURRENT_BAL),
date_trunc('day', BLOCK_TIMESTAMP::date) as TIME
from ethereum.core.ez_balance_deltas
where contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381'
group by 2
Run a query to Download Data