flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
number of bonding node addresses by node operators
Delamir-6014
number of bonding node addresses by node operators
Updated 2022-09-20
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
select
BLOCK_TIMESTAMP
::
date
as
date
,
FROM_ADDRESS
as
node_operator
,
count
(
split_part
(
memo
,
':'
,
2
)
)
as
number
from
flipside_prod_db
.
thorchain
.
bond_events
where
bond_type
=
'bond_paid'
group
by
1
,
2
order
by
3
Results
Run a query to Download Data