MoeJTO token mint / burn
Updated 2024-08-04
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
›
⌄
with burn as
(SELECT
DATE_TRUNC('month', block_timestamp) AS month,
SUM(burn_amount / pow(10,6)) AS burned_tokens
FROM
solana.defi.fact_token_burn_actions
WHERE
mint = 'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL'
GROUP BY
1
ORDER BY
1 ASC)
,
mint as
(SELECT
DATE_TRUNC('month', block_timestamp) AS month,
SUM(mint_amount / pow(10,6)) AS minted_tokens
FROM
solana.defi.fact_token_mint_actions
WHERE
mint = 'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL'
GROUP BY
1
ORDER BY
1 ASC)
select
a.month ,
minted_tokens ,
burned_tokens ,
sum(minted_tokens)over(order by month) as total_minted,
sum(burned_tokens)over(order by month) as total_burned,
total_minted - total_burned as net_issuance
from
burn a full outer join mint using (month)
order by 1
QueryRunArchived: QueryRun has been archived