SELECT

price

FROM

solana.price.ez_prices_hourly

WHERE

token_address = 'So11111111111111111111111111111111111111112'

ORDER BY

hour DESC

LIMIT 1

),

nft AS (

SELECT

mint,

nft_collection_name

FROM

solana.nft.dim_nft_metadata

block_timestamp AS date,

tx_id,

CASE

WHEN seller = '{{wallet}}' THEN 'Sell'

WHEN purchaser = '{{wallet}}' THEN 'Buy'

END AS action,

COALESCE(nft.nft_collection_name, f.mint) AS Collection, -- Get the collection name for the mint

sales_amount,

sales_amount * p.price AS usd_value -- Calculate USD value

solana.nft.fact_nft_sales f

price p

nft