with mints as (

select * from base.core.ez_nft_transfers

where nft_address = '0x7d5861cfe1c74aaa0999b7e2651bf2ebd2a62d89'

and event_type = 'mint')

select

date_trunc('hour', block_timestamp) as time,

count(distinct nft_to_address) as Bridge_to_base_minters,

count(tx_hash) as Bridge_to_base_mints,

Bridge_to_base_mints * 0.00077 as earning

from mints

group by time