top 50 route by vol

0-MIDtop 50 route by vol

Updated 2025-02-24

with tab1 as (

select

SYMBOL as symbol_out

,AMOUNT_USD as buy_volume

,TX_HASH

from ronin.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x7d0556d55ca1a92708681e2e231733ebd922597d'

and ORIGIN_FROM_ADDRESS=TO_ADDRESS

and BLOCK_TIMESTAMP::date>=current_date-90

and AMOUNT_USD is not null

tab2 as (

select

SYMBOL as symbol_in

,AMOUNT_USD as sell_volume

,TX_HASH

from ronin.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x7d0556d55ca1a92708681e2e231733ebd922597d'

and ORIGIN_FROM_ADDRESS=FROM_ADDRESS

and BLOCK_TIMESTAMP::date>=current_date-90

and AMOUNT_USD is not null

)

select concat(symbol_in,'➡',symbol_out) as pair

,sum(buy_volume) as volume

,count(distinct tab2.TX_HASH) as swaps

from tab1

left join tab2

on tab1.TX_HASH=tab2.TX_HASH

where pair is not null

group by 1

order by 2 desc

limit 50

Last run: 22 days ago

1KB

flipside