Query editor
WITHeth_daily AS (SELECTDATE(block_time) AS date,SUM(CAST(amount_usd AS DOUBLE)) / 1e9 AS eth_bill_volFROMdex."trades" AS tWHEREt.blockchain = 'ethereum'AND block_time > NOW() - INTERVAL '2' yearGROUP BYDATE(block_time)),all_daily AS (SELECTDATE(block_time) AS date,SUM(CAST(amount_usd AS DOUBLE)) / 1e9 AS all_bill_volFROMdex."trades" AS tWHEREblock_time > NOW() - INTERVAL '2' yearGROUP BYDATE(block_time))SELECTe.date,eth_bill_vol / all_bill_vol * 100 AS agg_shareFROMeth_daily AS eJOINall_daily AS aONe.date = a.dateORDER BYe.date