SELECT
count(distinct date_trunc('second', block_timestamp)) as seconds,
sum(gas_used) as total_gas,
total_gas / seconds as Gas_per_second
-- ((gas_used * gas_unit_price)/1e8) as tx_fee_MOVE
FROM
aptos.core.fact_transactions
where
block_timestamp >= current_date - 1
and TX_TYPE = 'user_transaction'