DATE | TX_COUNT | ACTIVE_ADDRESSES | ACTIVE_SENDERS | GAS_USED | PAID_FEES | AVG_TPS | MAX_TPS | AVG_GPS | MAX_GPS | AVG_GAS_PRICE | CUMULATIVE_ADDRESSES | NEW_ADDRESSES | CUMULATIVE_CONTRACTS | CUMULATIVE_DEPLOYERS | TX_PER_USER | CUMULATIVE_TX_COUNT | TOTAL_PAID_FEES | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-22 00:00:00.000 | 2007 | 12 | 5 | 48838666 | 1.2209666500488388 | 0 | 0 | 0 | 0 | 376 | 0 | 3 | 1 | 167 | 77892 | 91.8304272 |
Ali3NPast 24 Hours Koroshi Avalanche Subnet Metrics
Updated 7 hours ago
999
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 TXTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/txCount?timeInterval=day') as response),
ActiveAddressesTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/activeAddresses?timeInterval=day') as response),
ActiveSendersTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/activeSenders?timeInterval=day') as response),
FeesPaidTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/feesPaid?timeInterval=day') as response),
GasUsedTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/gasUsed?timeInterval=day') as response),
AVGTPSTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/avgTps?timeInterval=day') as response),
MAXTPSTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/maxTps?timeInterval=day') as response),
AVGGPSv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/avgGps?timeInterval=day') as response),
MAXGPSv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/maxGps?timeInterval=day') as response),
AVGGasPriceTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/avgGasPrice?timeInterval=day') as response),
CUMAddressesTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/cumulativeAddresses?timeInterval=day') as response),
CumContractsTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/cumulativeContracts?timeInterval=day') as response),
PLSRPrice as (select hour::date as day, avg (price) as PLSRPrice from avalanche.price.ez_prices_hourly where token_address = '0x7a842193d291840fc38b45f991c5b8cc908f8a7c' group by 1),
CumDeployersTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/379/metrics/cumulativeDeployers?timeInterval=day') as response),
TXT2 as (
select t.value:"timestamp" as timestamp1,
t.value:"value" as tx_count
from TXTv2,
table(FLATTEN(parse_json(response:data:"results"))) t),
ActiveAddressesT2 as (
select t.value:"timestamp" as timestamp1,
Last run: about 7 hours agoAuto-refreshes every 24 hours
1
111B
101s