adriaparcerisasOptimism vs Arbitrum 2
Updated 2023-01-18
999
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
t1 as (
SELECT
distinct x.from_address as active_users,
min(block_timestamp) as debut
from arbitrum.core.fact_transactions x
group by 1
),
tt1 as (
SELECT
trunc(debut,'day') as date,
count(distinct active_users) as new_users
from t1
--where debut>='2023-01-01'
group by 1
),
t2 as (
select
distinct ORIGIN_FROM_ADDRESS as swappers,
min(block_timestamp) as debut
from arbitrum.core.fact_event_logs y
where event_name='Swap'
group by 1
),
tt2 as (
SELECT
trunc(debut,'day') as date,
count(distinct swappers) as new_swappers
from t2
--where debut>='2023-01-01'
group by 1
),
t3 as (
select
distinct z.origin_from_address as nft_buyers,
min(block_timestamp) as debut
Run a query to Download Data