hbd1994Top Tokens | Swap To
Updated 2023-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
coalesce(SYMBOL_OUT,TOKEN_OUT) as "Token",
TOKEN_OUT as "Token Address",
count(distinct tx_hash) as "Swap Transactions",
count(*) as "Swaps",
count(distinct ORIGIN_FROM_ADDRESS) as "Swappers",
sum(AMOUNT_OUT) as "Token Volume",
sum(AMOUNT_OUT_USD) as "USD Volume"
from base.defi.ez_dex_swaps
where block_timestamp >= '{{Start_Date}}'
and block_timestamp <= '{{End_Date}}'
group by 1,2
order by 3 desc
Run a query to Download Data