DATE | CHAIN | NET_SUPPLY | TOTAL_SUPPLY | |
|---|---|---|---|---|
1 | 2024-12-12 00:00:00.000 | Solana | 1000000000 | 1000000000 |
2 | 2025-03-11 00:00:00.000 | Solana | 12816088.1521234 | 892816088.152123 |
3 | 2025-03-12 00:00:00.000 | Bsc | -947762.88865 | 106199232.243202 |
4 | 2025-03-12 00:00:00.000 | Solana | 947762.720112386 | 893763850.872236 |
5 | 2025-02-26 00:00:00.000 | Bsc | 120000000 | 120000000 |
6 | 2025-02-26 00:00:00.000 | Solana | -120000000 | 880000000 |
7 | 2025-03-11 00:00:00.000 | Bsc | -12853004.868148 | 107146995.131852 |
Pine Analyticspeculiar-sapphire
Updated 2025-03-12
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 tab1 as (
select
date,
chain,
sum(
case when type like 'Mint' then mint_amount
when type like 'Burn' then -mint_amount end
) / power(10, 9) as net_supply,
sum(net_supply) over (order by date) as total_supply
from (
select
date(block_timestamp) as date,
'Mint' as type,
'Solana' as chain,
mint_amount
from solana.defi.fact_token_mint_actions
where mint like 'FQgtfugBdpFN7PZ6NdPrZpVLDBrPGxXesi4gVu3vErhY'
union all
select
date(block_timestamp) as date,
'Burn' as type,
'Solana' as chain,
burn_amount
from solana.defi.fact_token_burn_actions
where mint like 'FQgtfugBdpFN7PZ6NdPrZpVLDBrPGxXesi4gVu3vErhY'
)
group by 1,2
), tab2 as (
select
date(block_timestamp) as date,
'Bsc' as chain,
Last run: about 1 month ago
7
447B
8s