SyndicaOptimism Wallets Transactions Count
Updated 2024-11-06
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
27
28
29
30
31
32
33
34
35
36
›
⌄
with
smart_contracts as (
select
from_address as contract
from optimism.core.fact_traces
where tx_status = 'SUCCESS'
and type = 'CREATE'
group by 1
-- and block_timestamp >= '2024-09-01' and block_timestamp < '2024-10-01'
-- limit 10
)
, base as (
select
from_address as user
, count(distinct tx_hash) as transactions
, case
when transactions > 1000000 then '> 1M'
when transactions > 100000 then '> 100k'
when transactions > 10000 then '> 10k'
when transactions > 1000 then '> 1k'
when transactions > 100 then '> 100'
else '<= 100'
end as txs_category
, case txs_category
when '> 1M' then 6
when '> 100k' then 5
when '> 10k' then 4
when '> 1k' then 3
when '> 100' then 2
else 1
end as idx
from optimism.core.fact_transactions
where status = 'SUCCESS'
and block_timestamp >= '2024-10-01'
QueryRunArchived: QueryRun has been archived