Total # of Users | |
|---|---|
1 | 11772 |
rezarwzTotal # of Users
Updated 2025-02-26
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
›
⌄
with all_wallets as (
SELECT
block_number,
block_timestamp,
tx_hash,
to_address AS created_contract_address,
from_address AS creator_address,
input AS created_contract_input,
INSERTED_TIMESTAMP
from
blast.core.fact_traces
WHERE
TYPE ILIKE 'create%'
AND to_address IS NOT NULL
AND input IS NOT NULL
AND input != '0x'
AND tx_status = 'SUCCESS'
AND trace_status = 'SUCCESS'
and tx_hash in (
SELECT
tx_hash
FROM
blast.core.fact_transactions
where
to_address = lower('0x0000000071727De22E5E9d8BAf0edAc6f37da032')
)
)
SELECT
count(created_contract_address) as "Total # of Users"
FROM
all_wallets
Last run: about 2 months ago
1
9B
164s