saeide-ahmadi-7Statistical Information
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with table1 as (SELECT
date_trunc('day', block_timestamp) as day,
count(distinct from_address) as number_of_unique_addresses,
count(tx_hash) as number_of_transaction
FROm
polygon.core.fact_transactions
GROUP BY day
ORDER by day
)
SELECT
max(number_of_unique_addresses) as max_daily_unique_addresses,
max(number_of_transaction) as max_daily_transactions,
avg(number_of_unique_addresses) as avg_daily_unique_addresses,
avg(number_of_transaction) as avg_daily_transactions
FROM
table1
Run a query to Download Data