jackguyNew Coinbase L2 Chain 5 copy copy
Updated 2023-08-09
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
›
⌄
-- forked from 35ae833f-45d6-4283-a0ad-35a16288f85f
-- forked from c1893b55-2ebd-490b-914f-279c92c28488
SELECT
active_weeks,
count(DISTINCT to_address) as users
FROM (
SELECT
to_address,
count(DISTINCT tx_hash) as transaction,
count(DISTINCT date_trunc('week', block_timestamp)) as active_weeks
-- count(DISTINCT to_address) as contracts_interacted_with
from base.goerli.fact_transactions
WHERE not to_address in (SELECT from_address FROM base.goerli.fact_transactions)
GROUP BY 1
)
GROUP BY 1
--a
Run a query to Download Data