Specterdistribution of name by length
Updated 2024-12-31
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
›
⌄
-- Register (No Discount)
WITH BaseN AS (
SELECT block_timestamp,
tx_hash,
topics,
ORIGIN_FROM_ADDRESS,
regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS segmented,
livequery.utils.udf_hex_to_int(segmented[1]::string) AS expirydate,
TO_TIMESTAMP(expirydate) AS expiry_date,
livequery.utils.udf_hex_to_string(segmented[3]::string) AS basename,
FROM base.core.fact_event_logs
WHERE block_timestamp >= '2024-08-20'
AND contract_address = '0x4ccb0bb02fcaba27e82a56646e81d8c5bc4119a5'
AND topics[0] = '0x0667086d08417333ce63f40d5bc2ef6fd330e25aaaf317b7c489541f8fe600fa'
AND ORIGIN_FUNCTION_SIGNATURE = '0xc7c79676'
AND TX_STATUS = 'SUCCESS'
--AND tx_hash = '0x19229f9c42e6100a2287fed3cf8e7b2e095466c9eb2ad54b71651b8a7486419f'
),
-- Discounted Basename
BaseDis AS (
SELECT block_timestamp,
tx_hash,
topics,
ORIGIN_FROM_ADDRESS,
regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS segmented,
livequery.utils.udf_hex_to_int(segmented[1]::string) AS expirydate,
TO_TIMESTAMP(expirydate) AS expiry_date,
livequery.utils.udf_hex_to_string(segmented[3]::string) AS basename,
FROM base.core.fact_event_logs
WHERE block_timestamp >= '2024-08-20'
AND contract_address = '0x4ccb0bb02fcaba27e82a56646e81d8c5bc4119a5'
AND topics[0] = '0x0667086d08417333ce63f40d5bc2ef6fd330e25aaaf317b7c489541f8fe600fa'
AND ORIGIN_FUNCTION_SIGNATURE = '0xe0093eda'
AND TX_STATUS = 'SUCCESS'
),
QueryRunArchived: QueryRun has been archived