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

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

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

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

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

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

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

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

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

CumDeployersT as (SELECT live.udf_api('https://metrics.avax.network/v1/cumulative/deployers/60118?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