dannerUntitled Query
Updated 2022-10-31Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with orgs as (
select
*,
regexp_substr_all(SUBSTR(input, 11, len(input)), '.{64}') AS segmented_input
from
polygon.core.fact_traces
where block_timestamp :: DATE > '2022-10-16' :: DATE
and type = 'CALL'
and from_address = LOWER('0x218b3c623ffb9c5e4dbb9142e6ca6f6559f1c2d6') -- deployer
and substr(input, 0, 10) = '0xb6dbcae5'
)
select
try_hex_decode_string(segmented_input[14]::string) as org_name,
to_address as org_address,
block_timestamp as org_created_timestamp,
block_number as org_created_block,
tx_hash as org_created_hash
from orgs
Run a query to Download Data