flipside

    Untitled Query
    mlhUntitled Query
    Updated 2022-06-16
    with times as (with tb1 as (SELECT
    SYMBOL_IN as coins

    from ethereum.sushi.ez_swaps
    union ALL
    SELECT
    SYMBOL_OUT as coins

    from ethereum.sushi.ez_swaps)

    select
    distinct SYMBOL,
    TOKEN_ADDRESS,
    avg(price)as aag
    from flipside_prod_db.ethereum_core.fact_hourly_token_prices
    where SYMBOL in ('usdc','usdt','dai','ustc')
    group by 1,2 having aag between 0.99 and 1.01)

    SELECT
    SYMBOL_IN as "Stable coin",
    TOKEN_IN as "Address of token",
    min (BLOCK_TIMESTAMP) as "First use time"
    from ethereum.sushi.ez_swaps
    where SYMBOL_IN in ('usdc','usdt','dai','ustc')
    group by 1,2
    order by 3
    Run a query to Download Data