Ali3NrETH Swap Activity Over Time
Updated 2022-09-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select block_timestamp::date as date,
case when token_in = '0xae78736cd615f374d3085123a210448e74fc6393' then 'Swap From rETH'
when token_out = '0xae78736cd615f374d3085123a210448e74fc6393' then 'Swap To rETH' else null end as type,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count,
sum (case when token_in = '0xae78736cd615f374d3085123a210448e74fc6393' then amount_in when token_out = '0xae78736cd615f374d3085123a210448e74fc6393' then amount_out end) as volume
from ethereum.core.ez_dex_swaps
where type is not null
group by 1,2 having volume > 0
order by 1
Run a query to Download Data