kaibladeDaily Bond Transaction Volume
Updated 2022-09-20
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
30
31
32
33
34
35
36
›
⌄
WITH event_data AS
(
SELECT *
FROM flipside_prod_db.thorchain.bond_events
WHERE memo !=''
ORDER BY block_timestamp DESC
),
combined_data AS
(SELECT events.block_timestamp, events.tx_id, events.from_address,
events.to_address, SPLIT(events.memo,':') AS memo_list, events.bond_type, actions.asset_amount
FROM flipside_prod_db.thorchain.bond_actions actions
JOIN event_data events
ON events.tx_id = actions.tx_id
WHERE events.block_timestamp::date >= '2022-03-23'
ORDER BY events.block_timestamp),
raw_data AS
(SELECT block_timestamp,
tx_id,
from_address,
memo_list,
memo_list[1] AS node_address,
bond_type,
asset_amount
FROM combined_data
),
valid_nodes AS(
SELECT DISTINCT(node_address) AS nodes,
from_address AS node_operators
FROM raw_data
WHERE ARRAY_SIZE(memo_list)=3
AND bond_type = 'bond_paid'
Run a query to Download Data