kaibladeOpensea Most Popular Collections
Updated 2022-12-10
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
›
⌄
WITH nft_sales AS
(SELECT *
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::date >= CURRENT_DATE - INTERVAL '2 months'
),
blur_sales AS
(SELECT *, 'WETH' AS symbol
FROM nft_sales
WHERE platform_name = 'blur'),
opensea_sales AS
(SELECT *
FROM nft_sales
WHERE platform_name = 'opensea'),
eth_price AS
(SELECT hour, decimals, symbol
FROM ethereum.core.fact_hourly_token_prices
WHERE symbol = 'WETH'
ORDER BY hour DESC
LIMIT 1)
-- SELECT nft_address
-- FROM opensea_sales
-- WHERE project_name = 'opensea'
-- daily_blur_sales AS
-- (
SELECT
(CASE
WHEN project_name IS NOT NULL THEN project_name
WHEN nft_address = '0xb16dfd9aaaf874fcb1db8a296375577c1baa6f21' THEN 'Nyolings'
WHEN nft_address = '0x8e6e63e05fffc220f808674e6ce14c82799d9f84' THEN 'Down Mother Ducks (DMD)'
WHEN nft_address = '0x942bc2d3e7a589fe5bd4a5c6ef9727dfd82f5c8a' THEN 'Art Blocks Explorations'
WHEN nft_address = '0x5802c586f657c787902280ac091d81832d7faf84' THEN 'Bored y00ts AC'
Run a query to Download Data