amin-zMy Marinade Staking in Context
Updated 2022-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('day',block_timestamp) as block_day,
date_trunc('hour',block_timestamp) as block_hour,
case when tx_id = '4vmrURXTyUHEvEwz8sbmrztqfYG8tTF7ePn9PecBcoPyb5DMsbWpurZhhWiE2ULh66US7TzhyKKTstTi3VvaZ7TS' then 'me'
else 'everyone else' end as staker,
count(*) as stake_count
from solana.events
where date_trunc('day', block_timestamp) = '2022-01-20 00:00:00.000'
and instruction:programId = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD'
And inner_instruction:instructions[0]:parsed:info:source = '7GgPYjS5Dza89wV6FpZ23kUJRG5vbQ1GM25ezspYFSoE'
and succeeded = TRUE
group by block_day, block_hour, staker;
Run a query to Download Data