Day | Total Transactions | Total Users | Sales | Wallet Transfers | |
|---|---|---|---|---|---|
1 | 2025-04-03 00:00:00.000 | 6734 | 3882 | 5171 | 11 |
2 | 2025-04-02 00:00:00.000 | 7663 | 4327 | 5995 | 53 |
3 | 2025-04-01 00:00:00.000 | 6215 | 3082 | 4565 | 53 |
4 | 2025-03-31 00:00:00.000 | 551 | 257 | 346 | 6 |
5 | 2025-03-30 00:00:00.000 | 129 | 87 | 76 | 7 |
6 | 2025-03-29 00:00:00.000 | 149 | 94 | 91 | 6 |
7 | 2025-03-28 00:00:00.000 | 548 | 306 | 365 | 3 |
8 | 2025-03-27 00:00:00.000 | 357 | 200 | 210 | 10 |
9 | 2025-03-26 00:00:00.000 | 194 | 119 | 101 | 14 |
10 | 2025-03-25 00:00:00.000 | 292 | 118 | 191 | 39 |
11 | 2025-03-24 00:00:00.000 | 41 | 24 | 32 | 8 |
12 | 2025-03-23 00:00:00.000 | 24 | 18 | 21 | 1 |
13 | 2025-03-22 00:00:00.000 | 69 | 37 | 30 | 35 |
14 | 2025-03-21 00:00:00.000 | 38 | 29 | 25 | 13 |
15 | 2025-03-20 00:00:00.000 | 42 | 34 | 29 | 9 |
16 | 2025-03-19 00:00:00.000 | 65 | 32 | 44 | 17 |
17 | 2025-03-18 00:00:00.000 | 73 | 44 | 57 | 15 |
18 | 2025-03-17 00:00:00.000 | 74 | 40 | 59 | 11 |
19 | 2025-03-16 00:00:00.000 | 129 | 62 | 88 | 39 |
20 | 2025-03-15 00:00:00.000 | 84 | 51 | 59 | 21 |
i_danRONKE: Daily Metrics
Updated 2025-04-03
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
›
⌄
With main_data AS (
SELECT
block_timestamp
, tx_hash
, is_mint
, origin_function_signature
, origin_from_address
, quantity
, token_id
FROM ronin.nft.ez_nft_transfers
WHERE
contract_address = lower('0x810b6d1374ac7ba0e83612e7d49f49a13f1de019')
AND is_mint = 'FALSE'
--GROUP BY 1
--ORDER BY 2 DESC
--LIMIT 1000
)
SELECT
date_trunc(day, block_timestamp) AS "Day"
, COUNT(tx_hash) "Total Transactions"
, COUNT(DISTINCT origin_from_address) AS "Total Users"
, COUNT(CASE WHEN origin_function_signature = '0x95a4ec00' THEN tx_hash
WHEN origin_function_signature = '0x00000000' THEN tx_hash
WHEN origin_function_signature = '0x17246d5d' THEN tx_hash
WHEN origin_function_signature = '0x2beee4c7' THEN tx_hash END) AS "Sales"
, COUNT(CASE WHEN origin_function_signature = '0x42842e0e' THEN tx_hash END) AS "Wallet Transfers"
-- , COUNT(CASE WHEN origin_function_signature = '0x17246d5d' THEN tx_hash END) AS "Offers Accepted"
-- , "Direct Sales" + "Offers Accepted" AS "Total Sales"
FROM main_data
GROUP BY 1
ORDER BY 1 DESC
Last run: about 1 month ago
38
2KB
3s