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'

--LIMIT 1000

),

balances AS (

SELECT

owner AS address

, mint AS CA

, balance AS token_balances

FROM latest_balances

WHERE rank = 1

AND balance > 0

),

Trump_Price as (

SELECT

hour AS recorded_Hour

, price AS t_price

FROM solana.price.ez_prices_hourly

WHERE

token_address = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

),

atl as (

SELECT

MIN(t_price) as Min_Price

FROM Trump_Price