SELECT

EVENT_DATA:"to" AS wallet_address,

EVENT_DATA:"id" AS nft_id,

ROW_NUMBER() OVER (PARTITION BY EVENT_DATA:"id" ORDER BY BLOCK_HEIGHT DESC) AS row_number

FROM flow.core.fact_events

WHERE

EVENT_CONTRACT LIKE 'A.8f9231920da9af6d.AFLNFT'

AND EVENT_TYPE = 'Deposit'

AND BLOCK_HEIGHT > 45416864

SELECT wallet_address, COUNT(nft_id) AS quantity_held

FROM latest_deposits

row_number = 1

AND nft_id IN (

SELECT EVENT_DATA:"id"

FROM flow.core.fact_events

WHERE

EVENT_CONTRACT LIKE 'A.8f9231920da9af6d.AFLNFT'

AND EVENT_TYPE = 'Withdraw'

AND TX_SUCCEEDED = 'TRUE'

AND BLOCK_HEIGHT > 45416864

AND EVENT_DATA:"from" = '0x8f9231920da9af6d'

{% if from %}

AND (

CASE WHEN '{{from}}' = '' OR '{{from}}' IS NULL THEN TRUE

ELSE BLOCK_TIMESTAMP >= '{{from}}' END

{% endif %}

{% if to %}

AND

CASE WHEN '{{to}}' = '' OR '{{to}}' IS NULL THEN TRUE

ELSE BLOCK_TIMESTAMP <= '{{to}}' END

)

{% endif %}

ORDER BY BLOCK_HEIGHT