peachycrypttTransaction volume
    Updated 2025-05-27
    with raw as(
    select
    date_trunc('day', block_timestamp) as day,
    sum(value) as total_transaction_volume
    from monad.testnet.fact_transactions
    where to_address = LOWER('0xb6091233aAcACbA45225a2B2121BBaC807aF4255')
    group by date_trunc('day', block_timestamp)
    ),

    totals as (
    select
    day,
    total_transaction_volume,
    SUM(total_transaction_volume) OVER (ORDER BY day) AS cumulative_transaction_volume,
    SUM(total_transaction_volume) OVER () as grand_total
    from raw
    order by day
    )

    select * from totals
    Last run: about 1 month ago
    DAY
    TOTAL_TRANSACTION_VOLUME
    CUMULATIVE_TRANSACTION_VOLUME
    GRAND_TOTAL
    1
    2025-03-17 00:00:00.00011573.03401162174041.9061539782693366.63414914
    2
    2025-03-18 00:00:00.00012358.49767476186400.4038287392693366.63414914
    3
    2025-03-19 00:00:00.00010456.19551867796856.5993474152693366.63414914
    4
    2025-02-24 00:00:00.000222693366.63414914
    5
    2025-02-25 00:00:00.00037.76589302839.7658930282693366.63414914
    6
    2025-03-02 00:00:00.000039.7658930282693366.63414914
    7
    2025-03-20 00:00:00.0006758.365672248103614.9650196632693366.63414914
    8
    2025-03-21 00:00:00.0006232.653959473109847.6189791362693366.63414914
    9
    2025-03-09 00:00:00.0003342.0216278647304.0101423172693366.63414914
    10
    2025-03-10 00:00:00.0007030.86468263314334.874824952693366.63414914
    11
    2025-03-04 00:00:00.0001.541.2658930282693366.63414914
    12
    2025-03-06 00:00:00.00018.09356118659.3594542142693366.63414914
    13
    2025-03-08 00:00:00.0003902.6290602383961.9885144522693366.63414914
    14
    2025-03-22 00:00:00.0008360.666265202118208.2852443382693366.63414914
    15
    2025-03-23 00:00:00.0007884.928904607126093.2141489452693366.63414914
    16
    2025-03-24 00:00:00.0007486.7274566133579.9416055442693366.63414914
    17
    2025-03-11 00:00:00.0009439.76792669223774.6427516412693366.63414914
    18
    2025-03-12 00:00:00.0004675.04370376328449.6864554042693366.63414914
    19
    2025-03-13 00:00:00.0005714.26938159934163.9558370032693366.63414914
    20
    2025-03-14 00:00:00.0002478.80447578436642.7603127872693366.63414914
    86
    6KB
    28s