kitlunaNumber of Interactions with Contracts Deployed in 2022 per Month
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
CASE
WHEN date_trunc('day', block_timestamp) BETWEEN '2022-01-01' AND '2022-01-31' THEN '1,January'
WHEN date_trunc('day', block_timestamp) BETWEEN '2022-02-01' AND '2022-02-28' THEN '2,February'
WHEN date_trunc('day', block_timestamp) BETWEEN '2022-03-01' AND '2022-03-31' THEN '3,March'
WHEN date_trunc('day', block_timestamp) BETWEEN '2022-04-01' AND '2022-04-30' THEN '4,April'
WHEN date_trunc('day', block_timestamp) BETWEEN '2022-05-01' AND '2022-05-31' THEN '5,May'
WHEN date_trunc('day', block_timestamp) BETWEEN '2022-06-01' AND '2022-06-30' THEN '6,June'
WHEN date_trunc('day', block_timestamp) BETWEEN '2022-07-01' AND '2022-07-31' THEN '7,July'
END AS "month",
COUNT (DISTINCT (TX_HASH)) AS interaction
FROM near.core.fact_transactions
WHERE TX_RECEIVER IN (
SELECT TX_RECEIVER
FROM near.core.fact_transactions
where TX LIKE '%DeployContract%"method_name":"new"%'
AND BLOCK_TIMESTAMP BETWEEN '2022-01-01' AND '2022-07-31'
)
AND block_timestamp BETWEEN '2022-01-01' AND '2022-07-31'
GROUP BY "month"
ORDER BY "month"
Run a query to Download Data