SYMBOL | NAME | SUPPLY | TOTAL_CRAFTED | STILL_CRAFTABLE | |
|---|---|---|---|---|---|
1 | CALMAX | Calico Maxhog | 30224 | 12533 | 17691 |
2 | FBLMEX | Fimbul Mamba EX | 3069 | 2549 | 520 |
AephiaSB ship crafting (MAXHOG & MAMBA)
Updated 9 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
33
34
35
36
›
⌄
WITH crafting AS (
select
date_trunc('day', block_timestamp::date) as date
----------------------------------------------------
,sum(case when value:parsed:info:authority IN ('5WuGtLeLW7VaaUceytDSsX2hFuigpcWocxhHKJtUPUcn')
then value:parsed:info:amount
end) as CALMAX_amount
,sum(case when value:parsed:info:authority IN ('BBxxUrq2yxSyrMbCmFsRpbakZJijQSucwgafcE3KkWVZ')
then value:parsed:info:amount
end) as FBLMEX_amount
---
,sum(CALMAX_amount) OVER (order by date) as CALMAX_total_crafted
,sum(FBLMEX_amount) OVER (order by date) as FBLMEX_total_crafted
from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')
AND succeeded = 'true'
AND value:parsed:type = 'transfer'
--AND tx_id = '35gjyumTsW9wr7taN3rx8NeyDfKWFKofNGby6HXPt6eY8qZCXqnnnEkR4FtNXL64r6d4skEV1VTrGfhfX5hMrtue'
AND block_timestamp > '2024-04-01' --AND block_timestamp < current_date
--limit 100
group by 1
),
burned_and_crafted (symbol, name, supply, total_crafted, still_craftable) as (
Last run: about 9 hours agoAuto-refreshes every 6 hours
2
89B
967s