Cipher009-CpUJ5kTop PSYOP Holders copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from jackguy / Top TOKE Holders @ https://flipsidecrypto.xyz/jackguy/q/rzgSRhWn6NeH/top-toke-holders
SELECT
user_address,
AVG(balance)
FROM flipside_prod_db.ethereum.erc20_balances
WHERE symbol LIKE 'PSYOP'
AND block_number >= 17239044
AND block_number <= 17289886
AND NOT user_address is NULL
GROUP BY 1
ORDER by 2 DESC
LIMIT 50