boomer77comp wd eth
Updated 2022-09-14
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with compound as (select block_timestamp, tx_hash, event_inputs:redeemAmount::int/1e18 as vol, event_inputs:redeemer::string as withdrawer
from ethereum.core.fact_event_logs
where contract_address = '0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5' and event_name = 'Redeem' and date(block_timestamp) >= '2022-07-01'
order by block_timestamp desc
)
select date_trunc('day', block_timestamp) as dt, sum(vol) as eth_withdrew, count(distinct withdrawer) as withdrawer_count,
count(distinct tx_hash) as tx_count
from compound
group by 1
Run a query to Download Data