Skip to content
Dune Analytics

@Brecht / Fork of (#3630) ENS Names to be released

SQL query

1SELECT name || '.eth' as name,
2       expires_at,
3       expires_at + INTERVAL '90 day' AS available_after,
4       value / 1e18 AS previous_auction_price
5FROM
6  (SELECT hash,
7          value,
8          row_number() OVER (PARTITION BY hash
9                             ORDER BY VALUE DESC) AS bid_rank
10   FROM ethereumnameservice."Registrar_old_evt_BidRevealed"
11   WHERE status IN (2,
12                    3)) bids
13INNER JOIN
14  (SELECT name,
15          hash
16   FROM ethereumnameservice."old_preimages"
17   UNION SELECT name,
18                label AS hash
19   FROM ethereumnameservice."ETHRegistrarController_3_evt_NameRegistered") labels ON bids.hash=labels.hash
20INNER JOIN
21  (SELECT id,
22          MAX(TIMESTAMP 'epoch' + expires * interval '1 second') AS expires_at
23   FROM
24     (SELECT id,
25             expires...

SQL query results

Loading