fantausdc
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tbl_dai as (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)
, tbl_usdc as (select month(block_timestamp) as months, week(block_timestamp) as weeks, event_inputs:pool as pool, count(*) as counts,
sum(event_inputs:amount / 1e6) as amounts
from ethereum.events_emitted
where contract_address = lower('0x66f4856f1bbd1eb09e1c8d9d646f5a3a193da569')
and tx_succeeded = 'TRUE'
and event_name = 'PoolAllocation' and pool != 3
group by months,weeks,pool)
select * from tbl_usdc
Run a query to Download Data