Tony_IntelTotals of Dexs - Avalanche
Updated 2023-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
select
count(distinct tx_hash) as tx_count,
count(distinct origin_from_address) as user_count,
sum(amount_out_usd) as total_volume,
case
when platform ilike '%trader-joe%' then 'trader_joe'
when platform ilike '%kyberswap%' then 'kyberswap'
else platform
end as platform,
case
when block_timestamp::date <= '2023-01-01' then 'Q4'
else 'Q1'
end as Quarter,
case
when block_timestamp::date <= '2023-01-01' then '2022-12-29'
else '2023-03-31'
end as Python_Quarter -- I use it to make quarters in python
from
avalanche.core.ez_dex_swaps
where
block_timestamp::date >= '2022-10-01'
group by
4,
5,
6
Run a query to Download Data