DATE(block_timestamp) as "Date",

COUNT(tx_hash) as "# of Transactions",

AVG(tx_fee) as "AVG Transaction Fee",

AVG(tx_fee * "Price") as "AVG Transaction Fee ($USD)",

SUM(tx_fee) as "Total Fees Per Day",

SUM(tx_fee * "Price") as "Total Fees Per Day ($USD)",

SUM(SUM(tx_fee)) OVER (

ORDER BY

DATE(block_timestamp)

) as "Cumulative Transaction Fees",

SUM(SUM(tx_fee * "Price")) OVER (

ORDER BY

DATE(block_timestamp)

) as "Cumulative Transaction Fees ($USD)"

base.core.fact_transactions t

LEFT JOIN (

SELECT

DATE(hour) as "D",

AVG(price) as "Price"

FROM

base.price.ez_hourly_token_prices

WHERE

symbol = 'WETH'

GROUP BY

DATE(hour)

) a ON a."D" = DATE(block_timestamp)

GROUP BY

DATE(block_timestamp)

ORDER BY

DATE(block_timestamp) DESC