mmdrezaact
Updated 2024-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with main as (
SELECT
distinct owner AS holder_address,
sum (balance) as balancee
FROM
solana.core.fact_token_balances
WHERE
mint = 'GJAFwWjJ3vnTsrQVabjBVK2TYB1YtRCQXRDfDgUnpump'
AND DATE(block_timestamp) = '2024-11-10'
group by
1
ORDER BY
balancee DESC
)
select
distinct holder_address,
balancee
from
main
where
balancee < 200000
order by
balancee desc
QueryRunArchived: QueryRun has been archived