DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",

AVG(GAS_USED * GAS_PRICE) AS "Average Gas Fee ($)"

FROM

base.core.fact_transactions

WHERE

TO_ADDRESS IN (

SELECT DISTINCT CONTRACT_ADDRESS

FROM base.core.ez_token_transfers

)

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

"Date";