SELECT

DISTINCT tx_id as tx,

block_timestamp,

b.address_name

FROM sei.core.fact_msg_attributes a

LEFT JOIN sei.core.dim_labels b ON a.ATTRIBUTE_VALUE = b.address

WHERE ATTRIBUTE_KEY = '_contract_address'

AND ATTRIBUTE_VALUE IN (SELECT address FROM sei.core.dim_labels WHERE label ilike 'fuzio')

,

swap as (

SELECT b.*

FROM sei.core.fact_msg_attributes a

INNER JOIN swap_addliquidity b ON a.tx_id = b.tx

WHERE ATTRIBUTE_KEY = 'action' AND ATTRIBUTE_VALUE = 'swap'

,

amount_i as (

SELECT

tx_id,

ATTRIBUTE_VALUE as amount_in

FROM sei.core.fact_msg_attributes

WHERE tx_id IN (SELECT tx FROM swap)

AND ATTRIBUTE_KEY = 'native_sold'

),

amount_o as (

SELECT

tx_id,

ATTRIBUTE_VALUE as amount_out

FROM sei.core.fact_msg_attributes

WHERE tx_id IN (SELECT tx FROM swap)

AND ATTRIBUTE_KEY = 'token_bought'

,