TX_HASH | BLOCK_TIMESTAMP | STAKE_ID | STAKER | BOBA_STAKED | |
|---|---|---|---|---|---|
1 | 0x31ab09b3c70f229726a9592592b1a12141ed1c4950148e29a3e9243a91e42c8e | 2025-02-25 10:41:41.000 | 1674 | 0x52edbd65166ddfb644a827a9944bd7f38373b424 | 949990 |
LittlerDataboba staking
Updated 2025-03-01
99
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
›
⌄
⌄
select
event_name
,count(*)
from boba.core.ez_decoded_event_logs
where contract_address = lower('0xa18bF3994C0Cc6E3b63ac420308E5383f53120D7')
group by 1
order by 2 desc
select
*
from boba.core.fact_event_logs
where 1=1
and block_timestamp > current_date - 5
and contract_address = '0x9fb3051148ff6efcd0b5ba0afa22eb0b9fc67a69'
and topic_0 = '0x0060a8caba85df807229fc2c649864fb5a7e4fe0f0582fb20615506e1a691cf9'
and tx_succeeded = 'TRUE'
and tx_hash = '0x31ab09b3c70f229726a9592592b1a12141ed1c4950148e29a3e9243a91e42c8e'
/*
select
min(block_timestamp) as first_tx
,max(block_timestamp) as last_tx
,current_timestamp
,timediff('minute', last_tx, current_timestamp)
from boba.core.fact_transactions
*/
Last run: 19 days ago
1
157B
3s