ADDRESS | TX_COUNT | LOCKED_AMOUNT | |
|---|---|---|---|
1 | 0xf187586275561f8ae8db94001a3088c8ac9195fe | 24 | 2513293.71362261 |
2 | 0xd007058e9b58e74c33c6bf6fbcd38baab813cbb6 | 6 | 1050000 |
3 | 0x0cc7cedb0935ceab0b4a6b38ee7dcfd403b19a7b | 10 | 687576.48931069 |
4 | 0x4cd35473b99125ec4a028081cec28aa2eb5eef84 | 48 | 500000.007316021 |
5 | 0x282be19f0d9870879ffbd4065fa35a9fa02560b8 | 11 | 351621.674831167 |
6 | 0xdaf5abd658722e374e48f4e742014af161358a11 | 7 | 319772.27649999 |
7 | 0x5a173642e34bc680ac3072c18e372a3f5d4c206f | 112 | 309134.138490676 |
8 | 0xacc884e01f6ed18e7313a0c480b389ffcd15e6e5 | 35 | 244151.952786211 |
9 | 0xf1d735c0d83c5dba51750539451d423cdbbd16ae | 3 | 200000 |
10 | 0x63e10765c0ba977e070c73c833b240cb4a5090e0 | 5 | 176354.53439267 |
11 | 0xe0dedcdb5b5ef2c82e4adc60aacc23486a518357 | 17 | 166227.268061467 |
12 | 0x344651a2445484bd2928eb46d2610daac1b42a66 | 7 | 162180.570739924 |
13 | 0xec4754393d505c617455afed988441fc3669c568 | 3 | 156527.78 |
14 | 0xb1ff8bf9c3a55877b5ee38e769e7a78cd000848e | 3 | 134094.053928959 |
15 | 0xe3e0352b9dcd62a8d514ffc7a4fc57d6eda66853 | 11 | 124164.673910822 |
16 | 0xcb36fd9bf9e6be4bb1af8e47dbf1f0e120f08435 | 13 | 115648.582007693 |
17 | 0x97a9fb8072af1bb71dc0388c1186a4b9f67db6ef | 1 | 109729.561204958 |
18 | 0xcde771cb4b774d9e78192d111ab45a34cf60e583 | 4 | 103139.107189678 |
19 | 0x8cdf1b6cfb693db9e171a1b9dda88c257e68638c | 1 | 101000 |
20 | 0x301ac3099ec0ac934e751dcec1a97cea2c33c94f | 1 | 100024.706434084 |
freemartianTop 50 STG Lockers
Updated 5 days ago
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
Last run: 5 days ago
50
3KB
461s