freemartianTest
Updated 2024-06-06
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
›
⌄
-- 0.2 STG Increase_amount: 0x87d1240f39965bd04c02383190a7e30560766dd24ab6443fd5fe7fe283ce8d51
-- 0.1 STG(1month) Increase_amount_and_time: 0x505801c8f9319e2e091fa7284a240777a47d80864591d8585662f5bbc7879f7e
-- only increase lock time (1 month): 0x3b5db6fb6779dd71d081734feaccb49c7528d6964efdf65da3118e5e1b6d0206
-- Deposit 0x65fc3873 => Create_lock
-- Deposit 0xeff7a612 => Increase_unlock_time
-- Deposit 0x4957677c => Increase_amount
-- {Deposit 0x7142a6a6 => Increase_amount_and_time}
-- {Deposit 0x2371eb23 => Withdraw_and_create_lock
-- Withdraw 0x2371eb23 => Withdraw_and_create_lock}
-- Withdraw 0x3ccfd60b => withdraw()
with datas AS
(
SELECT
block_timestamp,
tx_hash,
origin_from_address AS wallet_address,
event_name,
(CASE
WHEN origin_function_signature = '0x65fc3873' THEN 'Create_lock'
WHEN origin_function_signature = '0xeff7a612' THEN 'Increase_unlock_time'
WHEN origin_function_signature = '0x4957677c' THEN 'Increase_amount'
WHEN origin_function_signature = '0x7142a6a6' THEN 'Increase_amount_and_time'
WHEN origin_function_signature = '0x2371eb23' THEN 'Withdraw_and_create_lock'
WHEN origin_function_signature = '0x3ccfd60b' THEN 'withdraw'
END) AS function,
(CASE
WHEN event_name = 'Withdraw' THEN -decoded_log:value * POW(10, -18)
WHEN event_name = 'Deposit' THEN decoded_log:value * POW(10, -18)
END
QueryRunArchived: QueryRun has been archived