hessDaily Number of Senders and Receivers
    Updated 2025-04-01
    WITH stables AS (
    SELECT to_address,
    from_address,
    tx_hash,
    block_timestamp,
    amount,
    symbol
    FROM sei.core_evm.ez_token_transfers
    WHERE contract_address IN (
    LOWER('0xB75D0B03c06A926e488e2659DF1A861F860bD3d1'),
    LOWER('0x3894085Ef7Ff0f0aeDf52E2A2704928d1Ec074F1')
    ))


    select date(block_timestamp) as date,
    count(DISTINCT from_address) as senders,
    count(DISTINCT to_address) as receivers
    from stables
    where date >= '2024-05-27'
    group by 1
    order by 1 asc


    Last run: 22 days ago
    DATE
    SENDERS
    RECEIVERS
    1
    2024-05-28 00:00:00.00023
    2
    2024-05-29 00:00:00.0002429
    3
    2024-05-30 00:00:00.0005671
    4
    2024-05-31 00:00:00.0004958
    5
    2024-06-01 00:00:00.0003643
    6
    2024-06-02 00:00:00.0003737
    7
    2024-06-03 00:00:00.0005761
    8
    2024-06-04 00:00:00.0005154
    9
    2024-06-05 00:00:00.0005766
    10
    2024-06-06 00:00:00.0006674
    11
    2024-06-07 00:00:00.00082104
    12
    2024-06-08 00:00:00.0006067
    13
    2024-06-09 00:00:00.0004954
    14
    2024-06-10 00:00:00.0008887
    15
    2024-06-11 00:00:00.000666674
    16
    2024-06-12 00:00:00.00027212738
    17
    2024-06-13 00:00:00.00022012181
    18
    2024-06-14 00:00:00.000136119
    19
    2024-06-15 00:00:00.00094100
    20
    2024-06-16 00:00:00.000178178
    ...
    309
    11KB
    2s