cypherQuix vs Magic Eden vs OpenSea
Updated 2022-09-27
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
›
⌄
-- daily volume
-- fees generated
-- active users
-- top 5 projects per marketplace
-- number of transactions
with daily_volume as (select
date_trunc('day', block_timestamp) as day,
sum(price) as OP_volume,
sum(price_usd) as usd_volume,
currency_symbol
from optimism.core.ez_nft_sales
where platform_name = 'quixotic'
and block_timestamp >= '2022-1-1'
and event_type = 'sale'
and currency_symbol = 'OP'
group by day, currency_symbol)
select * from daily_volume
-- select distinct(currency_symbol) from optimism.core.ez_nft_sales
-- WITH table1 AS (
-- SELECT
-- date_trunc ('hour', BLOCK_TIMESTAMP) AS DATE,
-- CURRENCY_SYMBOL,
-- SUM (PRICE) AS "volume"
-- FROM optimism.core.ez_nft_sales
-- WHERE CURRENCY_SYMBOL = 'ETH'
-- GROUP BY 1,2
-- ),
-- eth AS (
-- SELECT
-- sum ("volume" * b.PRICE) AS "Sales volume in ETH (usd)"
-- FROM table1 a JOIN ethereum.core.fact_hourly_token_prices b ON a.DATE = b.HOUR
Run a query to Download Data