Crazy_KidNet Bonding Flow
    Updated 2022-05-10
    WITH paid AS (SELECT date_trunc('month',block_timestamp) as month1, sum(asset_usd) as bond_paid
    FROM thorchain.bond_actions
    WHERE bond_type = 'bond_paid'
    GROUP BY month1
    ORDER BY month1),

    returned AS (SELECT date_trunc('month',block_timestamp) as month2, sum(asset_usd) as bond_returned
    FROM thorchain.bond_actions
    WHERE bond_type = 'bond_returned'
    GROUP BY month2
    ORDER BY month2)

    SELECT month1 as month, bond_paid, bond_returned
    FROM paid JOIN returned ON month1 = month2
    Run a query to Download Data