shadilTrend of Pools - top pools by added liquidity
    Updated 2022-05-15
    select to_address_name as name, SUM(ZEROIFNULL(amount_usd)) as tvl_by_usd, COUNT(DISTINCT origin_address) as users_count
    from flipside_prod_db.ethereum.udm_events
    where to_label = 'sushiswap'
    AND to_label_subtype = 'pool'
    AND origin_function_name IN ('addLiquidity', 'addLiquidityETH')
    and SYMBOL IS NOT NULL
    and to_address_name ilike '%-%'
    and date(block_timestamp) >= CURRENT_DATE - 90
    -- and tx_id = '0x8bc50d67d8062824458dbfe99ecc3e8c56f136069db87231cfa3453337a15c8f' -- sample add liquidity
    group by to_address_name
    order by tvl_by_usd DESC
    limit 10
    Run a query to Download Data