Abbas_ra21boba network Factory: Contracts Deploying activity copy
Updated 2025-05-08
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
›
⌄
-- forked from SwellChain Factory: Contracts Deploying activity @ https://flipsidecrypto.xyz/studio/queries/9577b6a3-45e1-418f-b80d-741839401b2a
-- forked from The Law Offices of NEAR part 2 @ https://flipsidecrypto.xyz/studio/queries/49827d4c-92df-45a5-b4d8-5684a183fd40
select
'All time' AS Time,
count (DISTINCT TO_ADDRESS) as Total_contracts
from
boba.core.fact_traces
where
TYPE like 'CREATE%'
union ALL
select
'last 60 days' AS Time,
count (DISTINCT TO_ADDRESS) as Total_contracts
from
boba.core.fact_traces
where
TYPE like 'CREATE%'
and BLOCK_TIMESTAMP::date >= current_date - 60
union ALL
select
'last 30 days' AS Time,
count (DISTINCT TO_ADDRESS) as Total_contracts
from
boba.core.fact_traces
where
TYPE like 'CREATE%'
and BLOCK_TIMESTAMP::date >= current_date - 30
union ALL
select
'last 7 days' AS Time,
count (DISTINCT TO_ADDRESS) as Total_contracts
from
boba.core.fact_traces
where
QueryRunArchived: QueryRun has been archived