Query editor
WITH date_series AS (SELECT date_trunc('month', call_block_date) as "Date"FROM mpl_token_metadata_solana.mpl_token_metadata_call_CreateMetadataAccountV3WHEREcall_block_time >= date'2023-11-01'AND call_block_time < date'2024-12-31'GROUP BY date_trunc('month', call_block_date))SELECTdate_trunc('month', data.call_block_date) as "Date",data.account_mint as wallet_address,data.call_block_time as creation_timeFROMmpl_token_metadata_solana.mpl_token_metadata_call_CreateMetadataAccountV3 as dataWHEREdata.call_block_time >= date'2023-12-01'AND data.call_block_time <= date'2024-12-31'AND data.call_tx_signer = '7rFPFnxjXHC2sfDy3qrDa9pEb4j49oivMuV7e8sYDPmB'AND json_extract_scalar(data.createMetadataAccountArgsV3, '$.CreateMetadataAccountArgsV3.data.DataV2.symbol') = 'NODE'AND json_extract_scalar(data.createMetadataAccountArgsV3, '$.CreateMetadataAccountArgsV3.data.DataV2.creators[0].Creator.address') = 'PublicKey(NosanarMxfrZbyCx5CotBVrzxiPcrnhj6ickpX9vRkB)'ORDER BYdata.call_block_time