crypto_edgarSCS Token Info
Updated 2023-08-03
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
›
⌄
-- Note: We had to correct for wrong? mints & burns at the start
WITH
SCS_Burns as (
SELECT
TX_ID,
BLOCK_TIMESTAMP,
CASE
WHEN EVENT_TYPE = 'burnChecked' THEN INSTRUCTION:parsed:info:tokenAmount:amount / POW(10, 5)
WHEN EVENT_TYPE = 'burn' THEN INSTRUCTION:parsed:info:amount / POW(10, 5)
END AS amount_tokens_burned
FROM
solana.core.fact_events
WHERE
BLOCK_TIMESTAMP >= '2023-02-24'
AND EVENT_TYPE IN ('burn', 'burnChecked')
AND INSTRUCTION:parsed:info:mint = 'SCSuPPNUSypLBsV4darsrYNg4ANPgaGhKhsA3GmMyjz'
AND TX_ID != 'mGxqJ6DA6qoRo4u1t5tPCyMT3Resjuv1dWu4StZh5Pgy5o8zxLo6c9u6XKJTJtM6ZjQgzDW9oSXWKbHAsPrRtBC'
),
SCS_Mints as (
SELECT
TX_ID,
BLOCK_TIMESTAMP,
CASE
WHEN EVENT_TYPE = 'mintToChecked' THEN INSTRUCTION:parsed:info:tokenAmount:amount / POW(10, 5)
WHEN EVENT_TYPE = 'mintTo' THEN INSTRUCTION:parsed:info:amount / POW(10, 5)
END AS amount_tokens_minted
FROM
solana.core.fact_events
WHERE
BLOCK_TIMESTAMP >= '2023-02-24'
AND EVENT_TYPE IN ('mintTo', 'mintToChecked')
AND INSTRUCTION:parsed:info:mint = 'SCSuPPNUSypLBsV4darsrYNg4ANPgaGhKhsA3GmMyjz'
AND TX_ID != '46Zrwcoop4BpaxdXiit6P9khZ1eQwT5F4wp7otLfMMFGqvUZqbPTXeyyNkCBaWdtNQNvEKZvPYyACcS7t8AoYJPA'
)
SELECT
(