TIME | TOTAL_CONTRACTS | |
|---|---|---|
1 | All time | 8715 |
2 | last 60 days | 3894 |
3 | last 30 days | 3179 |
4 | last 7 days | 389 |
5 | last day | 137 |
Abbas_ra21SwellChain Factory: Contracts Deploying activity
Updated 2 days ago
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 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
swell.core.fact_traces
where
TYPE like 'CREATE%'
union ALL
select
'last 60 days' AS Time,
count (DISTINCT TO_ADDRESS) as Total_contracts
from
swell.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
swell.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
swell.core.fact_traces
where
TYPE like 'CREATE%'
and BLOCK_TIMESTAMP::date >= current_date - 7
Last run: 2 days ago
5
100B
2s