with mint_data as (

'Mint' as action,

a.block_timestamp,

a.tx_hash,

a.origin_function_signature,

a.origin_from_address,

a.event_index,

concat('0x', substr(topics[2],27,40)) as user,

livequery.utils.udf_hex_to_int(SUBSTR(topics[3], 3, 64)) :: int as tokenID,

b.value as eth_value

from blast.core.fact_event_logs a

join blast.core.fact_transactions b using(tx_hash, block_timestamp)

where topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- token transfer -- here "nft transfer"

and contract_address = '0xd641dde60985fab88c623188adba6be3148288d9'

and concat('0x', substr(topics[1],27,40)) = '0x0000000000000000000000000000000000000000'

select

min(block_timestamp) as first_mint,

max(block_timestamp) as last_mint,

datediff(hour, min(block_timestamp),max(block_timestamp)) as time

from mint_data