LTirrellUnique Txs - Vote and Non-Vote copy
    Updated 2024-02-09
    select
    'Transactions' as type,
    date(block_timestamp) as date,
    count(distinct tx_id) as transactions,
    AVG(count(distinct tx_id)) OVER (
    ORDER BY date
    ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
    ) AS moving_average
    from solana.core.fact_transactions
    where
    date(block_timestamp) between current_date()-61 and current_date()-1
    group by date
    order by date desc
    Last run: about 1 year ago
    TYPE
    DATE
    TRANSACTIONS
    MOVING_AVERAGE
    1
    Transactions2024-02-08 00:00:00.0008073890077615748
    2
    Transactions2024-02-07 00:00:00.0008352210275774448.714
    3
    Transactions2024-02-06 00:00:00.0006441721573025835
    4
    Transactions2024-02-05 00:00:00.0007970592473910030.571
    5
    Transactions2024-02-04 00:00:00.0007924645472284690.285
    6
    Transactions2024-02-03 00:00:00.0008286312670775098.285
    7
    Transactions2024-02-02 00:00:00.0007281651568834313.285
    8
    Transactions2024-02-01 00:00:00.0006784980568847570
    9
    Transactions2024-01-31 00:00:00.0006428180669819762.285
    10
    Transactions2024-01-30 00:00:00.0007060658471709839.714
    11
    Transactions2024-01-29 00:00:00.0006832854270628959.571
    12
    Transactions2024-01-28 00:00:00.0006867931069372670.142
    13
    Transactions2024-01-27 00:00:00.0006927763168445878.142
    14
    Transactions2024-01-26 00:00:00.0007290931267516526.714
    15
    Transactions2024-01-25 00:00:00.0007465515165610333.857
    16
    Transactions2024-01-24 00:00:00.0007751234863083357.142
    17
    Transactions2024-01-23 00:00:00.0006304042360061780.714
    18
    Transactions2024-01-22 00:00:00.0005953451659469286.285
    19
    Transactions2024-01-21 00:00:00.0006219176658762324.285
    20
    Transactions2024-01-20 00:00:00.0006277217156905171.857
    61
    4KB
    629s