with
metrics_api as (
select
live.udf_api(
'https://metrics.avax.network/v1/active_addresses/432204'
):data:results as response
)
select
to_timestamp(value:timestamp)::date as date,
'Dexalot' as subnet,
value:value as value
from
metrics_api,
table(flatten(input => response)) flattened_response
where
date >= (current_date - 180)