Cronos example queries

-- UDF for easier string manipulation. CREATE TEMP FUNCTION ParseSubStr(hexStr STRING, startIndex INT64, endIndex INT64) RETURNS STRING LANGUAGE js AS r"""  if (hexStr.length < 1) {  return hexStr;  }  return hexStr.substring(startIndex, endIndex); """; -- UDF to convert hex to decimal. CREATE TEMP FUNCTION HexToDecimal(hexStr STRING) RETURNS INT64 LANGUAGE js AS r"""  return parseInt(hexStr, 16); """; SELECT  t.transaction_hash,  t.from_address AS from_address,  CONCAT("0x", ParseSubStr(l.topics[OFFSET(2)], 26, LENGTH(l.topics[OFFSET(2)]))) AS to_address,  (HexToDecimal(l.data) / 1000000) AS usdt_transfer_amount FROM  `bigquery-public-data.goog_blockchain_cronos_mainnet_us.transactions` AS t INNER JOIN  `bigquery-public-data.goog_blockchain_cronos_mainnet_us.logs` AS l ON  l.transaction_hash = t.transaction_hash WHERE  t.to_address = LOWER("0x66e428c3f67a68878562e79a0234c1f83c208770") -- USDT AND  ARRAY_LENGTH(l.topics) > 0 AND  -- Transfer(address indexed src, address indexed dst, uint wad)  l.topics[OFFSET(0)] = LOWER("0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef") ; 

SELECT  from_address AS address,  CONCAT("https://cronoscan.com/address/", from_address) AS croniscan_link,  COUNT(from_address) AS num_transactions FROM  `bigquery-public-data.goog_blockchain_cronos_mainnet_us.transactions` AS t WHERE  to_address = LOWER("0x5C7F8A570d578ED84E63fdFA7b1eE72dEae1AE23") -- Wrapped CRO AND  block_timestamp > (CURRENT_TIMESTAMP() - INTERVAL 30 DAY) GROUP BY  from_address ORDER BY  COUNT(from_address) DESC ;