Kusama - on-chain league table wc 8th October 2023

Data analysis
, ,
1 
select chain.id, avg(numActiveAccounts) avgDailyAccounts from blocklog, chain where blocklog.chainID = chain.chainID and logDT > date_sub(Now(), interval 30 day) and chain.crawling = 1 and chain.relayChain = 'kusama' group by chain.id order by avgDailyAccounts desc limit 28;
+-------------------+------------------+
| id                | avgDailyAccounts |
+-------------------+------------------+
| kusama            |        1190.4483 |
| khala             |         804.0000 |
| bifrost-ksm       |         103.1034 |
| shiden            |          86.4828 |
| picasso           |          76.4138 |
| karura            |          69.4138 |
| mangatax          |          54.3793 |
| kintsugi          |          51.3793 |
| basilisk          |          46.0345 |
| moonriver         |          46.0345 |
| turing            |          45.0000 |
| zeitgeist         |          39.7931 |
| amplitude         |          29.7586 |
| statemine         |          29.4138 |
| parallel-heiko    |          26.2414 |
| tinkernet         |          22.8276 |
| altair            |          22.7931 |
| bitcountrypioneer |          22.7586 |
| robonomics        |          18.1379 |
| encointer         |          15.3448 |
| bridgehub         |          13.0345 |
| crab              |          12.8621 |
| integritee        |           7.7931 |
| shadow            |           4.6250 |
| subzero           |           4.1739 |
| quartz            |           3.9655 |
| litmus            |           3.7241 |
| kabocha           |           2.5517 |
+-------------------+------------------+