CarlOwOs(4) Contracts deployed
Updated 2022-08-01
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
›
⌄
⌄
WITH contracts AS (
SELECT SPLIT(tx_signer, '.') AS app
, app[1] a1
, app[2] a2
, app[3] a3
, CASE
WHEN a1 IS NOT NULL AND a2 IS NOT NULL AND a3 IS NOT NULL THEN concat(a1,'.',a2,'.',a3)
WHEN a1 IS NOT NULL AND a2 IS NOT NULL AND a3 IS NULL THEN concat(a1,'.',a2)
WHEN a1 IS NOT NULL AND a2 IS NULL AND a3 IS NULL THEN concat(a1)
END AS parent
, block_timestamp::DATE AS date
FROM near.core.fact_actions_events
JOIN near.core.fact_transactions
USING(tx_hash)
WHERE action_name = 'DeployContract'
AND block_timestamp::date >= CURRENT_DATE - 30
)
SELECT parent, date, COUNT(*) AS contracts
FROM contracts
GROUP BY 1,2
-- network view of contract creators
/* Each NEAR account can only hold one smart contract.
However, you can create "subaccounts" with a "master account"
for apps with multiple contracts. Account naming follows the internet
domains model. So for example, the account user-A-account can create
subaccounts contract1.user-A-account and contract2.user-A-account. */
Run a query to Download Data