flipside

    noisy-plum
    Mrftinoisy-plum
    Updated 2025-02-13
    WITH user_tx_counts AS (
    SELECT
    s.value::STRING AS "Address",
    COUNT(DISTINCT tx_id) AS "Total_tx"
    FROM
    eclipse.core.fact_transactions,
    LATERAL FLATTEN(input => signers) s
    GROUP BY
    1
    ),
    user_ranks AS (
    SELECT
    "Address",
    "Total_tx",
    NTILE(100) OVER (ORDER BY "Total_tx" DESC) AS percentile
    FROM
    user_tx_counts
    )
    SELECT
    COUNT(*) AS "Top 1% Users",
    MIN("Total_tx") AS "Min tx to be among top 1%"
    FROM
    user_ranks
    WHERE
    percentile = 1;

    Last run: about 1 month ago
    BLOCK_TIMESTAMP
    BLOCK_ID
    TX_ID
    INDEX
    RECENT_BLOCK_HASH
    SIGNERS
    FEE
    SUCCEEDED
    ACCOUNT_KEYS
    PRE_BALANCES
    POST_BALANCES
    PRE_TOKEN_BALANCES
    POST_TOKEN_BALANCES
    INSTRUCTIONS
    INNER_INSTRUCTIONS
    LOG_MESSAGES
    ADDRESS_TABLE_LOOKUPS
    UNITS_CONSUMED
    UNITS_LIMIT
    TX_SIZE
    VERSION
    FACT_TRANSACTIONS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		2025-02-13 12:51:53.00047994226
    Uqmv3NxvaowrVbr6xjCVrf5wtaAFWZgt1o6GALRzP2pJpqqGDb8sHyaC4teYhGPs2MtMhQDk...
    5
    		B2hHAWZ8rRx6Lynf6keXhSCiwbr3ENJxBeuXihsjZ9ZH
    [ "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM" ]
    		100TRUE
    [ { "pubkey": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "signer": true, "source": "transaction", "writable": true }, { "pubkey": "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM", "signer": true, "source": "transaction", "writable": true }, { "pubkey": "3NuAyAEeALEoxiEWuE1GgmhFAJHRHLgMtFTHB5TqSQJM", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "56TaWhtKFJU5dGV97zwyPXubrXcmzo6xZ1qzbKCKvLbn", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "6NnGAb4rRp8toihvexjro1U453azQHQSW7GkZqNaYQyS", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "73Rjq47RkUWWa2psSt8qydSKbBBQdxBMmUfAgMq3R9jV", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "7w8cCkrJyyzk7gBPQmqyHqpnYvMUk436VaCXt2eNpriz", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "85GYQUcLUYicSYLaoxKECCXmk4KyKGZHas9uwt8h5GKC", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "8goDZ3PGUE6mtKNgc5Mw6MmUT5ZMidMd193iCwDLrH2J", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "AeuDGtQ6jfJ3m728kw9zqWd3Ly74yc4J9mHV2gxFvzSq", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "Ap7P53xGWztRjfww6yXG1yHNvGCtZ6xuV7RfCBrsLSj3", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "BV21GibEdZwwHmatmuiaPPSec15PsaQaYvX1fq5XjkQ5", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "DiUhL8JArch5Y181yakeShiLASsy1zwcqEYEngcBXz6E", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "DX3outsbHQWQkB3afyU7QbFDfjkgyptDSWcaca8DpJRi", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "FvVsbwsbGVo6PVfimkkPhpcRfBrRitiV946nMNNuz7f9", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "Hs8fBFpopdJ8VUeH6EgUNeM3TBEfBqK1vLHuVnAuwycK", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "HUjEVJ6qZfg78we53bhMr6btsM6vXTtN9NidgAd14pW4", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "J9A2WuNF8JTB9NLKdn4bKa6o4D7dUn1mpWK8zaGeRjJ", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "L6busceyRG9KQBPDGKmy43xnRvLhiuYmcPcPubVuzDd", "signer": false, "source": "transaction", "writable": true }, { "pubkey": "11111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "D4P9HJYPczLFHvxBgpLKooy7eWczci8pr4x9Zu7iYCVN", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "J1GyvGaY3XPNGFQkMNx7C5aT48duYRrAJE75Evk3neas", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "So11111111111111111111111111111111111111112", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "SysvarRent111111111111111111111111111111111", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "signer": false, "source": "transaction", "writable": false }, { "pubkey": "TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb", "signer": false, "source": "transaction", "writable": false } ]
    [ 2673370, 0, 20264, 18904, 18904, 18904, 18904, 18904, 18904, 18904, 18904, 18904, 763436, 19924, 35904, 18904, 18904, 18904, 617994077664, 1, 0, 41412, 11152, 13736, 1000000000, 9860, 9076640, 11152 ]
    [ 153270, 0, 20264, 18904, 18904, 18904, 18904, 18904, 18904, 18904, 18904, 18904, 763436, 19924, 35904, 18904, 18904, 18904, 617996597664, 1, 0, 41412, 11152, 13736, 1000000000, 9860, 9076640, 11152 ]
    [ { "accountIndex": 2, "mint": "GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn", "owner": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "programId": "TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb", "uiTokenAmount": { "amount": "304590", "decimals": 9, "uiAmount": 0.00030459, "uiAmountString": "0.00030459" } }, { "accountIndex": 13, "mint": "GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn", "owner": "D4P9HJYPczLFHvxBgpLKooy7eWczci8pr4x9Zu7iYCVN", "programId": "TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb", "uiTokenAmount": { "amount": "782830183166", "decimals": 9, "uiAmount": 782.830183166, "uiAmountString": "782.830183166" } }, { "accountIndex": 18, "mint": "So11111111111111111111111111111111111111112", "owner": "D4P9HJYPczLFHvxBgpLKooy7eWczci8pr4x9Zu7iYCVN", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": { "amount": "617994057740", "decimals": 9, "uiAmount": 617.99405774, "uiAmountString": "617.99405774" } } ]
    [ { "accountIndex": 2, "mint": "GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn", "owner": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "programId": "TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb", "uiTokenAmount": { "amount": "2782963", "decimals": 9, "uiAmount": 0.002782963, "uiAmountString": "0.002782963" } }, { "accountIndex": 13, "mint": "GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn", "owner": "D4P9HJYPczLFHvxBgpLKooy7eWczci8pr4x9Zu7iYCVN", "programId": "TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb", "uiTokenAmount": { "amount": "782827704793", "decimals": 9, "uiAmount": 782.827704793, "uiAmountString": "782.827704793" } }, { "accountIndex": 18, "mint": "So11111111111111111111111111111111111111112", "owner": "D4P9HJYPczLFHvxBgpLKooy7eWczci8pr4x9Zu7iYCVN", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "uiTokenAmount": { "amount": "617996577740", "decimals": 9, "uiAmount": 617.99657774, "uiAmountString": "617.99657774" } } ]
    [ { "parsed": { "info": { "lamports": 19924, "newAccount": "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM", "owner": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "source": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "space": 165 }, "type": "createAccount" }, "program": "system", "programId": "11111111111111111111111111111111", "stackHeight": null }, { "parsed": { "info": { "destination": "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM", "lamports": 2520000, "source": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf" }, "type": "transfer" }, "program": "system", "programId": "11111111111111111111111111111111", "stackHeight": null }, { "parsed": { "info": { "account": "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM", "mint": "So11111111111111111111111111111111111111112", "owner": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "rentSysvar": "SysvarRent111111111111111111111111111111111" }, "type": "initializeAccount" }, "program": "spl-token", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "stackHeight": null }, { "accounts": [ "J1GyvGaY3XPNGFQkMNx7C5aT48duYRrAJE75Evk3neas", "FvVsbwsbGVo6PVfimkkPhpcRfBrRitiV946nMNNuz7f9", "DiUhL8JArch5Y181yakeShiLASsy1zwcqEYEngcBXz6E", "GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn", "So11111111111111111111111111111111111111112", "3NuAyAEeALEoxiEWuE1GgmhFAJHRHLgMtFTHB5TqSQJM", "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM", "DX3outsbHQWQkB3afyU7QbFDfjkgyptDSWcaca8DpJRi", "L6busceyRG9KQBPDGKmy43xnRvLhiuYmcPcPubVuzDd", "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "D4P9HJYPczLFHvxBgpLKooy7eWczci8pr4x9Zu7iYCVN", "TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb", "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "J9A2WuNF8JTB9NLKdn4bKa6o4D7dUn1mpWK8zaGeRjJ", "85GYQUcLUYicSYLaoxKECCXmk4KyKGZHas9uwt8h5GKC", "AeuDGtQ6jfJ3m728kw9zqWd3Ly74yc4J9mHV2gxFvzSq", "56TaWhtKFJU5dGV97zwyPXubrXcmzo6xZ1qzbKCKvLbn", "HUjEVJ6qZfg78we53bhMr6btsM6vXTtN9NidgAd14pW4", "6NnGAb4rRp8toihvexjro1U453azQHQSW7GkZqNaYQyS", "Ap7P53xGWztRjfww6yXG1yHNvGCtZ6xuV7RfCBrsLSj3", "8goDZ3PGUE6mtKNgc5Mw6MmUT5ZMidMd193iCwDLrH2J", "7w8cCkrJyyzk7gBPQmqyHqpnYvMUk436VaCXt2eNpriz", "73Rjq47RkUWWa2psSt8qydSKbBBQdxBMmUfAgMq3R9jV", "BV21GibEdZwwHmatmuiaPPSec15PsaQaYvX1fq5XjkQ5", "Hs8fBFpopdJ8VUeH6EgUNeM3TBEfBqK1vLHuVnAuwycK" ], "data": "6dBsuaBHXi8d3u1cxHuKp45Jn7kGR5196pae6h7atcfne2B", "programId": "iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU", "stackHeight": null }, { "parsed": { "info": { "account": "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM", "destination": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "owner": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf" }, "type": "closeAccount" }, "program": "spl-token", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "stackHeight": null } ]
    [ { "index": 3, "instructions": [ { "parsed": { "info": { "authority": "D4P9HJYPczLFHvxBgpLKooy7eWczci8pr4x9Zu7iYCVN", "destination": "3NuAyAEeALEoxiEWuE1GgmhFAJHRHLgMtFTHB5TqSQJM", "mint": "GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn", "source": "DX3outsbHQWQkB3afyU7QbFDfjkgyptDSWcaca8DpJRi", "tokenAmount": { "amount": "2478373", "decimals": 9, "uiAmount": 0.002478373, "uiAmountString": "0.002478373" } }, "type": "transferChecked" }, "program": "spl-token", "programId": "TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb", "stackHeight": 2 }, { "parsed": { "info": { "amount": "2520000", "authority": "6bBnX5wMaXdFi2Ci9GzuZdBt16WQvu9vx5o2UJohAJrf", "destination": "L6busceyRG9KQBPDGKmy43xnRvLhiuYmcPcPubVuzDd", "source": "FBfnCXbMXmMLko6pnphmpGrYaYKT2Q2vQzmVWFKG18oM" }, "type": "transfer" }, "program": "spl-token", "programId": "TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA", "stackHeight": 2 } ] } ]
    [ "Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success", "Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [1]", "Program log: Instruction: InitializeAccount", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA consumed 3442 of 1000000 compute units", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA success", "Program iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU invoke [1]", "Program log: Instruction: Swap", "Program log: INVARIANT: SWAP", "Program data: QMbN6CYIceJTDGBmJIiXPfv5IlyUqpfqjjdJeA8RYBSA2Cl57n9uDOXRMBRIEkva+/7iPuWw1AxR7WYwiSsDn6PDFJoTXSz3BpuIV/6rgYT7aH9jRhjANdrEOdwa6ztVmKDwAAAAAAEA/AAAAAAAAAD1JH1PsdrBuoTVAAAAAAAAgdwyzSWaz7qE1QAAAAAAAA==", "Program TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb invoke [2]", "Program log: Instruction: TransferChecked", "Program TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb consumed 8356 of 941949 compute units", "Program TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb success", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [2]", "Program log: Instruction: Transfer", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA consumed 4736 of 931393 compute units", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA success", "Program iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU consumed 70876 of 996558 compute units", "Program iNvTyprs4TX8m6UeUEkeqDFjAL9zRCRWcexK9Sd4WEU success", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [1]", "Program log: Instruction: CloseAccount", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA consumed 2914 of 925682 compute units", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA success" ]
    null
    		7723210000001152legacya31c44daabc3748a1ad74ce62bc8a9f42025-02-13 13:25:15.1152025-02-13 13:25:15.115
    1
    11KB
    25s