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