synthquestEthereum Staking Table - account Filter
Updated 2024-09-12
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 mintshare_burnshare AS
(SELECT tx_hash,
block_number,
block_timestamp,
contract_address,
event_name,
decoded_log:account::VARCHAR AS "Wallet Address",
0 AS "Merged Escrowed Amount",
(CASE
WHEN event_name = 'Burn' THEN -1*decoded_log:amount::DECIMAL*1e-18
WHEN event_name = 'Mint' THEN decoded_log:amount::DECIMAL*1e-18
END) AS "Minted Amount",
event_index
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0x89fcb32f29e509cc42d0c8b6f058c993013a843f')
AND event_name IN ('Burn', 'Mint')
AND "Minted Amount" != 0
),
account_merge AS
(SELECT
tx_hash,
block_number,
block_timestamp,
contract_address,
event_name,
decoded_log:accountToMerge::VARCHAR AS "Wallet Address",
decoded_log:escrowAmountMerged::INTEGER * 1e-18 AS "Merged Escrowed Amount",
0 AS "Minted Amount",
0 AS "SDS Balance",
event_index
FROM
ethereum.core.ez_decoded_event_logs
WHERE
QueryRunArchived: QueryRun has been archived