from terra.core.fact_msg_attributes_standard

where attribute_value = 'terra18plp90j0zd596zt3zdsf0w9vvk5ukwlwzwkksxv9mdu8rscat9sqndk5qz'

and attribute_key = '_contract_address'

and msg_type = 'execute'

and TX_SUCCEEDED = 'true')

,

token_in as ( select block_timestamp,

tx_id,

sender as swapper,

currency as token_in_address,

amount::int as amount_in_raw

from terra.core.ez_transfers

where receiver = 'terra18plp90j0zd596zt3zdsf0w9vvk5ukwlwzwkksxv9mdu8rscat9sqndk5qz'

and tx_id in (select tx_id from astroport))

,

max_token as (select max(MSG_INDEX) as max,

b.tx_id

from terra.core.fact_msg_attributes_standard a join token_in b on a.tx_id = b.tx_id

where attribute_key = 'ask_asset'

group by all )

,

token_out as ( select DISTINCT b.tx_id,

a.block_timestamp,

swapper,

token_in_address,

amount_in_raw,

c.max,

attribute_value as token_out_address

from terra.core.fact_msg_attributes_standard a join token_in b on a.tx_id = b.tx_id and a.block_timestamp = b.block_timestamp

right join max_token c on a.msg_index = c.max and a.tx_id = c.tx_id

where attribute_key = 'ask_asset'

and msg_type = 'wasm' )

,

token_out_amount as ( select DISTINCT b.tx_id,

a.block_timestamp,