flipside

    above-plum
    hs2019above-plum
    Updated 2024-12-30
    SELECT
    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
    FROM
    solana.core.fact_transactions
    WHERE
    ((post_balances[0] - pre_balances[0]) = 8560000000
    OR (post_balances[1] - pre_balances[1]) = 8560000000)
    AND block_id > 310303571
    LIMIT 100;
    Last run: 2 months 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
    1
    		2024-12-28 12:57:27.000310351661
    2mt2aT9e1pvBvmPJ9dHiSLeP3aSpE2nuQ4YK9mAg64R9bbRx2Zajf3aFp37ovf2hPVZirYDy...
    		CQ75QKPse4Qf8MTVUmNSnxpkQj1z1BJhuRtFQcSeazDF
    [ "J2aY2HW1btK8A75tAeMeK56ZLsm8gdrqrW2bG9pTmoC4" ]
    		15000TRUE
    [ { "pubkey": "J2aY2HW1btK8A75tAeMeK56ZLsm8gdrqrW2bG9pTmoC4", "signer": true, "source": "transaction", "writable": true }, { "pubkey": "6EUtpYca5F3QaYFVfo3t9RKsR95XjUnwYNFQ7bXSL6EH", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "ComputeBudget111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false } ]
    [ 8573524479, 242816861177, 1, 1 ]
    [ 13509479, 251376861177, 1, 1 ]
    []
    []
    [ { "accounts": [], "data": "3DVGviTXKAPH", "programId": "ComputeBudget111111111111111111111111111111", "stackHeight": null }, { "accounts": [], "data": "LKoyXd", "programId": "ComputeBudget111111111111111111111111111111", "stackHeight": null }, { "parsed": { "info": { "destination": "6EUtpYca5F3QaYFVfo3t9RKsR95XjUnwYNFQ7bXSL6EH", "lamports": 8560000000, "source": "J2aY2HW1btK8A75tAeMeK56ZLsm8gdrqrW2bG9pTmoC4" }, "type": "transfer" }, "program": "system", "programId": "11111111111111111111111111111111", "stackHeight": null } ]
    []
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success" ]
    		450266
    2
    		2024-12-28 11:46:25.000310341128
    3vdRJmasrn52t64QpeMR8UQWPxnq7cPSqVLs9neFsaUpcCXTPkB9vPWYmMQxEsguKzwuazh9...
    		7dPYSkBwrCgEVTE1VFun8tskq49wVZrSAzrfJSTGRh2z
    [ "yF6TFRBTxGptx9JRruEUBYfqVgpKxByMzYSgdSg99Eh" ]
    		46739TRUE
    [ { "pubkey": "yF6TFRBTxGptx9JRruEUBYfqVgpKxByMzYSgdSg99Eh", "signer": true, "source": "transaction", "writable": true }, { "pubkey": "AmAWVdxoJt4hwb9Hdxg9vwa7iodSZR7CSqdnVUPRHj99", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "ComputeBudget111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false } ]
    [ 43629905624, 8000001, 1, 1 ]
    [ 35069858885, 8568000001, 1, 1 ]
    []
    []
    [ { "accounts": [], "data": "Fj2Eoy", "programId": "ComputeBudget111111111111111111111111111111", "stackHeight": null }, { "accounts": [], "data": "3NBouVUXXAB9", "programId": "ComputeBudget111111111111111111111111111111", "stackHeight": null }, { "parsed": { "info": { "destination": "AmAWVdxoJt4hwb9Hdxg9vwa7iodSZR7CSqdnVUPRHj99", "lamports": 8560000000, "source": "yF6TFRBTxGptx9JRruEUBYfqVgpKxByMzYSgdSg99Eh" }, "type": "transfer" }, "program": "system", "programId": "11111111111111111111111111111111", "stackHeight": null } ]
    []
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success" ]
    		450266
    3
    		2024-12-29 09:36:57.000310533420
    9fz7ueoxu2qZCKLzVBmFPVETEPxpskXib3oqD2LHy8CCVPfE1hPQkbM8sS67aTctni3wEhdX...
    		BkKfSanp6DiW7pnE1UnftSta9goSSiFgQrLUNtDYtgdW
    [ "BHwdEUbzceijAjKFE5J98ABSQR7Qr6gviQk8GuemV5ue" ]
    		15000TRUE
    [ { "pubkey": "BHwdEUbzceijAjKFE5J98ABSQR7Qr6gviQk8GuemV5ue", "signer": true, "source": "transaction", "writable": true }, { "pubkey": "Cs1MsjY6JgsHMhzAAPY459hMW7zfBnSiacp4WTykMowV", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "ComputeBudget111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false } ]
    [ 15020471926, 0, 1, 1 ]
    [ 6460456926, 8560000000, 1, 1 ]
    []
    []
    [ { "accounts": [], "data": "3DVGviTXKAPH", "programId": "ComputeBudget111111111111111111111111111111", "stackHeight": null }, { "accounts": [], "data": "LKoyXd", "programId": "ComputeBudget111111111111111111111111111111", "stackHeight": null }, { "parsed": { "info": { "destination": "Cs1MsjY6JgsHMhzAAPY459hMW7zfBnSiacp4WTykMowV", "lamports": 8560000000, "source": "BHwdEUbzceijAjKFE5J98ABSQR7Qr6gviQk8GuemV5ue" }, "type": "transfer" }, "program": "system", "programId": "11111111111111111111111111111111", "stackHeight": null } ]
    []
    [ "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program ComputeBudget111111111111111111111111111111 invoke [1]", "Program ComputeBudget111111111111111111111111111111 success", "Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success" ]
    		450266
    3
    5KB
    12s