select

MINT

from

solana.nft.dim_nft_metadata

where

NFT_NAME LIKE 'Mad Honey Vial%'

),

HONEYLAND_VIAL_MINTS AS (

SELECT

BLOCK_TIMESTAMP,

MINT,

PURCHASER AS TX_TO

FROM

solana.nft.fact_nft_mints

WHERE

BLOCK_ID BETWEEN 168246309

AND 168271711

AND MINT IN (

SELECT

MINT

FROM

CIRCULATING_VIALS

)

GROUP BY

BLOCK_TIMESTAMP,

MINT,

TX_TO

),

honeyland_items_transfers as (

SELECT

DISTINCT ft.BLOCK_TIMESTAMP,

ft.MINT,

LAST_VALUE(ft.TX_TO IGNORE NULLS) OVER (

PARTITION BY ft.TX_ID,

ft.MINT