Data Cleaning

We transform the raw JSON per token into an array of simplified, flat objects like:

{
  token: "EDbiJeghrZeKdFM3utYzpZH9TPmszLhq56n1xVGrpBLV",
  realized: 2638.57,
  sold_usd: 5110.14,
  total_invested: 2471.57,
  trades: 4,
  pnl: 2638.57,
  buy_transactions: 2,
  sell_transactions: 2,
  first_trade: 1749658102360,
  last_trade: 1749658264132,
  average_buy: 1235.78,
}

We store cleaned data per wallet in Supabase using:

• wallet_address

• date

• reflect_score

• sub_metrics

• tokens[]

• notifications[]