dremovdSolana example
    Updated 2025-03-07
    select
    *
    from
    solana.core.fact_transactions
    where
    block_timestamp > current_date - interval '1 days'
    limit
    1;
    Last run: 25 days ago
    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.000324975186
    4QeQCnARzRTGmsN9LyuSNchtXjbtZMbkg7JuvFALJQGmwXmdmPkPVvN3EjjsLXJMT4AwYo7C...
    Ahn7xfUitXJYBasq3nod8qx1qJj6waPL1WXMa6kb8KgR
    [ "8iQP7Kqj1sSL8ThenF66Fx5mDYpPTPYTeGx9i25os9VG" ]
    6318FALSE
    [ { "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" ]
    4645855009687816631eda15f84632c98ab251ac06c5fc90352025-03-06 14:17:17.6882025-03-06 14:17:17.688
    1
    11KB
    1s