Query editor
-- Cross Chain Swap into Arbitrum Fees Split by Week(Destination Gas Fee, Bridge Fee, Swap Fee)-- Use WETH as ETH in prices.usd: https://dune.com/docs/data-tables/spellbook/top-tables/prices/#pricesusdWITHusdc_prices_usd AS (SELECTsymbol,price AS close_price,hourFROM(SELECTsymbol,price,minute,date_trunc('hour', minute) AS hour,ROW_NUMBER() OVER (PARTITION BYdate_trunc('hour', minute)ORDER BYminute DESC) AS rnFROMprices.usdWHEREblockchain = 'ethereum'AND symbol = 'USDC'AND minute >= TIMESTAMP '2024-01-01 00:00')WHERErn = 1),usdt_prices_usd AS (SELECTsymbol,price AS close_price,hourFROM(SELECTsymbol,price,minute,date_trunc('hour', minute) AS hour,ROW_NUMBER() OVER (PARTITION BYdate_trunc('hour', minute)ORDER BYminute DESC) AS rnFROMprices.usdWHEREblockchain = 'ethereum'AND symbol = 'USDT'AND minute >= TIMESTAMP '2024-01-01 00:00')WHERErn = 1),busd_prices_usd AS (