MLDZMNl3gas
    Updated 2023-10-02
    with t1 as (SELECT
    TO_TIMESTAMP(d.value:timestamp) as date,
    d.value:value as gas_used
    from (select livequery.live.udf_api(
    'https://metrics.avax.network/v1/gas_used/333000333?from=1682541000&interval=day'
    ) :"data" as data
    )
    join lateral flatten (input => data:results) d
    ),

    t2 as (SELECT
    TO_TIMESTAMP(d.value:timestamp) as date,
    d.value:value as Gas_per_second
    from (select livequery.live.udf_api(
    'https://metrics.avax.network/v1/avg_gps/333000333?from=1682541000&interval=day'
    ) :"data" as data
    )
    join lateral flatten (input => data:results) d
    ),

    t3 as (SELECT
    TO_TIMESTAMP(d.value:timestamp) as date,
    d.value:value as avg_gas_price
    from (select livequery.live.udf_api(
    'https://metrics.avax.network/v1/avg_gas_price/333000333?from=1682541000&interval=day'
    ) :"data" as data
    )
    join lateral flatten (input => data:results) d
    )

    SELECT
    t1.date as date,
    gas_used,
    Gas_per_second,
    avg_gas_price,
    gas_used*avg_gas_price/1e12 as "Avg Fee in gMELD"
    Run a query to Download Data