TRANSACTIONS | USERS | Locked Flow | TVL Flow | Avg Flow Per User | Avg Amount | Max Amount | |
|---|---|---|---|---|---|---|---|
1 | 1800 | 1184 | 30001394.0791047 | 30001394.0791047 | 25339.015269514 | 16667.441155058 | 99999.00100000 |
hessTotal Numbers
Updated 2025-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with base as (select block_timestamp,
tx_id,
EVENT_DATA:"initiator" as user,
event_data:"amount" as amt,
event_data:"contractTVL"::float as tvl
from flow.core.fact_events
where tx_succeeded = 'TRUE'
and event_contract = 'A.a45ead1cf1ca9eda.FlowRewards'
and event_type = 'Locked')
select
count(DISTINCT tx_id) as transactions,
count(DISTINCT user) as users,
sum(amt) as "Locked Flow",
max(tvl) as "TVL Flow",
"Locked Flow"/users as "Avg Flow Per User",
avg(amt) as "Avg Amount",
max(amt) as "Max Amount"
from base
Last run: 3 months ago
1
96B
1s