SELECT

TRUNC(hour, 'day') AS day,

AVG(price) AS price

FROM

solana.price.ez_prices_hourly

WHERE

token_address = 'SonicxvLud67EceaEzCLRnMTBqzYUUYNr93DBkBdDES'

GROUP BY

day

SELECT

DATE_TRUNC('day', t.block_timestamp) AS date,

COUNT(t.tx_id) AS transaction_count,

SUM(COUNT(t.tx_id)) OVER (ORDER BY DATE_TRUNC('day', t.block_timestamp)) AS cum_tx,

SUM(t.amount * p.price) AS total_amount_usd,

SUM(SUM(t.amount * p.price)) OVER (ORDER BY DATE_TRUNC('day', t.block_timestamp)) AS cum_total_amount_usd,

COUNT(DISTINCT t.tx_from) AS stakers

FROM

solana.core.fact_transfers t

LEFT JOIN

meprice p

ON

TRUNC(t.block_timestamp, 'day') = p.day

WHERE

t.tx_to = 'Hdy8hy5eTBriXH1unEiFYWqV48RUhuFVYK79K1Ys5oWs'

AND t.mint = 'SonicxvLud67EceaEzCLRnMTBqzYUUYNr93DBkBdDES'

GROUP BY

date, p.day

ORDER BY

date DESC;