freemartiancumulative stake
    Updated 3 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: 3 days agoAuto-refreshes every 1 hour
    HOUR
    TRANSACTIONS
    USERS
    AMOUNTS
    CUM_AMOUNT
    1
    2025-02-21 13:00:00.00014313847756.6088428254602312.38248589
    2
    2025-02-23 09:00:00.0004542842509.544708666351596.40147266
    3
    2025-03-14 14:00:00.00077-28.163014279993700.38998984
    4
    2025-02-25 21:00:00.00019183276.7518553917580481.91592936
    5
    2025-03-14 08:00:00.0001313-277.175998729983746.06277031
    6
    2025-03-16 10:00:00.00011910457.41542954910956706.7817948
    7
    2025-03-17 07:00:00.00055104.95544093710933809.7230493
    8
    2025-03-15 21:00:00.00099-842.4934246210942958.6462547
    9
    2025-03-20 03:00:00.00022-19.06541027311617385.7304282
    10
    2025-05-19 06:00:00.00066671.19083829419836309.0313839
    11
    2025-05-19 16:00:00.000181713402.29420987219874319.5328152
    12
    2025-03-21 17:00:00.0001717827.01705384513863622.1075053
    13
    2025-03-26 10:00:00.00011113624.09828870813958040.1918923
    14
    2025-03-04 23:00:00.00011111145.4432752559912234.1933771
    15
    2025-03-07 14:00:00.00055-36.4421415659979994.14451902
    16
    2025-03-10 03:00:00.0001616-91.8017439519850802.12466182
    17
    2025-03-12 06:00:00.00099-1041.4273556679923285.39135462
    18
    2025-04-11 21:00:00.00076-69.19885151314008562.8065043
    19
    2025-04-23 18:00:00.000555589.26310860516053169.386129
    20
    2025-05-06 16:00:00.00044432.90280578718669362.3261697
    ...
    2198
    137KB
    39s