nitsUntitled Query
Updated 2022-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT date(block_timestamp) as day, symbol, count(DISTINCT tx_id) as total_txs,
sum(from_amount /pow(10,from_decimal)*price) as total_vol
from
(SELECT * from
(SELECT * from osmosis.core.fact_swaps
where tx_status= 'SUCCEEDED')
inner join osmosis.core.dim_LABels
on address = from_currency )
inner join osmosis.core.dim_prices
on project_name ilike symbol
GROUP by 1,2
LIMIT 100
Run a query to Download Data