kaibladeBlur Transaction Count Stats in USD
Updated 2022-12-09
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 nft_sales AS
(SELECT *
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::date >= CURRENT_DATE - INTERVAL '2 months'
),
blur_sales AS
(SELECT *, 'WETH' AS symbol
FROM nft_sales
WHERE platform_name = 'blur'),
opensea_sales AS
(SELECT *
FROM nft_sales
WHERE platform_name = 'opensea'),
eth_price AS
(SELECT hour, decimals, symbol
FROM ethereum.core.fact_hourly_token_prices
WHERE symbol = 'WETH'
ORDER BY hour DESC
LIMIT 1),
daily_blur_sales AS
(SELECT DATE_TRUNC('day', block_timestamp) AS "Days", count(distinct tx_hash) AS "Sales Volume"
FROM blur_sales
GROUP BY "Days")
SELECT (SELECT SUM ("Sales Volume") FROM daily_blur_sales) AS total_sales_volume,
(SELECT AVG ("Sales Volume") FROM daily_blur_sales) AS avg_sales_volume,
(SELECT MAX("Sales Volume") FROM daily_blur_sales) AS max_sales_volume,
(SELECT MIN("Sales Volume") FROM daily_blur_sales) AS min_sales_volume
Run a query to Download Data