mattkstewVoting Activity 4
    Updated 2022-06-17
    with tabWhales as (
    select
    trader as whale,
    count(*)


    from osmosis.core.fact_swaps
    LEFT OUTER JOIN osmosis.core.dim_labels on address = to_currency
    group by 1
    having count(*) > 5000
    Order by 2 DESC
    )

    select
    date_trunc('day', block_timestamp),
    project_name,
    count(*)



    from osmosis.core.fact_swaps
    LEFT OUTER JOIN osmosis.core.dim_labels on address = to_currency
    where trader not in (select whale from tabWhales )
    group by 1,2
    Run a query to Download Data