r/wallstreetbets crowd amplification. Graphs which companies are most shorted by Wall Street scumbags.
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/