foo=`sqlite3 door_wordlist.db "SELECT ratings_1.q3 FROM articles LEFT JOIN ratings_1 ON articles.id = ratings_1.id where articles.date_utc > date('2007-11-11 03:30:00') ORDER BY articles.date;"`; python _test-sparkline.py $foo > r7.gif
and 10 days of aggregated sentiment
foo=`sqlite3 door_wordlist.db 'select r1q3 from scores order by date desc limit 240;'`; python _test-sparkline.py $foo > agg13.gif