autism

less than a day away

2 hours

Im too tired

=p

pretty fun shows this year
i’ve seen almost all of them though

i’m doing some fancy data collection this year
last years i just logged the shows as plaintext, but now i’m collecting some data into a clickhouse database

query of chat messages per hour last night

    ┌────────────────hour─┬─total─┐
 1. │ 2025-11-30 05:00:00 │    30 │
 2. │ 2025-11-30 06:00:00 │   155 │
 3. │ 2025-11-30 07:00:00 │    45 │
 4. │ 2025-11-30 08:00:00 │    22 │
 5. │ 2025-11-30 09:00:00 │     3 │
 6. │ 2025-11-30 10:00:00 │     5 │
 7. │ 2025-11-30 11:00:00 │     4 │
 8. │ 2025-11-30 12:00:00 │    40 │
 9. │ 2025-11-30 13:00:00 │    15 │
10. │ 2025-11-30 14:00:00 │     9 │
11. │ 2025-11-30 15:00:00 │    34 │
12. │ 2025-11-30 16:00:00 │   215 │
13. │ 2025-11-30 17:00:00 │   128 │
14. │ 2025-11-30 18:00:00 │   379 │
15. │ 2025-11-30 19:00:00 │   760 │
16. │ 2025-11-30 20:00:00 │  1216 │
17. │ 2025-11-30 21:00:00 │  1189 │
18. │ 2025-11-30 22:00:00 │  1285 │
19. │ 2025-11-30 23:00:00 │   872 │
20. │ 2025-12-01 00:00:00 │  1193 │
21. │ 2025-12-01 01:00:00 │  1595 │
22. │ 2025-12-01 02:00:00 │  1518 │
23. │ 2025-12-01 03:00:00 │  2880 │
24. │ 2025-12-01 04:00:00 │  4510 │
25. │ 2025-12-01 05:00:00 │ 27606 │
26. │ 2025-12-01 06:00:00 │ 13255 │
27. │ 2025-12-01 07:00:00 │ 15088 │
28. │ 2025-12-01 08:00:00 │ 10846 │
29. │ 2025-12-01 09:00:00 │  6512 │
30. │ 2025-12-01 10:00:00 │  6351 │
31. │ 2025-12-01 11:00:00 │  3948 │
32. │ 2025-12-01 12:00:00 │   543 │
33. │ 2025-12-01 13:00:00 │   197 │
34. │ 2025-12-01 14:00:00 │    37 │
35. │ 2025-12-01 15:00:00 │    90 │
36. │ 2025-12-01 16:00:00 │   292 │
37. │ 2025-12-01 17:00:00 │   493 │
38. │ 2025-12-01 18:00:00 │   510 │
39. │ 2025-12-01 19:00:00 │   189 │
40. │ 2025-12-01 20:00:00 │   169 │
41. │ 2025-12-01 21:00:00 │   143 │
42. │ 2025-12-01 22:00:00 │   342 │
43. │ 2025-12-01 23:00:00 │   475 │
    └─────────────────────┴───────┘

need by show

good idea

    ┌─video_title─────────────────────────────────────────────────────────────────────┬─chat_count─┐
 1. │ [tsukarimasen] Toradora! - 01 (BD 1280x720)                                     │      10054 │
 2. │ [Lulu] Aldnoah Zero - 01 [BD 1080p Hi10 FLAC][Dual-Audio]                       │       8239 │
 3. │ 13 Merry                                                                        │       7361 │
 4. │ [MTBB] Bakemonogatari - 01v2 [346DABB1]                                         │       6316 │
 5. │ [Oyasumi] Pani Poni Dash - 01 [Dca1154a]                                        │       5157 │
 6. │ Princess Principal - 01V2 [A3e98f1c]                                            │       3856 │
 7. │ [Utw] Carnival Phantasm - 01 [Bd][H264-1080P Flac][Ad3f6682]                    │       3711 │
 8. │ T ・ S ・ F in N I P P O N ！(Stereoman Bootleg Remix)                          │       3679 │
 9. │ [smol] Onii-chan wa Oshimai! - S01E01v2 (BD 1080p HEVC Opus) [723EEC4B]         │       3601 │
10. │ Genshiken 01 [2A41C806]                                                         │       2080 │
11. │ IOSYS F O E English subtitles                                                   │       2030 │
12. │ [Kethsar] Joshikousei no Mudazukai - 01 (BD 1920x1080)                          │       2014 │
13. │ [FFF] Golden Time - 01 [BD][1080p-FLAC][0A94EDB8]                               │       1932 │
14. │ [Deity] Heion Sedai no Idaten-tachi - 01 (BD 1080p x264 10-bit FLAC) [CE58A024] │       1853 │
15. │ padoru                                                                          │       1570 │
16. │ [Moozzi2] Emiya-San Chi No Kyou No Gohan - 01 (Bd 1920X1080 X.264 Flac)         │       1338 │
17. │ PaPa TuTu WaWa full clip HD Kakuchou Shoujokei Trinary                          │       1274 │
18. │ Nana.Seven.Of.Seven.01.(Dual.Audio).Xvid.[Am]-1                                 │       1157 │
19. │ [Doki] Non Non Biyori - 01 (1920x1080 Hi10P BD FLAC) [324F003D]                 │       1114 │
20. │ Accidentally on purpose                                                         │       1036 │
21. │ Migu 01                                                                         │       1013 │
22. │ GJ-bu ED3 (Purely Sky ~Watashi Dake no Sora~)                                   │        974 │
23. │ 【MMD】With pleasant companions『Go!Go!Carlito!』【PV】                         │        898 │
24. │ [Doki] Non Non Biyori - 01 (1920x1080 Hi10P BD FLAC) [324F003D]                 │        821 │
25. │ NANANANANANANANANANA                                                            │        782 │
    └─────────────────────────────────────────────────────────────────────────────────┴────────────┘

kinda tricky to query, not sure if accurate

nice movie

christmas episode was yuru yuri

thanks