TOTAL_DEPOSIT_TRANSACTIONS | TOTAL_DEPOSITORS | TOTAL_COOK_STAKED | TOTAL_COOK_USD_STAKED | TOTAL_COOK_POINTS | MAXIMUM_COOK_STAKED | MINIMUM_COOK_STAKED | MAX_COOK_USD | MIN_COOK_USD | AVERAGE_COOK_POWER_USER | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 8386 | 5449 | 516083369.21 | 14139512.1474824 | 894012038.036 | 62524319.64 | 0.01 | 2126979.19097097 | 0.0002733045 | 106607.68400143096 |
pepperatziHistorical Deposits Metrics
Updated 2025-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
--0x72362d760aec774f91Be7A34981FB6406Fb20A7C COOK feast staking contract
with deposits as (
SELECT
block_timestamp,
tx_hash,
decoded_log:owner::string as user,
'Deposit' as event_name,
decoded_log:amount::int /1e18 as raw_staked,
decoded_log:duration::int / 86400 as duration_locked
from mantle.core.ez_decoded_event_logs
where contract_address = lower('0x72362d760aec774f91Be7A34981FB6406Fb20A7C')
and event_name = 'DepositWithDuration'
),
withdraws as (
SELECT
block_timestamp,
tx_hash,
decoded_log:assets::int / 1e18 as amount_withdrawn,
decoded_log:receiver::string as to_address,
decoded_log:sender::string as from_address
from mantle.core.ez_decoded_event_logs
where contract_address = lower('0x72362d760aec774f91Be7A34981FB6406Fb20A7C')
and event_name = 'Withdraw'
),
prices as (
SELECT
hour,
price
from mantle.price.ez_prices_hourly
where token_address = lower('0x9F0C013016E8656bC256f948CD4B79ab25c7b94D')
),
base_deposits as (
SELECT
Last run: 2 months ago
1
123B
7s