c2ctrader03-Comparison Rewards for Some of the Most Important Pools in the First 30 Days (Pivot Result)
    Updated 2022-04-20
    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

    Run a query to Download Data