PapasotENS
Updated 2023-05-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
block_timestamp,
tx_hash,
owner as ethereum_address,
twitter,
ens_name,
expiration_date
from
crosschain.core.ez_ens
where
twitter is not null
and tx_hash is not null
--and expiration_date > '2023-01-01'
order by
block_timestamp desc
SELECT
distinct (twitter)
from crosschain.core.ez_ens