hessDaily Numbers
    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')
    )
    and to_address not in ('0x0000000000000000000000000000000000000000')
    and from_address not in ('0x0000000000000000000000000000000000000000'))


    select date(block_timestamp) as date,
    symbol,
    count(DISTINCT tx_hash) as transactions,
    sum(amount) as volume,
    avg(amount) as avg_volume
    from stables
    where date >= '2024-05-27'
    group by 1,2

    Last run: 13 days ago
    DATE
    SYMBOL
    TRANSACTIONS
    VOLUME
    AVG_VOLUME
    1
    2024-07-14 00:00:00.000USDC60344283113.895762396.144459467
    2
    2024-08-10 00:00:00.000USDT107957451796.250535296.482702735
    3
    2024-10-09 00:00:00.000USDT704316477542.8946681885.302390694
    4
    2025-02-08 00:00:00.000USDT94477740689.79503531.385308919
    5
    2025-03-25 00:00:00.000USDC22309156105817.8416413913.01493562
    6
    2024-09-03 00:00:00.000USDT25793869868.8070281177.325466087
    7
    2024-08-16 00:00:00.000USDT41672326901.530803431.707148572
    8
    2024-11-06 00:00:00.000USDC2857195927463.5419352131.200451933
    9
    2024-12-14 00:00:00.000USDT125252927423.816372171.234430064
    10
    2024-07-26 00:00:00.000USDC76446818112.922957409.348758583
    11
    2024-06-02 00:00:00.000USDC267108764.061716357.776518803
    12
    2024-09-07 00:00:00.000USDT167028288182.65204413024.025162083
    13
    2025-02-12 00:00:00.000USDT1467734817950.1073131465.895508055
    14
    2024-10-16 00:00:00.000USDC1127465287493.494463917.40630592
    15
    2024-09-22 00:00:00.000USDC11508121927631.5312697751.772619446
    16
    2024-11-26 00:00:00.000USDT4569359211742.477234792.51201217
    17
    2024-11-13 00:00:00.000USDC4235476246086.7266361272.592160875
    18
    2024-09-11 00:00:00.000USDC9327136726274.6912719742.502115667
    19
    2024-08-31 00:00:00.000USDC38289928227.9244071710.583722331
    20
    2024-06-17 00:00:00.000USDC23237796104.364372913.342438105
    ...
    618
    43KB
    7s