SELECT

block_timestamp as mint_time,

date_part('epoch_second',block_timestamp) AS mint_epoch,

lag(date_part('epoch_second',block_timestamp), 1,0) over (order by mint_time) as perv_mint_epoch,

tx_hash

from base.nft.ez_nft_transfers

where event_type = 'mint'

and nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'

ORDER BY 1 ASC

mint_time,

tx_hash,

TIMEDIFF(second,TO_TIMESTAMP(perv_mint_epoch),mint_time) AS "Timediff Seconds",

CONCAT(HOUR(TO_TIMESTAMP(mint_epoch - perv_mint_epoch) ),':',MINUTE(TO_TIMESTAMP(mint_epoch - perv_mint_epoch) ),':',SECOND(TO_TIMESTAMP(mint_epoch - perv_mint_epoch) )) AS "timestamp diff"

from data

where tx_hash not in ('0x87279304fd577f504a147034bc7faabcf7abc9923ba5acb64f563221750bab9e', '0xf05b7ffe3ecaa080c8050902063148c9a7f6268db5affb57078890e5a563e0b6')

order by mint_time DESC