with token_bonk as ( Select VALUE:"DECIMAL" as decimal,

value:"TOKEN_ADDRESS" as token_address,

value:"TOKEN_NAME" as token_name

from (

SELECT livequery.live.udf_api(

'https://flipsidecrypto.xyz/api/v1/queries/afb49a72-5616-4521-bc64-019467ed698b/data/latest') as resp

,LATERAL FLATTEN (input => resp:data)),

swaps as (

select

block_timestamp,

tx_id,

swapper,

platform,

CURRENCY_IN,

CURRENCY_OUT,

amount_in,

amount_out

from

sei.defi.fact_dex_swaps

),

tokens as (

select

block_timestamp,

CURRENCY_IN as token_address,

tx_id,

swapper

from

swaps

where amount_in > 0

union all

select

block_timestamp,

CURRENCY_OUT as token_address,