Spectersummary
Updated 2025-01-13
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
›
⌄
-- SELECT *
-- FROM polygon.core.ez_decoded_event_logs
-- WHERE contract_address = '0x8ccd9c0a9c084412416a85fd748c7f1e9b86442d'
-- AND TX_HASH = '0x2daa58666760248dd1f923bfec75a2a48205855a6ca02f0d1bb0e0b2fb18ac38'
-- AND block_timestamp >= '2024-05-31'
WITH Polygon AS (
SELECT block_timestamp, tx_hash, 'polygon' AS chain,
decoded_log:domainName AS Name,
TO_TIMESTAMP(decoded_log:expiry) AS expiry_date,
decoded_log:owner AS Owner
FROM polygon.core.ez_decoded_event_logs
WHERE contract_address = '0x8ccd9c0a9c084412416a85fd748c7f1e9b86442d'
--AND TX_HASH = '0xb662f846f85093b9971cc2facdbb0ac774977ca8f232e573656e26dda848fd17'
AND block_timestamp >= '2024-05-31'
AND event_name = 'MintedDomain'
--),
UNION ALL
--BSC AS (
SELECT
block_timestamp, tx_hash, 'bsc' AS chain,
decoded_log:domainName AS Name,
TO_TIMESTAMP(decoded_log:expiry) AS expiry_date,
decoded_log:owner AS Owner
FROM bsc.core.ez_decoded_event_logs
WHERE contract_address = '0x7e2cf06f092c9f5cf5972ef021635b6c8e1c5bb2'
--AND TX_HASH = '0x8fb144315a4d626b64417179918723361ba36a7e16e013fcdf6998e213eddf62'
AND block_timestamp >= '2024-04-30'
AND event_name = 'MintedDomain'
--),
UNION ALL
---Blast AS (
SELECT
block_timestamp, tx_hash, 'blast' AS chain,
decoded_log:domainName AS Name,
QueryRunArchived: QueryRun has been archived