CartanGroup2023-11-27 10:45 AM
Updated 2023-11-27
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
›
⌄
select
date(a.block_timestamp) as time_of_sale,
project_name as collection,
tokenid as token_id,
platform_name as marketplace,
price as sale_price,
tx_hash
-- buyer_address as buyer,
-- CREATOR_FEE as royalty_fee
from ethereum.nft.ez_nft_sales a
where currency_symbol in ('ETH','WETH')
and block_timestamp >= '2023-01-01'
and nft_address in (
'0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258',
'0x790b2cf29ed4f310bf7641f013c65d4560d28371',
'0x9d305a42a3975ee4c1c57555bed5919889dce63f',
'0xf87e31492faf9a91b02ee0deaad50d51d56d5d4d'
)
--and nft_address = '0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258'
--and creator_fee > 0 --no other wash trade filter?
and price < 1000
order by price desc
limit 10
Run a query to Download Data