DATE | EVENT_NAME | TRANSACTIONS | USERS | VOLUME | AVERAGE_AMOUNT | CUMULATIVE_TRANSACTIONS | CUMULATIVE_VOLUME | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | Stake | 14603 | 11518 | 29462.189428 | 2.017543616243 | 14603 | 29462.189428 |
2 | 2025-02-19 00:00:00.000 | Unstake | 1962 | 1560 | 1380.878249 | 0.696709510091 | 1962 | 1380.878249 |
3 | 2025-02-20 00:00:00.000 | Stake | 52838 | 41739 | 169646.284924 | 3.210687098755 | 67441 | 199108.474352 |
4 | 2025-02-20 00:00:00.000 | Unstake | 13191 | 8719 | 124086.530737 | 9.201819112866 | 15153 | 125467.408986 |
5 | 2025-02-21 00:00:00.000 | Stake | 47060 | 36620 | 146927.552162 | 3.122132430132 | 114501 | 346036.026514 |
6 | 2025-02-21 00:00:00.000 | Unstake | 13916 | 8972 | 44692.374334 | 3.114668223151 | 29069 | 170159.78332 |
7 | 2025-02-22 00:00:00.000 | Stake | 57176 | 39822 | 89452.553968 | 1.564484914703 | 171677 | 435488.580482 |
8 | 2025-02-22 00:00:00.000 | Unstake | 19941 | 12197 | 71215.429909 | 3.427114047594 | 49010 | 241375.213229 |
9 | 2025-02-23 00:00:00.000 | Stake | 100184 | 55522 | 208862.633394 | 2.084790319752 | 271861 | 644351.213876 |
10 | 2025-02-23 00:00:00.000 | Unstake | 34066 | 16056 | 419774.471783 | 11.785127931245 | 83076 | 661149.685012 |
11 | 2025-02-24 00:00:00.000 | Stake | 115700 | 67015 | 86673.150478 | 0.749119710268 | 387561 | 731024.364354 |
12 | 2025-02-24 00:00:00.000 | Unstake | 44206 | 20000 | 70583.16287 | 1.523224197635 | 127282 | 731732.847882 |
13 | 2025-02-25 00:00:00.000 | Stake | 262212 | 161983 | 109306.391618 | 0.416862659291 | 649773 | 840330.755972 |
14 | 2025-02-25 00:00:00.000 | Unstake | 75231 | 36409 | 117897.712209 | 1.51625227904 | 202513 | 849630.560091 |
15 | 2025-02-26 00:00:00.000 | Stake | 519685 | 340649 | 136310.497001 | 0.26229446107 | 1169458 | 976641.252973 |
16 | 2025-02-26 00:00:00.000 | Unstake | 149576 | 72580 | 130807.067061 | 0.851930201906 | 352089 | 980437.627152 |
17 | 2025-02-27 00:00:00.000 | Stake | 254807 | 161003 | 75659.868297 | 0.296930101202 | 1424265 | 1052301.12127 |
18 | 2025-02-27 00:00:00.000 | Unstake | 87897 | 43537 | 107955.100521 | 1.173629115074 | 439986 | 1088392.727673 |
19 | 2025-02-28 00:00:00.000 | Stake | 223611 | 128045 | 56865.52115 | 0.254304425299 | 1647876 | 1109166.64242 |
20 | 2025-02-28 00:00:00.000 | Unstake | 95522 | 44287 | 115860.464673 | 1.125427057087 | 535508 | 1204253.192346 |
winnie-fsOvertime copy
Updated 7 days ago
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
›
⌄
-- forked from Afonso_Diaz / Overtime @ https://flipsidecrypto.xyz/Afonso_Diaz/q/sVvAaf2NMfhr/overtime
with
main as (
select
tx_hash,
block_timestamp,
origin_from_address as user,
utils.udf_hex_to_int(data)::bigint / 1e18 as amount,
iff(topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000', 'Stake', 'Unstake') as event_name
from
monad.testnet.fact_event_logs
where
tx_succeeded
and origin_to_address = '0xb2f82d0f38dc453d596ad40a37799446cc89274a'
and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and contract_address = lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
and block_timestamp >= '2025-02-19'
)
select
date_trunc('{{ period }}', block_timestamp) as date,
event_name,
count(distinct tx_hash) as transactions,
count(distinct user) as users,
sum(amount) as volume,
avg(amount) as average_amount,
sum(transactions) over (partition by event_name order by date) as cumulative_transactions,
sum(volume) over (partition by event_name order by date) as cumulative_volume
from
main
group by 1, 2
order by 1, 2
Last run: 7 days ago
74
7KB
31s