flipside

    Number of swaps to stablecoins (BUSD and USDC) per day
    Soheil_MKNumber of swaps to stablecoins (BUSD and USDC) per day
    Updated 2022-07-01
    with stablecoins as (
    select
    distinct FROM_ASSET as assets
    from flipside_prod_db.thorchain.swaps
    where FROM_ASSET ILIKE '%usdc%'
    or FROM_ASSET ILIKE '%BUSD%'
    )

    select
    date_trunc('day',BLOCK_TIMESTAMP) as date,
    count(TX_ID)

    from flipside_prod_db.thorchain.swaps
    where to_ASSET in (select assets from stablecoins)
    and DATE>='2022-01-01'
    group by 1
    Run a query to Download Data