Date | MINTS | |
|---|---|---|
1 | 2024-10-27 00:00:00.000 | 1 |
2 | 2024-10-28 00:00:00.000 | 5 |
3 | 2024-10-29 00:00:00.000 | 12 |
4 | 2024-10-30 00:00:00.000 | 7 |
5 | 2024-10-31 00:00:00.000 | 3 |
6 | 2024-11-01 00:00:00.000 | 3 |
7 | 2024-11-02 00:00:00.000 | 2 |
8 | 2024-11-03 00:00:00.000 | 2 |
9 | 2024-11-04 00:00:00.000 | 3 |
10 | 2024-11-05 00:00:00.000 | 5 |
11 | 2024-11-06 00:00:00.000 | 6 |
12 | 2024-11-07 00:00:00.000 | 3 |
13 | 2024-11-08 00:00:00.000 | 32 |
14 | 2024-11-09 00:00:00.000 | 25 |
15 | 2024-11-10 00:00:00.000 | 11 |
16 | 2024-11-11 00:00:00.000 | 10 |
17 | 2024-11-12 00:00:00.000 | 2 |
18 | 2024-11-13 00:00:00.000 | 2 |
19 | 2024-11-14 00:00:00.000 | 1 |
20 | 2024-11-15 00:00:00.000 | 1 |
piperDaily minted Mad Scientists
Updated 2025-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",
COUNT(1) AS mints
FROM
osmosis.core.fact_transactions
WHERE
MSGS[14].attributes[2].value = lower('osmo1mrl3lug3cr5ltcutlpj2m8vqgcsw3fw94jysgcctyukdunnrmjhs8cacrf')
AND
BLOCK_TIMESTAMP >= '2024-04-16'
AND
BLOCK_TIMESTAMP >= CURRENT_DATE - 90
GROUP BY 1
ORDER BY 1 ASC
Last run: about 2 months ago
85
3KB
10s