elsina2023-08-27 10:35 PM
Updated 2023-08-27
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
›
⌄
-- -- Contract creation based on EMPTY tx.to address and NOT NULL input_data --
-- SELECT
-- ORIGIN_FUNCTION_SIGNATURE as "Signature",
-- COUNT(*) as "Count"
-- FROM
-- ethereum.core.fact_transactions
-- WHERE
-- TO_ADDRESS IS NULL
-- AND date_trunc('day', block_timestamp) >= '{{date}}'
-- AND INPUT_DATA != ''
-- GROUP BY
-- 1
-- ORDER BY
-- 2 DESC
-- SELECT
-- TX_HASH,
-- BLOCK_TIMESTAMP,
-- INPUT_DATA
-- FROM
-- ethereum.core.fact_transactions
-- WHERE
-- TO_ADDRESS IS NULL
-- -- AND date_trunc('day', BLOCK_TIMESTAMP) >= '{{date}}'
-- AND INPUT_DATA != ''
-- AND ORIGIN_FUNCTION_SIGNATURE = '0x60806040'
-- LIMIT
-- 10
SELECT
TX_HASH,
BLOCK_TIMESTAMP,
INPUT_DATA
FROM
ethereum.core.fact_transactions
WHERE
TO_ADDRESS IS NULL
Run a query to Download Data