nitsNew Users Joining Optimism Over Time
Updated 2022-11-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with op as
(SELECT date(first_use) as day, count(DISTINCT origin_from_address) as total_addresses,
sum(total_addresses) over (order by day rows BETWEEN 6 preceding and CURRENT row) as moving_avg_addresses, 'op' as type
from
(SELECT origin_from_address,min(block_timestamp) as first_use from optimism.sushi.ez_swaps
GROUP by 1 )
GROUP by 1
ORDER by 1 DESC
LIMIT 183 ),
eth as
(SELECT date(first_use) as day, count(DISTINCT origin_from_address) as total_addresses,
sum(total_addresses) over (order by day rows BETWEEN 6 preceding and CURRENT row) as moving_avg_addresses, 'eth' as type
from
(SELECT origin_from_address,min(block_timestamp) as first_use from ethereum.sushi.ez_swaps
GROUP by 1 )
GROUP by 1
ORDER by 1 DESC
LIMIT 183 )
SELECT * from eth
UNION ALL
SELECT * FROM op
Run a query to Download Data