mo115Untitled Query
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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