kenobi9270fuse
Updated 2022-05-22
9
1
2
3
4
5
6
7
›
⌄
select month(block_timestamp) as months, week(block_timestamp) as weeks, event_inputs:pool as pool, count(*) as counts,
sum(event_inputs:amount / 1e18) as amounts
from ethereum.events_emitted
where contract_address = lower('0xaFD2AaDE64E6Ea690173F6DE59Fc09F5C9190d74')
and tx_succeeded = 'TRUE'
and event_name = 'PoolAllocation'
group by months,weeks,pool
Run a query to Download Data