zakkisyedUser Metrics Leaderboard
Updated 2024-05-09
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
34
35
36
›
⌄
-- forked from Raw Deposit Data @ https://flipsidecrypto.xyz/edit/queries/68dd6cf3-e5f3-4803-92e0-c572b8a4ba67
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'
),
raw_data as (
select * from eth_deposits
UNION ALL
select * from lst_deposits
ORDER BY 1 desc
)
QueryRunArchived: QueryRun has been archived