HadisehHop In the Pool 6
    Updated 2022-11-28

    select
    PROJECT_NAME,
    count (distinct trader) as total_swapper,
    count (distinct tx_id) as total_swap
    from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
    on from_currency=address
    where tx_status = 'SUCCEEDED'
    and TO_CURRENCY like '%pool%' or TO_CURRENCY is null
    and from_decimal is not null
    and PROJECT_NAME != 'MEME'
    and block_timestamp::date >= CURRENT_DATE - 90
    group by 1
    order by 2 desc
    limit 15

    Run a query to Download Data