with distinct_transactions as (

select distinct tx_id

from sei.core.fact_msg_attributes

where ATTRIBUTE_VALUE = 'sei152u2u0lqc27428cuf8dx48k8saua74m6nql5kgvsu4rfeqm547rsnhy4y9'

and ATTRIBUTE_KEY = '_contract_address'

and msg_type in ('wasm-buy_now', 'wasm-accept_bid')

and TX_SUCCEEDED = 'true'

and block_timestamp::date >= '2024-01-10'

),

seller_data as (

select

block_timestamp,

tx_id,

msg_index,

ATTRIBUTE_VALUE as seller

from sei.core.fact_msg_attributes

where tx_id in (select tx_id from distinct_transactions)

and ATTRIBUTE_KEY = 'nft_seller'

and block_timestamp::date >= '2024-01-10'

),

nft_data as (

select

attr.block_timestamp,

attr.tx_id,

attr.msg_index,

s.seller,

ATTRIBUTE_VALUE as token_id

from sei.core.fact_msg_attributes attr

join seller_data s on attr.tx_id = s.tx_id and attr.msg_index = s.msg_index

where ATTRIBUTE_KEY = 'nft_token_id'

and attr.block_timestamp::date >= '2024-01-10'

),

collection_data as (

select