StangFAST06 - NEAR redux
Updated 2023-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
date_trunc( 'week' , a.block_timestamp ) AS date01
, count( DISTINCT a.tx_hash ) AS swap_count
, count( DISTINCT a.trader ) AS unique_swapper
FROM
near.core.ez_dex_swaps a
WHERE
a.block_timestamp::date < current_date
AND a.platform = 'v2.ref-finance.near'
AND ( a.token_in = 'wNEAR' OR a.token_out = 'wNEAR' )
GROUP BY
date01
ORDER BY
date01 DESC
Run a query to Download Data