Multipartite2022-11-23 RUNE emitted by date
    Updated 2022-11-23
    WITH
    bond_emission AS (
    SELECT DATE(block_timestamp) AS date, bond_e8 AS rune_e8
    FROM thorchain.rewards_events
    ),

    pool_emission AS (
    SELECT DATE(block_timestamp) AS date, rune_e8
    FROM thorchain.rewards_event_entries
    )

    SELECT date, POWER(10,-8) * SUM(rune_e8) AS emitted_rune
    FROM (
    (SELECT * FROM bond_emission)
    UNION ALL
    (SELECT * FROM pool_emission)
    )
    GROUP BY date
    QUALIFY date <> MAX(date) OVER()
    ORDER BY date DESC
    Run a query to Download Data