Introduction to Parsed

Parsed is a specialized tool designed for interacting with and analyzing blockchain data using DuneSQL, an optimized query language based on TrinoSQL. Parsed's primary function is to decode blockchain data, such as transaction logs and smart contract events, into a more human-readable format. This is achieved by extracting, transforming, and converting complex byte arrays and hexadecimal values from blockchain logs, making it easier for users to retrieve and analyze on-chain data. For example, users can decode Ethereum transaction logs to extract information about transfers, events, or contract interactions, then present this data as structured tables. Parsed’s approach simplifies working with raw blockchain data by offering custom SQL functions, such as `bytearray_to_uint256` or `bytearray_substring`, which help in extracting and converting on-chain data segments.

Main Functions of Parsed

  • Decoding Blockchain Logs

    Example Example

    A user wants to decode an Ethereum transaction log to extract values like token addresses, sender/receiver addresses, and transfer amounts. Parsed uses functions like `bytearray_substring` to extract specific byte positions and `bytearray_to_uint256` to convert values from hexadecimal to decimal format.

    Example Scenario

    For example, decoding a log related to an ERC20 token transfer where the log data contains the sender address, receiver address, and the amount of tokens transferred.

  • Handling Large Numeric Types

    Example Example

    Users can cast large numbers, such as those in `uint256` format, by using Parsed’s built-in `bytearray_to_uint256` or arithmetic operations like addition, subtraction, or multiplication on blockchain-related data. This helps in decoding large amounts or balances stored in smart contracts.

    Example Scenario

    For example, calculating the total value transferred in a DeFi application using `uint256` formatted token values extracted from Ethereum smart contract logs.

  • Querying Multiple Blockchain Chains

    Example Example

    Users can query and decode data across multiple blockchains, including Ethereum, Arbitrum, Optimism, and others. Parsed facilitates queries on different networks by utilizing DuneSQL’s optimized query capabilities and abstracted tables.

    Example Scenario

    A user analyzing cross-chain bridge transactions can decode and compare logs from both the Ethereum mainnet and a Layer 2 solution like Optimism, extracting common elements such as sender, receiver, and token amounts.

Ideal Users of Parsed

  • Blockchain Data Analysts

    Analysts working with large datasets from blockchain networks will benefit from Parsed’s ability to extract, decode, and manipulate transaction logs and smart contract events. The built-in support for handling large numerical data types and byte arrays simplifies analysis, allowing analysts to retrieve meaningful insights from raw blockchain data.

  • DeFi Developers and Researchers

    DeFi developers and researchers working on decentralized financial applications can use Parsed to decode and analyze on-chain financial transactions, token swaps, liquidity pool activities, and more. The ability to retrieve data across multiple chains helps in understanding cross-chain liquidity flows and building robust DeFi protocols.

How to Use Parsed

  • Visit aichatonline.org for a free trial without login, also no need for ChatGPT Plus.

    Start by accessing Parsed from aichatonline.org. You can sign up for a free trial to explore its features without needing to create an account or subscribe to any premium services like ChatGPT Plus.

  • Access the query interface

    Once logged in, navigate to the SQL query interface. Parsed is based on DuneSQL, designed for efficient blockchain data querying. You'll be able to input complex queries and get precise blockchain data responses.

  • Prepare your data inputs

    Gather any relevant blockchain data such as transaction hashes, token addresses, and contract addresses that you wish to query or decode using the Parsed platform.

  • Use decoding and querying tools

    Make use of Parsed's features for decoding hashes and querying raw blockchain data. Parsed supports byte array functions, UINT256, and INT256 data types for handling large blockchain data values. You can slice and convert blockchain data as needed.

  • Review and analyze the results

    After running your queries, Parsed provides results for analysis. You can decode specific segments of data or access token and contract information directly from blockchain records.

  • Smart Contracts
  • Data Query
  • Hash Decoding
  • Blockchain Analytics
  • Byte Arrays

Common Questions about Parsed

  • What makes Parsed unique for blockchain data analysis?

    Parsed integrates DuneSQL's powerful blockchain-specific query tools, including byte array manipulation, uint256/int256 support, and detailed hash decoding. This allows for precise data extraction and analysis tailored to blockchain environments.

  • Do I need programming skills to use Parsed?

    While some familiarity with SQL is helpful, Parsed provides many ready-to-use functions and templates that simplify blockchain data querying. Users can rely on DuneSQL’s documentation to guide them through more complex operations.

  • What blockchain data can Parsed help me query?

    Parsed is designed to analyze data from multiple blockchains, including Ethereum, Arbitrum, Optimism, and more. It can process raw logs, decoded events, contract interactions, and transaction histories across various chains.

  • How can I decode blockchain hashes with Parsed?

    Using Parsed's byte array functions, you can slice and decode specific parts of blockchain transaction hashes, extracting data like sender, receiver, token, and transaction amount. It supports functions like `bytearray_substring` and `bytearray_to_decimal` for this purpose.

  • Does Parsed support custom data types for blockchain data?

    Yes, Parsed offers custom data types and conversions such as UINT256 and INT256, specifically designed to handle large numeric values and binary data commonly found in blockchain records.