total transactions | total wallets | total fees | avg fee per wallet | |
---|---|---|---|---|
1 | 2045862 | 1058505 | 7364.980722595 | 0.006957908298 |
datavortexTotals
Updated 2025-03-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
COUNT(DISTINCT t.tx_hash) AS "total transactions",
COUNT(DISTINCT t.from_address) AS "total wallets",
SUM(f.tx_fee) AS "total fees",
SUM(f.tx_fee) / NULLIF(COUNT(DISTINCT t.from_address), 0) AS "avg fee per wallet"
FROM
kaia.core.fact_traces t
JOIN kaia.core.fact_transactions f ON t.tx_hash = f.tx_hash
WHERE
t.to_address IN (
'0x0d0966da8e610376f723e42fdfc7a7383a1efd05',
'0x2f0bcecce06b6eb32a83073984d0b793640aeaf6',
'0xd37f28c6c51420054b1fb1362288d07ba40440e8',
'0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2',
'0x97fa0937b99896f2415baf37ce002623dc3b905d',
'0x2e930f07b30c566e8ac7dd018ee895cfa0732a71'
)
AND t.tx_succeeded = TRUE;
Last run: 2 months ago
1
49B
50s