HOLDERS | |
|---|---|
1 | 15665 |
Flipside Teambase
Updated 3 days ago
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
›
⌄
with t1 as (SELECT address, SUM(holding) AS total_value
FROM (
SELECT
TO_ADDRESS AS address,
sum(RAW_AMOUNT /1e18 ) AS holding
FROM base.core.fact_token_transfers
WHERE contract_address = lower('0x54330d28ca3357F294334BDC454a032e7f353416')
--and TO_ADDRESS <> lower('0xBA12222222228d8Ba445958a75a0704d566BF2C8')
GROUP BY 1
UNION ALL
SELECT
FROM_ADDRESS AS address,
-sum(RAW_AMOUNT /1e18 ) AS holding
FROM base.core.fact_token_transfers
WHERE contract_address = lower('0x54330d28ca3357F294334BDC454a032e7f353416')
--and FROM_ADDRESS <> lower('0xBA12222222228d8Ba445958a75a0704d566BF2C8')
GROUP BY 1
)
GROUP BY 1
--having sum(holding) > 0.05
ORDER BY total_value DESC
)
select count(distinct address) as holders from t1
where total_value is not null
and total_value > 0
Last run: 3 days agoAuto-refreshes every 12 hours
1
9B
326s