SELECT * FROM (
SELECT
date_trunc('day',block_timestamp) day,
pool_name,
sum(rune_e8) reward_pool
FROM
(select * from thorchain.rewards_event_entries where block_timestamp<=dateadd('day',30,(select min(block_timestamp) from thorchain.rewards_event_entries)) )
group by day,POOL_NAME
order by day,POOL_NAME
)
PIVOT (
SUM(reward_pool)
FOR pool_name
IN (
'BCH.BCH',
'BNB.BNB',
'BTC.BTC',
'DOGE.DOGE',
'ETH.ETH',
'LTC.LTC',
'TERRA.LUNA',
'TERRA.UST'
)
) AS PivotTable