SELECT

date(block_timestamp) AS date,

avg(tx_fee) AS avg_fee,

sum(tx_fee) AS total_daily_fee,

sum(total_daily_fee) OVER (ORDER BY date) AS cumulative_fee

FROM polygon.core.fact_transactions

WHERE status = 'SUCCESS'

GROUP BY 1

),

eth_fees AS (

SELECT

date(block_timestamp) AS date,

avg(tx_fee) AS avg_fee,

sum(tx_fee) AS total_daily_fee,

sum(total_daily_fee) OVER (ORDER BY date) AS cumulative_fee

FROM ethereum.core.fact_transactions

WHERE status = 'SUCCESS'

GROUP BY 1

SELECT

p.date AS "Date",

p.avg_fee AS "Polygon average fee (MATIC)",

e.avg_fee AS "Ethereum average fee (ETH)"

FROM poly_fees p

JOIN eth_fees e on p.date = e.date

WHERE p.date BETWEEN '2022-07-01' AND '2022-07-08'

ORDER BY 1;