from ethereum.core.ez_nft_mints m

left join ethereum.core.fact_transactions t

on m.tx_hash = t.tx_hash

where nft_address = lower('0xdfb57B6E16DDB97Aeb8847386989f4DCA7202146'))

select date_trunc ('hour', block_timestamp) as hora,

count (distinct tx_hash) as hourly_mints,

sum (hourly_mints) over (order by hora) as total_mints

from raw

group by 1

order by 1 desc