[Report] Totals per AppID

[mliu-xlabs]

Task Deliver a report that includes Totals per AppID data exported to a CSV file.

Requirements

• 1 time report
• date starting from January 1, 2024
• Split up based on AppID - examples below
• for the AppID, record each combination and permutation as its own unique AppID

Examples of AppID combinations:

Portal Token Bridge, Connect Portal Token Bridge, Unknown CCTP Wormhole Integration Standard Relayer (currently says Generic Relayer) Portal Token Bridge, Wormchain Gateway Transfer (qq - this means we don't know if its connect or otherwise, just that it goes through cosmos) etc

Expected Column structure |AppID combination| Total # of Transactions| Total amount in USD, if applicable|

last 30, 60, 120 days would be great to get the raw data so we can do custom filtering

[SamantaCasal]

@mliu-xlabs Take a look to the report :

[
  {
    "_id": [ 'PORTAL_TOKEN_BRIDGE', 'CONNECT' ],
    "total_amount_usd": "68878555,8763445",
    "total_number_transactions": "104808"
  },
  {
    "_id": [ 'PORTAL_TOKEN_BRIDGE', 'OMNISWAP' ],
    "total_amount_usd": "3794628,10151",
    "total_number_transactions": "24471"
  },
  {
    "_id": [ 'CCTP_WORMHOLE_INTEGRATION', 'STABLE' ],
    "total_amount_usd": "34980,022913",
    "total_number_transactions": "47537"
  },
  { "_id": null, 
    "total_amount_usd": "376871,80314208",
    "total_number_transactions": "393901"
  {
    "_id": [ 'PORTAL_TOKEN_BRIDGE', 'WORMCHAIN_GATEWAY_TRANSFER' ],
    "total_amount_usd": "23817245,21086932",
    "total_number_transactions": "40825"
  },
  {
    "_id": [ 'CCTP_WORMHOLE_INTEGRATION', 'UNKNOWN' ],
    "total_amount_usd": "1055,930355",
    "total_number_transactions": "21306"
  },
  {
    "_id": [ 'PORTAL_TOKEN_BRIDGE' ],
    "total_amount_usd": "625111603,61066189",
    "total_number_transactions": "2056697"
  },
  {
    "_id": [ 'PORTAL_TOKEN_BRIDGE', 'UNKNOWN' ],
    "total_amount_usd": "331348319,87681909",
    "total_number_transactions": "277390"
  },
  {
    "_id": [ 'PORTAL_TOKEN_BRIDGE', 'TBTC' ],
    "total_amount_usd": "43100003",
    "total_number_transactions": "1991"
  },
  {
    "_id": [ 'PORTAL_TOKEN_BRIDGE', 'ETH_BRIDGE' ],
    "total_amount_usd": "29002067,88396",
    "total_number_transactions": "8044"
  },
  {
   "_id": [ 'PORTAL_TOKEN_BRIDGE', 'MAYAN' ],
    "total_amount_usd": "2657770,215042",
    "total_number_transactions": "1403"
  },
  {
    "_id": [ 'GENERIC_RELAYER'],
    "total_number_transactions": "887242"   
  },
  {
    "_id": [ 'MAYAN'],
    "total_number_transactions": "2483"     
  }
]