from sei.core.fact_msg_attributes

where attribute_value = 'sei1hjsqrfdg2hvwl3gacg4fkznurf36usrv7rkzkyh29wz3guuzeh0snslz7d'

and ATTRIBUTE_KEY = '_contract_address'

and block_timestamp::date >= '2023-12-28'

and TX_SUCCEEDED = 'TRUE')

,

minter as ( select a.block_timestamp,

a.tx_id,

attribute_value as minter

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

where attribute_key = 'fee_payer'

and a.block_timestamp::date >= '2023-12-28')

,

collection as ( select a.block_timestamp,

a.tx_id,

attribute_value as collection,

ifnull(LABEL,collection) as collections,

msg_group,

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

left OUTER join sei.core.dim_labels c on attribute_value = c.address

where attribute_key = 'collection'

and a.block_timestamp::date >= '2023-12-28')

,

price as ( select a.block_timestamp,

a.tx_id,

collection,

collections,

a.msg_group,

minter,

attribute_value/pow(10,6) as price

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

left OUTER join sei.core.dim_labels c on attribute_value = c.address

where attribute_key = 'price'

and a.block_timestamp::date >= '2023-12-28')