OneDataAnalystDaily past 5 months
Updated 2022-10-05Copy Reference Fork
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 Ethereum AS (
SELECT
Date_trunc('day',BLOCK_TIMESTAMP) AS Date,
BUYER_ADDRESS,
SELLER_ADDRESS,
PROJECT_NAME AS Collection,
PRICE_USD
FROM ethereum.core.ez_nft_sales
WHERE tx_hash != '0xc5531fa64ce1e5c609489e734325835471215ad5f8e0972c94b64d12242d97e4'
),
OP AS (
SELECT
Date_trunc('day',BLOCK_TIMESTAMP) AS Date,
BUYER_ADDRESS,
SELLER_ADDRESS,
NFT_ADDRESS AS Collection,
PRICE_USD
FROM optimism.core.ez_nft_sales
),
SOLP AS (
SELECT DATE_TRUNC('Day',HOUR) AS dt, AVG(PRICE) AS SOL_PRICE
FROM ethereum.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS = '0xd31a59c85ae9d8edefec411d448f90841571b89c'
GROUP BY 1
),
Solana AS (
SELECT
Date_trunc('day',BLOCK_TIMESTAMP) AS Date,
PURCHASER,
SELLER,
MINT AS Collection,
SALES_AMOUNT*SOL_PRICE AS PRICE_USD
FROM solana.core.fact_nft_sales
Run a query to Download Data