Sbhn_NP2023-08-25 04:50 PM
Updated 2023-08-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select date_trunc('day',block_timestamp) as date,
platform,
case when
LOWER(SYMBOL_in)>LOWER(SYMBOL_OUT)
then concat(SYMBOL_OUT,' => ',SYMBOL_in)
else
concat(SYMBOL_in,' => ',SYMBOL_OUT)
end AS path ,
count(DISTINCT tx_hash ) as txs,
count(DISTINCT origin_from_address) as users,
sum(amount_in_usd) as usd_volume
from base.defi.ez_dex_swaps
group by 1,2,3
having usd_volume is not null
Run a query to Download Data