defi__joshComprehensive Daily Network Metrics (since launch)
    Updated 2025-06-02
    WITH daily_stats AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) as date,
    COUNT(DISTINCT block_number) as blocks_created,
    COUNT(DISTINCT tx_hash) as total_transactions,
    COUNT(DISTINCT from_address) as unique_active_addresses,
    AVG(gas_used) as avg_gas_used,
    MAX(gas_used) as max_gas_used,
    MIN(gas_used) as min_gas_used,
    AVG(tx_fee) as avg_tx_fee,
    SUM(tx_fee) as total_tx_fees,
    SUM(CASE WHEN tx_succeeded = true THEN 1 ELSE 0 END) as successful_tx,
    ROUND(SUM(CASE WHEN tx_succeeded = true THEN 1 ELSE 0 END) * 100.0 / COUNT(*), 2) as success_rate,
    SUM(value) as total_value_transferred
    FROM mezo.testnet.fact_transactions
    WHERE block_timestamp >= (
    SELECT MIN(block_timestamp)
    FROM mezo.testnet.fact_transactions
    )
    GROUP BY 1
    ORDER BY 1
    )

    SELECT
    date as "day",
    blocks_created as "blocks created",
    SUM(blocks_created) OVER (ORDER BY date) AS "cumulative blocks created",
    total_transactions as "total transactions",
    SUM(total_transactions) OVER (ORDER BY date) AS "cumulative total transactions",
    unique_active_addresses as "unique active addresses",
    SUM(unique_active_addresses) OVER (ORDER BY date) AS "cumulative unique active addresses",
    successful_tx as "successful transactions",
    SUM(successful_tx) OVER (ORDER BY date) AS "cumulative successful transactions",
    success_rate as "success rate %",
    ROUND(avg_gas_used, 2) as "avg gas used",
    max_gas_used as "max gas used",
    Last run: 13 days ago
    day
    blocks created
    cumulative blocks created
    total transactions
    cumulative total transactions
    unique active addresses
    cumulative unique active addresses
    successful transactions
    cumulative successful transactions
    success rate %
    avg gas used
    max gas used
    min gas used
    avg tx fee
    total tx fees
    total value transferred
    1
    2025-06-02 00:00:00.00056487836203499222306516187089110081615.1715574544919000
    2
    2025-06-01 00:00:00.00012648778122034986723064912187088510079784.8318538921000000.000111
    3
    2025-05-31 00:00:00.000336487663420349743230642341870873100271718.6842688644919000
    4
    2025-05-30 00:00:00.000106487331020349405230639918708399075824.6715574521000000.001
    5
    2025-05-29 00:00:00.00019648723202034930823063418187083090211831.26100000044919000.027727
    6
    2025-05-28 00:00:00.0001145648704175420349102512306261742187081299.32402388.9217693630000.410926
    7
    2025-05-27 00:00:00.0003998647559703420331568872303756608186907093.94222263.144750000000.000010.519515
    8
    2025-05-26 00:00:00.0005360643561105662026122105622948810070186246295.31270940.6717693632100000.000852.43706
    9
    2025-05-25 00:00:00.00010372638201299602015556238922843228665185239295.68276580.484750000000.0003830.191622
    10
    2025-05-24 00:00:00.00017058627829412481985596897122604338564182372793.49234968.533000000210000.0000060.247020.270647
    11
    2025-05-23 00:00:00.000185196107715518219443481489621707250590178516391.68233313.29371950000.0007290.900711
    12
    2025-05-22 00:00:00.00021100592252207036188916615561202176198359173457395.81247565.288981613000.002042.539048
    13
    2025-05-21 00:00:00.00020247571152225202168213014864186615176972153621478.58102876.6798490532100000.0000071.738105
    14
    2025-05-20 00:00:00.00021194550905165603145692816508171751106515135924264.32160241.498490532100000.0001411.893522
    15
    2025-05-19 00:00:00.00019544529711196480129132518377155243187695125272795.53103956.5547500002100000.0005147.635649
    16
    2025-05-18 00:00:00.00013908510167401971094845948013686637881106503294.24192444.5847500002100000.0022192.989798
    17
    2025-05-17 00:00:00.00020866496259799501054648952812738678077102715197.66154080.3995439122100000.0154194.823821
    18
    2025-05-16 00:00:00.000148774753933702497469863641178583545494907495.76194326.658802342000.0002312.680915
    19
    2025-05-15 00:00:00.000120844605162794693767415371114942720691362097.35163881.6749226982100000.0001051.134392
    20
    2025-05-14 00:00:00.000103274484321931790972816611099571869588641496.78210237.7475000021000005.61325
    67
    8KB
    442s