rbn_vault_destination

maybeyonasrbn_vault_destination

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

flipside