DrsimonFrax and Osmosis - deposit and withdraw d1
    Updated 2023-02-26
    with Frax as
    (
    select
    * ,
    DECIMAL as ddd
    from osmosis.core.dim_tokens
    where
    LABEL = 'Frax'
    or PROJECT_NAME = 'FRAX'
    or ADDRESS = 'ibc/0E43EDE2E2A3AFA36D0CD38BDDC0B49FECA64FA426A82E102F304E430ECF46EE'

    ) ,
    price1 as (
    SELECT
    date_trunc('week', RECORDED_AT) as day1,
    avg(price) as price

    FROM osmosis.core.dim_prices
    LEFT outer JOIN osmosis.core.dim_labels
    ON PROJECT_NAME LIKE symbol
    WHERE symbol LIKE 'OSMO'
    GROUP BY 1
    ),
    TAB1 AS (
    SELECT
    DATE_TRUNC('week', BLOCK_TIMESTAMP) AS DAY,
    CASE WHEN not TO_CURRENCY LIKE 'uosmo' THEN TO_CURRENCY ELSE FROM_CURRENCY END AS token_address,
    MEDIAN(CASE WHEN not TO_CURRENCY LIKE 'uosmo' THEN ((FROM_AMOUNT/POWER(10, FROM_DECIMAL)) * PRICE)/(TO_AMOUNT/POWER(10, TO_DECIMAL))
    ELSE ((TO_AMOUNT/POWER(10, TO_DECIMAL)) * PRICE)/(FROM_AMOUNT/POWER(10, FROM_DECIMAL)) END) AS MEDIAN_PRICE,
    AVG(CASE WHEN not TO_CURRENCY LIKE 'uosmo' THEN ((FROM_AMOUNT/POWER(10, FROM_DECIMAL)) * PRICE)/(TO_AMOUNT/POWER(10, TO_DECIMAL))
    ELSE ((TO_AMOUNT/POWER(10, TO_DECIMAL)) * PRICE)/(FROM_AMOUNT/POWER(10, FROM_DECIMAL)) END) AS AVG_PRICE
    FROM osmosis.core.fact_swaps
    LEFT outer JOIN osmosis.core.dim_labels
    Run a query to Download Data