select count(TX_HASH) as mint_tx , date_trunc('day', block_timestamp) as block_day,
date_trunc('hour', block_timestamp) as block_khour
from ethereum_core.fact_event_logs
where CONTRACT_ADDRESS= '0x23581767a106ae21c074b2276d25e5c3e136a68b'
and EVENT_INPUTS:from='0x0000000000000000000000000000000000000000'
group by block_day,block_khour
order by block_day desc