PURCHASER | total purchases | total Kaia spent | total Purchase Fees(kaia) | |
|---|---|---|---|---|
1 | 0xe665...b638 | 39 | 270.63K | 0.13 |
2 | 0xdf86...a891 | 110 | 191.59K | 0.38 |
3 | 0x3316...e5a1 | 214 | 153.55K | 0.73 |
4 | 0x0279...cdbd | 7 | 140.32K | 0.02 |
5 | 0x42e9...50a8 | 214 | 133.84K | 0.74 |
6 | 0xab28...036d | 181 | 125.52K | 0.61 |
7 | 0x976b...a471 | 196 | 115.95K | 0.65 |
8 | 0x2426...040d | 393 | 115.43K | 1.36 |
9 | 0x7ebe...c8d5 | 71 | 112.99K | 0.25 |
10 | 0x2c67...4fdd | 147 | 93.04K | 0.56 |
datavortexTop Purchasers
Updated 2025-02-27
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
›
⌄
SELECT
LEFT(from_address, 6) || '...' || RIGHT(from_address, 4) AS purchaser,
COUNT(DISTINCT tx_hash) AS "total purchases",
CASE
WHEN SUM(VALUE) >= 1e12 THEN TO_CHAR(ROUND(SUM(VALUE) / 1e12, 2)) || 'T'
WHEN SUM(VALUE) >= 1e9 THEN TO_CHAR(ROUND(SUM(VALUE) / 1e9, 2)) || 'B'
WHEN SUM(VALUE) >= 1e6 THEN TO_CHAR(ROUND(SUM(VALUE) / 1e6, 2)) || 'M'
WHEN SUM(VALUE) >= 1e3 THEN TO_CHAR(ROUND(SUM(VALUE) / 1e3, 2)) || 'K'
ELSE TO_CHAR(ROUND(SUM(VALUE), 2))
END AS "total Kaia spent",
CASE
WHEN SUM(tx_fee) >= 1e12 THEN TO_CHAR(ROUND(SUM(tx_fee) / 1e12, 2)) || 'T'
WHEN SUM(tx_fee) >= 1e9 THEN TO_CHAR(ROUND(SUM(tx_fee) / 1e9, 2)) || 'B'
WHEN SUM(tx_fee) >= 1e6 THEN TO_CHAR(ROUND(SUM(tx_fee) / 1e6, 2)) || 'M'
WHEN SUM(tx_fee) >= 1e3 THEN TO_CHAR(ROUND(SUM(tx_fee) / 1e3, 2)) || 'K'
ELSE TO_CHAR(ROUND(SUM(tx_fee), 2))
END AS "total Purchase Fees(kaia)"
FROM
kaia.core.fact_transactions
WHERE
to_address = '0x703e56244b73427fe1fea3374e296606ca64096b'
AND block_timestamp >= '2025-01-28'
GROUP BY
from_address
ORDER BY
SUM(VALUE) DESC
LIMIT 10;
Last run: 2 months ago
10
386B
2s