Abbas_ra21Volume 2
Updated 2025-04-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from Volume @ https://flipsidecrypto.xyz/studio/queries/5b5a97f9-2661-4f99-acdc-dac2b3f7b6f7
select
case when symbol_in in ('uSOL', 'uSEI', 'uDOGE', 'uSUI', 'uAPT', 'uBTC','uNEAR') then symbol_in else symbol_out end AS Symbol,
sum(coalesce(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS volume,
count(*) AS Swaps,
Count(DISTINCT ORIGIN_FROM_ADDRESS) AS traders
from
base.defi.ez_dex_swaps
where
platform like 'aerodrome%'
and (
symbol_in in ('uSOL', 'uSEI', 'uDOGE', 'uSUI', 'uAPT', 'uBTC','uNEAR')
or symbol_out in ('uSOL', 'uSEI', 'uDOGE', 'uSUI', 'uAPT', 'uBTC','uNEAR')
) group by 1 order by 2 desc
QueryRunArchived: QueryRun has been archived