SYMBOL | NAME | DATE | COPPER_AMOUNT | COPPER_BURN_AMOUNT | NET_COPPER_CRAFTED | TOTAL_BURNED | TOTAL_CRAFTED | |
|---|---|---|---|---|---|---|---|---|
1 | COPPER | Copper | 2024-08-24 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493342570 |
2 | COPPER | Copper | 2024-08-22 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493342570 |
3 | COPPER | Copper | 2024-08-21 00:00:00.000 | 9742 | 0 | 9742 | -80713678895 | 83493342570 |
4 | COPPER | Copper | 2024-08-20 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493332828 |
5 | COPPER | Copper | 2024-08-16 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493332828 |
6 | COPPER | Copper | 2024-12-16 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493374482 |
7 | COPPER | Copper | 2024-12-07 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493374482 |
8 | COPPER | Copper | 2024-12-05 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493374482 |
9 | COPPER | Copper | 2024-12-03 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493374482 |
10 | COPPER | Copper | 2025-01-21 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493394482 |
11 | COPPER | Copper | 2025-01-10 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493394482 |
12 | COPPER | Copper | 2025-01-01 00:00:00.000 | 20000 | 0 | 20000 | -80713678895 | 83493394482 |
13 | COPPER | Copper | 2024-12-25 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493374482 |
14 | COPPER | Copper | 2024-08-06 00:00:00.000 | 0 | 0 | 0 | -80713540721 | 83493332828 |
15 | COPPER | Copper | 2024-07-27 00:00:00.000 | 0 | -50000 | -50000 | -80713540721 | 83493332828 |
16 | COPPER | Copper | 2024-07-18 00:00:00.000 | 0 | 0 | 0 | -80713490721 | 83493332828 |
17 | COPPER | Copper | 2024-10-05 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493374482 |
18 | COPPER | Copper | 2024-10-02 00:00:00.000 | 0 | 0 | 0 | -80713678895 | 83493374482 |
19 | COPPER | Copper | 2024-09-27 00:00:00.000 | 31912 | 0 | 31912 | -80713678895 | 83493374482 |
20 | COPPER | Copper | 2024-05-03 00:00:00.000 | 0 | 0 | 0 | -80707948843 | 83483876927 |
Flipside CommunitySAGE crafting
Updated 7 days 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
›
⌄
-- Star Atlas daily copper crafted and burnt
-- Original author: Aephia
-- Original query: https://flipsidecrypto.xyz/Aephia/q/4agnBUwRn9tr/sage-crafting
-- Original dashboard: https://flipsidecrypto.xyz/Aephia/daily-analysis-xGXyHF
-- get all the copper burnt by day
WITH burning AS (
-- select the date the action took place
SELECT date_trunc('day', block_timestamp::date) as date
, SUM(
-- CPPRam7wKuBkYzN5zCffgNU17RKaeMEns4ZD83BqBVNR is the mint for the copper resource
CASE WHEN value:parsed:info:mint::string = 'CPPRam7wKuBkYzN5zCffgNU17RKaeMEns4ZD83BqBVNR'
-- the 'burn' is specified in the tx instruction data
AND value:parsed:type = 'burn'
THEN value:parsed:info:amount
END
) as copper_burn_amount
, SUM(copper_burn_amount) OVER (order by date) as copper_total_burned
FROM solana.core.fact_events
-- the lateral flatten allows us to extract each instruction in the event
, lateral flatten(input => inner_instruction:instructions)
-- the date where this feature was launched
WHERE block_timestamp > '2023-09-22'
-- this is the star atlas burning program id
AND program_id = 'Craftf1EGzEoPFJ1rpaTSQG1F6hhRRBAf4gRo9hdSZjR'
AND succeeded = 'true'
GROUP BY 1
ORDER BY 1 DESC
)
, crafting AS (
-- select the date the action took place
SELECT date_trunc('day', block_timestamp::date) as date
, SUM(
-- FF2zDTzTeEH8SDwz6D5iqdDqQ8CsPXCuDVv3Uzw4wGN1 is the authority to craft copper
CASE WHEN value:parsed:info:authority = 'FF2zDTzTeEH8SDwz6D5iqdDqQ8CsPXCuDVv3Uzw4wGN1'
Last run: 7 days ago
...
282
26KB
59s