Query editor
WITHapi_response AS (SELECT json_parse(http_get(CONCAT('https://currency-api-cayg.onrender.com/api/exchange-rates?start_date=2025-01-01&end_date=', SUBSTRING(CAST(DATE_TRUNC('day', NOW()) AS varchar), 1, 10), '&symbols=MXN,BRL,ARS,COP,CLP,PEN'))) AS response),weekly_forex AS (SELECTDATE_TRUNC('week', CAST(JSON_EXTRACT_SCALAR(value, '$.day') AS date)) AS week,JSON_EXTRACT_SCALAR(value, '$.symbol') AS currency,AVG(CAST(JSON_EXTRACT_SCALAR(value, '$.price') AS double)) AS avg_priceFROM UNNEST (CAST((SELECT response FROM api_response) AS array(json))) AS t (value)GROUP BY DATE_TRUNC('week', CAST(JSON_EXTRACT_SCALAR(value, '$.day') AS date)), JSON_EXTRACT_SCALAR(value, '$.symbol')),stablecoin_currency_map AS (SELECT stablecoin, currencyFROM (VALUES-- ARS('ARST', 'ARS'), ('ARGt', 'ARS'), ('wARS', 'ARS'),-- BRL('BRZ', 'BRL'), ('BRL1', 'BRL'), ('BRLA', 'BRL'), ('cBRL', 'BRL'), ('wBRL', 'BRL'),-- COP('cCOP', 'COP'), ('COPM', 'COP'), ('wCOP', 'COP'),-- MXN('MXNB', 'MXN'), ('MXNE', 'MXN'), ('MXNT', 'MXN'), ('XOC', 'MXN'), ('wMXN', 'MXN'),-- CLP('CLPC', 'CLP'), ('CLPD', 'CLP'), ('wCLP', 'CLP'),-- PEN('wPEN', 'PEN')) AS t(stablecoin, currency)),token_info AS (SELECT'Base' AS chain, 0xe29410178928ecbf0f20203ede333aa6058c8767 AS contract_address, 'ARST' AS stablecoin, 18 AS decimalsUNION ALLSELECT 'Base', 0x0dc4f92879b7670e5f4e4e6e3c801d229129d90d, 'wARS', 18UNION ALLSELECT 'World', 0x0dc4f92879b7670e5f4e4e6e3c801d229129d90d, 'wARS', 18UNION ALLSELECT 'Base', 0xd76f5faf6888e24d9f04bf92a0c8b921fe4390e0, 'wBRL', 18UNION ALLSELECT 'World', 0xd76f5faf6888e24d9f04bf92a0c8b921fe4390e0, 'wBRL', 18UNION ALLSELECT 'Base', 0x337e7456b420bd3481e7fa61fa9850343d610d34, 'wMXN', 18UNION ALLSELECT 'World', 0x337e7456b420bd3481e7fa61fa9850343d610d34, 'wMXN', 18UNION ALLSELECT 'Base', 0x8a1d45e102e886510e891d2ec656a708991e2d76, 'wCOP', 18UNION ALLSELECT 'World', 0x8a1d45e102e886510e891d2ec656a708991e2d76, 'wCOP', 18UNION ALL