Sandeshnew users active
Updated 2022-10-25
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
26
›
⌄
with new_users as
(
select distinct from_address
from optimism.core.fact_transactions
where to_address in
(
lower('0xc35DADB65012eC5796536bD9864eD8773aBc74C4'),
lower('0x93395129bd3fcf49d95730D3C2737c17990fF328'),
lower('0x2f686751b19a9d91cc3d57d90150Bc767f050066'),
lower('0xCaAbdD9Cf4b61813D4a52f980d6BC1B713FE66F5'),
lower('0xbE811A0D44E2553d25d11CB8DC0d3F0D0E6430E6'),
lower('0xaB235da7f52d35fb4551AfBa11BFB56e18774A65'),
lower('0x8B396ddF906D552b2F98a8E7d743DD58Cd0d920f'),
lower('0x4ab2fc6e258a0ca7175d05ff10c5cf798a672cae'),
lower('0x0689640d190b10765f09310fcfe9c670ede4e25b')
)
and block_timestamp > CURRENT_DATE - interval ' {{number_of_months}} months'
and nonce < 3
group by 1
)
select date_trunc('week',block_timestamp) as week, count(distinct tx_hash) as transactions, count(distinct ORIGIN_FROM_ADDRESS) as users
from optimism.sushi.ez_swaps
where ORIGIN_FROM_ADDRESS in ( select * from new_users)
and block_timestamp > current_date - interval ' {{number_of_months}} months'
group by week
Run a query to Download Data