Query editor
-- part of a query repo-- query name: Ethereum share of DEX volume 🍰-- query link: https://dune.com/queries/21693WITHeth AS (SELECTSUM(CAST(amount_usd AS DOUBLE)) / 1e9 AS eth_bill_volFROMdex."trades" AS tWHEREt.blockchain = 'ethereum'AND block_time > NOW() - INTERVAL '7' day),all AS (SELECTSUM(CAST(amount_usd AS DOUBLE)) / 1e9 AS all_bill_volFROMdex."trades" AS tWHEREblock_time > NOW() - INTERVAL '7' day)SELECTeth_bill_vol / all_bill_vol * 100 AS agg_shareFROMeth,all