elsinadaily activity
Updated 2024-10-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
date_trunc('month', block_timestamp) as date,
count(DISTINCT origin_from_address) as user_count,
count(DISTINCT tx_hash) as tx_count,
count(distinct program_name) as program_count,
sum(amount_usd) as total_vol,
avg(amount_usd) as avg_stake_vol,
sum(total_vol) over (order by date) as cum_total_vol,
sum(tx_count) over (order by date) as cum_tx_count
from
crosschain.olas.ez_olas_staking
group by
date
order by
date asc
QueryRunArchived: QueryRun has been archived