oooooblahparallel_legendaries
Updated 2023-11-29
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
›
⌄
select
block_timestamp,
platform_name,
tokenid,
currency_symbol,
price,
price_usd,
CASE
WHEN tokenid = '10842' THEN 'Ottius'
WHEN tokenid = '10395' THEN 'Magna'
WHEN tokenid = '10947' THEN 'Akara'
WHEN tokenid = '10867' THEN 'Tane'
WHEN tokenid = '10309' THEN 'JRJ'
ELSE NULL
END AS Name
from
ethereum.nft.ez_nft_sales
where
(
tokenid = '10395'
or tokenid = '10842'
or tokenid = '10947'
or tokenid = '10867'
or tokenid = '10309'
)
AND nft_address = lower('0x76be3b62873462d2142405439777e971754e8e77')
and date(block_timestamp) > '2023-09-01'
and price_usd < 600
Run a query to Download Data