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-29 00:00:00.000 | 542674 | 1070 | 1057 | 178902521574 | 447.256303935 | 0 | 0 | 0 | 0 | 6565 | 0 | 68 | 8 | 507 | 160336900 | 129243.064413758 |
Ali3NPast 24 Hours Pulsar Avalanche Subnet Metrics
Updated 31 minutes 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
›
⌄
-- forked from Past 24 Hours TixBase Avalanche Subnet Metrics @ https://flipsidecrypto.xyz/studio/queries/e757dec0-d371-4df8-8e38-4eec7bd03fb2
with TXTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/txCount?timeInterval=day') as response),
ActiveAddressesTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/activeAddresses?timeInterval=day') as response),
ActiveSendersTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/activeSenders?timeInterval=day') as response),
FeesPaidTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/feesPaid?timeInterval=day') as response),
GasUsedTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/gasUsed?timeInterval=day') as response),
AVGTPSTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/avgTps?timeInterval=day') as response),
MAXTPSTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/maxTps?timeInterval=day') as response),
AVGGPSv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/avgGps?timeInterval=day') as response),
MAXGPSv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/maxGps?timeInterval=day') as response),
AVGGasPriceTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/avgGasPrice?timeInterval=day') as response),
CUMAddressesTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/metrics/cumulativeAddresses?timeInterval=day') as response),
CumContractsTv2 as (SELECT live.udf_api('https://metrics.avax.network/v2/chains/357/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/357/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),
Last run: 31 minutes agoAuto-refreshes every 24 hours
1
129B
99s