freemartianWallet Rank in Lock Amount
Updated 2023-11-03
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 ethereum AS(
SELECT
block_timestamp::date AS timestamp,
tx_hash,
origin_from_address AS wallet_address,
(CASE
WHEN event_name = 'Withdraw' THEN -decoded_log:value * POW(10, -18)
WHEN event_name = 'Deposit' THEN decoded_log:value * POW(10, -18)
END
) AS supply,
TO_TIMESTAMP(decoded_log:locktime)::date AS lock_time,
TIMEDIFF('month',timestamp,lock_time) AS lock_monthes,
'Ethereum' AS label
FROM
ethereum.core.ez_decoded_event_logs
WHERE
contract_name = 'veSTG'
AND event_name in ('Deposit','Withdraw')
ORDER BY block_timestamp DESC
),
optimism AS (
SELECT
block_timestamp::date AS timestamp,
tx_hash,
origin_from_address AS wallet_address,
(CASE
WHEN event_name = 'Withdraw' THEN -decoded_log:value * POW(10, -18)
WHEN event_name = 'Deposit' THEN decoded_log:value * POW(10, -18)
END
) AS supply,
TO_TIMESTAMP(decoded_log:locktime)::date AS lock_time,
TIMEDIFF('month',timestamp,lock_time) AS lock_monthes,
'Optimism' AS label
FROM
optimism.core.ez_decoded_event_logs
WHERE
Run a query to Download Data