from aptos.core.fact_changes

where success

and change_type = 'write_resource'

and inner_change_type = '0x1::stake::StakePool'

and block_timestamp > current_date - 7

limit 10

select *

from aptos.core.fact_events

where tx_hash = '0xe9edbea4e0305c50e42db68a465e209641c928e411a7653be47f1ffadee4bb78'

and block_timestamp::date >= current_date - 1

select event_resource ,

count(1)

from aptos.core.fact_events

where event_address = '0xc0deb00c405f84c85dc13442e305df75d1288100cdd82675695f6148c7ece51c'

group by 1

select event_type,

count(1)

from aptos.core.fact_events

where block_timestamp::date >= current_date - 7

and event_data : pool_address = '0xa651c7c52d64a2014379902bbc92439d196499bcc36d94ff0395aa45837c66db'

group by 1

order by 2 desc

select event_module,

count(1)

from aptos.core.fact_events

where block_timestamp > current_date - 7