jak-IWUlHqdays of month
Updated 2022-10-10
9
1
2
3
4
5
6
7
8
9
›
⌄
select 'uniswapv3' as sushi_uni , count(*) as swap , count(distinct RECIPIENT ) as users , dayofmonth(BLOCK_TIMESTAMP::date) from ethereum.uniswapv3.ez_swaps
where BLOCK_TIMESTAMP::date >= '2022-01-01'
group by 4
UNION
select 'sushiswap' as sushi_uni , count(*) as swap , count(distinct ORIGIN_FROM_ADDRESS) as users , dayofmonth(BLOCK_TIMESTAMP::date) from ethereum.sushi.ez_swaps
where BLOCK_TIMESTAMP::date >= '2022-01-01'
group by 4
Run a query to Download Data