KeyrockOSMOSIS TX COUNT 180D
    Updated 2024-03-08
    -- forked from osmosis TX COUNT 180D copy @ https://flipsidecrypto.xyz/edit/queries/c27d548c-0af2-48fb-ae13-2826fb987d82

    -- forked from osmosis TX COUNT 180D @ https://flipsidecrypto.xyz/edit/queries/a22b67ac-7202-477d-95da-4546316bd638

    WITH min_block_timestamp AS (
    SELECT MIN(block_timestamp) AS min_timestamp
    FROM osmosis.core.fact_transactions
    )

    SELECT
    date_trunc('day', block_timestamp) AS day,
    COUNT(DISTINCT FACT_TRANSACTIONS_ID) AS daily_transactions
    FROM
    osmosis.core.fact_transactions
    CROSS JOIN
    min_block_timestamp
    WHERE
    block_timestamp <= DATEADD(day, 180, min_timestamp) -- Limit to the first 180 days
    GROUP BY
    day
    ORDER BY
    day;



    QueryRunArchived: QueryRun has been archived