daily_token_prices__flow_native AS (

SELECT

timestamp::date AS utc_date

, token

, asset_id

, symbol

, avg(price_usd) AS price_usd

FROM flow.core.fact_prices

GROUP BY 1,2,3,4

),

daily_token_prices__ethereum AS (

SELECT

hour::date AS utc_date

, symbol

, avg(price) AS price_usd

FROM ethereum.core.fact_hourly_token_prices

GROUP BY 1,2

),

flow_token_symbols AS (

SELECT

column1 AS token_contract

, column2 AS symbol

FROM (VALUES

('A.0f9df91c9121c460.BloctoToken', 'BLT')

, ('A.cfdd90d4a00f7b5b.TeleportedTetherToken', 'USDT')

, ('A.231cc0dbbcffc4b7.RLY', 'RLY')

, ('A.1654653399040a61.FlowToken', 'FLOW')