SELECT

dateadd(HOUR,-5,block_timestamp) AS ts,

CASE

WHEN pre_balance = 0 AND balance > 0 THEN 1

WHEN pre_balance > 0 THEN

CASE WHEN balance / pre_balance - 1 < -0.97 THEN -1 ELSE 0 END

END AS action,

CASE

WHEN pre_balance = 0 AND balance > 0 THEN 1

WHEN pre_balance > 0 AND balance = 0 THEN -1 ELSE 0

END AS action_orig,

CASE

WHEN pre_balance = 0 AND balance > 0 THEN 1 ELSE 0

END AS buys,

CASE

WHEN pre_balance > 0 AND balance = 0 THEN 1 ELSE 0

END AS sells,

pre_balance,

balance,

balance - pre_balance AS net,

owner,

tx_id,

mint

FROM solana.core.fact_token_balances

WHERE lower(mint) = lower('CC422cYvUeHkd4zsb93EuMVq2iqWVcTMvup4bqdJpump')

AND BLOCK_TIMESTAMP > '2024-12-24 00:00'

AND BLOCK_TIMESTAMP < '2024-12-25 23:59'

),

cte_dev as (

select owner from cte where pre_balance > 0

order by pre_balance desc

limit 1

,

cte_interval as (