alitaslimiSwaps Daily
    Updated 2022-10-12
    WITH
    prices AS (
    SELECT
    DISTINCT day,
    AVG(price) AS price
    FROM (
    SELECT
    block_timestamp::date AS day,
    AVG((to_amount / POW(10, to_decimal)) / (from_amount / POW(10, from_decimal))) AS price
    FROM
    osmosis.core.fact_swaps swaps
    JOIN
    osmosis.core.dim_labels labels
    ON
    swaps.from_currency = labels.address
    WHERE
    block_timestamp::date BETWEEN (TO_DATE('2022-09-26') - DATEDIFF(day, TO_DATE('2022-09-28'), CURRENT_DATE - 1)) AND (CURRENT_DATE - 1)
    AND tx_status = 'SUCCEEDED'
    AND project_name = '{{token}}'
    AND to_currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'
    GROUP BY
    day
    UNION ALL
    SELECT
    block_timestamp::date AS day,
    AVG((from_amount / POW(10, from_decimal)) / (to_amount / POW(10, to_decimal))) AS price
    FROM
    osmosis.core.fact_swaps swaps
    JOIN
    osmosis.core.dim_labels labels
    ON
    swaps.to_currency = labels.address
    WHERE
    block_timestamp::date BETWEEN (TO_DATE('2022-09-26') - DATEDIFF(day, TO_DATE('2022-09-28'), CURRENT_DATE - 1)) AND (CURRENT_DATE - 1)
    AND tx_status = 'SUCCEEDED'
    AND project_name = '{{token}}'
    Run a query to Download Data