For far too long, The Suits have served their own selfish interests above the rights of the majority -- and gotten away with it.
Until now.
# Clone this repo
npm i
npm run build
npm run dev
# Or
npm i && npm run build && npm run dev
Now visit http://localhost:5000/ !
Top 6 most shorted companies in the last 5 trading days, assuming there were no holidays in the last week:
fuckthesuits=# SELECT symbol, SUM(short_volume) AS total FROM daily_short_volume WHERE date > now() - interval '1d' * 7 GROUP BY symbol ORDER BY total DESC LIMIT 6;
Get the latest data on the above companies, assuming the top 6 didn't change:
fuckthesuits=# do $body$ declare _symbol text; _date text; _short_volume int; symbols text[] := array['SNDL', 'NAKD', 'AMC', 'CTRM', 'ZOM', 'NOK']; begin FOREACH _symbol IN ARRAY symbols LOOP SELECT date, short_volume FROM daily_short_volume WHERE symbol = _symbol AND date = '2021-02-03' INTO _date, _short_volume; RAISE NOTICE '%: ["%", %]', _symbol, _date, _short_volume; END LOOP; end; $body$;
svelte-fusioncharts/