maybeyonasrbn_net_deposits
    Updated 2022-02-07
    with
    deposits as (
    select
    block_timestamp,
    tx_id,
    origin_address as user,
    case to_address
    when lower('0x25751853eab4d0eb3652b5eb6ecb102a2789644b') then 'ETH'
    when lower('0x65a833afDc250D9d38f8CD9bC2B1E3132dB13B2F') then 'WBTC'
    when lower('0xe63151A0Ed4e5fafdc951D877102cf0977Abd365') then 'AAVE'
    when lower('0xCc323557c71C0D1D20a1861Dc69c06C5f3cC9624') then 'USDC'
    when lower('0x53773E034d9784153471813dacAFF53dBBB78E8c') then 'stETH'
    else 'sus' end as vault,
    case origin_function_signature
    when '0xf6326fb3' then 'depositETH'
    when '0x8fd3ab80' then 'migrate'
    when '0xb6b55f25' then 'depositERC'
    when '0x31807e42' then 'depositYield'
    when '0xe0724b6e' then 'argent'
    when '0x1cff79cd' then 'dsProxy'
    when '0x6a761202' then 'gnosisSafe'
    end as function,
    'deposit' as event,
    amount,
    amount_usd
    from ethereum.udm_events
    where event_name = 'transfer'
    and origin_function_signature not in (
    '0xb9f8092b', --roll over to next option
    '0x' -- deposit eth
    )
    and to_address in (
    lower('0x25751853eab4d0eb3652b5eb6ecb102a2789644b'), -- ETH
    lower('0x65a833afDc250D9d38f8CD9bC2B1E3132dB13B2F'), -- WBTC
    lower('0xe63151A0Ed4e5fafdc951D877102cf0977Abd365'), -- AAVE
    lower('0xCc323557c71C0D1D20a1861Dc69c06C5f3cC9624'), -- USDC
    Run a query to Download Data