with cte_main as (

select

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

--sunday nov 3rd new time (-5)

BLOCK_TIMESTAMP,

mint,

owner,

pre_balance as pre_balance,

balance as balance,

tx_id

from

solana.core.fact_token_balances

where

BLOCK_TIMESTAMP > '2024-12-17 10:00'

and BLOCK_TIMESTAMP < '2024-12-18 05:00' --and tx_id = '4mPzsoMbtx7MXNTqUEn3Agr1obPePbwL2BVS3QfuNPECvyF44qf4Xs9etQo7SMnu7DFdhPhnjVeTdPGRZZBusrX9'

and mint LIKE '%pump'

--and mint = '7UeQu9ymy2eCxpgGaVzVBR6rSBJUjX48vg7675h9pump'

-- and mint = 'HBXXhWZCoUGUQCafrdeR34TuGv6hpVLoVzi58QHapump'

--limit 100

),

cte as (

select

min(ts) as ts,

min(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP,

mint,

sum(pre_balance) as pre_balance,

sum(balance) as balance,

count(*) as counts,

tx_id

from

cte_main --where owner = 'EVFjZxibVpwMD6h8NuFwVNzyYHaM1qmKLzPXNkKBdET4'

group by