SocioCryptodaily NEW smart contracts
Updated 2023-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT CASE WHEN date between '2023-01-07' AND '2023-01-13' THEN 'before'
WHEN date between '2023-01-15' AND '2023-01-21' THEN 'after'
ELSE 'announcement' END as periods,
avg(n_new_contracts) as avg_new_contracts
FROM
(
SELECT date_Trunc('day',first_used) as date,
COUNT(DISTINCT contract) as n_new_contracts
FROM
(
SELECT tm.attribute_value as contract,
min(block_timestamp) as first_used
FROM terra.core.fact_msg_attributes tm
left JOIN terra.core.dim_address_labels tl
on tm.attribute_value = tl.address
WHERE tm.attribute_key IN ('_contract_address', 'contract_addr', 'contract_address', 'contract_name', 'contract')
GROUP BY contract
)
GROUP BY date)
WHERE date BETWEEN '2023-01-07' AND '2023-01-21'
GROUP BY periods
Run a query to Download Data