SELECT

date_trunc('hour', block_timestamp) AS hour,

COUNT(*) AS events,

SUM(15000000.0 / POWER(10, 9)) AS volume_eth

FROM eclipse.core.fact_transfers

WHERE tx_to LIKE '6fviXSXwds8BRLCdisipRRfiZJENQ9LjESXAGkoVeADy'

AND mint LIKE 'Eth1111111111111111111111111111111111111111'

AND amount = 15000000

and succeeded

GROUP BY 1

SELECT

hour,

events,

volume_eth,

SUM(volume_eth) OVER (order by hour) AS total_volume_eth,

SUM(events) OVER (order by hour) AS total_mint_events

FROM transfer_data

order by hour DESC;