picasooveral state BOBA
    Updated 2025-03-12
    WITH daily_data AS (
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
    COUNT(DISTINCT TX_HASH) AS daily_transactions,
    COUNT(DISTINCT FROM_ADDRESS) AS daily_active_users,
    SUM(TX_FEE) AS daily_fees
    FROM
    boba.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= DATEADD('year', -1, CURRENT_DATE)
    GROUP BY
    1
    ),
    weekly_data AS (
    SELECT
    DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,
    COUNT(DISTINCT TX_HASH) AS weekly_transactions,
    COUNT(DISTINCT FROM_ADDRESS) AS weekly_active_users,
    SUM(TX_FEE) AS weekly_fees
    FROM
    boba.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= DATEADD('year', -1, CURRENT_DATE)
    GROUP BY
    1
    ),
    monthly_data AS (
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
    COUNT(DISTINCT TX_HASH) AS monthly_transactions,
    COUNT(DISTINCT FROM_ADDRESS) AS monthly_active_users,
    SUM(TX_FEE) AS monthly_fees
    FROM
    boba.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= DATEADD('year', -1, CURRENT_DATE)
    QueryRunArchived: QueryRun has been archived