token_prices AS (

SELECT

TRUNC(RECORDED_HOUR, 'day') AS day,

'A.1654653399040a61.FlowToken' AS token,

AVG(open) AS avg_price

FROM

flow.core.fact_hourly_prices

WHERE

token = 'Flow'

AND RECORDED_HOUR >= '2023-01-01'

GROUP BY

1,

2

UNION

SELECT

TRUNC(RECORDED_HOUR, 'day') AS day,

'A.ead892083b3e2c6c.DapperUtilityCoin' AS token,

1 AS avg_price

FROM

flow.core.fact_hourly_prices

WHERE

RECORDED_HOUR >= '2023-01-01'

UNION

SELECT

TRUNC(RECORDED_HOUR, 'day') AS day,

'A.3c5959b568896393.FUSD' AS token,

1 AS avg_price

FROM

flow.core.fact_hourly_prices

WHERE

RECORDED_HOUR >= '2023-01-01'

),

sales_info AS (

SELECT

TRUNC(block_timestamp, 'day') AS day,