adriaparcerisasflow stats: monthly new contracts
Updated 2025-01-03
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
›
⌄
WITH core_news AS (
SELECT DISTINCT event_contract AS new_contract,
MIN(trunc(block_timestamp, 'month')) AS debut
FROM flow.core.fact_events
GROUP BY 1
),
evm_news AS (
SELECT DISTINCT contract AS new_contract,
MIN(trunc(block_timestamp, 'month')) AS debut
FROM (
select x.block_timestamp, x.from_address as creator,y.contract_address as contract
from flow.core_evm.fact_transactions x
join flow.core_evm.fact_event_logs y on x.tx_hash=y.tx_hash
where y.topics[0] ilike '%0x8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e0%'
UNION
select x.block_timestamp, x.from_address as creator, x.tx_hash as contract
from flow.core_evm.fact_transactions x
where (x.origin_function_signature='0x60c06040' or x.origin_function_signature='0x60806040') and tx_hash not in (select x.tx_hash
from flow.core_evm.fact_transactions x
join flow.core_evm.fact_event_logs y on x.tx_hash=y.tx_hash
where y.topics[0] ilike '%0x8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e0%')
)
GROUP BY 1
),
combined_news AS (
SELECT new_contract, debut FROM core_news
UNION ALL
SELECT new_contract, debut FROM evm_news
),
tots as (
select count(distinct new_contract) as total_contracts from combined_news
),
active_contracts AS (
SELECT
trunc(x.block_timestamp, 'month') AS date,
COUNT(DISTINCT event_contract) AS active_contracts
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived