New Holders since 30D | New Holders since 7D | Total Holders | GROWTH_RATE_30D | GROWTH_RATE_7D | |
|---|---|---|---|---|---|
1 | 90 | 7 | 1195 | 7.5314 | 0.5858 |
Kruys-Collinsformal-emerald
Updated 2025-02-18
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
32
33
34
35
36
›
⌄
WITH base AS (
SELECT
ACCOUNT_ADDRESS AS Wallet,
AMOUNT / 1e6 AS amount
FROM aptos.core.fact_transfers
WHERE TOKEN_ADDRESS = '0x61ed8b048636516b4eaf4c74250fa4f9440d9c3e163d96aeb863fe658a4bdc67::CASH::CASH'
AND TRANSFER_EVENT = 'DepositEvent'
UNION ALL
SELECT
ACCOUNT_ADDRESS AS Wallet,
-AMOUNT / 1e6 AS amount
FROM aptos.core.fact_transfers
WHERE TOKEN_ADDRESS = '0x61ed8b048636516b4eaf4c74250fa4f9440d9c3e163d96aeb863fe658a4bdc67::CASH::CASH'
AND TRANSFER_EVENT = 'WithdrawEvent'
),
refine AS (
SELECT
wallet,
SUM(amount) AS balance
FROM base
GROUP BY wallet
),
holders AS (
SELECT
wallet
FROM refine
WHERE balance >= 1
),
network_growth AS (
SELECT
ACCOUNT_ADDRESS wallet,
MIN(block_timestamp) AS first_seen
FROM aptos.core.fact_transfers
WHERE TOKEN_ADDRESS = '0x61ed8b048636516b4eaf4c74250fa4f9440d9c3e163d96aeb863fe658a4bdc67::CASH::CASH'
GROUP BY wallet
),
Last run: 2 months ago
1
27B
27s