WEEK_START | C_CHAIN_TRANSACTIONS | GAMING_L1_TRANSACTIONS | |
|---|---|---|---|
1 | 2025-03-10 00:00:00.000 | 2178688 | 734971 |
2 | 2025-03-03 00:00:00.000 | 2938659 | 547044 |
3 | 2025-02-24 00:00:00.000 | 2818020 | 581910 |
4 | 2025-02-17 00:00:00.000 | 2308461 | 670918 |
5 | 2025-02-10 00:00:00.000 | 2314237 | 826615 |
6 | 2025-02-03 00:00:00.000 | 2568890 | 10863845 |
7 | 2025-01-27 00:00:00.000 | 2333782 | 35881575 |
8 | 2025-01-20 00:00:00.000 | 2406164 | 36135322 |
9 | 2025-01-13 00:00:00.000 | 2936176 | 35716674 |
10 | 2025-01-06 00:00:00.000 | 3249404 | 36582135 |
11 | 2024-12-30 00:00:00.000 | 2348347 | 36227070 |
12 | 2024-12-23 00:00:00.000 | 1963025 | 37315617 |
13 | 2024-12-16 00:00:00.000 | 2206657 | 38066955 |
14 | 2024-12-09 00:00:00.000 | 1758847 | 37710401 |
15 | 2024-12-02 00:00:00.000 | 2122500 | 36882263 |
16 | 2024-11-25 00:00:00.000 | 1999583 | 36119020 |
17 | 2024-11-18 00:00:00.000 | 1779477 | 37578379 |
18 | 2024-11-11 00:00:00.000 | 1892213 | 32171337 |
19 | 2024-11-04 00:00:00.000 | 1547618 | 33070879 |
20 | 2024-10-28 00:00:00.000 | 1335870 | 33610135 |
datavortexTransactions
Updated 2025-03-16
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 CChainTransactions AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week_start,
COUNT(DISTINCT tx_hash) AS c_chain_transactions
FROM avalanche.core.fact_transactions
GROUP BY 1
),
Transactions AS (
SELECT 'Solo Leveling L1 Space' AS chain_name, '8227' AS chain_id, live.udf_api('https://metrics.avax.network/v1/tx_count/8227?timeInterval=day') AS response
UNION ALL
SELECT 'DFK (DeFi Kingdoms)', '53935', live.udf_api('https://metrics.avax.network/v1/tx_count/53935?timeInterval=day')
UNION ALL
SELECT 'Blitz', '1344', live.udf_api('https://metrics.avax.network/v1/tx_count/1344?timeInterval=day')
UNION ALL
SELECT 'PLAYA3ULL GAMES', '3011', live.udf_api('https://metrics.avax.network/v1/tx_count/3011?timeInterval=day')
UNION ALL
SELECT 'Playdapp Network', '504441', live.udf_api('https://metrics.avax.network/v1/tx_count/504441?timeInterval=day')
UNION ALL
SELECT 'Pulsar', '357', live.udf_api('https://metrics.avax.network/v1/tx_count/357?timeInterval=day')
UNION ALL
SELECT 'Shrapnel', '2044', live.udf_api('https://metrics.avax.network/v1/tx_count/2044?timeInterval=day')
UNION ALL
SELECT 'Solert Games', '9899', live.udf_api('https://metrics.avax.network/v1/tx_count/9899?timeInterval=day')
UNION ALL
SELECT 'Swimmer Network', '73772', live.udf_api('https://metrics.avax.network/v1/tx_count/73772?timeInterval=day')
UNION ALL
SELECT 'Tiltyard', '710420', live.udf_api('https://metrics.avax.network/v1/tx_count/710420?timeInterval=day')
UNION ALL
SELECT 'Xana', '8888', live.udf_api('https://metrics.avax.network/v1/tx_count/8888?timeInterval=day')
UNION ALL
SELECT 'MUGEN', '29111', live.udf_api('https://metrics.avax.network/v1/tx_count/29111?timeInterval=day')
UNION ALL
SELECT 'OMOCHI', '5041', live.udf_api('https://metrics.avax.network/v1/tx_count/5041?timeInterval=day')
UNION ALL
SELECT 'ONIGIRI', '5040', live.udf_api('https://metrics.avax.network/v1/tx_count/5040?timeInterval=day')
Last run: 2 months ago
...
234
10KB
37s