block_timestamp::date as date,

LEFT(burn_asset, 3) as network,

SUM(rune_amount) as total_rune,

SUM(rune_amount_usd) as total_usd

FROM thorchain.upgrades

GROUP BY date, network

ORDER BY date