Updated 2025-01-26
    WITH price_data AS (
    SELECT
    AVG(PRICE) AS avg_price
    FROM
    flow.price.ez_prices_hourly
    WHERE
    SYMBOL = 'FLOW'
    ),
    transaction_data AS (
    SELECT
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    BLOCK_HASH,
    TX_HASH,
    NONCE,
    POSITION,
    ORIGIN_FUNCTION_SIGNATURE,
    FROM_ADDRESS,
    TO_ADDRESS,
    VALUE,
    VALUE_PRECISE_RAW,
    VALUE_PRECISE,
    TX_FEE,
    TX_FEE_PRECISE,
    STATUS
    FROM
    flow.core_evm.fact_transactions
    ),
    daily_tpm AS (
    SELECT
    DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS day,
    COUNT(DISTINCT TX_HASH) / 1440 AS tpm
    FROM
    transaction_data
    GROUP BY 1
    ),
    Last run: 20 days ago
    tx
    USER
    Avg TPM
    total tx fee FLOW$
    total tx fee usd
    avg tx fee FLOW$
    avg tx fee usd
    block count
    avg tx per user
    success rate
    1
    119735942705.73447797241479.007936982448.7840958680.000065985169850.000374811644515453735280.41194379499.31992
    1
    123B
    3s