SELECT

block_timestamp

, owner

, mint

, balance

, row_number() OVER(PARTITION BY owner, mint ORDER BY block_timestamp DESC) AS rank

FROM solana.core.fact_token_balances bl

WHERE mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

AND owner != '2RH6rUTPBJ9rUDPpuV9b8z1YL56k1tYU6Uk5ZoaEFFSK'

),

labels AS (

SELECT

address

, address_name

, label

FROM solana.core.dim_labels

),

Prices AS (

SELECT

price

, token_address

FROM solana.price.ez_prices_hourly

WHERE token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

AND hour IN (SELECT

MAX(hour)

FROM solana.price.ez_prices_hourly

WHERE token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN')

CASE WHEN owner = address THEN address_name ELSE owner END AS "Address"

, balance AS "Token Balance"

, '💲'|| price * balance AS "Holding Value"

FROM latest_balances b

LEFT JOIN labels l ON l.address = b.owner