rezarwzAmount of USDB on the Blast
    Updated 2025-03-28
    with all_tx as (
    SELECT
    TX_hash,
    block_timestamp,
    'Deposit' as action,
    amount as USDB_amount
    FROM
    blast.core.ez_token_transfers
    Where
    from_address = '0x0000000000000000000000000000000000000000'
    and ORIGIN_FUNCTION_SIGNATURE = '0xd764ad0b'
    and CONTRACT_ADDRESS = '0x4300000000000000000000000000000000000003'
    UNION
    all
    SELECT
    TX_hash,
    block_timestamp,
    'Withdraw' as action,
    amount as USDB_amount
    FROM
    blast.core.ez_token_transfers
    Where
    to_address = '0x0000000000000000000000000000000000000000'
    and origin_to_address in (
    '0x4300000000000000000000000000000000000005',
    '0x4200000000000000000000000000000000000010'
    )
    and CONTRACT_ADDRESS = '0x4300000000000000000000000000000000000003'
    ),
    TimeFrame_data as (
    SELECT
    date_trunc('day', block_timestamp) AS date,
    SUM(
    COALESCE(
    CASE
    WHEN action = 'Deposit' THEN USDB_amount
    Last run: 29 days ago
    DATE
    NET_FLOW
    CUMULATIVE
    Total Yield
    1
    2025-03-28 00:00:00.000303263.46599395164360314.49651824654047.1744777
    2
    2025-03-27 00:00:00.000299886.937504838164057051.03052424608557.6545786
    3
    2025-03-26 00:00:00.000371447.074954267163757164.09301924563574.6139529
    4
    2025-03-25 00:00:00.000388313.002912303163385717.01806524507857.5527098
    5
    2025-03-24 00:00:00.000617963.217003418162997404.01515324449610.6022729
    6
    2025-03-23 00:00:00.00050976.525904057162379440.79814924356916.1197224
    7
    2025-03-22 00:00:00.000198254.23935254162328464.27224524349269.6408368
    8
    2025-03-21 00:00:00.000-96876.633604456162130210.03289324319531.5049339
    9
    2025-03-20 00:00:00.000239981.393527336162227086.66649724334062.9999746
    10
    2025-03-19 00:00:00.000308946.95502677161987105.2729724298065.7909455
    11
    2025-03-18 00:00:00.000220330.637044435161678158.31794324251723.7476915
    12
    2025-03-17 00:00:00.000190438.73668567161457827.68089924218674.1521348
    13
    2025-03-16 00:00:00.00013337.564765383161267388.94421324190108.341632
    14
    2025-03-15 00:00:00.000114099.551722935161254051.37944824188107.7069172
    15
    2025-03-14 00:00:00.000169063.79671398161139951.82772524170992.7741587
    16
    2025-03-13 00:00:00.0009468.012347278160970888.03101124145633.2046516
    17
    2025-03-12 00:00:00.000106825.674719639160961420.01866424144213.0027995
    18
    2025-03-11 00:00:00.000-399557.396418674160854594.34394424128189.1515916
    19
    2025-03-10 00:00:00.000-67629.841905407161254151.74036324188122.7610544
    20
    2025-03-09 00:00:00.000105305.721183314161321781.58226824198267.2373402
    ...
    397
    31KB
    9s