NuveveCryptoArchivedParticipant Addresses
Updated 2022-09-21
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
28
29
›
⌄
with total as (
select
substring(memo, 6) as nodes
from flipside_prod_db.thorchain.bond_events
where bond_type = 'bond_paid'
),
classic as (
select
distinct(node_address) as nodes
from flipside_prod_db.thorchain.new_node_events
),
pooled as (
select
distinct(total.nodes) as nodes
from classic
right join total on classic.nodes = total.nodes
where classic.nodes is null
)
select
distinct(events.from_address) as participants
from flipside_prod_db.thorchain.bond_events as events
inner join pooled on substring(events.memo, 6) = pooled.nodes
where events.bond_type = 'bond_paid'
Run a query to Download Data