rezarwz2024-05-13 08:03 PM
Updated 2024-05-17
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 all_contracts as (
SELECT
'Blast' as blockchain,
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 BLOCK_TIMESTAMP::date>='2024-02-29'
union
all
SELECT
'Base' as blockchain,
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
Base.core.fact_traces
WHERE
TYPE ILIKE 'create%'
AND to_address IS NOT NULL
QueryRunArchived: QueryRun has been archived