Top symbol out

Afonso_DiazTop symbol out

Updated 2025-05-07

with

pricet as (

select

hour::date as date,

token_address,

avg(price) as token_price_usd

from

aptos.price.ez_prices_hourly

group by 1, 2

main as (

select

tx_hash,

block_timestamp,

sender as swapper,

event_data:amount_in::bigint / pow(10, token_in.decimals) as amount_in,

event_data:amount_out::bigint / pow(10, token_out.decimals) as amount_out,

event_data:in_coin as token_in_address,

event_data:out_coin as token_out_address,

token_in.symbol as symbol_in,

token_out.symbol as symbol_out

from

aptos.core.fact_transactions a

join

aptos.core.fact_events b

left join

aptos.core.dim_tokens token_in on event_data:in_coin = token_in.token_address

left join

aptos.core.dim_tokens token_out on event_data:out_coin = token_out.token_address

using (tx_hash)

where

success

and a.payload_function = '0x5d19daf9e0e9270cb7946fb29cd3b515837199564730f84605df76005e8f954f::router::swap_exact_in'

and b.event_type = '0x5d19daf9e0e9270cb7946fb29cd3b515837199564730f84605df76005e8f954f::router::Swap'

Last run: 23 days ago

400B

92s

flipside