[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[[["\u003cp\u003eThis page provides example queries for analyzing blockchain data on Cronos using BigQuery.\u003c/p\u003e\n"],["\u003cp\u003ePre-GA products and features, like the ones discussed here, are subject to the "Pre-GA Offerings Terms," have limited support, and are available "as is".\u003c/p\u003e\n"],["\u003cp\u003eOne example query demonstrates how to view all transfers of the USDT token on Cronos since its creation.\u003c/p\u003e\n"],["\u003cp\u003eAnother query identifies the wallets that have interacted most with Wrapped Cronos within the past 30 days.\u003c/p\u003e\n"],["\u003cp\u003eThe BigQuery console is the main platform required to execute the queries provided, and a link is available to access it directly.\u003c/p\u003e\n"]]],[],null,["# Cronos example queries\n\n| **Preview**\n|\n|\n| This product or feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA products and features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThis page provides Blockchain Analytics query examples for Cronos.\n\nSee the [BigQuery documentation](/bigquery/docs/introduction) for\ninstructions on using BigQuery.\n\nShow all USDT transfers\n-----------------------\n\nThis query shows transfers of the USDT token on Cronos since genesis.\n\nIn the Google Cloud console, go to the **BigQuery** page.\n\n[Go to BigQuery](https://console.cloud.google.com/bigquery?sq=650023896125:5c3ab9f971ee4302b8dddaaf06d30232)\n\nThe following query is loaded into the **Editor** field: \n\n -- UDF for easier string manipulation.\n CREATE TEMP FUNCTION ParseSubStr(hexStr STRING, startIndex INT64, endIndex INT64)\n RETURNS STRING\n LANGUAGE js\n AS r\"\"\"\n if (hexStr.length \u003c 1) {\n return hexStr;\n }\n return hexStr.substring(startIndex, endIndex);\n \"\"\";\n\n -- UDF to convert hex to decimal.\n CREATE TEMP FUNCTION HexToDecimal(hexStr STRING)\n RETURNS INT64\n LANGUAGE js\n AS r\"\"\"\n return parseInt(hexStr, 16);\n \"\"\";\n\n SELECT\n t.transaction_hash,\n t.from_address AS from_address,\n CONCAT(\"0x\", ParseSubStr(l.topics[OFFSET(2)], 26, LENGTH(l.topics[OFFSET(2)]))) AS to_address,\n (HexToDecimal(l.data) / 1000000) AS usdt_transfer_amount\n FROM\n `bigquery-public-data.goog_blockchain_cronos_mainnet_us.transactions` AS t\n INNER JOIN\n `bigquery-public-data.goog_blockchain_cronos_mainnet_us.logs` AS l\n ON\n l.transaction_hash = t.transaction_hash\n WHERE\n t.to_address = LOWER(\"0x66e428c3f67a68878562e79a0234c1f83c208770\") -- USDT\n AND\n ARRAY_LENGTH(l.topics) \u003e 0\n AND\n -- Transfer(address indexed src, address indexed dst, uint wad)\n l.topics[OFFSET(0)] = LOWER(\"0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef\")\n ;\n\nThe following shows an example result:\n\nWrapped Cronos activity\n-----------------------\n\nThis query shows the wallets with the most interactions with Wrapped Cronos in the last 30 days.\n\nIn the Google Cloud console, go to the **BigQuery** page.\n\n[Go to BigQuery](https://console.cloud.google.com/bigquery?sq=650023896125:ed059681c252444886f759cbc3d7bda9)\n\nThe following query is loaded into the **Editor** field: \n\n SELECT\n from_address AS address,\n CONCAT(\"https://cronoscan.com/address/\", from_address) AS croniscan_link,\n COUNT(from_address) AS num_transactions\n FROM\n `bigquery-public-data.goog_blockchain_cronos_mainnet_us.transactions` AS t\n WHERE\n to_address = LOWER(\"0x5C7F8A570d578ED84E63fdFA7b1eE72dEae1AE23\") -- Wrapped CRO\n AND\n block_timestamp \u003e (CURRENT_TIMESTAMP() - INTERVAL 30 DAY)\n GROUP BY\n from_address\n ORDER BY\n COUNT(from_address) DESC\n ;\n\nThe following shows an example result:"]]