Methodology

This analysis involves a structured approach to extract, transform, and analyze blockchain transaction data to derive insights about BRRR Token activities. The steps outlined below are based on my code provided:

1. Token Price Aggregation:

- Hourly token price data is retrieved from the price dataset.

- The average daily token price is calculated by aggregating hourly prices, providing a consistent basis for converting token amounts into USD values.

2. Transaction Data Filtering:

- A subset of transactions is extracted from the blockchain event data based on specific criteria:

- The method_name field is used to identify relevant actions (e.g., account_stake_booster for staking and account_unstake_booster for unstaking).

- The receiver_id ensures only transactions involving the target contract are included.

- Only successful transactions (`receipt_succeeded`) are considered.

3. Data Transformation:

- The transaction type is standardized by mapping raw method names to human-readable labels such as "Stake" and "Unstake."

- The token amount is extracted from either transaction arguments or log data, handling variations in the data structure.

- Token amounts are normalized by dividing by \(10^{18}\) to account for token decimals.

- The token amounts are converted to USD using the pre-calculated daily average token price.

4. Metrics Calculation:

- The processed data is aggregated to compute key metrics for each transaction type:

- Total and average transaction volumes in both token units and USD.

- The number of unique transactions and users.

- Daily averages for transactions and unique users.

5. Result Grouping:

- Metrics are grouped by transaction type (`Stake` or Unstake) to provide clear and actionable insights into user behavior and token activity patterns.

This methodology ensures a comprehensive analysis of staking and unstaking activities, combining token price data with blockchain event data to deliver meaningful metrics