Movement TeamGas per Second
    Updated 2024-11-18
    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'