freemartiancumulative stake
    Updated 9 days ago

    WITH datas as (
    select
    block_timestamp, tx_hash, origin_from_address as user_address, amount, 'stake' as label
    from base.core.ez_token_transfers
    where origin_function_signature = '0x6e553f65'
    and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'
    and origin_to_address = '0x548d3b444da39686d1a6f1544781d154e7cd1ef7'
    -- and from_address = '0x0000000000000000000000000000000000000000'
    -- and tx_hash = '0xbbb7bd642c374163d57fb3edc9d776d3144c47db1456b7ca441abccc5061ccb4'

    union all

    select
    block_timestamp,tx_hash, origin_from_address as user_address, -amount as amount, 'unstake' as label
    from base.core.ez_token_transfers
    where origin_function_signature = '0x9343d9e1'
    and from_address = '0x548d3b444da39686d1a6f1544781d154e7cd1ef7'
    and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

    order by 1 asc
    )

    select
    date_trunc('hour',block_timestamp) as hour,
    -- label,
    count(tx_hash) as transactions,
    count(distinct user_address) as users,
    sum(amount) as amounts,
    SUM(amounts) over(order by hour asc) as cum_amount
    from datas
    group by 1




    Last run: 9 days agoAuto-refreshes every 1 hour
    HOUR
    TRANSACTIONS
    USERS
    AMOUNTS
    CUM_AMOUNT
    1
    2025-02-20 18:00:00.000360353183864.2899291572502377.16860534
    2
    2025-02-20 20:00:00.000220217114695.7198640782800759.78774516
    3
    2025-02-20 23:00:00.000213211194112.7303799213138809.20093256
    4
    2025-05-22 08:00:00.0001091045.54892202620177231.0218364
    5
    2025-05-24 06:00:00.00099816.41208215820602144.1827461
    6
    2025-05-21 20:00:00.0001111275.72034639220163948.2928603
    7
    2025-06-14 12:00:00.00019196368.44228613925706044.3067653
    8
    2025-06-20 07:00:00.000111086077.18722131326028636.8542526
    9
    2025-06-23 23:00:00.00014143333.03661274425822157.0969716
    10
    2025-04-30 13:00:00.0002217.79123693917351369.9020262
    11
    2025-02-27 00:00:00.00035351634.8991692378541734.70117784
    12
    2025-06-14 07:00:00.0002019-140.22981412625697766.8166328
    13
    2025-06-18 23:00:00.00066517.49656352625961001.5400899
    14
    2025-06-18 20:00:00.00088-1584.85502259925980474.5863363
    15
    2025-06-23 00:00:00.00033-97.48451403325789548.7457099
    16
    2025-02-23 00:00:00.00031319800.9439669865292050.27092745
    17
    2025-02-24 22:00:00.000252414820.0780099827051671.09854544
    18
    2025-02-25 05:00:00.000333333997.0754483747110555.4809988
    19
    2025-05-06 08:00:00.0001110-286.18303858818672894.8808881
    20
    2025-05-11 05:00:00.0001010-8601.06058184516745623.0729442
    ...
    2924
    184KB
    194s