DAY | NEW_LOCKS | TOPUPS | DAILY_LOCKED | TOP_LOCKERS | |
|---|---|---|---|---|---|
1 | 2024-12-16 00:00:00.000 | 0 | 1 | 7.418973604 | [
[
"0x0fc59c9c998537c940a9dfc7dacde533a9c496fe",
1
]
] |
2 | 2024-12-18 00:00:00.000 | 2 | 3 | 2058.092013804 | [
[
"0x822c9782f35c4bc34216588e96fd6451e8db80cf",
3
],
[
"0xa9a509d1a1f3218a0479829c2e57d02c2c4ac61b",
2
]
] |
3 | 2024-12-19 00:00:00.000 | 6 | 9 | 178019.086498924 | [
[
"0xf3d9a2cc135550a985b0a82ccb744c13971aed43",
4
],
[
"0x93bbf2b1ffe750fad9a83384e6c4fbca01401b03",
2
],
[
"0x00951c1d1241f9be0ef5a55a1755fa49c5629ebd",
2
],
[
"0x41aa7d375914ea1cb5a855642fc1924fd7e4ea17",
2
],
[
"0x492dd09622989c4cab4fade04928da893a55d127",
2
]
] |
4 | 2024-12-20 00:00:00.000 | 24 | 29 | 211574.077710983 | [
[
"0x24a3bde2bd95fe4c36894049e34501d340d9fd56",
4
],
[
"0xf3d9a2cc135550a985b0a82ccb744c13971aed43",
3
],
[
"0x7a4115f70d0d0f0a373e58a957696f850748cd94",
3
],
[
"0xa48cd684ded1eee3de13e052bbdcfed59558a1ca",
2
],
[
"0x90e7d024ba936b2648aa08bf5bcdcfe800ae59e0",
2
]
] |
5 | 2024-12-21 00:00:00.000 | 30 | 36 | 387746.808432799 | [
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0xd9998ff1efc1a9f202ffd7f0e2d57b37dc9eb3f2",
3
],
[
"0x82ca345c167bdcad56fbedc7cc85a488885bdadc",
3
],
[
"0x24a3bde2bd95fe4c36894049e34501d340d9fd56",
3
],
[
"0xac5e9b73ee39c9fedd861199464b71b799462356",
3
]
] |
6 | 2024-12-22 00:00:00.000 | 41 | 52 | 783818.710923617 | [
[
"0x081854783fc14497093c2759f67fad196c39bb37",
4
],
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0x7692a4436f8252f34258c2bfa846ec5e840d5e55",
3
],
[
"0x5161c6cdea429719be8a5ceca7a960b55a3f3a86",
3
],
[
"0x73860dc8055a36199fa017e4d9b6584e1497df85",
3
]
] |
7 | 2024-12-23 00:00:00.000 | 35 | 47 | 545524.242524405 | [
[
"0x82ca345c167bdcad56fbedc7cc85a488885bdadc",
3
],
[
"0xb615a04a4fb67613086271ec7a16070fb7ff0045",
3
],
[
"0x6c01410a6bd1cd99b4fae029012ce12c9deb7a22",
3
],
[
"0xe1685a3d1ae79b7c85829fcce57d62a02eac61a5",
3
],
[
"0x4c3fa36a3c10fd7a8cd3530a4a9ac6cb7aa341cc",
3
]
] |
8 | 2024-12-24 00:00:00.000 | 41 | 54 | 978901.795310333 | [
[
"0x41501185c3a4e79a33bc48aff202b86f5ac35034",
4
],
[
"0x212514e0c3caffe485eafbd625775af5e792c16b",
4
],
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0x82ca345c167bdcad56fbedc7cc85a488885bdadc",
4
],
[
"0x08a1d63589a52455e90ca1ec01c8d48c54a84ed0",
3
]
] |
9 | 2024-12-25 00:00:00.000 | 48 | 112 | 367986.891697334 | [
[
"0xd4f23afeacfc05399e58e122b9a23cd04fa02c3b",
41
],
[
"0xae75b29ade678372d77a8b41225654138a7e6ff1",
15
],
[
"0xbfb1ac13b6720bdd7a8a61b949bd3a8b869b871b",
4
],
[
"0xcaead7a458295cd78c76bc1404e75984643cfc21",
3
],
[
"0xdd9bf0a45452a4f22cfd2c963c15b191d97ce106",
3
]
] |
10 | 2024-12-26 00:00:00.000 | 50 | 168 | 738193.059984624 | [
[
"0xd4f23afeacfc05399e58e122b9a23cd04fa02c3b",
88
],
[
"0xae75b29ade678372d77a8b41225654138a7e6ff1",
19
],
[
"0x772fbc095311d98e66470f34ed3fd9df3db7a6f2",
5
],
[
"0x3c8653496e3a9eb2ffbab931eb5067f126b6a9cd",
4
],
[
"0x2b2ca9d399919505d05107579d7984cf613575d3",
4
]
] |
11 | 2024-12-27 00:00:00.000 | 52 | 82 | 774042.542669571 | [
[
"0xd4f23afeacfc05399e58e122b9a23cd04fa02c3b",
18
],
[
"0xae75b29ade678372d77a8b41225654138a7e6ff1",
6
],
[
"0x82d1afc8d2f2b6eceacc3be156456eeab2c15368",
4
],
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0xefb1f0dd64ca69bddeb01da4b7c244e752ed45a9",
3
]
] |
12 | 2024-12-28 00:00:00.000 | 56 | 89 | 511919.016984164 | [
[
"0xd4f23afeacfc05399e58e122b9a23cd04fa02c3b",
19
],
[
"0xae75b29ade678372d77a8b41225654138a7e6ff1",
6
],
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0x219ea7a661c3701ee0646a14e1952d150c3e588a",
4
],
[
"0xdfffaeeaabf1140d1ddf98a7138b96cf1e63a08b",
4
]
] |
13 | 2024-12-29 00:00:00.000 | 66 | 104 | 428183.653605125 | [
[
"0xd4f23afeacfc05399e58e122b9a23cd04fa02c3b",
21
],
[
"0x24a3bde2bd95fe4c36894049e34501d340d9fd56",
5
],
[
"0xae75b29ade678372d77a8b41225654138a7e6ff1",
5
],
[
"0xaef0971103ab159d1f86efa8b94248459ace0e3a",
4
],
[
"0x9ac56a110122237cc03efa0b3eea277db13bf6d5",
3
]
] |
14 | 2024-12-30 00:00:00.000 | 60 | 118 | 1929873.43246587 | [
[
"0xd4f23afeacfc05399e58e122b9a23cd04fa02c3b",
41
],
[
"0xae75b29ade678372d77a8b41225654138a7e6ff1",
8
],
[
"0x2b586923147f059fe737e9d83a211009ef5a2997",
4
],
[
"0xba77e0b03b41a980bb4e7bb32ec7a2dfe1b66f8f",
3
],
[
"0x2b10978b45cf1b05f69c556e59a687ca6532a806",
3
]
] |
15 | 2024-12-31 00:00:00.000 | 96 | 168 | 1888216.32648761 | [
[
"0xd4f23afeacfc05399e58e122b9a23cd04fa02c3b",
36
],
[
"0xae75b29ade678372d77a8b41225654138a7e6ff1",
9
],
[
"0xbba047ae12a0d720adc6afe6011a7d3f380e6f76",
7
],
[
"0x9ec348ce283e03f5f16e72285575bd0caa924f6b",
5
],
[
"0x714f51383b0d593cac9ff567faa47f20bedad1ad",
5
]
] |
16 | 2025-01-01 00:00:00.000 | 88 | 112 | 2028332.95994201 | [
[
"0xf540a4bd153fc1b740102d07569a0d24d995990d",
5
],
[
"0x059597069fa55108a8375714061dc85c3f1ece32",
4
],
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0xb18dacf8937dcd595ac19f3ca4390e5a411b2eae",
3
],
[
"0x7a385430cfbfa0550d43ed6532def1ca88f5d6d3",
3
]
] |
17 | 2025-01-02 00:00:00.000 | 109 | 137 | 686563.717088208 | [
[
"0xcdc4e6005bb465c45e4d29ef8100f73364eacc1f",
5
],
[
"0x594553b39699e8b8fec157eca2e26d27d86efc71",
4
],
[
"0x082be917c616c7216a798e915671332a1a3c2d33",
4
],
[
"0x1425c312b3ae2f7d01dffa87e56d1fa565172f16",
4
],
[
"0xcb173738313a3237b24124fa09377ca515515899",
3
]
] |
18 | 2025-01-03 00:00:00.000 | 80 | 94 | 429772.439551416 | [
[
"0x41501185c3a4e79a33bc48aff202b86f5ac35034",
4
],
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0x0ba709b2f600a98732fb8df6d39b0585fce583a4",
3
],
[
"0x2e8fba7125cfad75b8bc750832b06acae9729b16",
3
],
[
"0x825f23921dcff36944d8b0b0ca23ac7d05fb86cb",
3
]
] |
19 | 2025-01-04 00:00:00.000 | 62 | 75 | 344562.624295591 | [
[
"0x41501185c3a4e79a33bc48aff202b86f5ac35034",
5
],
[
"0x70a99c4127620129d0ca30827e0fc9b75ec2891b",
4
],
[
"0x891da613d26ef051eca35ea337428c514d271c98",
3
],
[
"0x3c5501066f049bf00d4c851fad3ee345c8961484",
3
],
[
"0x568f94d11ce0b5a6bf2d9d3fdff42eace811b91c",
3
]
] |
20 | 2025-01-05 00:00:00.000 | 50 | 63 | 195071.599395619 | [
[
"0xca63a21562dae4472bb15351aee25522e0a14d75",
5
],
[
"0xccd724b9af92a3a389150334556330efd3f59487",
4
],
[
"0x41501185c3a4e79a33bc48aff202b86f5ac35034",
3
],
[
"0x10447f93ce6990d5c0192fa79ad6cb4187b8bf22",
3
],
[
"0xa8e7a4e45c5b4d1abfdb25c3175b15ff25bb232a",
3
]
] |
permarydaily locks + lockers
Updated 2025-04-05
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
raw_logs as (
select * from swell.core.fact_event_logs
where lower(contract_address) in (
'0xda1f8ea667dc5600f5f654df44b47f1639a83dd1', -- reward token
'0x2826d136f5630ada89c1678b64a61620aab77aea' -- swell token
) and lower(topic_0) in (
'0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef', -- transfer
'0x68f4429ffe70afd17cd51d3c12265a7698579e0dc36b7099e2f6d5263e739d39', -- lockcreated
'0x5981e4d35a45c9e8c96ae51ca0f24127eaad820537621c89bbe1ba8b1712b61b' -- lockremoved
)
),
decoded_transfers as (
select
block_timestamp, block_number, tx_hash, event_index, contract_address,
'0x' || substring(topic_1, 27, 40) as from_address,
'0x' || substring(topic_2, 27, 40) as to_address,
ethereum.public.udf_hex_to_int(data)/pow(10,18) as amount
from raw_logs
where lower(topic_0) = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- transfer
),
decoded_locks as (
select
block_timestamp, block_number, tx_hash, event_index, contract_address,
case when lower(topic_0) = '0x68f4429ffe70afd17cd51d3c12265a7698579e0dc36b7099e2f6d5263e739d39'
then 'create'
else 'remove'
end as event,
'0x' || substring(topic_1, 27, 40) as account,
ethereum.public.udf_hex_to_int(data) as lock_timestamp
from raw_logs
where lower(topic_0) in (
'0x68f4429ffe70afd17cd51d3c12265a7698579e0dc36b7099e2f6d5263e739d39', -- lockcreated
'0x5981e4d35a45c9e8c96ae51ca0f24127eaad820537621c89bbe1ba8b1712b61b' -- lockremoved
)
),
Last run: 2 months ago
...
110
32KB
2s