maybeyonasCopy of sushi_liq_whales_changes_works
    Updated 2022-01-30
    with whales as (
    select * from (
    select
    user_address,
    sum(amount_usd) as usd_value
    from ethereum.erc20_balances
    where balance_date in (select balance_date from ethereum.erc20_balances where amount_usd is not null order by balance_date desc limit 1)
    and amount_usd is not null
    and amount_usd > 0
    group by 1
    order by usd_value asc
    )
    where usd_value > 100000
    ),
    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
    Run a query to Download Data