Ali3NDaily Pulsar Avalanche Subnet Metrics Over Time
Updated 18 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
›
⌄
-- forked from Daily TixBase Avalanche Subnet Metrics Over Time @ https://flipsidecrypto.xyz/studio/queries/00f75d34-7b3a-4977-ba4a-e7167f550fae
with TXT as (SELECT live.udf_api('https://metrics.avax.network/v1/tx_count/357?timeInterval=day') as response),
ActiveAddressesT as (SELECT live.udf_api('https://metrics.avax.network/v1/active_addresses/357?timeInterval=day') as response),
ActiveSendersT as (SELECT live.udf_api('https://metrics.avax.network/v1/active_senders/357?timeInterval=day') as response),
FeesPaidT as (SELECT live.udf_api('https://metrics.avax.network/v1/fees_paid/357?timeInterval=day') as response),
GasUsedT as (SELECT live.udf_api('https://metrics.avax.network/v1/gas_used/357?timeInterval=day') as response),
AVGTPST as (SELECT live.udf_api('https://metrics.avax.network/v1/avg_tps/357?timeInterval=day') as response),
MAXTPST as (SELECT live.udf_api('https://metrics.avax.network/v1/max_tps/357?timeInterval=day') as response),
AVGGPS as (SELECT live.udf_api('https://metrics.avax.network/v1/avg_gps/357?timeInterval=day') as response),
MAXGPS as (SELECT live.udf_api('https://metrics.avax.network/v1/max_gps/357?timeInterval=day') as response),
AVGGasPriceT as (SELECT live.udf_api('https://metrics.avax.network/v1/avg_gas_price/357?timeInterval=day') as response),
AVAXPrice as (select hour::date as day, avg (price) as avaxprice from avalanche.price.ez_prices_hourly where symbol ilike 'WAVAX' group by 1),
PLSRPrice as (select hour::date as day, avg (price) as PLSRPrice from avalanche.price.ez_prices_hourly where token_address = '0x7a842193d291840fc38b45f991c5b8cc908f8a7c' group by 1),
CUMAddressesT as (SELECT live.udf_api('https://metrics.avax.network/v1/cumulative/addresses/357?timeInterval=day') as response),
CumContractsT as (SELECT live.udf_api('https://metrics.avax.network/v1/cumulative/contracts/357?timeInterval=day') as response),
CumDeployersT as (SELECT live.udf_api('https://metrics.avax.network/v1/cumulative/deployers/357?timeInterval=day') as response),
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),