SELECT TIMESTAMP::DATE AS DAYS, AVG(PRICE_USD) AS Price

FROM flow.core.fact_prices

WHERE Token = 'Flow' AND DAYS >= '2022-04-20'

GROUP BY DAYS

ORDER BY DAYS),

STABLE_COIN_SALES AS (SELECT BLOCK_TIMESTAMP::DATE AS Days, SUM(Price) AS VOLUME

FROM flow.core.ez_nft_sales

WHERE TX_SUCCEEDED = 'TRUE' AND DAYS >= '2022-04-20' AND Currency != 'A.1654653399040a61.FlowToken'

GROUP BY Days),

Paied_with_flow AS (

SELECT BLOCK_TIMESTAMP::DATE AS Days, SUM(Price) AS SALES_Volume

FROM flow.core.ez_nft_sales

WHERE TX_SUCCEEDED = 'TRUE' AND DAYS >= '2022-04-20' AND Currency = 'A.1654653399040a61.FlowToken'

GROUP BY Days

),

FLOW_SALES_VOUME AS (

SELECT Paied_with_flow.Days, SALES_Volume*Price AS VOLUME

FROM FLOW_PRICE JOIN Paied_with_flow USING (Days)),

ALL_SALES AS (

SELECT * FROM STABLE_COIN_SALES

UNION ALL

SELECT * FROM FLOW_SALES_VOUME),

Daily_Sales_Volume AS (SELECT Days, SUM(VOLUME) AS "Daily sales volume" FROM ALL_SALES GROUP BY Days),

Daily_Sales_Number_AND_Unique_Addresses AS (

SELECT BLOCK_TIMESTAMP::DATE AS Days, COUNT(TX_ID) AS "Number of daily sales", COUNT(DISTINCT(BUYER)) AS "Number of unique daily buyers"

FROM flow.core.ez_nft_sales WHERE DAYS >= '2022-04-20'

GROUP BY Days

)