alessio9567$IXS Metrics
    Updated 2025-01-22
    with api_price AS (
    select
    response:data:prices as response
    from
    (
    SELECT
    livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/coins/ix-swap/market_chart?vs_currency=usd&days=365'
    ) as response
    )
    ),
    flatten_cmc_data_price AS (
    SELECT
    *
    FROM
    api_price,
    table(flatten(response, ''))
    ),
    final_api_price as (
    select
    *,
    TO_TIMESTAMP(CAST(value [0] AS BIGINT) / 1000) AS dt
    from
    flatten_cmc_data_price
    ),
    api_volume AS (
    select
    response:data:total_volumes as response
    from
    (
    SELECT
    livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/coins/ix-swap/market_chart?vs_currency=usd&days=365'
    ) as response
    )
    ),
    QueryRunArchived: QueryRun has been archived