Query editor
WITH token_dataset AS (SELECT address, name, currency, decimals, regionFROM (VALUES(0x269caE7Dc59803e5C596c95756faEeBb6030E0aF,'MXNE','MXN', 6, 'Mexico'),(0x18Bc5bcC660cf2B9cE3cd51a404aFe1a0cBD3C22,'IDRX','IDR', 2, 'Indonesia'),(0x46C85152bFe9f96829aA94755D9f915F9B10EF5F,'CNGN','NGN', 6, 'Nigeria'),(0xe743f13623e000261b634f0e5676f294475ec24d,'NGNC','NGN', 18, 'Nigeria'),(0xb755506531786C8aC63B756BaB1ac387bACB0C04,'ZARP','ZAR', 18, 'South Africa'),(0x2dD087589ce9C5b2D1b42e20d2519B3c8cF022b7,'NZDD','NZD', 6, 'New Zealand'),(0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42,'EURC','EUR', 6, 'EU'),(0x4933a85b5b5466fbaf179f72d3de273c287ec2c2,'EURAU','EUR', 6, 'EU'),(0x043eB4B75d0805c43D7C834902E335621983Cf03,'CADC','CAD', 18, 'Canada'),(0xE9185Ee218cae427aF7B9764A011bb89FeA761B4,'BRZ','BRL', 18, 'Brazil'),(0x1a9be8a692de04bcb7ce5cddd03afca97d732c62,'TRYB','TRY', 8, 'Turkey'),(0xFb8718a69aed7726AFb3f04D2Bd4bfDE1BdCb294,'TRYB','TRY', 6, 'Turkey'),(0x4ed9df25d38795a47f52614126e47f564d37f347,'VEUR','EUR', 18, 'EU'),(0x1fca74d9ef54a6ac80ffe7d3b14e76c4330fd5d8,'VCHF','CHF', 18, 'Switzerland'),(0xaeb4bb7debd1e5e82266f7c3b5cff56b3a7bf411,'VGBP','GBP', 18, 'UK'),(0x27f6c8289550fce67f6b50bed1f519966afe5287,'TGBP','GBP', 18, 'UK'),(0xe29410178928ecbf0f20203ede333aa6058c8767,'ARST','ARS', 18, 'Argentina'),(0xf016413834E6D1A14F3D628B11D6Ef725a6bdbDD,'ARGT','ARS', 18, 'Argentina'),(0x449b3317a6d1efb1bc3ba0700c9eaa4ffff4ae65,'AUDD','AUD', 6, 'Australia'),(0xdC200537D99d8b4f0C89D59A68e29b67057d2c5F,'THBT','THB', 6, 'Thailand'),(0xfCB34c47f850f452C15EA1B84d51231C38A61783,'BRLA','BRL', 18, 'Brazil'),(0x57323Db6d883811C17877d075e05AD9E2ED41519,'BRLY','BRL', 18, 'Brazil'),(0xd2a530170D71a9Cfe1651Fb468E2B98F7Ed7456b,'AUDF','AUD', 6, 'Australia'),(0x0DC4F92879B7670e5f4e4e6e3c801D229129D90D,'wARS','ARS', 18, 'Argentina'),(0x3eD03E95DD894235090B3d4A49E0C3239EDcE59e,'MYRC','MYR', 18, 'Malaysia'),(0x2A2f398d4DCeEB02d66a1BfFd6FaF1EAFa2318C9,'UGXC','UGX', 6, 'Uganda'),(0x0A4C9cb2778aB3302996A34BeFCF9a8Bc288C33b,'XSGD','SGD', 6, 'Singapore'),(0xF476BA983DE2F1AD532380630e2CF1D1b8b10688,'nTZS','TZS', 18, 'Tanzania'),(0xCf3783ABaF4A11da1382F0c49748Fa87a1b6b739,'MXNB','MXN', 18, 'Mexico'),(0x8a1d45e102e886510e891d2ec656a708991e2d76,'WCOP','COP', 18, 'Columbia'),(0x4F34c8b3b5FB6D98Da888F0feA543d4d9C9F2eBE,'WPEN','PEN', 18, 'Peru'),(0x61D450a098b6a7f69fC4b98CE68198fe59768651,'WCLP','CLP', 18, 'Chile'),(0x6d7432114c148a8975906716b9d3ddac6bb83cf1,'ARSX','ARS', 6, 'Argentina')) AS t(address, name, currency, decimals, region)),onchain_price AS (SELECTCAST(timestamp AS DATE) AS day,td.name AS symbol,td.currency,AVG(price) AS token_price_usdFROM prices.day pINNER JOIN token_dataset tdON p.contract_address = td.addressWHERE p.blockchain = 'base'AND p.timestamp BETWEENtimestamp '2026-01-01'AND timestamp '2026-03-31'GROUP BY 1,2,3),fx_prices AS (SELECTCAST(date AS DATE) AS day,