maybeyonassushi_user_liq_spread_whales
    Updated 2021-12-27
    with
    lp_add as (
    select --*
    origin_address as user,
    to_address_name as pool_name,
    symbol as token,
    contract_address as token_contract,
    amount as token_added,
    amount_usd as usd_added
    from ethereum.udm_events
    where
    to_label = 'sushiswap'
    and to_label_subtype = 'pool'
    and origin_function_name in (
    'ZapIn',
    'addLiquidity',
    'addLiquidityETH',
    'allocate'
    )
    and amount_usd < pow(10,8)
    and amount_usd > 0
    ),
    user_aggr as (
    select
    user,
    count(distinct pool_name) as pools,
    sum(usd_added) as deposit_amt
    from lp_add
    group by 1
    ),
    pools_aggr as (
    select
    pools,
    count(distinct user) as users,
    round(sum(deposit_amt)) as usd_deposit,
    round(avg(deposit_amt)) as avg_deposit
    Run a query to Download Data