bachiquix mkt2
Updated 2022-09-28Copy 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
›
⌄
with quix_nfts as (
SELECT tx_hash AS tx_id
, block_timestamp
, buyer_address AS buyer
, seller_address AS seller
, nft_address
, NULL AS project_name
, currency_symbol
, price
, price_usd
FROM optimism.core.ez_nft_sales
WHERE platform_name = 'quixotic'
AND block_timestamp >= '2022-01-01'
)
select date(block_timestamp) as day,
count(distinct tx_id) as no_of_txns,
count(distinct buyer) as no_of_users,
round(sum(price),2) as tot_volume,
round(sum(price_usd),2) as tot_volume_usd
from quix_nfts
group by day
order by day desc
Run a query to Download Data