Josh956Poly summary stats
Updated 2023-02-17
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 a as (select date_trunc('day',block_timestamp) as day, 'Pre-upgrade' as type,
count(distinct tx_hash) as "TX Count",
count(distinct from_address) as "Unique Senders",
sum(matic_value) as "Matic volume",
avg(matic_value) as "Avg matic value",
median(matic_value) as "Median matic value",
max(matic_value) as "Max matic value",
sum(tx_fee) as "tx fee volume",
avg(tx_fee) as "Avg tx fee value",
median(tx_fee) as "Median tx fee value",
max(tx_fee) as "Max tx fee value",
sum(gas_used) as "Gas Used",
sum("TX Count") over (order by day) as "cumulative tx count",
sum("Unique Senders") over (order by day) as "cumulative unique sender count",
sum("Matic volume") over (order by day) as "cumulative matic volume",
sum("tx fee volume") over (order by day) as "cumulative tx fee volume",
sum("Gas Used") over (order by day) as "cumulative gas used"
from polygon.core.fact_transactions
where matic_value>0.01
and day>'2023-01-01'
and day<='2023-01-17'
group by 1,2),
b as (select date_trunc('day',block_timestamp) as day, 'Post-Upgrade' as type,
count(distinct tx_hash) as "TX Count",
count(distinct from_address) as "Unique Senders",
sum(matic_value) as "Matic volume",
avg(matic_value) as "Avg matic value",
median(matic_value) as "Median matic value",
max(matic_value) as "Max matic value",
sum(tx_fee) as "tx fee volume",
avg(tx_fee) as "Avg tx fee value",
median(tx_fee) as "Median tx fee value",
max(tx_fee) as "Max tx fee value",
sum(gas_used) as "Gas Used",
sum("TX Count") over (order by day) as "cumulative tx count",
Run a query to Download Data