DAY | NEW_BUYERS | |
|---|---|---|
1 | 2025-02-27 00:00:00.000 | 140 |
2 | 2025-02-26 00:00:00.000 | 63 |
3 | 2025-02-25 00:00:00.000 | 93 |
4 | 2025-02-24 00:00:00.000 | 208 |
5 | 2025-02-23 00:00:00.000 | 2168 |
monadmetrics-JFe1_RNew Buyer Ratio
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH first_buy AS (
SELECT from_address, MIN(block_timestamp) AS first_tx_time
FROM MONAD.testnet.fact_transactions
WHERE to_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'
GROUP BY 1
)
SELECT
DATE_TRUNC('day', first_tx_time) AS day,
COUNT(DISTINCT from_address) AS new_buyers
FROM first_buy
WHERE first_tx_time >= '2025-02-19 15:00:00.000'
GROUP BY 1
ORDER BY 1 DESC
Last run: about 1 month ago
5
160B
2s