nitsUntitled Query
    Updated 2022-11-17
    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