frankmaseo2024-03-29 05:56 PM
Updated 2024-03-29
999
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
edges as (
SELECT
to_address as address,
from_address as funder_address,
amount,
block_number,
ROW_NUMBER() OVER (PARTITION BY to_address order by block_number asc) as tx_order
FROM ethereum.core.ez_native_transfers t
WHERE to_address IN (
lower('0x2aD954593EA24C60E5FEe7b84715227420890BE6'),
lower('0xAB6e493b50AF4E432bA1A9eB37c07EAd13188a94'),
lower('0xbB6077aA3c60179306C78F42FC73888fe8cB8f65'),
lower('0x3476613f6b2865aBf6f9fA621Cf018D810000f70'),
lower('0x59e69d7988d98cd5255966b6419d927bebafc578')
)
)/*,
contracts as (
SELECT DISTINCT to_address as contract_address
FROM ethereum.core.fact_traces
WHERE
TYPE IN ('CREATE', 'CREATE2')
AND TX_STATUS = 'SUCCESS'
AND TRACE_STATUS = 'SUCCESS'
AND TO_ADDRESS IN (lower('0x71660c4005ba85c37ccec55d0c4493e66fe775d3'),
lower('0x6000da47483062a0d734ba3dc7576ce6a0b645c4'),
lower('0xa9d1e08c7793af67e9d92fe308d5697fb81d3e43'),
lower('0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad'),
lower('0x419a37421eed2c6d7061c28eb7f8aa8ed2e5b7ba'),
lower('0xecfe954287effd8dbaffd8881b82633dd9a61f97'),
lower('0x15a68861dfb6877ea04769a778826aeee49a6903'),
lower('0x3f5ce5fbfe3e9af3971dd833d26ba9b5c936f0be'),
QueryRunArchived: QueryRun has been archived