WEEK | Mint Count | SUCCEEDED | |
|---|---|---|---|
1 | Mar 01 - Mar 07 | 6364 | TRUE |
2 | Mar 01 - Mar 07 | 226 | FALSE |
3 | Mar 08 - Mar 14 | 182 | FALSE |
4 | Mar 08 - Mar 14 | 23590 | TRUE |
5 | Mar 15 - Mar 21 | 174 | FALSE |
6 | Mar 15 - Mar 21 | 25117 | TRUE |
7 | Mar 22 - Mar 28 | 24274 | TRUE |
8 | Mar 22 - Mar 28 | 494 | FALSE |
9 | Mar 29 - Mar 31 | 103 | FALSE |
10 | Mar 29 - Mar 31 | 12028 | TRUE |
alfredfx10Solana week-2
Updated 2025-04-05
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
35
36
›
⌄
---QUESTION 4
-- SELECT COUNT(TX_ID) AS "Nft Purchase"
-- FROM solana.nft.ez_nft_sales
-- WHERE date_trunc('day',BLOCK_TIMESTAMP)>'2025-04-02'
-- AND date_trunc('day',BLOCK_TIMESTAMP)<'2025-04-04'
-- AND SUCCEEDED='TRUE'
-- J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn
-- SELECT date_trunc('WEEK',BLOCK_TIMESTAMP) AS Week, COUNT(TX_ID) AS "Mint Count",SUCCEEDED
-- FROM solana.defi.fact_token_mint_actions
-- WHERE date_trunc('WEEK',BLOCK_TIMESTAMP) >= date_trunc('WEEK',DATE'2025-03-01')
-- AND date_trunc('WEEK',BLOCK_TIMESTAMP) < date_trunc('WEEK',DATE'2025-04-01')
-- AND MINT='J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
-- AND EVENT_TYPE='mintTo'
-- GROUP BY date_trunc('WEEK',BLOCK_TIMESTAMP),3
-- ORDER BY Week
--QUESTION 5
SELECT
CASE
WHEN date_trunc('DAY', BLOCK_TIMESTAMP) >= DATE '2025-03-01' AND date_trunc('DAY', BLOCK_TIMESTAMP) < DATE '2025-03-08' THEN 'Mar 01 - Mar 07'
WHEN date_trunc('DAY', BLOCK_TIMESTAMP) >= DATE '2025-03-08' AND date_trunc('DAY', BLOCK_TIMESTAMP) < DATE '2025-03-15' THEN 'Mar 08 - Mar 14'
WHEN date_trunc('DAY', BLOCK_TIMESTAMP) >= DATE '2025-03-15' AND date_trunc('DAY', BLOCK_TIMESTAMP) < DATE '2025-03-22' THEN 'Mar 15 - Mar 21'
WHEN date_trunc('DAY', BLOCK_TIMESTAMP) >= DATE '2025-03-22' AND date_trunc('DAY', BLOCK_TIMESTAMP) < DATE '2025-03-29' THEN 'Mar 22 - Mar 28'
WHEN date_trunc('DAY', BLOCK_TIMESTAMP) >= DATE '2025-03-29' AND date_trunc('DAY', BLOCK_TIMESTAMP) <= DATE '2025-03-31' THEN 'Mar 29 - Mar 31'
END AS Week,
COUNT(TX_ID) AS "Mint Count",
SUCCEEDED
FROM solana.defi.fact_token_mint_actions
WHERE date_trunc('DAY', BLOCK_TIMESTAMP) >= DATE '2025-03-01'
AND date_trunc('DAY', BLOCK_TIMESTAMP) < DATE '2025-04-01'
AND MINT = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
AND EVENT_TYPE = 'mintTo'
Last run: about 2 months ago
10
305B
9s