TOTAL_CA | AVG_CA_PER_DAY | |
|---|---|---|
1 | 16083 | 2612.324675 |
feyikemiTotal Contracts
Updated 2025-02-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH daily_ca AS (
SELECT
block_timestamp::date AS event_date,
COUNT(DISTINCT CONTRACT_ADDRESS) AS daily_deployed_CA
FROM kaia.core.fact_event_logs
WHERE block_timestamp::date >= '2024-09-25'
GROUP BY event_date
)
SELECT
(SELECT COUNT(DISTINCT CONTRACT_ADDRESS)
FROM kaia.core.fact_event_logs
WHERE block_timestamp::date >= '2024-09-25') AS TOTAL_CA,
AVG(daily_deployed_CA) AS AVG_CA_PER_DAY
FROM daily_ca
Last run: 3 months ago
1
21B
5s