aor67po6
Updated 2022-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH bullsontheblock AS (
SELECT * FROM ethereum.core.ez_nft_sales
WHERE event_type = 'sale'
AND block_timestamp::DATE >= '2022-01-01'
AND project_name IN ('bullsontheblock')
AND buyer_address <> '0x0000000000000000000000000000000000000000'
AND price <> '0'
)
SELECT tokenid, price_usd, price
FROM bullsontheblock
where price_usd is not null
ORDER BY 2 DESC
LIMIT 10
Run a query to Download Data