jackguyCopy of potato 7
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
-- date_trunc('day', block_timestamp) as day,
BUYER_ADDRESS,
count(DISTINCT tx_hash) as sales,
sum(PRICE_USD) as sales_volume,
median(PRICE_USD) as median_price
FROM optimism.core.ez_nft_sales
WHERE nft_address LIKE lower('0xfA14e1157F35E1dAD95dC3F822A9d18c40e360E2')
AND not price_usd is NULL
GROUP BY 1
ORDER BY 3 DESC
LIMIT 20
Run a query to Download Data