zakkisyedRaw Deposit Data
Updated 2024-05-13
99
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
›
⌄
with eth_deposits as (
select block_timestamp,
decoded_log:depositor as user,
'ETH' as asset,
decoded_log:depositAmount/pow(10,18) as deposit_amt,
tx_hash
from ethereum.core.ez_decoded_event_logs
where contract_address = '0x036676389e48133b63a802f8635ad39e752d375d'
AND event_name = 'ETHDeposit'
AND block_timestamp >= '2024-05-08 04:30:00.000'
),
lst_deposits as (
select block_timestamp,
decoded_log:depositor as user,
CASE WHEN decoded_log:asset = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' THEN 'stETH'
WHEN decoded_log:asset = '0xa35b1b31ce002fbf2058d22f30f95d405200a15b' THEN 'ETHx'
WHEN decoded_log:asset = '0xac3e018457b222d93114458476f3e3416abbe38f' THEN 'sfrxETH'
END AS asset,
decoded_log:depositAmount/pow(10,18) as deposit_amt,
tx_hash
from ethereum.core.ez_decoded_event_logs
where contract_address = '0x036676389e48133b63a802f8635ad39e752d375d'
AND event_name = 'AssetDeposit'
AND block_timestamp >= '2024-05-08 04:30:00.000'
)
select * from eth_deposits
UNION ALL
select * from lst_deposits
ORDER BY 1 desc