flopywoodFlow_Events Event Examples copy
    Updated 2025-03-26
    -- forked from Diamond / Flow_Events Event Examples @ https://flipsidecrypto.xyz/Diamond/q/jB08bL1jsmc2/flow_events-event-examples

    SELECT
    DATE_TRUNC('day', block_timestamp) as date,
    event_contract,
    event_type,
    COUNT(DISTINCT tx_id) as daily_event_count,
    SUM(COUNT(DISTINCT tx_id)) OVER (ORDER BY DATE_TRUNC('day', block_timestamp) ASC) as running_total
    FROM flow.core.fact_events
    WHERE event_contract = 'A.1e3c78c6d580273b.LNVCT'
    GROUP BY
    1, 2, 3
    ORDER BY
    date DESC;


    Last run: about 2 months ago
    DATE
    EVENT_CONTRACT
    EVENT_TYPE
    DAILY_EVENT_COUNT
    RUNNING_TOTAL
    1
    2024-09-04 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw13279184051868
    2
    2024-09-04 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit27347184051868
    3
    2024-09-03 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw43922184011242
    4
    2024-09-03 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit91223184011242
    5
    2024-09-02 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw42042183876097
    6
    2024-09-02 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit87632183876097
    7
    2024-09-01 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit105066183746423
    8
    2024-09-01 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw50328183746423
    9
    2024-08-31 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit94905183591029
    10
    2024-08-31 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw45446183591029
    11
    2024-08-30 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw53352183450678
    12
    2024-08-30 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit110954183450678
    13
    2024-08-29 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit93084183286372
    14
    2024-08-29 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw44466183286372
    15
    2024-08-28 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw48960183148822
    16
    2024-08-28 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit102240183148822
    17
    2024-08-27 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit87436182997622
    18
    2024-08-27 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw42017182997622
    19
    2024-08-26 00:00:00.000A.1e3c78c6d580273b.LNVCTDeposit109892182868169
    20
    2024-08-26 00:00:00.000A.1e3c78c6d580273b.LNVCTWithdraw52116182868169
    ...
    1679
    133KB
    48s