kaibladeDaily Bond Transaction Volume
    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