flipside

    Over Time[Stake/Unstake]
    0xHaM-dOver Time[Stake/Unstake]
    Updated 2025-03-27
    with eventTb as (
    select
    EVENT_NAME,
    BLOCK_TIMESTAMP,
    TX_HASH,
    DECODED_LOG:owner::string as owner,
    DECODED_LOG:assets::float/1e18 as amt_avUSD,
    DECODED_LOG:shares::float/1e18 as amt_savUSD,
    from avalanche.core.ez_decoded_event_logs
    where CONTRACT_ADDRESS = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'
    and EVENT_NAME in ('Deposit', 'Withdraw')
    )
    select
    EVENT_NAME,
    trunc(BLOCK_TIMESTAMP, 'week') as date,
    count(*) as n_transactions,
    count(distinct owner) as n_users,
    sum(amt_avUSD) as total_amt_avUSD,
    sum(amt_savUSD) as total_amt_savUSD
    from eventTb
    group by 1,2
    order by 2 desc



    Last run: 30 days ago
    EVENT_NAME
    DATE
    N_TRANSACTIONS
    N_USERS
    TOTAL_AMT_AVUSD
    TOTAL_AMT_SAVUSD
    1
    		Withdraw2025-03-24 00:00:00.0002212.34692846511.990497999
    2
    		Deposit2025-03-24 00:00:00.0004440509.32479908639339.903794782
    3
    		Withdraw2025-03-17 00:00:00.00033115986.294205763112961.992232668
    4
    		Deposit2025-03-17 00:00:00.00033171969817.565520071913233.78074037
    5
    		Withdraw2025-03-10 00:00:00.00076280793.527760916274474.123913282
    6
    		Deposit2025-03-10 00:00:00.0003429939768.317271937918306.068832769
    7
    		Deposit2025-03-03 00:00:00.000171569195.02499085467738.749247914
    8
    		Withdraw2025-03-03 00:00:00.00066222300.322119282217877.869414693
    9
    		Withdraw2025-02-24 00:00:00.00066504531.115207365495873.656453873
    10
    		Deposit2025-02-24 00:00:00.0001381043825.301390391024922.90307101
    11
    		Withdraw2025-02-17 00:00:00.000332457.1471498022421.360877725
    12
    		Deposit2025-02-17 00:00:00.0003732333311.081956013328049.24252907
    13
    		Withdraw2025-02-10 00:00:00.000111011236.03366372111087.440400647
    14
    		Deposit2025-02-10 00:00:00.00069472829945.133631272792748.51558431
    15
    		Withdraw2025-02-03 00:00:00.000661277.6499047111264.229548856
    16
    		Deposit2025-02-03 00:00:00.0003327483244.271007552477939.783561927
    17
    		Withdraw2025-01-27 00:00:00.000161413619.59761556413521.861910122
    18
    		Deposit2025-01-27 00:00:00.0006149126835.214735115125883.71555153
    19
    		Withdraw2025-01-20 00:00:00.0006618974.30916269418880.082807616
    20
    		Deposit2025-01-20 00:00:00.0008960465187.156818216463306.393661494
    29
    2KB
    3s