distinct owner AS holder_address,

sum (balance) as balancee

FROM

solana.core.fact_token_balances

WHERE

mint = '2qEHjDLDLbuBgRYvsxhc5D6uDWAivNFZGan56P1tpump'

AND DATE(block_timestamp) between '2024-10-31' and '2024-11-1'

group by 1

ORDER BY

balancee DESC)

select

distinct holder_address

from main

where balancee < 200000000 and balancee >= 100000

select

distinct owner as holder

from solana.core.fact_token_balances

where mint = '5z3iCe53hUANTiG8Js8RjHNE2Arjik7L2CXLyr2rpump'

and date(block_timestamp) = '2024-11-14'

and owner in (select * from tab1)