SELECT

owner AS holder_address,

SUM(balance) AS balancee

FROM

solana.core.fact_token_balances

WHERE

mint = '2qEHjDLDLbuBgRYvsxhc5D6uDWAivNFZGan56P1tpump'

AND block_timestamp BETWEEN '2024-10-31' AND '2024-11-01 23:59:59'

GROUP BY owner

HAVING SUM(balance) < 200000000 AND SUM(balance) >= 100000

),

main_tab AS (

SELECT DISTINCT holder_address

FROM main

SELECT

mint,

COUNT(DISTINCT owner) AS holders

FROM

solana.core.fact_token_balances

WHERE

block_timestamp <= CURRENT_DATE

AND owner IN (SELECT holder_address FROM main_tab)

group by 1

order by 2 desc

limit 100