lbryio
Create page to show top content and channel claims
Similar to the rich list, have a page which shows claims/channels that have top LBC bid amounts.
Internal Use
Acceptance Criteria
Definition of Done
- [ ] Tested against acceptance criteria
- [ ] Tested against the assumptions of the user story
- [ ] The project builds without errors
- [ ] Unit tests are written and passing
- [ ] Tests on devices/browsers listed in the issue have passed
- [ ] QA performed & issues resolved
- [ ] Refactoring completed
- [ ] Any configuration or build changes documented
- [ ] Documentation updated
- [ ] Peer Code Review performed
We can just #ChainqueryIt
This will give us the data we want in the format we want to present how we want :)
SELECT
name,
(effective_amount/100000000) as amount
FROM chainquery.claim
WHERE claim_type = 2
ORDER BY effective_amount
DESC LIMIT 100
For claim streams just do claim_type = 1
So what you enter would be
https://chainquery.lbry.io/api/sql?query=SELECT name,(effective_amount/100000000) as amount FROM chainquery.claim WHERE claim_type = 1 ORDER BY effective_amount DESC LIMIT 100
To expand on your suggestion, here are some good stats that could be added :
- List of channels and claims by highest bid
- Claims and channels that got the most from paid content (not sure if this can be found, doesn't seem so according to https://lbry.io/faq/transaction-types)
- Top channels regarding tips
Also it would be good to have one or several charts with the following data points :
- Number of claims and channels published per day and total
- Number of LBC locked in claims/channels per day and total
- Tips sent per day
This could be added to a separate page concerning content stats, as opposed to blocks/addresses stats. Since LBRY is a marketplace, it seems important to make such data points available, to help publishers and users. It would be also good to have a search feature to find out, for example, which are the top claims or channels in a certain category.
