Sector | First-timer Addresses | Total Native Token Value | Total USD Value | Percentage of First-timers | Average Transaction Value | |
|---|---|---|---|---|---|---|
1 | games | 256674 | 1984982.14901543 | 301354.71 | 90.909542 | 7.733023811 |
2 | cex | 10606 | 312596507.258515 | 44863217.43 | 3.756464 | 29473.553390394 |
3 | defi | 7228 | 6688764.99685858 | 1082798.45 | 2.560034 | 925.396374773 |
4 | bridge | 3799 | 17092.362377 | 2279.34 | 1.345541 | 4.499174092 |
5 | nft | 3505 | 0 | 0 | 1.241411 | 0 |
6 | dex | 383 | 5468.415930253 | 814.26 | 0.135652 | 14.277848382 |
7 | dapp | 139 | 2504519.37830643 | 339724 | 0.049231 | 18018.125023787 |
8 | chadmin | 6 | 3e-18 | 0 | 0.002125 | 5e-19 |
Kruys-Collinspetite-rose
Updated 2025-01-30
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 FirstTransactionDates AS (
SELECT
address,
MIN(block_timestamp) AS first_transaction_date
FROM (
SELECT from_address AS address, block_timestamp
FROM kaia.core.fact_transactions
WHERE from_address NOT IN (
SELECT address FROM kaia.core.dim_contracts
)
AND tx_succeeded = TRUE
AND block_timestamp >= DATE_TRUNC('day', TRY_TO_TIMESTAMP('{{lookback_period}}', 'YYYY-MM-DD'))
UNION ALL
SELECT to_address AS address, block_timestamp
FROM kaia.core.fact_transactions
WHERE to_address NOT IN (
SELECT address FROM kaia.core.dim_contracts
)
AND tx_succeeded = TRUE
AND block_timestamp >= DATE_TRUNC('day', TRY_TO_TIMESTAMP('{{lookback_period}}', 'YYYY-MM-DD'))
) all_transactions
GROUP BY address
),
FirstTransactions AS (
SELECT
ft.address,
ft.first_transaction_date,
t.block_hash,
t.tx_hash,
t.from_address,
t.to_address,
t.value,
tx_succeeded
Last run: 3 months ago
8
441B
1s