ArioPolygon Details
Updated 2022-08-26
999
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
A_TPM as (
select
date_trunc('day', BLOCK_TIMESTAMP) as date,
count(distinct Tx_hash) as Number_of_STX, -- N of Success Tx
Number_of_STX/1440 as Average_N_TX_M --Average number of transactions per minute
FROM
polygon.core.fact_transactions
where
BLOCK_TIMESTAMP >= CURRENT_DATE - 30
AND
STATUS = 'SUCCESS'
group by date
order by date desc
),
Matic_Price as (
select
date_trunc('day', HOUR) as date,
avg(price) as avg_price
from ethereum.core.fact_hourly_token_prices
where
symbol = 'MATIC'
AND
HOUR >= CURRENT_DATE - 30
group by DATE
order by date desc
),
N_Users as (
SELECT
date_trunc('day', BLOCK_TIMESTAMP) as date,
count(distinct FROM_ADDRESS) as N_Unique_Users
from
polygon.core.fact_transactions
Run a query to Download Data