WITH chains AS (

SELECT 81457 AS chain_id, 'Blast' AS chain_name UNION

SELECT 534352 AS chain_id, 'Scroll' AS chain_name UNION

SELECT 5000 AS chain_id, 'Mantle' AS chain_name UNION

SELECT 34443 AS chain_id, 'Mode' AS chain_name UNION

SELECT 30 AS chain_id, 'Rootstock' AS chain_name UNION

SELECT 1313161554 AS chain_id, 'Aurora' AS chain_name UNION

SELECT 288 AS chain_id, 'Boba' AS chain_name UNION

SELECT 122 AS chain_id, 'FUSE' AS chain_name UNION

SELECT 1284 AS chain_id, 'Moonbeam' AS chain_name UNION

SELECT 1285 AS chain_id, 'Moonriver' AS chain_name UNION

SELECT 250 AS chain_id, 'Fantom' AS chain_name UNION

SELECT 100 AS chain_id, 'Gnosis' AS chain_name UNION

SELECT 59144 AS chain_id, 'Linea' AS chain_name UNION

SELECT 43114 AS chain_id, 'Avalanche' AS chain_name UNION

SELECT 8453 AS chain_id, 'BASE' AS chain_name UNION

SELECT 1101 AS chain_id, 'Polygon zkEVM' AS chain_name UNION

SELECT 324 AS chain_id, 'zkSync Era' AS chain_name UNION

SELECT 56 AS chain_id, 'BSC' AS chain_name UNION

SELECT 137 AS chain_id, 'Polygon' AS chain_name UNION

SELECT 10 AS chain_id, 'Optimism' AS chain_name UNION

SELECT 42161 AS chain_id, 'Arbitrum' AS chain_name UNION

SELECT 1 AS chain_id, 'Ethereum' AS chain_name

),

prices AS (

SELECT hour::date AS price_date, symbol, AVG(price) AS price

FROM optimism.price.ez_prices_hourly

GROUP BY 1,2

),

transfer AS (

SELECT