Query editor
WITH project as (SELECT project, date_trunc('day', block_time) as dt, count(*) as swaps, sum(usd_amount) as volumeFROM dune_user_generated."1inch_dextrades_byrouter_middle"WHERE block_time between '2022-05-01' and '2022-05-19'GROUP BY 1,2)SELECT p.dt, SUM(CASE WHEN project = '1inch' THEN volume ELSE 0 END) as "1inch", SUM(CASE WHEN project = 'Uniswap' THEN volume ELSE 0 END) as Uniswap, SUM(CASE WHEN project = 'Matcha' THEN volume ELSE 0 END) as Matcha, SUM(CASE WHEN project = '0x' THEN volume ELSE 0 END) as "0x", SUM(CASE WHEN project = 'Sushiswap' THEN volume ELSE 0 END) as Sushiswap, SUM(CASE WHEN project = 'Metamask' THEN volume ELSE 0 END) as Metamask, SUM(CASE WHEN project = 'Paraswap' THEN volume ELSE 0 END) as Paraswap-- , SUM(CASE WHEN project = 'MEV_bots' THEN volume ELSE 0 END) as MEV_bots, SUM(CASE WHEN project = 'small projects' THEN volume ELSE 0 END) as others-- , SUM(CASE WHEN project = 'unknown' THEN volume ELSE 0 END) as unknown, SUM(CASE WHEN project = 'Cowswap' THEN volume ELSE 0 END) as CowswapFROM project as pGROUP BY p.dt