DATE_TRUNC('day',block_timestamp) as date,

COUNT(DISTINCT TX_HASH) as number_transactions,

SUM(gas_burnt) as gas_burnt,

SUM(gas_burnt)/AVG(gas_burnt) as gas_burnt_norm,

avg(number_transactions) OVER(ORDER BY date

ROWS BETWEEN 8 PRECEDING AND CURRENT ROW )

as "7d_MA_tx"

block_timestamp,

tx_hash,

gas_burnt,

logs as logs1

FROM near.core.fact_receipts

WHERE receiver_id = 'contract.main.burrow.near'

AND block_timestamp::date < CURRENT_DATE

where date >= current_date() - {{n_days}}

and date< current_date()

GROUP BY date

ORDER BY date