adriaparcerisasThorchain bonds 2
Updated 2024-08-09
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
trunc(block_timestamp,'week') as date,
count(distinct to_address) as bonded_nodes,
count(distinct tx_id) as bonded_actions,
sum(bonded_actions) over (order by date) as total_bond_actions
from thorchain.defi.fact_bond_actions
where to_address in (
select
distinct node_address
from thorchain.gov.fact_new_node_events)
group by 1
order by 1 desc
QueryRunArchived: QueryRun has been archived