crypto_edgarDRAKO Minted
Updated 2024-03-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH
DRAKO_MINTED_PREP AS (
SELECT
block_timestamp,
TX_ID,
INSTRUCTION:parsed:info:mint as TOKEN_ADDRESS,
CASE WHEN EVENT_TYPE IN ('mint', 'mintToChecked') THEN INSTRUCTION:parsed:info:tokenAmount:amount
ELSE INSTRUCTION:parsed:info:amount END AS AMOUNT,
5 as DECIMALS
FROM
solana.core.fact_events
WHERE
BLOCK_TIMESTAMP >= '2023-12-23'
AND TOKEN_ADDRESS = 'drakduQWnTS89CdTUdgHmZzEkN6reBLYqrk8rzVhU53'
AND EVENT_TYPE IN ('mint', 'mintTo', 'mintToChecked')
)
SELECT
SUM(AMOUNT / POW(10, DECIMALS)) AS TOTAL_DRAKO_MINTED
FROM
DRAKO_MINTED_PREP
QueryRunArchived: QueryRun has been archived