Muze2023-03-21 07:12 PM
    select
    pool_name,
    contract_address,
    count( distinct tx_hash ) as number_swaps

    from ethereum.core.ez_dex_swaps a
    left join ethereum.core.dim_labels b on a.contract_address = b.address
    and b.address_name ilike 'sushiswap'
    where a.block_timestamp >= cast('2023-02-01' as timestamp)
    and a.block_timestamp < cast('2023-03-01' as timestamp)
    group by 1,2
    order by 3 desc
    limit 10
    Run a query to Download Data