CarlOwOsUntitled Query
Updated 2022-10-25
99
1
2
3
4
5
6
7
8
9
10
›
⌄
WITH projects AS (
SELECT tx_json:receipt:contractAddress AS project_address
FROM polygon.core.fact_transactions
WHERE from_address = '0x36fb3886cf3fc4e44d8b99d9a8520425239618c2'
AND substr(input_data, 0, 10) = '0x60806040'
)
SELECT *
FROM polygon.core.fact_transactions
WHERE tx_hash = '0x739f7604a60aa872352338f2f2123ad22f48fae8f7322f1bac749a284e882447'
AND block_timestamp >= '2022-01-01'
Run a query to Download Data