SELECT

tx_id ,

block_timestamp

FROM sei.core.fact_msg_attributes

WHERE msg_type = 'wasm'

AND ATTRIBUTE_KEY = 'minter'

AND ATTRIBUTE_VALUE = 'sei1hjsqrfdg2hvwl3gacg4fkznurf36usrv7rkzkyh29wz3guuzeh0snslz7d'

AND tx_succeeded

AND block_timestamp::date >= '2023-09-14'

intersect

SELECT

tx_id ,

block_timestamp

FROM sei.core.fact_msg_attributes

WHERE ATTRIBUTE_KEY = 'action'

AND msg_type = 'wasm'

AND ATTRIBUTE_VALUE = 'mint'

AND block_timestamp::date >= '2023-09-14'

)

SELECT

date_trunc('d', block_timestamp) as date,

count(DISTINCT tx_id) as n_nfts_minted

FROM all_txns

GROUP BY 1