date_trunc('hour', block_timestamp) as hour_,

count(distinct tx_hash) as number_of_transfers,

sum(number_of_transfers) over(order by hour_) as total_transfers

from ethereum.core.ez_nft_transfers

where nft_address = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'

and event_type <> 'mint'

group by 1