DATE | mint count | total tokens minted | burn count | total tokens burned | net token change | |
|---|---|---|---|---|---|---|
1 | 2025-06-16 00:00:00.000 | 3 | 9.739863538 | 0 | 0 | 9.739863538 |
2 | 2025-06-15 00:00:00.000 | 61 | 1190.329243055 | 8 | 64.844142376 | 1125.485100679 |
3 | 2025-06-14 00:00:00.000 | 63 | 348.891690386 | 7 | 590.910768832 | -242.019078446 |
4 | 2025-06-13 00:00:00.000 | 86 | 6020.522137192 | 7 | 3.126690146 | 6017.395447046 |
5 | 2025-06-12 00:00:00.000 | 104 | 11209.409571794 | 7 | 0.899101858 | 11208.510469936 |
6 | 2025-06-11 00:00:00.000 | 206 | 16029.85095664 | 11 | 1371.18980691 | 14658.66114973 |
7 | 2025-06-10 00:00:00.000 | 81 | 25514.329378767 | 15 | 32010.968430206 | -6496.639051439 |
8 | 2025-06-09 00:00:00.000 | 159 | 31996.558256872 | 14 | 5386.408951818 | 26610.149305054 |
9 | 2025-06-08 00:00:00.000 | 68 | 798.06240342 | 2 | 0.003872259 | 798.058531161 |
10 | 2025-06-07 00:00:00.000 | 77 | 5047.470996612 | 13 | 10714.795587777 | -5667.324591165 |
11 | 2025-06-06 00:00:00.000 | 79 | 469.734060655 | 9 | 12.926502542 | 456.807558113 |
12 | 2025-06-05 00:00:00.000 | 118 | 6207.755200201 | 12 | 940.895426583 | 5266.859773618 |
13 | 2025-06-04 00:00:00.000 | 126 | 11361.740365094 | 12 | 601.675347812 | 10760.065017282 |
14 | 2025-06-03 00:00:00.000 | 148 | 38907.692633661 | 10 | 8.510088972 | 38899.182544689 |
15 | 2025-06-02 00:00:00.000 | 114 | 8529.438700542 | 19 | 26878.758677823 | -18349.319977281 |
16 | 2025-06-01 00:00:00.000 | 172 | 18575.919744208 | 26 | 481.394501744 | 18094.525242464 |
17 | 2025-05-31 00:00:00.000 | 118 | 445.668631679 | 20 | 1589.122450274 | -1143.453818595 |
18 | 2025-05-30 00:00:00.000 | 82 | 753.851105691 | 14 | 559972.998544658 | -559219.147438967 |
19 | 2025-05-29 00:00:00.000 | 90 | 1020.928905896 | 4 | 0.100000276 | 1020.82890562 |
20 | 2025-05-28 00:00:00.000 | 86 | 1462.466138508 | 28 | 1056.734322996 | 405.731815512 |
defi__joshMint and burn activities over the last 30 days
Updated 19 hours ago
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
›
⌄
WITH mint_data AS (
SELECT
DATE_TRUNC('day', block_timestamp) as date,
COUNT(*) as mint_count,
SUM(mint_amount/POWER(10, decimal)) as total_tokens_minted
FROM solana.defi.fact_token_mint_actions
WHERE mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
AND succeeded = true
AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
GROUP BY 1
),
burn_data AS (
SELECT
DATE_TRUNC('day', block_timestamp) as date,
COUNT(*) as burn_count,
SUM(burn_amount/POWER(10, decimal)) as total_tokens_burned
FROM solana.defi.fact_token_burn_actions
WHERE mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
AND succeeded = true
AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
GROUP BY 1
)
SELECT
COALESCE(m.date, b.date) as date,
COALESCE(m.mint_count, 0) as "mint count",
COALESCE(m.total_tokens_minted, 0) as "total tokens minted",
COALESCE(b.burn_count, 0) as "burn count",
COALESCE(b.total_tokens_burned, 0) as "total tokens burned",
COALESCE(m.total_tokens_minted, 0) - COALESCE(b.total_tokens_burned, 0) as "net token change"
FROM mint_data m
FULL OUTER JOIN burn_data b ON m.date = b.date
ORDER BY date DESC;
Last run: about 19 hours agoAuto-refreshes every 12 hours
31
2KB
6s