ramishoowUntitled Query
Updated 2022-11-16
9
1
2
3
4
5
6
›
⌄
select count(*) as " number of swaps",sum(TO_AMOUNT/TO_DECIMAL) as "volume of swaps" , PROJECT_NAME , to_date(block_timestamp) as day
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