WEEK | N_MINT_TXNS | TOTAL_MINTED_JITOSOL | |
|---|---|---|---|
1 | 2025-03-31 00:00:00.000 | 6416 | 102117.532351097 |
2 | 2025-03-24 00:00:00.000 | 21585 | 307353.539044321 |
3 | 2025-03-17 00:00:00.000 | 27636 | 234554.156127354 |
4 | 2025-03-10 00:00:00.000 | 26942 | 607498.793350395 |
5 | 2025-03-03 00:00:00.000 | 6514 | 899631.81785294 |
6 | 2025-02-24 00:00:00.000 | 2280 | 51113.764801494 |
feyikemiSolana Quiz 1 No. 5
Updated 2025-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(DISTINCT tx_id) AS n_mint_txns,
SUM(mint_amount/POW(10, 9)) AS total_minted_jitosol
FROM solana.defi.fact_token_mint_actions
WHERE MINT = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
AND EVENT_TYPE = 'mintTo'
AND SUCCEEDED = 'True'
AND block_timestamp::Date >= '2025-03-01'
AND block_timestamp::Date < '2025-04-01'
GROUP BY 1
ORDER BY 1 DESC
Last run: about 2 months ago
6
302B
9s