SELECT

block_timestamp,

tx_hash,

EVENT_INPUTS,

CONTRACT_ADDRESS,

EVENT_INPUTS:"_id"::string as tokenid,

EVENT_INPUTS:"_to"::string as minter,

ROW_NUMBER() OVER (PARTITION BY minter ORDER BY block_timestamp ASC) as rank

FROM polygon.core.FACT_EVENT_LOGS

WHERE 1=1

and event_name = 'TransferSingle'

and ORIGIN_FUNCTION_SIGNATURE IN ('0x669f5a51', '0x5a86c41a')

and EVENT_INPUTS:"_from" = '0x0000000000000000000000000000000000000000'

and TX_STATUS = 'SUCCESS'

QUALIFY rank = 1 -- Only look at the first mint tx, ignore 2nd onwards

, sales as (

SELECT

block_timestamp,

tx_hash,

CONTRACT_ADDRESS,

EVENT_INPUTS:"_from" as Seller,

EVENT_INPUTS:"_to" as buyer,

EVENT_INPUTS:"_id" as tokenid

FROM polygon.core.FACT_EVENT_LOGS

WHERE CONTRACT_ADDRESS IN (SELECT CONTRACT_ADDRESS FROM mints)

and event_name = 'TransferSingle'

and EVENT_INPUTS:"_from" != '0x0000000000000000000000000000000000000000'

and EVENT_INPUTS:"_to" != '0x0000000000000000000000000000000000000000'

and TX_STATUS = 'SUCCESS'

)

, transfers AS (

SELECT

block_timestamp,

tx_hash,