DATE | ADDRESS | CAP_LABEL | INTERACT | |
|---|---|---|---|---|
1 | 2024-02-12 00:00:00.000 | 1 | Openbook | 11 |
2 | 2024-02-12 00:00:00.000 | 1 | Orca | 3 |
3 | 2024-02-12 00:00:00.000 | 42 | Saga Monkes | 632 |
4 | 2024-02-12 00:00:00.000 | 1 | Metaplex | 2 |
5 | 2024-02-12 00:00:00.000 | 1 | Incinerator | 5 |
6 | 2024-02-12 00:00:00.000 | 4 | Jupiter | 19 |
7 | 2024-02-12 00:00:00.000 | 1 | Jito Mev | 29 |
8 | 2024-02-12 00:00:00.000 | 1 | Serum | 1 |
9 | 2024-02-11 00:00:00.000 | 1 | Jito Mev | 29 |
10 | 2024-02-11 00:00:00.000 | 1 | Metaplex | 2 |
11 | 2024-02-11 00:00:00.000 | 24 | Saga Monkes | 533 |
12 | 2024-02-11 00:00:00.000 | 4 | Jupiter | 15 |
13 | 2024-02-11 00:00:00.000 | 1 | Incinerator | 1 |
14 | 2024-02-10 00:00:00.000 | 1 | Jito Mev | 23 |
15 | 2024-02-10 00:00:00.000 | 1 | Star Atlas | 6 |
16 | 2024-02-10 00:00:00.000 | 4 | Jupiter | 5 |
17 | 2024-02-10 00:00:00.000 | 16 | Saga Monkes | 595 |
18 | 2024-02-09 00:00:00.000 | 1 | Raydium | 1 |
19 | 2024-02-09 00:00:00.000 | 1 | Star Atlas | 3 |
20 | 2024-02-09 00:00:00.000 | 1 | Jito Mev | 29 |
LTirrelltop_stakers_interactions
Updated 2024-02-13
9999
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
›
⌄
select
DATE_TRUNC('day', block_timestamp) as date,
count(distinct t.signers[0]) as address,
initcap(l.label) as cap_label,
count(l.label) as interact
from
solana.core.fact_transactions t
join solana.core.dim_labels l on t.instructions[0]:programId = l.address
where
t.block_timestamp::date between CURRENT_DATE - 91 and CURRENT_DATE - 1
and l.label_subtype != 'token_contract'
and l.label != 'solana'
and t.succeeded = TRUE
and t.signers[0] in ( --from list of all top stakers
'12Euh1pmCycRLq4grkyY7VDubawWJKXxbX9FJQAs4hZy',
'12qzhTmTD45otivVHVJPiEUk1Zqfoy37mNeZVNXzejyX',
'13AMgNUoQtFv921xPPmRfCwvjonVwcnAtKmANcLAfm4w',
'13Ti94G8MSFMEonBbT74TP7rC4kPXHyKF6mSq8PjHCW4',
'13dure57EBjfdeA8tbFUuuv5VAzYiuKVw1aHTFutCBTt',
'13f81bVwCp5HtLogKdXdshieYzxm7HgHtoMdWDqSFwcA',
'13sfSyYJs9YzDbbnUuMZZ1U9Tp7WE3cBtqYe6Pngbbnz',
'146izAJD1S8FJ7extmvyXrnLiqpfbNvQkU2YgqFQ894L',
'16P5okwg1NHWd7MvvBY42bAYv81Rb4xwEjyKV1UwJ5C',
'223ufrwUhrdybUrU7ozVBWEHeJRTyGex8Mpxno8hvx4P',
'22PH69vdWZK1CEPC5C5zDkZmo3zByBa1eCLHiCFKHDhY',
'22XPnCiP1Atj7PM67LABqLAXvMNzQNN6GJF1p6fQJAcS',
'22ZvZFFVEtY4esUDUHsdJmSFCPHsWRYaWGuhkPGEmCXT',
'23XLvYAxwcdkv5w5NSGUJLa8AMPoCjgrG9Y136Y3ii85',
'2415XKAZvjx1RyXoHGW8CzsycChLoh4FZBUP3QBGZUXi',
'24KcsFW1EKZCqPmVY4NpkxQhJgcK46qdNDrmAPY8ZDHq',
'25Mat1VgJ4WMbBwL8zog5ZtBYniRmfBa9JqssuziSprJ',
'25QVxybehwyacVRBrYkztcb8Xa2cEBi2bjiEN8DLsV3S',
'25TkcVshzz82FEgfdHSLdsJB68eeJ7fvrJfAjJ5PhAVA',
'25omuonwEaL9jUdJYNUki7KjdxxH3L6iyWPmfvXa8xRe',
'2665M9KvM7bg6oHi2cNfUpTVvvpvk3r4prVqtttN4BTm',
'26H113i8gqHyHPAYYdekSu22sBmVtcJEDtyEWvFdvyZb',
Last run: about 1 year ago
...
599
26KB
958s