crypto_edgarTotal Nana Emission
Updated 2024-06-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH
NANA_TOKEN_TRANSFERS_FROM_MINT_WALLET AS (
SELECT
BLOCK_TIMESTAMP,
AMOUNT
FROM
solana.core.fact_transfers
WHERE
BLOCK_TIMESTAMP >= '2023-04-17'
AND MINT = 'HxRELUQfvvjToVbacjr9YECdfQMUqGgPYB68jVDYxkbr'
AND TX_FROM = '3LcKTdV47hLhXmaqDqzCqby7Y2pPbvW91RME99rCVQSG'
)
SELECT
1000000000 AS TOTAL_NANA_SUPPLY,
SUM(AMOUNT) AS NANA_EMITTED,
1000000000 - SUM(AMOUNT) AS NANA_TO_EMIT
FROM
NANA_TOKEN_TRANSFERS_FROM_MINT_WALLET
QueryRunArchived: QueryRun has been archived