Updated 2022-11-13
9
1
2
3
4
5
›
⌄
select count(*),sum(TO_AMOUNT/TO_DECIMAL) , PROJECT_NAME , to_date(block_timestamp) from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
on ADDRESS=FROM_CURRENCY
where TX_STATUS='SUCCEEDED' and to_date(block_timestamp) > '2022-11-01' and to_date(block_timestamp)!=CURRENT_DATE
and (PROJECT_NAME like '%USDC%' or PROJECT_NAME like '%DAI%' or PROJECT_NAME like '%USDT%')
group by PROJECT_NAME , to_date(block_timestamp)
Run a query to Download Data