MONTH_START | TOTAL_MINT_PRICE_FOR_MONTH | RUNNING_TOTAL_MINT_PRICE | TOTAL_MINTS_FOR_MONTH | RUNNING_TOTAL_MINTS | |
|---|---|---|---|---|---|
1 | 2024-11-01 00:00:00.000 | 0.01668856 | 0.07109208 | 1 | 3 |
2 | 2024-05-01 00:00:00.000 | 0.05440352 | 0.05440352 | 2 | 2 |
HitmonleeCryptoMonthly Mint Activity
Updated 2025-04-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
DATE_TRUNC('month', mi.block_timestamp) AS month_start,
SUM(mi.mint_price) AS total_mint_price_for_month,
SUM(SUM(mi.mint_price)) OVER (ORDER BY DATE_TRUNC('month', mi.block_timestamp)) AS running_total_mint_price,
COUNT(mi.mint) AS total_mints_for_month,
SUM(COUNT(mi.mint)) OVER (ORDER BY DATE_TRUNC('month', mi.block_timestamp)) AS running_total_mints
FROM
solana.nft.fact_nft_mints mi
WHERE
purchaser = '{{Address}}'
GROUP BY
DATE_TRUNC('month', mi.block_timestamp)
ORDER BY
month_start DESC;
Last run: 21 days ago
2
109B
2s