AVG(daily_total_tx_fee) OVER (ORDER BY DATE ROWS BETWEEN 10 PRECEDING AND CURRENT ROW) AS daily_total_tx_fee_10day_ma,

avg(gas_price) as average_daily_gas_price,

avg(gas_used) as average_daily_gas_used,

AVG(average_daily_gas_price) OVER (ORDER BY DATE ROWS BETWEEN 10 PRECEDING AND CURRENT ROW) AS gas_price_10day_ma,

AVG(average_daily_gas_used) OVER (ORDER BY DATE ROWS BETWEEN 10 PRECEDING AND CURRENT ROW) AS gas_used_10day_ma ,

avg(gas_limit) as average_gas_limit,

(average_daily_gas_used/average_gas_limit)*100 as percentage_gas_used

from polygon.core.fact_transactions

where to_date(block_timestamp) >= '{{Starting_Date}}'

and status = 'SUCCESS'

GROUP BY DATE