MLDZMNWeekly Swap Transactions
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with swap as ( select date(block_timestamp) as date, tx_hash, trader, token_out, token_in , token_in_contract, TOKEN_OUT_CONTRACT, concat(token_in,'/',token_out) as pair
from near.core.ez_dex_swaps
where PLATFORM = 'v2.ref-finance.near'
and block_timestamp::date >= '2023-01-01')
,
final as ( select date, trader,
count(DISTINCT(tx_hash)) as total_tx,count(DISTINCT(trader)) as total_user
from swap
group by 1 ,2)
select trunc(date,'week') as weekly, count(DISTINCT(trader)) as total_user,
sum(total_tx) as total_txs, avg(total_tx) as avg_tx,
sum(total_txs) over (order by weekly asc) as cum_tx
from final
group by 1
Run a query to Download Data