from sei.defi.fact_dex_swaps

where block_timestamp::date >= '2024-03-01')

,

milli as (select DISTINCT tx_id

from sei.core.fact_msg_attributes

where ATTRIBUTE_VALUE = 'sei170949pwl4h36neazkwmdgtrh6nuenh66462n34839e23e8he3pqsnm5r2v'

and tx_id not in (select tx_id from swap)

and tx_id in (select tx_id from sei.core.fact_msg_attributes

where ATTRIBUTE_VALUE = 'transfer'

and block_timestamp::date >= '2024-03-01')

and block_timestamp::Date >= '2024-03-01')

,

sender as ( select DISTINCT ATTRIBUTE_VALUE as sender,

block_timestamp,

tx_id,

from sei.core.fact_msg_attributes

where block_timestamp::date >= '2024-03-01'

and tx_id in (select tx_id from milli)

and TX_SUCCEEDED = 'true' and ATTRIBUTE_KEY = 'fee_payer' )

,

receiver as ( select a.tx_id,

a.block_timestamp,

a.MSG_GROUP,

sender,

ATTRIBUTE_VALUE as receiver

from sei.core.fact_msg_attributes a join sender b on a.tx_id = b.tx_id

where ATTRIBUTE_KEY = 'to'

and a.block_timestamp::date >= '2024-03-01')

,

amount as ( select a.block_timestamp,

a.tx_id,

a.MSG_GROUP,

sender,