flipside

    Daily
    Afonso_DiazDaily
    Updated 2024-06-27
    WITH tab1 AS (
    SELECT
    tx_hash,
    SPLIT(payload_function, ':')[0] AS contract_address,
    block_timestamp
    FROM aptos.core.fact_transactions
    WHERE success = TRUE
    AND tx_hash IN (SELECT DISTINCT tx_hash FROM aptos.core.fact_events WHERE event_type = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387::event::PriceFeedUpdate')
    AND NOT contract_address IS NULL
    )

    SELECT
    DATE_TRUNC('day', block_timestamp) AS DATE,
    contract_address,
    COUNT(DISTINCT tx_hash) AS TXNS,
    SUM(TXNS) OVER (PARTITION BY contract_address ORDER BY DATE) AS CUM_TXNS
    FROM tab1
    GROUP BY 1, 2
    QueryRunArchived: QueryRun has been archived