DT | N_SEARCHERS_PER_STAKE | |
|---|---|---|
1 | 2025-04-06 00:00:00.000 | 9.75993804e-7 |
2 | 2025-04-04 00:00:00.000 | 0.001476272925 |
3 | 2025-03-30 00:00:00.000 | 0.001053888535 |
4 | 2025-03-27 00:00:00.000 | 0.00002659155064 |
5 | 2025-04-03 00:00:00.000 | 0.001404761364 |
6 | 2025-03-29 00:00:00.000 | 3.282907486e-7 |
7 | 2025-04-01 00:00:00.000 | 0.000002942729945 |
8 | 2025-03-26 00:00:00.000 | 6.61290586e-7 |
9 | 2025-03-26 00:00:00.000 | 0.002054299205 |
10 | 2025-04-03 00:00:00.000 | 0.00000195922087 |
11 | 2025-03-26 00:00:00.000 | 0.000003967743516 |
12 | 2025-04-08 00:00:00.000 | 0.000002924394639 |
13 | 2025-04-05 00:00:00.000 | 0.001131176819 |
14 | 2025-03-23 00:00:00.000 | 0.001413033657 |
15 | 2025-04-08 00:00:00.000 | 9.74798213e-8 |
16 | 2025-03-21 00:00:00.000 | 3.32975486e-7 |
17 | 2025-03-29 00:00:00.000 | 0.00001276845383 |
18 | 2025-04-08 00:00:00.000 | 0.00005937498157 |
19 | 2025-03-30 00:00:00.000 | 4.91094378e-7 |
20 | 2025-04-09 00:00:00.000 | 0.002430881598 |
MostlyData_MEV Tippers
Updated 2025-04-10
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 date_filter as (
select
case
when {{n_days}} != 0 then dateadd(day, -{{n_days}}, current_date())
else to_timestamp('{{start_date}}')
end start_date,
case
when {{n_days}} != 0 then current_date()
else to_timestamp('{{end_date}}')
end end_date
)
,validators_pubkeys as (
select column1 as pubkey
from values
-- Control set start --
('HEL1USMZKAL2odpNBj2oCjffnFGaYwmbGmyewGv1e2TU'), -- Helius
('DRpbCBMxVnDK7maPM5tGv6MvB3v1sRMC86PZ8okm21hy'), -- Binance
('DtdSSG8ZJRZVv5Jx7K1MeWp7Zxcu19GD5wQRGRpQ9uMF'), -- Galaxy
('q9XWcZ7T1wP4bW9SB4XgNNwjnFEJ982nE8aVbbNuwot'), -- Ledger by Figment
('Fd7btgySsrjuo25CJCj7oE7VPMyezDhnx7pZkj2v69Nk'), -- Figment
('ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n'), -- Chorus One
('DWvDTSh3qfn88UoQTEKRV2JnLt5jtJAVoiCo3ivtMwXP'), -- P2P.org
('DTSUkYHd2e9P2HLyZfbLarsbDdPhQUhZnWjRYuJZQRC8'), -- Temporal
--('2abwQG3v2xRemFxRszVHSfnjJNe9zu5X8duKgxjyLeaK'), -- C1 Research
-- Control set end --
-- Test set start --
('5pPRHniefFjkiaArbGX3Y8NUysJmQ9tMZg3FrFGwHzSm'), -- Kiln1
('EvnRmnMrd69kFdbLMxWkTn1icZ7DCceRhvmb2SJXqDo4'), -- Everstake
('BtsmiEEvnSuUnKxqXj2PZRYpPJAc7C34mGz8gtJ1DAaH'), -- Coinbase
('7Zm1pE4FubFYZDyAQ5Labh3A4cxDcvve1s3WCRgEAZ84'), -- test 7Z
('91oPXTs2oq8VvJpQ5TnvXakFGnnJSpEB6HFWDtSctwMt'), -- Stronghold
('Awes4Tr6TX8JDzEhCZY2QVNimT6iD1zWHzf1vNyGvpLM'), -- Staking Facilities
('ACvL73V4GNnxPVfZ7K89jCrYurLyzpEuE9qirjvh2Xmi') -- test AC
-- Test set end --
Last run: 18 days ago
58
2KB
31s