hessSwaps Per Pair
Updated 2023-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select concat(symbol_in,'/',symbol_out) as pair,
count(DISTINCT(tx_hash)) as transaction, count(DISTINCT(origin_from_address)) as users,
sum(amount_out_usd) as volume
from ethereum.core.ez_dex_swaps
where block_timestamp::date >= '2022-01-01'
and TOKEN_OUT = lower('0xcAfE001067cDEF266AfB7Eb5A286dCFD277f3dE5')
group by 1
UNION
select concat(symbol_in,'/',symbol_out) as pair,
count(DISTINCT(tx_hash)) as transaction, count(DISTINCT(origin_from_address)) as users,
sum(amount_IN_usd) as volume
from ethereum.core.ez_dex_swaps
where block_timestamp::date >= '2022-01-01'
and TOKEN_IN = lower('0xcAfE001067cDEF266AfB7Eb5A286dCFD277f3dE5')
group by 1
Run a query to Download Data