Tokenflow

    Tokenflow is the Ethereum data warehouse (EDW) providing full details of raw data on the Ethereum chain. In Flipsidecryto, a curated version of this schema has been imported to cover the classic version of the Ethereum schema.

    Methodology

    1. Sample one of the token flow schema (using the random address and specific time) called 'state-diff' to analyze the pros and cons of it.

    Analysis

    'State-diff' can be used to track balance activity in the Ethereum chain where it can specifically track on a specific user address to find the trading activities and their balance. The example is shown in the figure below:

    State-diff breakdown

    Although the state-diff is good for tracing the trading activity of the specific address at a specific time. However, the provided schema is seemed to lack a piece of crucial information so the user has to browse through a 'tx_hash' for more information. For example, the target address and its address name interacted with this address so that it will be easier for the user to distinguish and group up transactions. Moreover, this schema can only trace Ethereum balance. It would be good if this schema could also trace the other alternate coins balance like a classic Ethereum.

    State-diff explanation

    The table above is an example of querying a random address at a specific date (2021-11-20). Noted that this random address and its tx_hash have been hidden for a privacy issue. In this table, there are two complete transactions of swapping between ETH tokens to alternate coins. The first one is swapping alternate coins for ETH and the second one is vice versa. In each transaction the process of updating is listed in detail below:

    • nonce change
    • gas stake
    • eth transfer
    • unused gas

    To be shortened, the user can focus on nonce change and prev_value of the gas stake and curr_value of the unused gas to roughly see the balance update before and after on each transaction.

    Conclusion

    'State-diff' is quite useful to track the target address activities compared to erc20_balance from classic Ethereum which only focused on a result balance of that address per day. Besides, this state-diff can be improved by adding more information into a schema such as an information of the interacted address or alternative coin tracing.

    Loading...