Total Value Bonded Over Time

kaibladeTotal Value Bonded Over Time

Updated 2022-09-20

-- 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