PROGRAM_NAME | TRANSACTIONS | USERS | VOLUME_OLAS | VOLUME_USD | AVERAGE_AMOUNT_OLAS | AVERAGE_AMOUNT_USD | DAILY_AVERAGE_TRANSACTIONS | DAILY_AVERAGE_USERS | |
|---|---|---|---|---|---|---|---|---|---|
1 | Everest | 81 | 12 | 52.027174272 | 214.03 | 0.6423107935 | 2.642345679 | 1.5 | 0.222222 |
2 | Alpine | 164 | 75 | 67.34088955 | 295.68 | 0.4106151802 | 1.802926829 | 2.484848 | 1.136364 |
3 | Coastal | 299 | 84 | 1038.653026094 | 2137.57 | 3.47375594 | 7.149063545 | 3.147368 | 0.884211 |
4 | Alpha | 127 | 41 | 56.651042732 | 104.03 | 0.4460712026 | 0.8191338583 | 1.953846 | 0.630769 |
Afonso_Diazby program
Updated 2025-01-27
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
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
amount,
amount_usd,
origin_from_address as user,
program_name
from
crosschain.olas.ez_olas_staking
)
select
program_name,
count(distinct tx_hash) as transactions,
count(distinct user) as users,
sum(amount) as volume_olas,
sum(amount_usd) as volume_usd,
avg(amount) as average_amount_olas,
avg(amount_usd) as average_amount_usd,
transactions / count(distinct block_timestamp::date) as daily_average_transactions,
users / count(distinct block_timestamp::date) as daily_average_users
from
main
where
block_timestamp between '{{ start_date }}' and '{{ end_date }}'
group by 1
Last run: 3 months ago
4
321B
1s