BLOCK_TIMESTAMP | BLOCK_ID | TX_ID | RECENT_BLOCK_HASH | SIGNERS | FEE | SUCCEEDED | ACCOUNT_KEYS | PRE_BALANCES | POST_BALANCES | PRE_TOKEN_BALANCES | POST_TOKEN_BALANCES | INSTRUCTIONS | INNER_INSTRUCTIONS | LOG_MESSAGES | UNITS_CONSUMED | UNITS_LIMIT | TX_SIZE | TX_INDEX | FACT_TRANSACTIONS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-06 14:07:20.000 | 324975186 | 4QeQCnARzRTGmsN9LyuSNchtXjbtZMbkg7JuvFALJQGmwXmdmPkPVvN3EjjsLXJMT4AwYo7C... | Ahn7xfUitXJYBasq3nod8qx1qJj6waPL1WXMa6kb8KgR | [
"8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG"
] | 6318 | FALSE | [
{
"pubkey": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG",
"signer": true,
"source": "transaction",
"writable": true
},
{
"pubkey": "ABziFtPTFTBpXfnoZVqRpLcDXWoSB2B8vB4JbqF6t4qZ",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "FbnrZQBUmt9mVUkHRokaVZoSLTQ5PxJVMTJMUSB6DMP1",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "42XoQNbGHxRTBKMfqgdH3u4uV2cdeUmeRSAzcQJBguTb",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "F4omSYrA1nshW12kPHNmeygFVzWnjkyoqB8HAXC69HAD",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "4WMWtsWW9NQM52EuY5RLpuE58nJQkBo5hfLbX9RPa9Ti",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "uyM5Xd4iyPh7xKN336K1gFCFhZwG8Jf7jqibFL9R3Xm",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "EiTv4FUm5faqYbz6Vi2UeAqad1GTcWGktF9x1AbWQ2xC",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "Aj2JFJZLMYdpFTYZsHqppf7YEZPBLLkkvusSnyAjvpHS",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "BKuZgKhvewefF9TaT9RvQ9LA2FgUyFNyTbgeRwFT8qcb",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "81L6G5fQMyHrX6MsDFs8Ndu9uaEWpoVncusVgmBudPhv",
"signer": false,
"source": "transaction",
"writable": true
},
{
"pubkey": "ComputeBudget111111111111111111111111111111",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "11111111111111111111111111111111",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "2FAaDn5qgjhhWsn9mw8CAFPNHvqB7M6TyL4CKVPegeTh",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "So11111111111111111111111111111111111111112",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8",
"signer": false,
"source": "transaction",
"writable": false
},
{
"pubkey": "5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1",
"signer": false,
"source": "transaction",
"writable": false
}
] | [
9263660609,
0,
79740381232,
7182720,
2039280,
91651483600,
23385600,
71437440,
105124800,
1183264908897,
2039280,
1,
731913600,
9985875651,
1,
934087680,
1141440,
1141440,
994538950606,
4000000,
1141440,
21901538406
] | [
9263654291,
0,
79740381232,
7182720,
2039280,
91651483600,
23385600,
71437440,
105124800,
1183264908897,
2039280,
1,
731913600,
9985875651,
1,
934087680,
1141440,
1141440,
994538950606,
4000000,
1141440,
21901538406
] | [
{
"accountIndex": 2,
"mint": "So11111111111111111111111111111111111111112",
"owner": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "79738341952",
"decimals": 9,
"uiAmount": 79.738341952,
"uiAmountString": "79.738341952"
}
},
{
"accountIndex": 4,
"mint": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"owner": "42XoQNbGHxRTBKMfqgdH3u4uV2cdeUmeRSAzcQJBguTb",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "707258877681",
"decimals": 6,
"uiAmount": 707258.877681,
"uiAmountString": "707258.877681"
}
},
{
"accountIndex": 5,
"mint": "So11111111111111111111111111111111111111112",
"owner": "42XoQNbGHxRTBKMfqgdH3u4uV2cdeUmeRSAzcQJBguTb",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "91649444320",
"decimals": 9,
"uiAmount": 91.64944432,
"uiAmountString": "91.64944432"
}
},
{
"accountIndex": 9,
"mint": "So11111111111111111111111111111111111111112",
"owner": "5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "1183262869613",
"decimals": 9,
"uiAmount": 1183.262869613,
"uiAmountString": "1183.262869613"
}
},
{
"accountIndex": 10,
"mint": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"owner": "5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "67362247905931",
"decimals": 6,
"uiAmount": 67362247.905931,
"uiAmountString": "67362247.905931"
}
}
] | [
{
"accountIndex": 2,
"mint": "So11111111111111111111111111111111111111112",
"owner": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "79738341952",
"decimals": 9,
"uiAmount": 79.738341952,
"uiAmountString": "79.738341952"
}
},
{
"accountIndex": 4,
"mint": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"owner": "42XoQNbGHxRTBKMfqgdH3u4uV2cdeUmeRSAzcQJBguTb",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "707258877681",
"decimals": 6,
"uiAmount": 707258.877681,
"uiAmountString": "707258.877681"
}
},
{
"accountIndex": 5,
"mint": "So11111111111111111111111111111111111111112",
"owner": "42XoQNbGHxRTBKMfqgdH3u4uV2cdeUmeRSAzcQJBguTb",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "91649444320",
"decimals": 9,
"uiAmount": 91.64944432,
"uiAmountString": "91.64944432"
}
},
{
"accountIndex": 9,
"mint": "So11111111111111111111111111111111111111112",
"owner": "5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "1183262869613",
"decimals": 9,
"uiAmount": 1183.262869613,
"uiAmountString": "1183.262869613"
}
},
{
"accountIndex": 10,
"mint": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"owner": "5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"uiTokenAmount": {
"amount": "67362247905931",
"decimals": 6,
"uiAmount": 67362247.905931,
"uiAmountString": "67362247.905931"
}
}
] | [
{
"accounts": [],
"data": "LYFUYo",
"programId": "ComputeBudget111111111111111111111111111111",
"stackHeight": null
},
{
"accounts": [],
"data": "3UX1vGRtdxvs",
"programId": "ComputeBudget111111111111111111111111111111",
"stackHeight": null
},
{
"parsed": {
"info": {
"account": "ABziFtPTFTBpXfnoZVqRpLcDXWoSB2B8vB4JbqF6t4qZ",
"mint": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"source": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG",
"systemProgram": "11111111111111111111111111111111",
"tokenProgram": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"wallet": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG"
},
"type": "create"
},
"program": "spl-associated-token-account",
"programId": "ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL",
"stackHeight": null
},
{
"accounts": [
"8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG",
"FbnrZQBUmt9mVUkHRokaVZoSLTQ5PxJVMTJMUSB6DMP1",
"ABziFtPTFTBpXfnoZVqRpLcDXWoSB2B8vB4JbqF6t4qZ",
"TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"11111111111111111111111111111111",
"LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo",
"42XoQNbGHxRTBKMfqgdH3u4uV2cdeUmeRSAzcQJBguTb",
"F4omSYrA1nshW12kPHNmeygFVzWnjkyoqB8HAXC69HAD",
"4WMWtsWW9NQM52EuY5RLpuE58nJQkBo5hfLbX9RPa9Ti",
"DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"So11111111111111111111111111111111111111112",
"uyM5Xd4iyPh7xKN336K1gFCFhZwG8Jf7jqibFL9R3Xm",
"TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"D1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6",
"EiTv4FUm5faqYbz6Vi2UeAqad1GTcWGktF9x1AbWQ2xC",
"EiTv4FUm5faqYbz6Vi2UeAqad1GTcWGktF9x1AbWQ2xC",
"EiTv4FUm5faqYbz6Vi2UeAqad1GTcWGktF9x1AbWQ2xC",
"675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8",
"Aj2JFJZLMYdpFTYZsHqppf7YEZPBLLkkvusSnyAjvpHS",
"5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1",
"BKuZgKhvewefF9TaT9RvQ9LA2FgUyFNyTbgeRwFT8qcb",
"81L6G5fQMyHrX6MsDFs8Ndu9uaEWpoVncusVgmBudPhv"
],
"data": "YrpUV6Kpy53AZWBsiD7vMu",
"programId": "2FAaDn5qgjhhWsn9mw8CAFPNHvqB7M6TyL4CKVPegeTh",
"stackHeight": null
},
{
"parsed": {
"info": {
"account": "ABziFtPTFTBpXfnoZVqRpLcDXWoSB2B8vB4JbqF6t4qZ",
"destination": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG",
"owner": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG"
},
"type": "closeAccount"
},
"program": "spl-token",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"stackHeight": null
}
] | [
{
"index": 2,
"instructions": [
{
"parsed": {
"info": {
"extensionTypes": [
"immutableOwner"
],
"mint": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump"
},
"type": "getAccountDataSize"
},
"program": "spl-token",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"stackHeight": 2
},
{
"parsed": {
"info": {
"lamports": 2039280,
"newAccount": "ABziFtPTFTBpXfnoZVqRpLcDXWoSB2B8vB4JbqF6t4qZ",
"owner": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"source": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG",
"space": 165
},
"type": "createAccount"
},
"program": "system",
"programId": "11111111111111111111111111111111",
"stackHeight": 2
},
{
"parsed": {
"info": {
"account": "ABziFtPTFTBpXfnoZVqRpLcDXWoSB2B8vB4JbqF6t4qZ"
},
"type": "initializeImmutableOwner"
},
"program": "spl-token",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"stackHeight": 2
},
{
"parsed": {
"info": {
"account": "ABziFtPTFTBpXfnoZVqRpLcDXWoSB2B8vB4JbqF6t4qZ",
"mint": "DjgujfEv2u2qz7PNuS6Ct7bctnxPFihfWE2zBpKZpump",
"owner": "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG"
},
"type": "initializeAccount3"
},
"program": "spl-token",
"programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA",
"stackHeight": 2
}
]
}
] | [
"Program ComputeBudget111111111111111111111111111111 invoke [1]",
"Program ComputeBudget111111111111111111111111111111 success",
"Program ComputeBudget111111111111111111111111111111 invoke [1]",
"Program ComputeBudget111111111111111111111111111111 success",
"Program ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL invoke [1]",
"Program log: Create",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [2]",
"Program log: Instruction: GetAccountDataSize",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA consumed 1569 of 544729 compute units",
"Program return: TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA pQAAAAAAAAA=",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA success",
"Program 11111111111111111111111111111111 invoke [2]",
"Program 11111111111111111111111111111111 success",
"Program log: Initialize the associated token account",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [2]",
"Program log: Instruction: InitializeImmutableOwner",
"Program log: Please upgrade to SPL Token 2022 for immutable owner support",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA consumed 1405 of 538142 compute units",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA success",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [2]",
"Program log: Instruction: InitializeAccount3",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA consumed 4188 of 534260 compute units",
"Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA success",
"Program ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL consumed 20307 of 550096 compute units",
"Program ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL success",
"Program 2FAaDn5qgjhhWsn9mw8CAFPNHvqB7M6TyL4CKVPegeTh invoke [1]",
"Program 2FAaDn5qgjhhWsn9mw8CAFPNHvqB7M6TyL4CKVPegeTh consumed 25851 of 529789 compute units",
"Program 2FAaDn5qgjhhWsn9mw8CAFPNHvqB7M6TyL4CKVPegeTh failed: custom program error: 0x1"
] | 46458 | 550096 | 878 | 1663 | 1eda15f84632c98ab251ac06c5fc9035 | 2025-03-06 14:17:17.688 | 2025-03-06 14:17:17.688 |
dremovdSolana example
Updated 2025-03-07
9
1
2
3
4
5
6
7
8
›
⌄
select
*
from
solana.core.fact_transactions
where
block_timestamp > current_date - interval '1 days'
limit
1;
Last run: 25 days ago
1
11KB
1s