ML62in
Updated 2023-02-04
9
1
2
3
4
5
6
7
8
9
›
⌄
select 'Swap NEAR token to other tokens' , count(*) , sum(AMOUNT_IN) , count(distinct trader) , block_timestamp::date from near.core.ez_dex_swaps
where token_in_contract='wrap.near' and block_timestamp::date>= current_date - 7
group by 5
UNION
select 'Swap other tokens to NEAR token' , count(*) , sum(AMOUNT_OUT) , count(distinct trader) , block_timestamp::date from near.core.ez_dex_swaps
where token_out_contract='wrap.near' and block_timestamp::date>= current_date - 7
group by 5
Run a query to Download Data