potmopolygon active users
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with transactors as
(select distinct from_address as transactor
from polygon.core.fact_transactions
where block_timestamp >= CURRENT_DATE - INTERVAL '{{interval}}' ),
receivers as
(select distinct to_address as receiver
from polygon.core.fact_transactions
where block_timestamp>=CURRENT_DATE-INTERVAL '{{interval}}' )
select
(select count(*)
from transactors) as total_active_transactors,
(select count(*)
from receivers) as total_active_receivers,
(select count(receiver)
from receivers
where receiver not in
(select transactor
from transactors)) as receivers_only,
total_active_transactors + receivers_only as total_active_users
Run a query to Download Data