rezarwzContract Deployments copy
Updated 2024-04-07
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
›
⌄
-- forked from Contract Deployments @ https://flipsidecrypto.xyz/edit/queries/9cd85963-6149-469c-a74d-82d873ec1244
with all_contracts 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'
)
SELECT
*
from
all_contracts
where
created_contract_address = '0x7f0db0d77d0694f29c3f940b5b1f589fff6ef2e0'
QueryRunArchived: QueryRun has been archived