agatsoh / raiden_analytics Goto Github PK

I've opened this issue in order to keep track of all the queries that have to be performed.

Queries that have to be performed:

• Channel operations
  • Number of channels (created, closed, settled)
  • Channels opened/closed each day (average)
• Deposits performed (queries are the same as above)
  • Number of deposits performed (daily)
  • Avg number of deposits performed per day
• Side by side comparison of events
• Number of different Raiden users
• Number of existing channels in the network

More advanced queries:

• Average amount of tokens used for a deposit
• Daily network activity (mesured by the events in the network)
• Estimated number of nodes without a channel:
• Avg number of channels a node has

Other queries:

• max_deposit
• min_deposit
• network_capacity
• channel with the highest capacity
• channel with the lowest capacity

needs discussion

We can also provide as you said a search bar that would allow any user to search for statistics related to a specific user:

• Channels opened by him
• Channels opened by the counterparty
• Amount of tokens he deposited
• Channels he Closed
• Channels that were closed by the counterparty
• Settled channels
  etc.