carlesmontalaCOSMO FREE PLAY 9
    Updated 2023-01-18
    with EVMOSpricet as (
    select recorded_at::date as day,
    avg (price) as EVMOSPrice
    from osmosis.core.dim_prices where symbol = 'EVMOS'
    and recorded_at >= CURRENT_DATE - 7
    group by 1)
    select from_currency,
    project_name,
    count (distinct tx_id) as Swaps_Count,
    count (distinct trader) as Swappers_Count,
    sum ((to_amount/1e18)*EVMOSPrice) as USD_Volume
    from osmosis.core.fact_swaps t1 join EVMOSPricet t2 on t1.block_timestamp::date = t2.day
    full outer join osmosis.core.dim_labels t3 on t1.from_currency = t3.address
    where to_currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A'
    and block_timestamp >= CURRENT_DATE - 7
    group by 1,2
    order by 3 DESC
    limit 4
    Run a query to Download Data