freemartianBit Bears holders vs bridgers
Updated 2025-03-05
999
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
32
33
34
35
36
›
⌄
with eth_chain_holders AS(
SELECT
user_address as holder, current_bal_unadj, token_name
FROM ethereum.core.ez_current_balances
WHERE contract_address = lower('0xF17Bb82b6e9cC0075ae308e406e5198BA7320545')
and holder not in ('0x6b1c374105467d1fc1090c989bcbbcc172c8a89c')
UNION ALL
SELECT
null as holder, 0 AS current_bal_unadj, 'Bong Bears' AS token_name
FROM ethereum.core.ez_current_balances
WHERE contract_address = lower('0x1897C001341F81Ca72154b75b882aE708e06bF48')
UNION ALL
SELECT
user_address as holder, current_bal_unadj, token_name
FROM ethereum.core.ez_current_balances
WHERE contract_address = lower('0x2c889A24AF0d0eC6337DB8fEB589fa6368491146')
AND holder not in ('0x7591992f1a98636c6b7207f30382ca4bec83d9be')
UNION ALL
SELECT
user_address as holder, current_bal_unadj, token_name
FROM ethereum.core.ez_current_balances
WHERE contract_address = lower('0x9e629d779be89783263d4c4a765c38eb3f18671c')
AND holder not in ('0xc48c54e92d135b356dd0cbf50f803a8c8d38968b')
UNION ALL
SELECT
user_address as holder, current_bal_unadj, token_name
FROM ethereum.core.ez_current_balances
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived