laurenTotal metrics
Updated 2025-01-22
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
›
⌄
WITH
transaction_summary AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_transactions
FROM
crosschain.olas.ez_service_donations
),
user_summary AS (
SELECT
COUNT(DISTINCT donor_address) AS total_users
FROM
crosschain.olas.ez_service_donations
),
volume_summary AS (
SELECT
SUM(eth_amount) AS total_volume_eth,
SUM(eth_amount_usd) AS total_volume_usd,
AVG(eth_amount) AS avg_volume_eth,
AVG(eth_amount_usd) AS avg_volume_usd
FROM
crosschain.olas.ez_service_donations
),
daily_summary AS (
SELECT
COUNT(DISTINCT block_timestamp::DATE) AS unique_days
FROM
crosschain.olas.ez_service_donations
)
SELECT
ts.total_transactions AS tx_count,
us.total_users AS user_count,
QueryRunArchived: QueryRun has been archived