nsa2000Total Block Rewards USD
    Updated 2022-10-04
    SELECT
    -- date_trunc('week', day),
    sum(block_rewards * rune_price)

    FROM flipside_prod_db.thorchain.block_rewards
    LEFT outer JOIN (
    SELECT
    date_trunc('day', block_timestamp) as day1,
    median(LIQ_FEE_RUNE_USD/LIQ_FEE_RUNE) as rune_price
    FROM flipside_prod_db.thorchain.swaps
    where not LIQ_FEE_RUNE = 0
    GROUP BY 1
    ) ON day = day1
    --GROUP BY 1


    Run a query to Download Data