Query editor
WITH fee_incurring_swaps AS (SELECTDATE_TRUNC('day', block_time) AS block_date,SUM(amount_usd) AS fee_amount_usdFROM dune.sushi_labs.result_revenue_2_0_recordsWHERE block_time >= date_add('day', -1000, date_trunc('day', CURRENT_TIMESTAMP))AND transfer_type = 'SWAP_FEE'AND blockchain = 'arbitrum'GROUP BY 1)SELECTblock_date,SUM(fee_amount_usd) AS total_fe_fee_usdFROM fee_incurring_swapsGROUP BY block_dateORDER BY block_date DESC;