with mnts as (select

BLOCK_TIMESTAMP,

TOKENID,

TO_ADDRESS,

from ethereum.nft.ez_nft_transfers

where --tx_hash = '0xe2b5084ea66af96d317bec749e5a9be47553d689e26892293f6176e2daa9f64b'

EVENT_TYPE = 'mint'

and FROM_ADDRESS = '0x0000000000000000000000000000000000000000'

and NFT_ADDRESS = '0xf39c410dac956ba98004f411e182fb4eed595270'

),

phase as (select

date_trunc('second',block_timestamp) as time,

count(distinct TOKENID) as "Mints",

count(distinct TO_ADDRESS) as "Minters",

sum("Mints") over (order by time) as "Cumulative mints"

from mnts

where --block_timestamp::date >= '2025-03-12' and

block_timestamp >= '2025-03-13 08:00:00.000'

group by all

order by 1 desc)

SELECT datediff('second', min(time) , max(time) ) as time_diff

from phase