WITH raw AS (

SELECT

block_timestamp,

tx_hash,

nft_from_address,

nft_to_address,

nft_address,

tokenid,

event_index,

project_name

FROM

ethereum.nft.ez_nft_transfers

WHERE

nft_address = LOWER('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8')

QUALIFY

ROW_NUMBER() OVER (PARTITION BY tokenid ORDER BY block_timestamp DESC, event_index DESC) = 1 -- Get the latest transfers per token id

),

holdings AS (

SELECT

nft_to_address,

COUNT(1) AS holdings

FROM

raw

GROUP BY

nft_to_address

),

top5 AS (

SELECT

nft_to_address,

holdings

FROM

holdings