Mrfti2024-07-24 06:13 PM copy copy
    Updated 7 days ago
    -- forked from 2024-07-24 06:13 PM copy @ https://flipsidecrypto.xyz/studio/queries/e58d2eb4-3cf0-441d-9078-7f8b86ca6ebe

    SELECT
    date_trunc (day, block_timestamp) as "Date",
    count (DISTINCT tx_id) as "Total Transaction",
    sum ("Total Transaction") over (order by "Date") as "Cumulative tx count",
    sum (fee) as "Total fee ($Aleo)",
    sum ("Total fee ($Aleo)") over (order by "Date") as "Cumulative fee ($Aleo)"
    from aleo.core.fact_transactions
    GROUP by 1


    Last run: 7 days agoAuto-refreshes every 12 hours
    Date
    Total Transaction
    Cumulative tx count
    Total fee ($Aleo)
    Cumulative fee ($Aleo)
    1
    2024-11-13 00:00:00.00096284488534218078.753639638633.514958
    2
    2024-11-27 00:00:00.00094038623748014589.474753870501.800519
    3
    2024-12-18 00:00:00.000154550859892517382.5737841199480.768652
    4
    2025-02-17 00:00:00.00021279127301611123.1996111658903.268295
    5
    2025-03-09 00:00:00.000105572143735562705.1042761705053.747298
    6
    2025-02-07 00:00:00.0001156712563336844.601781648780.095933
    7
    2025-02-13 00:00:00.0001605312651891969.6222831654558.930779
    8
    2024-09-05 00:00:00.000540547563.14625563.381793
    9
    2025-03-31 00:00:00.000184813162977452179.7982291749598.978006
    10
    2025-04-09 00:00:00.00078127186415961701.7050011777894.474726
    11
    2025-04-28 00:00:00.00054406196697551028.5053311802265.892547
    12
    2025-05-17 00:00:00.0003671720513345729.414851819463.95
    13
    2024-09-29 00:00:00.000111121402098853.69779414465.61098
    14
    2025-04-22 00:00:00.00047851193397771238.4460451795733.920401
    15
    2025-05-19 00:00:00.0003538120584748748.2980311820953.666499
    16
    2024-10-04 00:00:00.0001756514864351468.95933221336.4253
    17
    2024-10-08 00:00:00.0001752515471701496.81016326817.252262
    18
    2024-11-09 00:00:00.00094071448578317125.584193562768.357295
    19
    2024-12-04 00:00:00.00088110693667814282.292999980640.612699
    20
    2025-01-13 00:00:00.00079989113043939507.778391495983.418093
    ...
    274
    18KB
    26s