top token pairs

Afonso_Diaztop token pairs

Updated 2025-02-02

with

main as (

select

tx_hash,

block_timestamp,

swapper,

symbol_in,

symbol_out,

amount_in_usd,

amount_out_usd,

nvl(amount_in_usd, amount_out_usd) as amount_usd

from aptos.defi.ez_dex_swaps

where platform = 'thala'

and block_timestamp>= '2024-01-01'

and block_timestamp< '2025-01-01'

)

select

iff(symbol_in > symbol_out, symbol_in || ' - ' || symbol_out, symbol_out || ' - ' || symbol_in) as token_pair,

count(distinct tx_hash) as swaps,

count(distinct swapper) as swappers,

sum(amount_usd) as volume_usd,

avg(amount_usd) as average_amount_usd

from main

where amount_usd > 0

group by 1

order by 4 desc

limit 10

Last run: 3 months ago

	TOKEN_PAIR	SWAPS	SWAPPERS	VOLUME_USD	AVERAGE_AMOUNT_USD
1	thAPT - APT	1900782	36983	1495622584.43114	785.705061633
2	USDC - MOD	1298789	70291	1121545023.47964	838.823064786
3	USDC - APT	1682617	136676	351242943.793899	185.158817424
4	amAPT - APT	215041	29749	150429325.102597	671.913441467
5	USDT - USDC	286972	54093	103899314.630862	352.059049505
6	THL - MOD	406143	33459	94411723.591943	224.8310371
7	USDC - USDC	284044	30799	81212485.0717557	279.581260855
8	WETH - USDC	224756	23518	38647343.4908878	169.069870207
9	THL - APT	274752	39938	6525357.85016436	18.41937372
10	WBTC - USDC	45886	4509	5988502.11967737	129.615646935

592B

flipside