SELECT

date_trunc('hour', block_timestamp) as hour,

'in' as flow,

mint,

amount

FROM solana.core.fact_transfers

WHERE tx_to IN ('3msVd34R5KxonDzyNSV5nT19UtUeJ2RF1NaQhvVPNLxL')

AND block_timestamp > '2023-10-01'

UNION ALL

SELECT

date_trunc('hour', block_timestamp) as hour,

'out' as flow,

mint,

amount

FROM solana.core.fact_transfers

WHERE tx_from IN ('3msVd34R5KxonDzyNSV5nT19UtUeJ2RF1NaQhvVPNLxL')

AND block_timestamp > '2023-10-01'

*,

balance * price as balance_usd

FROM (

SELECT

hour,

mint,

sum(CASE WHEN flow LIKE 'in' THEN amount ELSE -amount END) as net_amt,

sum(net_amt) OVER (PARTITION BY mint ORDER BY hour) as balance

FROM tab1

GROUP BY 1, 2

) AS a

LEFT OUTER JOIN (

SELECT

date_trunc('hour', RECORDED_HOUR) as date,

token_address as token,