ML64
Updated 2022-10-31Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select 'NEAR',count(*),date_trunc('month', mdate) as mmonth from( select min(block_timestamp::date) as mdate , trader from near.core.ez_dex_swaps
group by trader)
group by mmonth
UNION
select 'ETHEREUM',count(*),date_trunc('month', mdate) as mmonth from( select min(block_timestamp::date) as mdate , sender from ethereum.core.ez_dex_swaps
group by sender)
group by mmonth
Run a query to Download Data