date_trunc('day', block_timestamp) as burn_date,

count(*) as total_batch_burns,

count (distinct origin_from_address) as unique_users

from monad.testnet.fact_event_logs

where origin_function_signature = '0x7bad2380'

and contract_address = LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a') -- Fantasy Top Contract

-- Second special burn event type - sales-like events from the special burn address

(topic_0 IN ('0xb197f0b7d29f585d30223a9c287a1309a7c3371a57036eb30995ae25ba906dae',

'0xd650132a7cad9fe7456a6d9bde31152a79c0f8e136974063a84e045a2cdb7842')

AND contract_address IN (LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64'))

AND origin_from_address = LOWER('0x366694cdef0A8c55b60e2cB28AaF6C2c1958313a'))

group by burn_date

order by burn_date desc;

select *

from monad.testnet.fact_event_logs

where topic_0 ='0xb197f0b7d29f585d30223a9c287a1309a7c3371a57036eb30995ae25ba906dae'

and contract_address= ''