select

date_trunc('hour',BLOCK_TIMESTAMP) as date,

tx_id,

msg_index,

MSG_TYPE,

MSG_GROUP

from sei.core.fact_msg_attributes a

where msg_type = 'wasm'

and ATTRIBUTE_KEY = '_contract_address'

and ATTRIBUTE_VALUE = 'sei1pdwlx9h8nc3fp6073mweug654wfkxjaelgkum0a9wtsktwuydw5sduczvz'

and BLOCK_TIMESTAMP >= '2023-08-15'

),

details as (

select

date_trunc('hour',BLOCK_TIMESTAMP) as date,

tx_id,

msg_index,

MSG_TYPE,

MSG_GROUP,

listagg(case when ATTRIBUTE_KEY = 'exchange-type' then ATTRIBUTE_VALUE end) as exchange_type,

split(listagg(case when ATTRIBUTE_KEY = 'nft' then ATTRIBUTE_VALUE end),',') as nft_datails

from sei.core.fact_msg_attributes a

where tx_id in (select distinct tx_id from Dagora_marketplace)

and BLOCK_TIMESTAMP >= '2023-08-15'

and msg_type = 'wasm'

group by 1,2,3,4,5

),

sale_detail as (

select

date_trunc('hour',BLOCK_TIMESTAMP) as date,

tx_id,

msg_index,