date | total transactions | total traders | |
|---|---|---|---|
1 | 2024-09-01 00:00:00.000 | 15622 | 7778 |
2 | 2024-09-02 00:00:00.000 | 15197 | 7429 |
3 | 2024-09-03 00:00:00.000 | 20419 | 8877 |
4 | 2024-09-04 00:00:00.000 | 22447 | 8098 |
5 | 2024-09-05 00:00:00.000 | 32564 | 9895 |
6 | 2024-09-06 00:00:00.000 | 27183 | 8483 |
7 | 2024-09-07 00:00:00.000 | 23670 | 7033 |
8 | 2024-09-08 00:00:00.000 | 21037 | 7377 |
9 | 2024-09-09 00:00:00.000 | 17888 | 7325 |
10 | 2024-09-10 00:00:00.000 | 16764 | 7745 |
11 | 2024-09-11 00:00:00.000 | 27714 | 7836 |
12 | 2024-09-12 00:00:00.000 | 20801 | 7466 |
13 | 2024-09-13 00:00:00.000 | 21378 | 9416 |
14 | 2024-09-14 00:00:00.000 | 17405 | 8429 |
15 | 2024-09-15 00:00:00.000 | 18815 | 9387 |
16 | 2024-09-16 00:00:00.000 | 14360 | 8609 |
17 | 2024-09-17 00:00:00.000 | 15119 | 6699 |
18 | 2024-09-18 00:00:00.000 | 12433 | 6675 |
19 | 2024-09-19 00:00:00.000 | 22325 | 7568 |
20 | 2024-09-20 00:00:00.000 | 15497 | 7100 |
datavortexDaily trends
Updated 2025-03-25
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
›
⌄
⌄
/*
SELECT
AVG(price) AS average_price
FROM
solana.price.ez_prices_hourly
WHERE
hour BETWEEN '2024-08-31 00:00:00' AND '2024-09-18 23:59:59'
AND
token_address = 'So11111111111111111111111111111111111111112';
*/
SELECT
date_trunc('day', block_timestamp) AS "date",
COUNT(DISTINCT tx_id) AS "total transactions",
COUNT(DISTINCT CASE WHEN seller IS NOT NULL THEN seller END) +
COUNT(DISTINCT CASE WHEN purchaser IS NOT NULL THEN purchaser END) AS "total traders"
FROM
solana.nft.fact_nft_sales
WHERE
block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'
GROUP BY
date_trunc('day', block_timestamp)
ORDER BY
"date";
Last run: 3 months ago
29
1KB
1s