SELECT

event_data:id AS nft_id

FROM flow.core.fact_events

WHERE event_contract = 'A.edf9df96c92f4595.Pinnacle'

AND event_type = 'Deposit'

AND event_data:to = '0x58bdc3d07e83ba18' -- Your address here

),

Withdrawals AS (

SELECT

event_data:id AS nft_id

FROM flow.core.fact_events

WHERE event_contract = 'A.edf9df96c92f4595.Pinnacle'

AND event_type = 'Withdraw'

AND event_data:from = '0x58bdc3d07e83ba18' -- Your address here

),

Minted AS (

SELECT

event_data:id AS nft_id,

event_data:editionID AS edition_id

FROM flow.core.fact_events

WHERE event_contract = 'A.edf9df96c92f4595.Pinnacle'

AND event_type = 'PinNFTMinted'

SELECT

'0x58bdc3d07e83ba18' AS vault_address,

m.edition_id AS editionID,

COUNT(m.edition_id) AS quantity

FROM Deposits d

LEFT JOIN Minted m ON d.nft_id = m.nft_id

WHERE NOT EXISTS (

SELECT 1

FROM Withdrawals w

WHERE d.nft_id = w.nft_id