freemartianهولدرهای قلمو
Updated 2024-09-22
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
›
⌄
-- forked from Brush Holders Count @ https://flipsidecrypto.xyz/edit/queries/0e86cf60-3c6e-452d-856e-dcf29219f12d
with
sells_buys AS (
select
tx_hash,
block_timestamp,
seller_address AS nft_from,
buyer_address AS nft_to,
tokenid
from base.nft.ez_nft_sales
where nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'
-- and tokenid = 696
),
transfers AS (
select
tx_hash,
block_timestamp,
nft_to_address AS nft_to,
nft_from_address AS nft_from,
tokenid
from base.nft.ez_nft_transfers
where nft_address = '0xd68fe5b53e7e1abeb5a4d0a6660667791f39263a'
and tx_hash not in (select tx_hash from sells_buys)
),
final AS (
SELECT
block_timestamp,
nft_from,
nft_to,
tokenid
FROM
sells_buys
UNION
SELECT
block_timestamp,
QueryRunArchived: QueryRun has been archived