feyikemi$PYR Txns
    Updated 2025-04-07
    With Tab1 as (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    SUM(amount_USD) AS Total_Volume_USD,
    COUNT(DISTINCT Tx_hash) AS Transaction_Count,
    COUNT(DISTINCT From_address) AS Active_Addresses
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    contract_address = '0x430ef9263e76dae63c84292c3409d61c598e9682' -- $PYR Contract Address
    AND date >= '2024-01-01'
    GROUP BY
    date
    ORDER BY
    date DESC;
    )

    SELECT
    Date,
    Total_Volume_USD,
    SUM(Total_Volume_USD) OVER (ORDER BY date) AS Cumulative_Volume_USD,
    Transaction_Count

    FROM
    Tab1
    Last run: about 2 months ago
    DATE
    TOTAL_VOLUME_USD
    CUMULATIVE_VOLUME_USD
    TRANSACTION_COUNT
    1
    2025-02-22 00:00:00.000254071.353915231224259274.0129565
    2
    2025-02-21 00:00:00.000379881.1588623211224005202.6590477
    3
    2025-02-20 00:00:00.0005446303.626007441223625321.50017203
    4
    2025-02-19 00:00:00.000961068.5107627571218179017.87417109
    5
    2025-02-18 00:00:00.0002508204.577882831217217949.3634146
    6
    2025-02-17 00:00:00.000574443.0057001781214709744.7855279
    7
    2025-02-16 00:00:00.000205263.5042332121214135301.77982104
    8
    2025-03-09 00:00:00.0003155067.730226851234475753.66834323
    9
    2025-03-08 00:00:00.000141217.6007273381231320685.9381170
    10
    2025-03-07 00:00:00.000145680.3761651221231179468.3373970
    11
    2025-03-06 00:00:00.000147496.1227009091231033787.9612287
    12
    2025-03-05 00:00:00.000101665.6293724781230886291.8385274
    13
    2025-03-04 00:00:00.000930355.6179101841230784626.20915114
    14
    2025-03-03 00:00:00.000416759.0875337571229854270.59124100
    15
    2025-03-02 00:00:00.0001026819.733102621229437511.5037122
    16
    2025-03-01 00:00:00.000336634.1750690481228410691.770659
    17
    2025-02-28 00:00:00.000531860.0833983981228074057.59553112
    18
    2025-02-27 00:00:00.000492823.0803381431227542197.51213148
    19
    2025-02-26 00:00:00.000477664.7280357191227049374.4318130
    20
    2025-02-25 00:00:00.0001300834.679309641226571709.70376152
    ...
    463
    30KB
    28s