allblocks AS

SELECT block_timestamp, block_id, POWER(10,-8) * SUM(emission) AS block_emission

FROM (

(SELECT block_timestamp, block_id, bond_e8 AS emission FROM thorchain.rewards_events)

UNION ALL

(SELECT block_timestamp, block_id, rune_e8 AS emission FROM thorchain.rewards_event_entries)

)

GROUP BY block_timestamp, block_id

),

rowcounting AS

SELECT

COUNT(allblocks.*) AS rowcount,

10000 AS target_rows

FROM allblocks

SELECT allblocks.*

FROM allblocks, rowcounting

QUALIFY (

(MOD((ROW_NUMBER() OVER(ORDER BY block_id ASC)), CEIL(rowcount/target_rows)) = 0)

--Row-sampling.

OR (ROW_NUMBER() OVER(ORDER BY block_id ASC) = 1)

--Include the first data point.

OR (ROW_NUMBER() OVER(ORDER BY block_id DESC) = 1)

--Include the last data point.

)

ORDER BY block_id DESC