alitaslimiSales Daily
Updated 2022-11-02
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
prices AS (
SELECT
timestamp::date AS date,
AVG(price_usd) AS price
FROM
flow.core.fact_prices
WHERE
token_contract = 'A.1654653399040a61.FlowToken'
GROUP BY
date
),
transactions AS (
SELECT
DATE_TRUNC(day, sales.block_timestamp) AS interval,
sales.currency AS token,
COUNT(DISTINCT sales.tx_id) AS txn,
COUNT(DISTINCT sales.nft_id) AS nfts,
COUNT(DISTINCT sales.buyer) AS buyers,
COUNT(DISTINCT sales.seller) AS sellers,
CASE
WHEN sales.currency = 'A.1654653399040a61.FlowToken' THEN SUM(sales.price * prices.price)
ELSE SUM(sales.price)
END AS volume_usd,
CASE
WHEN sales.currency = 'A.1654653399040a61.FlowToken' THEN AVG(sales.price * prices.price)
ELSE AVG(sales.price)
END AS price_usd,
avg(price_usd) OVER(ORDER BY interval ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as price_7dma
FROM
flow.core.fact_nft_sales sales
JOIN
prices
ON
sales.block_timestamp::date = prices.date
WHERE
Run a query to Download Data