maybeyonassushi_whales_fees_daily
    Updated 2021-12-28
    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 '30 days'
    ),
    lp_rem as (
    select --*
    block_timestamp,
    tx_id,
    origin_address as user,
    from_address_name as pool_name,
    symbol as token,
    contract_address as token_contract,
    - amount as token_removed,
    - amount_usd as usd_removed
    from ethereum.udm_events
    Run a query to Download Data