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}}')
group by
1