trunc(x.block_timestamp,'hour') as hour,

count(distinct event_data:id) as mints,

sum(mints) over (order by hour) as total_mints,

sum(case when event_type='Mint' then transaction_result:events[0]:value:fields[0] end) as volume,

sum(volume) over (order by hour) as total_volume,

avg(case when event_type='Mint' then transaction_result:events[0]:value:fields[0] end) as avg_paid,

count(distinct authorizers) as minters,

sum(minters) over (order by hour) as total_miners

from flow.core.fact_events x

join flow.core.fact_transactions z on x.tx_id=z.tx_id

where event_contract ilike '%dimension%' and event_type='Mint'

and z.tx_succeeded = true

and x.block_timestamp ilike '%2022-09-07%'

group by 1

order by 1 asc