ActiveAddressesT as (SELECT live.udf_api('https://metrics.avax.network/v1/active_addresses/8227?timeInterval=day') as response),

ActiveSendersT as (SELECT live.udf_api('https://metrics.avax.network/v1/active_senders/8227?timeInterval=day') as response),

GasUsedT as (SELECT live.udf_api('https://metrics.avax.network/v1/gas_used/8227?timeInterval=day') as response),

AVGTPST as (SELECT live.udf_api('https://metrics.avax.network/v1/avg_tps/8227?timeInterval=day') as response),

MAXTPST as (SELECT live.udf_api('https://metrics.avax.network/v1/max_tps/8227?timeInterval=day') as response),

AVGGPS as (SELECT live.udf_api('https://metrics.avax.network/v1/avg_gps/8227?timeInterval=day') as response),

MAXGPS as (SELECT live.udf_api('https://metrics.avax.network/v1/max_gps/8227?timeInterval=day') as response),

AVGGasPriceT as (SELECT live.udf_api('https://metrics.avax.network/v1/avg_gas_price/8227?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),

CUMAddressesT as (SELECT live.udf_api('https://metrics.avax.network/v1/cumulative/addresses/8227?timeInterval=day') as response),

CumContractsT as (SELECT live.udf_api('https://metrics.avax.network/v1/cumulative/contracts/8227?timeInterval=day') as response),

CumDeployersT as (SELECT live.udf_api('https://metrics.avax.network/v1/cumulative/deployers/8227?timeInterval=day') as response),

TXT1 as (

select t.value:"timestamp" as timestamp1,

t.value:"value" as tx_count

from TXT,

table(FLATTEN(parse_json(response:data:"results"))) t),

ActiveAddressesT1 as (

select t.value:"timestamp" as timestamp1,

t.value:"value" as Active_Addresses