Updated 2025-06-13
    SELECT
    date_trunc('day', block_timestamp) as day,
    count(DISTINCT tx_id) as events,
    count(DISTINCT signers[0]) as buyers,
    (sum(pre_balances[0] - post_balances[0])/power(10,9)) as volume

    from eclipse.core.fact_transactions
    --where tx_id like '4TwEfdwK9WNwHWybfLeoZmeMZQPWDRBb4ZqRNzofk58XiRjxRN4GoWiCSzTvH8xLUyJGRF4Yp6n3w6Y3CLpnrpQb'
    WHERE ((log_messages[0] LIKE 'Program Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic invoke [1]' and log_messages[1] in ('Program log: Instruction: FillOrder', 'Program log: Instruction: FillOrderV2'))
    OR (log_messages[2] LIKE 'Program Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic invoke [1]' and log_messages[3] in ('Program log: Instruction: FillOrder', 'Program log: Instruction: FillOrderV2')))
    and block_timestamp > '2024-12-05 14:00:00.000'
    AND SUCCEEDED
    GROUP BY 1


    Last run: about 2 months ago
    DAY
    EVENTS
    BUYERS
    VOLUME
    1
    2025-03-31 00:00:00.0004043209.030788324
    2
    2025-02-13 00:00:00.00034416511.758447981
    3
    2025-02-17 00:00:00.0003832066.276709794
    4
    2025-05-17 00:00:00.00039281.016721878
    5
    2025-03-14 00:00:00.0005202095.23167623
    6
    2025-04-16 00:00:00.0006148-1.122665722
    7
    2025-04-12 00:00:00.00012294-3.326046508
    8
    2025-05-08 00:00:00.00073392.671972874
    9
    2025-04-03 00:00:00.0003661807.942344796
    10
    2025-01-27 00:00:00.00031622117.291195146
    11
    2025-05-21 00:00:00.00055382.571112184
    12
    2025-05-05 00:00:00.000100802.982388444
    13
    2025-02-15 00:00:00.0002712059.969822207
    14
    2025-03-15 00:00:00.0005821934.910223294
    15
    2025-03-19 00:00:00.00068026418.118977594
    16
    2025-04-26 00:00:00.0003542259.065112668
    17
    2024-12-20 00:00:00.00055036156.88324021
    18
    2025-02-04 00:00:00.0002051603.629094111
    19
    2025-04-25 00:00:00.0002511892.562814425
    20
    2025-01-26 00:00:00.00037623619.160859446
    ...
    191
    9KB
    465s