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