DATE(BLOCK_TIMESTAMP) as time,

TX_ID,

EVENT_TYPE,

PROGRAM_ID,

PARSE_JSON(INSTRUCTION):parsed:type::string AS instruction_type,

PARSE_JSON(INSTRUCTION):parsed:info:account::string AS account,

PARSE_JSON(INSTRUCTION):parsed:info:mint::string AS mint,

PARSE_JSON(INSTRUCTION):parsed:info:mintAuthority::string AS mint_authority,

PARSE_JSON(INSTRUCTION):parsed:info:tokenAmount:amount::string AS token_amount_raw,

PARSE_JSON(INSTRUCTION):parsed:info:tokenAmount:decimals::integer AS token_decimals,

PARSE_JSON(INSTRUCTION):parsed:info:tokenAmount:uiAmount::integer AS token_amount,

SUM(PARSE_JSON(INSTRUCTION):parsed:info:tokenAmount:uiAmount::integer) OVER (ORDER BY block_timestamp) as cum

FROM solana.core.fact_events

WHERE block_id >= 263338600

AND event_type = 'mintToChecked'

AND PARSE_JSON(INSTRUCTION):parsed:info:mint::string = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'

ORDER BY 1 DESC