Pmisha-bmlMdxtop.pools
    Updated 2022-05-19
    SELECT
    TO_ADDRESS_NAME as pool,
    count(tx_id) as no_txn,
    count(distinct FROM_ADDRESS) as total_users
    FROM ethereum.udm_events
    where (to_label = 'sushiswap')
    AND TO_LABEL_SUBTYPE ilike 'pool'
    and ORIGIN_FUNCTION_NAME in ('deposit','addLiquidityETH','addLiquidity')
    and BLOCK_TIMESTAMP>=CURRENT_DATE-90
    and FROM_ADDRESS_NAME is null
    group by 1
    order by 2 desc limit 10
    Run a query to Download Data