DATE | ETH_ACTIVE_TRADERS | RONIN_ACTIVE_TRADERS | |
|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 7700 | 35407 |
2 | 2025-01-02 00:00:00.000 | 8802 | 39777 |
3 | 2025-01-03 00:00:00.000 | 8922 | 39960 |
4 | 2025-01-04 00:00:00.000 | 7980 | 38162 |
5 | 2025-01-05 00:00:00.000 | 7726 | 36847 |
6 | 2025-01-06 00:00:00.000 | 7843 | 46844 |
7 | 2025-01-07 00:00:00.000 | 7880 | 42891 |
8 | 2025-01-08 00:00:00.000 | 7271 | 39854 |
9 | 2025-01-09 00:00:00.000 | 7003 | 41065 |
10 | 2025-01-10 00:00:00.000 | 7107 | 39477 |
11 | 2025-01-11 00:00:00.000 | 6776 | 36007 |
12 | 2025-01-12 00:00:00.000 | 6651 | 37243 |
13 | 2025-01-13 00:00:00.000 | 8075 | 45739 |
14 | 2025-01-14 00:00:00.000 | 8209 | 41175 |
15 | 2025-01-15 00:00:00.000 | 7149 | 40413 |
16 | 2025-01-16 00:00:00.000 | 7024 | 37414 |
17 | 2025-01-17 00:00:00.000 | 7610 | 40010 |
18 | 2025-01-18 00:00:00.000 | 7729 | 36809 |
19 | 2025-01-19 00:00:00.000 | 5997 | 36788 |
20 | 2025-01-20 00:00:00.000 | 5249 | 45421 |
kentoNumber of Active NFT Traders
Updated 2025-03-24
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
›
⌄
WITH eth_traders AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
COUNT(DISTINCT seller_address) + COUNT(DISTINCT buyer_address) AS eth_active_traders
FROM ethereum.nft.ez_nft_sales
WHERE block_timestamp >= '2025-01-01'
GROUP BY 1
),
ronin_traders AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
COUNT(DISTINCT from_address) + COUNT(DISTINCT to_address) AS ronin_active_traders
FROM ronin.nft.ez_nft_transfers
WHERE block_timestamp >= '2025-01-01'
GROUP BY 1
)
SELECT
COALESCE(e.date, r.date) AS date,
COALESCE(e.eth_active_traders, 0) AS eth_active_traders,
COALESCE(r.ronin_active_traders, 0) AS ronin_active_traders
FROM eth_traders e
FULL OUTER JOIN ronin_traders r ON e.date = r.date
ORDER BY date;
Last run: 2 months ago
83
3KB
2s