primo_datapolygon_daily_active_addresses
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
--Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
--In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
-- Daily Active Address
select dt, count(distinct addr) addr_ct
from
(
select date(block_timestamp) dt, from_address addr
from polygon.core.fact_transactions
where date(block_timestamp) >= date('2022-07-01')
and date(block_timestamp) <= date('2022-07-12')
union all
select date(block_timestamp) dt, to_address addr
from polygon.core.fact_transactions
where date(block_timestamp) >= date('2022-07-01')
and date(block_timestamp) <= date('2022-07-12')
) addr
group by 1
order by 1 asc
Run a query to Download Data