Alexayeth remove compound
Updated 2022-09-17
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select block_timestamp::date as day, count (distinct tx_hash) as txns,
count (distinct redeemer) as users, sum (received_amount) as volume,
sum (received_amount_usd) as volume_usd, sum (volume) over (order by day) as cum_volume ,
sum (volume_usd) over (order by day) as cum_volume_usd
from ethereum.compound.ez_redemptions
where received_contract_symbol ilike '%ETH%'
and day >= '2022-06-01'
and block_number <= 15537393 --last block mined.
group by 1
Run a query to Download Data