TelemennoyerUntitled Query
    Updated 2022-10-28
    select
    LABEL,
    count(tx_id) as "swap count",

    count(distinct trader) as "count of users",
    sum(FROM_AMOUNT/1e6) as volume
    from osmosis.core.fact_swaps,osmosis.core.dim_labels a join osmosis.core.dim_prices b on a.PROJECT_NAME = b.SYMBOL
    where FROM_CURRENCY= 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
    and TO_CURRENCY = address
    and pool_ids[0]=812
    group by 1
    order by 4 desc
    limit 10
    Run a query to Download Data