cryptoshipDaily Transaction Volume - 2024
    Updated 2024-06-07
    SELECT
    DATE_TRUNC('day', block_timestamp) as "Day",
    COUNT(*) as "Transaction Count",
    AVG(gas_price) as "Average Gas Price",
    AVG(GAS_USED) as "Average Gas Used",
    COUNT(DISTINCT from_address) as "Unique Active Addresses",
    AVG(TX_FEE) as "Average Transaction Fee",
    FROM
    ethereum.core.fact_transactions
    WHERE
    extract('year', block_timestamp)='2024'
    GROUP BY
    DATE_TRUNC('day', block_timestamp)
    ORDER BY
    "Day" DESC;

    QueryRunArchived: QueryRun has been archived