MostlyData_Osmosis Volume data
    Updated 2023-02-15
    with swaps_list as(
    select
    block_id,
    block_timestamp,
    tx_id,
    trader,
    from_currency as token,
    (from_amount * pow(10,-from_decimal)) as tx_volume

    from osmosis.core.fact_swaps
    where block_timestamp >= '2023-02-01 00:00:00'
    and block_timestamp <= '2023-02-07 00:00:00'
    and tx_succeeded
    ),

    price_infos as(
    select
    price,
    symbol,
    recorded_at

    from osmosis.core.dim_prices
    where recorded_at >= '2023-02-01 00:00:00'
    and recorded_at <= '2023-02-07 00:00:00'
    ),

    token_infos as (
    select
    address,
    project_name,
    label

    from osmosis.core.dim_labels
    ),

    Run a query to Download Data