mo115Untitled Query
    Updated 2022-06-28
    with B as (select ADDRESS, LABEL
    from osmosis.core.dim_labels
    where LABEL= 'Tether USD' or
    LABEL= 'USD Coin' or
    LABEL= 'Dai Stablecoin')
    select TX_ID,(FROM_AMOUNT/FROM_DECIMAL) as amount, LABEL
    from osmosis.core.fact_swaps a inner join B b on a.FROM_CURRENCY=b.ADDRESS
    where BLOCK_TIMESTAMP = '2022-02-08'


    Run a query to Download Data