winnie-fsAvalanche DEXs Volume Over Time
Updated 2024-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select date_trunc ({{Time_Interval}},block_timestamp) as date,
case when platform ilike '%joe%' then 'Trader Joe'
when platform ilike '%uniswap%' then 'Uniswap'
when platform ilike '%kyberswap%' then 'Kyberswap'
when platform ilike '%hashflow%' then 'Hashflow'
else initcap (platform) end as "DEX",
--pool_name,
sum (amount_in_usd) as "Volume",
count (distinct tx_hash) as "Transactions",
count (distinct origin_from_address) as "Users"
from avalanche.defi.ez_dex_swaps
--where "DEX" ilike '{{Project_Name}}'
group by 1,2
order by 1 desc
QueryRunArchived: QueryRun has been archived