DATE | total purchases | purchasers | total Wklay | total Purchase Fees(kaia) | |
|---|---|---|---|---|---|
1 | 2025-01-28 00:00:00.000 | 5739 | 4979 | 96554.9868 | 19.662816673 |
2 | 2025-01-29 00:00:00.000 | 12109 | 8653 | 201928.3466 | 41.444775973 |
3 | 2025-01-30 00:00:00.000 | 18069 | 13095 | 215901.09275 | 61.784954547 |
4 | 2025-01-31 00:00:00.000 | 20348 | 17117 | 204288.9502 | 69.682978418 |
5 | 2025-02-01 00:00:00.000 | 20660 | 19779 | 178339.8698 | 70.711007315 |
6 | 2025-02-02 00:00:00.000 | 9983 | 9070 | 150704.2004 | 34.202577138 |
7 | 2025-02-03 00:00:00.000 | 25054 | 24264 | 122602.41110088 | 89.269483308 |
8 | 2025-02-04 00:00:00.000 | 54049 | 52857 | 196702.0037 | 184.989201486 |
9 | 2025-02-05 00:00:00.000 | 57433 | 56003 | 207619.8666 | 196.925536846 |
10 | 2025-02-06 00:00:00.000 | 1918 | 1165 | 81695.5516 | 6.572724692 |
11 | 2025-02-07 00:00:00.000 | 100031 | 98834 | 361524.7153 | 340.81365815 |
12 | 2025-02-08 00:00:00.000 | 27661 | 26804 | 155235.1777 | 95.471557816 |
13 | 2025-02-09 00:00:00.000 | 31625 | 30885 | 195147.5166 | 106.245010656 |
14 | 2025-02-10 00:00:00.000 | 25209 | 24499 | 141077.4698 | 84.164327576 |
15 | 2025-02-11 00:00:00.000 | 39661 | 35807 | 758269.492986124 | 128.981644347 |
16 | 2025-02-12 00:00:00.000 | 16627 | 15830 | 179199.43 | 54.906193668 |
17 | 2025-02-13 00:00:00.000 | 3174 | 2704 | 144315.6389 | 10.876249693 |
18 | 2025-02-14 00:00:00.000 | 20214 | 19627 | 243964.4161 | 66.236623761 |
19 | 2025-02-15 00:00:00.000 | 5847 | 5188 | 257969.1357 | 20.047847941 |
20 | 2025-02-16 00:00:00.000 | 7101 | 6106 | 340113.125 | 24.367980534 |
datavortexdaily purchases
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
COUNT(DISTINCT tx_hash) AS "total purchases",
COUNT(DISTINCT from_address) AS "purchasers",
SUM(VALUE) AS "total Wklay",
SUM(tx_fee) AS "total Purchase Fees(kaia)"
FROM
kaia.core.fact_transactions
WHERE
to_address = '0x703e56244b73427fe1fea3374e296606ca64096b'
AND block_timestamp >= '2025-01-28'
GROUP BY
DATE_TRUNC('day', block_timestamp)
ORDER BY
date;
Last run: 2 months ago
31
2KB
2s