defi__joshTrading Volume Analysis
    Updated 2025-04-04
    SELECT
    DATE_TRUNC('day', block_timestamp) as date,
    COUNT(DISTINCT tx_hash) as number_of_transfers,
    COUNT(DISTINCT from_address) as unique_senders,
    COUNT(DISTINCT to_address) as unique_receivers,
    SUM(amount) as total_volume,
    AVG(amount) as avg_transfer_size,
    SUM(amount_usd) as total_volume_usd
    FROM ronin.core.ez_token_transfers
    WHERE contract_address = LOWER('0x7eae20d11ef8c779433eb24503def900b9d28ad7')
    AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
    GROUP BY 1
    ORDER BY 1;
    Last run: 2 months ago
    DATE
    NUMBER_OF_TRANSFERS
    UNIQUE_SENDERS
    UNIQUE_RECEIVERS
    TOTAL_VOLUME
    AVG_TRANSFER_SIZE
    TOTAL_VOLUME_USD
    1
    2025-03-05 00:00:00.000290668351114476688626.496451184.609394918311905.87
    2
    2025-03-06 00:00:00.000291277799126656905230.4188894384.557638329330153.15
    3
    2025-03-07 00:00:00.0002634065461041443314845.6697376647.5146600552063288.5
    4
    2025-03-08 00:00:00.00024421561099927603930.97504979124.939303906343839.49
    5
    2025-03-09 00:00:00.000271285647118586672629.39957305100.551980102286268.03
    6
    2025-03-10 00:00:00.000271286636108781747394572.568125911.12685085764313820.49
    7
    2025-03-11 00:00:00.0002466753321026913721390.1588991210.897146705501187.75
    8
    2025-03-12 00:00:00.000261046009106669598934.2126918142.120107974363466.36
    9
    2025-03-13 00:00:00.000268795649114186603729.5376293897.066563839251440.16
    10
    2025-03-14 00:00:00.000268626103100002848488124.3581643337.514063385113174050.36
    11
    2025-03-15 00:00:00.0002590754591015150169470.4620949740.0718463211983735.87
    12
    2025-03-16 00:00:00.000289437582932560377084.690707805.0385297232408859.39
    13
    2025-03-17 00:00:00.000212394456810232369133.3414379503.0402869041262066.61
    14
    2025-03-18 00:00:00.00027867924611054305655947.9067223592.31774800511906100.51
    15
    2025-03-19 00:00:00.0002349565389904239769157.2491733127.7773650399322712.57
    16
    2025-03-20 00:00:00.000188845267892014156102.5285533323.235586906535602.99
    17
    2025-03-21 00:00:00.000224946761930013463450.2649591330.399525509503326
    18
    2025-03-22 00:00:00.0002536980211235114359166.5263464317.540170861545024.25
    19
    2025-03-23 00:00:00.000210837059107867116322.01458368165.951261942272692.67
    20
    2025-03-24 00:00:00.0002136569881101117514802.9575742395.457280595681548.25
    31
    3KB
    2s