maybeyonasrbn_net_deposits
Updated 2022-02-07
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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