maybeyonassushi_pools_and_wallet_bals
    Updated 2022-02-05
    with
    lp_add as (
    select --*
    block_timestamp,
    tx_id,
    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
    -- and block_timestamp > current_date - interval '60 days'
    ),
    user_pools as (
    select
    user,
    count(distinct pool_name) as pools
    from lp_add
    group by 1
    ),
    user_bals as (
    select
    user_address,
    sum(amount_usd) as usd_value
    Run a query to Download Data