flipside

    List of Stable coins
    MLDZMNList of Stable coins
    Updated 2022-12-05
    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 (select coins from tb1)
    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 (select SYMBOL from times)
    group by 1,2
    order by 3
    Run a query to Download Data