SELECT
block_timestamp :: date as date,
sum(TX_FEE) as "Daily Total tx fee (ETH)",
sum(GAS_USED) as "Daily Total gas used",
avg(TX_FEE) as "Daily Avg tx fee (ETH)",
avg(GAS_USED) as "Daily Avg gas used"
FROM
blast.core.fact_transactions
where
TO_ADDRESS = lower('{{contract_address}}')
and block_timestamp :: Date >= DATEADD(day, - {{past_x_days}}, CURRENT_DATE)
group by
1