TOKEN_COUNT | N_WALLETS | |
|---|---|---|
1 | 9 | 1 |
2 | 1 | 64468 |
3 | 6 | 48 |
4 | 4 | 887 |
5 | 2 | 11044 |
6 | 7 | 5 |
7 | 3 | 3079 |
8 | 8 | 1 |
9 | 5 | 200 |
dethectiveMulti ICO wallet distribution
Updated 2025-04-07
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
›
⌄
-- forked from Multi ICO @ https://flipsidecrypto.xyz/studio/queries/31f78651-69c7-4750-a11e-7bc52263e165
WITH token_raises AS (
SELECT
tx_from as buyer,
tx_to AS token,
sum(amount) as tot_sol_bought
FROM
solana.core.fact_transfers
WHERE
tx_to IN (
'BL1gBdtuYRYSepKKpoy1GCNSmS1JeGSiNb7tdB2HQzor',
'4gHb9tUASDRgpe2vdi6Y2jh8mbSqPCmyf1ZvSUcazKSc',
'2Y8hZh5on4q9wyqXoNYC8oYPUVQMunrzqW8qDmxup4R8',
--'5agSjW9MZEXntG9kw8fzY6cPPbdhWGBgKSLXfDLFeEqZ',
'CZ5aEKMBsiVyAKCig8R2RQYF9T1rPdPDrdonWvS4v6iz',
'31bbrnPrWKqJYkdHCWPYNBLnAZ3yqRBmLJDtSEwBNgQE',
'GsjtZXs5cGKSdUoW6CveUu5z7JDT5UL6rPkQEsDwbKww',
'97xH1PV8zGhMbEZCuMN2TQTCTsZ5HgkvQvm2ncfqT2TZ',
'E9E6Nxc8DdfLj7vQHLyuXuZxAWYLs3Q5UAaEwByBidz6',
'6jfC9p4jzTBTGpMrbR8H464kNo1SBGNCW17oDETzSJrf',
'6JR5Jgy9bTvEeuMh5QKRRPXCWq38s97Eba6PxGvdafTQ',
'HdENn8wP6srk1AuE2CaJj6bRbjcU2kYs12H4C4HgNAsF'
)
AND mint IN (
'So11111111111111111111111111111111111111112',
'So11111111111111111111111111111111111111111'
)
GROUP BY
buyer, token
),
buyer_table as
(SELECT
r.token,
r.buyer,
Last run: 2 months ago
9
71B
8s