zakkisyedUser Distribution based on deposit amount
Updated 2024-01-22
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
›
⌄
WITH blast_deposit_indexer AS (
SELECT
block_timestamp,
tx_hash,
event_name,
decoded_log:amount / POWER(10, 18) AS amount,
decoded_log:shares AS shares,
decoded_log:user AS user,
CASE
WHEN event_name = 'USDDeposited' THEN decoded_log:daiAmount / POWER(10, 18)
ELSE 0
END AS dai_amount,
CASE
WHEN event_name = 'ETHDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0x3265aead' THEN 'stETH'
WHEN event_name = 'ETHDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0xf6326fb3' THEN 'ETH'
WHEN event_name = 'USDDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0x365833e1' THEN 'DAI'
WHEN event_name = 'USDDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0xf688bcfb' THEN 'USDC'
WHEN event_name = 'USDDeposited' AND ORIGIN_FUNCTION_SIGNATURE = '0x0a553dcb' THEN 'USDT'
WHEN event_name = 'ETHDeposited' THEN 'ETH'
WHEN event_name = 'USDDeposited' THEN 'DAI'
END AS token_type
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d'
AND block_timestamp > '2023-11-17'
AND event_name IN ('USDDeposited', 'ETHDeposited')
AND tx_status = 'SUCCESS'
),
eth_prices_hourly AS (
SELECT
symbol,
price,
hour
FROM ethereum.price.ez_hourly_token_prices
WHERE hour >= TIMESTAMP '2023-11-17'
AND symbol = 'stETH'
AND token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
QueryRunArchived: QueryRun has been archived