headitmanagerdaily
Updated 2022-05-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with daily as (select count(*) as count,block_timestamp::date as date from thorchain.update_node_account_status_events
where
(CURRENT_STATUS='Standby' or CURRENT_STATUS='Disabled') and FORMER_STATUS='Active'
group by date)
, weekly as (select count(*) as count,week(block_timestamp::date) as date from thorchain.update_node_account_status_events
where
(CURRENT_STATUS='Standby' or CURRENT_STATUS='Disabled') and FORMER_STATUS='Active'
group by date)
, monthly as (select count(*) as count,month(block_timestamp::date) as date from thorchain.update_node_account_status_events
where
(CURRENT_STATUS='Standby' or CURRENT_STATUS='Disabled') and FORMER_STATUS='Active'
group by date)
select * from daily
Run a query to Download Data