WITH unique_moments AS (

SELECT

NFT_ID AS momentId,

set_id,

metadata:FullName AS player,

serial_number

FROM

flow.nft.dim_moment_metadata

WHERE

set_id = '32'

),

ccsend AS (

SELECT

MAX(deposits.block_timestamp - INTERVAL '7 hour') AS bt,

deposits.tx_id AS tx,

deposits.event_data:id AS momentId,

MAX(deposits.event_data:to) AS deposit_to,

MAX(withdrawals.event_data:from) AS addy_withdraw

FROM

flow.core.fact_events deposits

JOIN

flow.core.fact_events withdrawals ON deposits.tx_id = withdrawals.tx_id

WHERE

deposits.event_contract = 'A.0b2a3299cc857e29.TopShot'

AND withdrawals.event_contract = 'A.0b2a3299cc857e29.TopShot'

AND deposits.event_type = 'Deposit'

AND withdrawals.event_type = 'Withdraw'

AND deposits.event_data:to = '0x2bf4ada619de2fe5'

AND deposits.block_timestamp >= '2024-05-01 07:00:00'

AND deposits.block_timestamp < '2024-08-31 00:00:00'

GROUP BY

deposits.tx_id,

deposits.event_data:id