Sbhn_NP2023-08-15 10:48 AM
Updated 2023-08-15
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('month',block_timestamp) as date,
case when
LOWER(SYMBOL_in)>LOWER(SYMBOL_OUT)
then concat(SYMBOL_OUT,'/',SYMBOL_in)
else
concat(SYMBOL_in,'/',SYMBOL_OUT)
end as pair,
sum(amount_in_usd) as usd_volume
from ethereum.core.ez_dex_swaps
where (token_in = '0xb4b9dc1c77bdbb135ea907fd5a08094d98883a35' or token_out = '0xb4b9dc1c77bdbb135ea907fd5a08094d98883a35')
group by 1,2
Run a query to Download Data