Deebs-DeFi-j9fRbzSibel ETH balances Moodeng
Updated 2024-11-09
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
25
26
27
28
29
30
31
›
⌄
-- forked from Rothschild Investigation Part 1 BAR CHART ADJUSTED copy @ https://flipsidecrypto.xyz/studio/queries/355a86c8-bd97-4cf1-abe6-6e4e048ab0b5
-- forked from Rothschild Investigation Part 1 BAR CHART ADJUSTED @ https://flipsidecrypto.xyz/studio/queries/b2a2f5fc-b95b-4c5a-be90-90524d007c3c
-- forked from Rothschild Investigation Part 1 PNUT 68 wallets @ https://flipsidecrypto.xyz/studio/queries/6aadb0ee-3702-466e-bf69-4cee15ae0a88
-- forked from Rothschild Investigation @ https://flipsidecrypto.xyz/studio/queries/718cde45-657d-45f9-b83d-d56c2908a515
SELECT
--ROW_NUMBER() OVER (ORDER BY MAX(BALANCE) DESC) AS row_num,
Owner,
--MAX(BALANCE) AS top_balance,
--date_trunc('day', BLOCK_TIMESTAMP)
BLOCK_TIMESTAMP,
Balance
FROM solana.core.fact_token_balances
WHERE BLOCK_TIMESTAMP BETWEEN '{{start_date}}' AND '{{end_date}}'
AND MINT='{{CA}}'
AND OWNER NOT IN('5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1','2JUXSuq1A1EdBzZj757cXFYuALPxv6vee4X981ajpzo8')
AND balance=500000
--GROUP BY 2,4
--HAVING MAX(Balance)>4000000
--AND MAX(Balance)<1000000000000
--ORDER BY top_balance DESC
LIMIT 100;
QueryRunArchived: QueryRun has been archived