maybeyonastoke_vault_removals
    Updated 2022-06-22
    with
    removes as (
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    case from_address
    when lower('0xD3D13a578a53685B4ac36A1Bab31912D2B2A2F36') then 't-weth'
    when lower('0x04bDA0CF6Ad025948Af830E75228ED420b0e860d') then 't-usdc'
    when lower('0x0ce34f4c26ba69158bc2eb8bf513221e44fdfb75') then 't-dai'
    when lower('0x7211508D283353e77b9A7ed2f22334C219AD4b4C') then 't-alusd'
    when lower('0x03dcccd17cc36ee61f9004bcfd7a85f58b2d360d') then 't-fei'
    when lower('0x94671a3cee8c7a12ea72602978d1bb84e920efb2') then 't-frax'
    when lower('0x41f6a95Bacf9bC43704c4A4902BA5473A8B00263') then 't-gohm'
    when lower('0x9eee9ee0cbd35014e12e1283d9388a40f69797a3') then 't-lusd'
    when lower('0x2e9F9bECF5229379825D0D3C1299759943BD4fED') then 't-mim'
    when lower('0x482258099De8De2d0bda84215864800EA7e6B03D') then 't-wust'
    when lower('0x5Fa464CEfe8901d66C09b85d5Fcdc55b3738c688') then 't-uni-lp'
    when lower('0xd4e7a6e2D03e4e48DfC27dd3f46DF1c176647E38') then 't-sushi-lp'
    when lower('0xe7a7D17e2177f66D035d9D50A7f48d8D8E31532D') then 't-ohm'
    when lower('0xD3B5D9a561c293Fb42b446FE7e237DaA9BF9AA84') then 't-alcx'
    when lower('0x15A629f0665A3Eb97D7aE9A7ce7ABF73AeB79415') then 't-tcr'
    when lower('0xADF15Ec41689fc5b6DcA0db7c53c9bFE7981E655') then 't-fxs'
    when lower('0xf49764c9C5d644ece6aE2d18Ffd9F1E902629777') then 't-sushi'
    when lower('0x808D3E6b23516967ceAE4f17a5F9038383ED5311') then 't-fox'
    when lower('0xDc0b02849Bb8E0F126a216A2840275Da829709B0') then 't-apw'
    when lower('0x2d3eADE781c4E203c6028DAC11ABB5711C022029') then 't-visr'
    when lower('0xeff721Eae19885e17f5B80187d6527aad3fFc8DE') then 't-snx'
    else null end as vault_name,
    amount_usd,
    'deposit' as event
    from ethereum.core.ez_token_transfers
    where from_address in (
    lower('0xD3D13a578a53685B4ac36A1Bab31912D2B2A2F36'), -- weth
    lower('0x04bDA0CF6Ad025948Af830E75228ED420b0e860d'), -- usdc
    lower('0x0ce34f4c26ba69158bc2eb8bf513221e44fdfb75'), -- dai
    Run a query to Download Data