Query editor
WITHeth AS (SELECTDATE_TRUNC('hour', block_time) AS hour,SUM(CAST(amount_usd AS DOUBLE)) / 1e9 AS eth_bill_volFROMdex."trades" AS tWHEREt.blockchain = 'ethereum'AND block_time > NOW() - INTERVAL '5' yearGROUP BYhour),all AS (SELECTDATE_TRUNC('hour', block_time) AS hour,SUM(CAST(amount_usd AS DOUBLE)) / 1e9 AS all_bill_volFROMdex."trades" AS tWHEREblock_time > NOW() - INTERVAL '5' yearGROUP BYhour)SELECTeth.hour,eth.eth_bill_vol / all.all_bill_vol * 100 AS agg_shareFROMethJOINallONeth.hour = all.hourORDER BYeth.hour