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 --