First things first, let’s grab 1. RedditExtractoR for scraping reddit posts 2. ttr for quant trading info & ticker lists 3. BatchGetSymbols for symbol look up 4. Various Plotting tools
library(RedditExtractoR)## Warning: package 'RedditExtractoR' was built under R version 4.1.3library(TTR)## Warning: package 'TTR' was built under R version 4.1.3library(curl)## Using libcurl 7.64.1 with Schannellibrary(tidyverse)## -- Attaching packages --------------------------------------- tidyverse 1.3.1 --## v ggplot2 3.3.5 v purrr 0.3.4
## v tibble 3.1.6 v dplyr 1.0.8
## v tidyr 1.2.0 v stringr 1.4.0
## v readr 2.1.2 v forcats 0.5.1## -- Conflicts ------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag() masks stats::lag()
## x readr::parse_date() masks curl::parse_date()library(quanteda)## Warning: package 'quanteda' was built under R version 4.1.3## Warning in .recacheSubclasses(def@className, def, env): undefined subclass
## "packedMatrix" of class "replValueSp"; definition not updated## Warning in .recacheSubclasses(def@className, def, env): undefined subclass
## "packedMatrix" of class "mMatrix"; definition not updated## Package version: 3.2.1
## Unicode version: 13.0
## ICU version: 69.1## Parallel computing: 12 of 12 threads used.## See https://quanteda.io for tutorials and examples.library(readr)
library(dplyr)
library(tm)## Warning: package 'tm' was built under R version 4.1.3## Loading required package: NLP##
## Attaching package: 'NLP'## The following objects are masked from 'package:quanteda':
##
## meta, meta<-## The following object is masked from 'package:ggplot2':
##
## annotate##
## Attaching package: 'tm'## The following object is masked from 'package:quanteda':
##
## stopwordslibrary(SnowballC)
library(BatchGetSymbols)## Warning: package 'BatchGetSymbols' was built under R version 4.1.3## Loading required package: rvest##
## Attaching package: 'rvest'## The following object is masked from 'package:readr':
##
## guess_encoding## library(lubridate)##
## Attaching package: 'lubridate'## The following objects are masked from 'package:base':
##
## date, intersect, setdiff, unionlibrary(arsenal)## Warning: package 'arsenal' was built under R version 4.1.3##
## Attaching package: 'arsenal'## The following object is masked from 'package:lubridate':
##
## is.Datelibrary(ggplot2)
library(plotly)## Warning: package 'plotly' was built under R version 4.1.3##
## Attaching package: 'plotly'## The following object is masked from 'package:ggplot2':
##
## last_plot## The following object is masked from 'package:stats':
##
## filter## The following object is masked from 'package:graphics':
##
## layoutlibrary(reshape2)## Warning: package 'reshape2' was built under R version 4.1.3##
## Attaching package: 'reshape2'## The following object is masked from 'package:tidyr':
##
## smithslibrary(sentimentr)## Warning: package 'sentimentr' was built under R version 4.1.3##
## Attaching package: 'sentimentr'## The following object is masked from 'package:plotly':
##
## highlightFirst things first we’re going to get a codex of all ticker symbols listed on all exchanges.
Then we are going to get all subthreads on WSB indexed by reddit, sorted by new and set for an hour duration!
Because I don’t know how much power your computer has, I’m going to limit it to 500 total posts!
master <- TTR::stockSymbols(exchange = c("AMEX", "NASDAQ", "NYSE", "ARCA", "BATS", "IEX"))[,c('Name', 'Symbol')]## Fetching NASDAQ symbols...## Fetching non-NASDAQ symbols... all_posts <- find_thread_urls(subreddit="wallstreetbets", sort_by="new", period="hour")## parsing URLs on page 1...
## parsing URLs on page 2...
## parsing URLs on page 3...
## parsing URLs on page 4...
## parsing URLs on page 5...
## parsing URLs on page 6...
## parsing URLs on page 7...
## parsing URLs on page 8...
## parsing URLs on page 9...
## parsing URLs on page 10... slim_posts <- head(all_posts, n=500L)At this point we have our 500 indexed posts, and we’re going to create a corpus out of all of them!
From there, we’re going to strip numbers and punctuation, and create a window around each of the ticker symbols found in the text.
slim_posts$index <- 1:nrow(slim_posts)
corp <- corpus(slim_posts, docid_field = "index", text_field = "text")
x <- kwic(tokens(corp, remove_punct = TRUE, remove_numbers = TRUE),
pattern = master$Symbol,
window = 8, case_insensitive = FALSE,
)
x$index = x$docname
add_In_Date <- slim_posts[c("index","date_utc")]
rownames(add_In_Date) <- NULL
target <- as.data.frame(x)
target$sentence = paste(target$pre, target$post)
target <- merge(target,add_In_Date,by="index")
targetBecause there was some issues with stripping punctuation causing issues in getting sentiment for sentences I threw it through a a punctuation stripper.
target$sentence <- str_replace_all(target$sentence, pattern = '[:punct:]', replacement =" ")At this point we have relatively sanitized data and we will proceed to take the data, run both sides of the window through a sentiment determining routine, and then create a dataframe that has the sentiment, date, and ticker symbol.
#get_sentences(Bravo_Lima$sentence)
target$sentiment <- sentiment(target$sentence)$sentiment
sentimentHolder <- target[c("keyword","date_utc", "sentiment")]
sentimentHolder = setNames(sentimentHolder, c("ticker", "ref.date","sentiment"))
sentimentHolder <- sentimentHolder %>% group_by(ticker, ref.date) %>% summarise(mean(sentiment))## `summarise()` has grouped output by 'ticker'. You can override using the
## `.groups` argument.sentimentHolderback <- sentimentHolder
sentimentHolder$ref.date = as.Date(sentimentHolder$ref.date)
sentimentHolderAt this point we will get the price metrics of all ticker symbols enclosed in the data for a range of the sentiment data minus one day to plus two days!
max(sentimentHolder$ref.date)+2## [1] "2022-05-11"min(sentimentHolder$ref.date)-1## [1] "2022-05-01"l.out <- BatchGetSymbols(tickers = unique(sentimentHolder$ticker),
first.date = as.Date(min(sentimentHolder$ref.date)),
last.date = min(as.Date(max(sentimentHolder$ref.date)+2,Sys.Date())), do.cache=FALSE)## Warning: `BatchGetSymbols()` was deprecated in BatchGetSymbols 2.6.4.
## Please use `yfR::yf_get()` instead.
## 2022-05-01: Package BatchGetSymbols will soon be replaced by yfR.
## More details about the change is available at github <<www.github.com/msperlin/yfR>
## You can install yfR by executing:
##
## remotes::install_github('msperlin/yfR')##
## Running BatchGetSymbols for:
## tickers =A, AAPL, ABNB, ADM, AGRO, AI, ALL, AM, AMC, AMD, AMZN, ANTM, ARE, ARKK, ASTS, B, BA, BAC, BB, BBBY, BE, BG, BOOM, BP, BY, C, CAR, CASH, CC, CCJ, CDC, CI, CLNE, CLOV, CMBS, CMS, CNC, COIN, COP, CPI, CVNA, CWH, D, DC, DCF, DD, DEF, DHI, DIDI, DKNG, DM, DMA, DNA, DO, DOW, E, EDIT, ENPH, EOD, EPS, ESG, ET, ETN, ETSY, EVER, EXPE, F, FL, FOMO, FOR, FREE, GET, GME, GO, GOOD, H, HHS, HIMX, HOLD, HUT, HYG, IBB, IG, IMO, IP, IPO, IS, IT, IWM, IYH, J, JD, JNJ, KEY, L, LEAP, LEN, LLY, LMT, LNG, LOVE, LQD, LYFT, MA, MBB, MCO, MCR, MD, ME, MGPI, MPC, MRNA, MRO, MSCI, MSFT, MSM, NEXT, NGL, NKLA, NOW, NVAX, O, OI, ON, OUT, OXY, PANW, PEG, PENN, PFE, PLAY, PLTR, PM, PST, PYPL, QQQ, R, RAYS, RC, RH, RICO, RIVN, RNA, ROC, ROKU, RSI, S, SHE, SHOP, SNDL, SO, SOFI, SP, SPCE, SPOT, SPY, SQQQ, STAR, T, TA, TAN, TIGO, TLRY, TLT, TQQQ, TRUE, TSLA, TV, TWTR, UK, UNH, UP, UPST, USA, USD, USO, UVXY, UWMC, VC, VERY, VMBS, VTI, VXX, W, WE, WGO, WISH, WOW, WTI, XBI, XHB, XLE, XLI, XLU, Y, YOLO, ZIM
## Downloading data for benchmark ticker
## ^GSPC | yahoo (1|1)
## A | yahoo (1|197) - Got 100% of valid prices | Nice!
## AAPL | yahoo (2|197) - Got 100% of valid prices | Youre doing good!
## ABNB | yahoo (3|197) - Got 100% of valid prices | OK!
## ADM | yahoo (4|197) - Got 100% of valid prices | Mas bah tche, que coisa linda!
## AGRO | yahoo (5|197) - Got 100% of valid prices | You got it!
## AI | yahoo (6|197) - Got 100% of valid prices | Mas bah tche, que coisa linda!
## ALL | yahoo (7|197) - Got 100% of valid prices | Nice!
## AM | yahoo (8|197) - Got 100% of valid prices | Got it!
## AMC | yahoo (9|197) - Got 100% of valid prices | Well done!
## AMD | yahoo (10|197) - Got 100% of valid prices | Well done!
## AMZN | yahoo (11|197) - Got 100% of valid prices | Good job!
## ANTM | yahoo (12|197) - Got 100% of valid prices | Good stuff!
## ARE | yahoo (13|197) - Got 100% of valid prices | OK!
## ARKK | yahoo (14|197) - Got 100% of valid prices | Feels good!
## ASTS | yahoo (15|197) - Got 100% of valid prices | Well done!
## B | yahoo (16|197) - Got 100% of valid prices | Looking good!
## BA | yahoo (17|197) - Got 100% of valid prices | OK!
## BAC | yahoo (18|197) - Got 100% of valid prices | Good stuff!
## BB | yahoo (19|197) - Got 100% of valid prices | Well done!
## BBBY | yahoo (20|197) - Got 100% of valid prices | Looking good!
## BE | yahoo (21|197) - Got 100% of valid prices | You got it!
## BG | yahoo (22|197) - Got 100% of valid prices | Looking good!
## BOOM | yahoo (23|197) - Got 100% of valid prices | Feels good!
## BP | yahoo (24|197) - Got 100% of valid prices | Well done!
## BY | yahoo (25|197) - Got 100% of valid prices | OK!
## C | yahoo (26|197) - Got 100% of valid prices | Good job!
## CAR | yahoo (27|197) - Got 100% of valid prices | You got it!
## CASH | yahoo (28|197) - Got 100% of valid prices | Good stuff!
## CC | yahoo (29|197) - Got 100% of valid prices | Good stuff!
## CCJ | yahoo (30|197) - Got 100% of valid prices | Feels good!
## CDC | yahoo (31|197) - Got 100% of valid prices | Well done!
## CI | yahoo (32|197) - Got 100% of valid prices | Well done!
## CLNE | yahoo (33|197) - Got 100% of valid prices | Nice!
## CLOV | yahoo (34|197) - Got 100% of valid prices | You got it!
## CMBS | yahoo (35|197) - Got 100% of valid prices | Got it!
## CMS | yahoo (36|197) - Got 100% of valid prices | OK!
## CNC | yahoo (37|197) - Got 100% of valid prices | Looking good!
## COIN | yahoo (38|197) - Got 100% of valid prices | You got it!
## COP | yahoo (39|197) - Got 100% of valid prices | Nice!
## CPI | yahoo (40|197) - Got 100% of valid prices | You got it!
## CVNA | yahoo (41|197) - Got 100% of valid prices | Good job!
## CWH | yahoo (42|197) - Got 100% of valid prices | Nice!
## D | yahoo (43|197) - Got 100% of valid prices | Good stuff!
## DC | yahoo (44|197) - Got 100% of valid prices | Youre doing good!
## DCF | yahoo (45|197) - Got 100% of valid prices | Well done!
## DD | yahoo (46|197) - Got 100% of valid prices | Boa!
## DEF | yahoo (47|197) - Got 100% of valid prices | Good job!
## DHI | yahoo (48|197) - Got 100% of valid prices | Good job!
## DIDI | yahoo (49|197) - Got 100% of valid prices | You got it!
## DKNG | yahoo (50|197) - Got 100% of valid prices | Youre doing good!
## DM | yahoo (51|197) - Got 100% of valid prices | Youre doing good!
## DMA | yahoo (52|197) - Got 100% of valid prices | You got it!
## DNA | yahoo (53|197) - Got 100% of valid prices | Youre doing good!
## DO | yahoo (54|197) - Got 100% of valid prices | Nice!
## DOW | yahoo (55|197) - Got 100% of valid prices | Good job!
## E | yahoo (56|197) - Got 100% of valid prices | You got it!
## EDIT | yahoo (57|197) - Got 100% of valid prices | Youre doing good!
## ENPH | yahoo (58|197) - Got 100% of valid prices | You got it!
## EOD | yahoo (59|197) - Got 100% of valid prices | Feels good!
## EPS | yahoo (60|197) - Got 100% of valid prices | Good job!
## ESG | yahoo (61|197) - Got 100% of valid prices | Well done!
## ET | yahoo (62|197) - Got 100% of valid prices | Good stuff!
## ETN | yahoo (63|197) - Got 100% of valid prices | Feels good!
## ETSY | yahoo (64|197) - Got 100% of valid prices | OK!
## EVER | yahoo (65|197) - Got 100% of valid prices | Youre doing good!
## EXPE | yahoo (66|197) - Got 100% of valid prices | OK!
## F | yahoo (67|197) - Got 100% of valid prices | Well done!
## FL | yahoo (68|197) - Got 100% of valid prices | Feels good!
## FOMO | yahoo (69|197) - Got 100% of valid prices | You got it!
## FOR | yahoo (70|197) - Got 100% of valid prices | OK!
## FREE | yahoo (71|197) - Got 100% of valid prices | OK!
## GET | yahoo (72|197) - Got 100% of valid prices | Good job!
## GME | yahoo (73|197) - Got 100% of valid prices | Youre doing good!
## GO | yahoo (74|197) - Got 100% of valid prices | Looking good!
## GOOD | yahoo (75|197) - Got 100% of valid prices | Good job!
## H | yahoo (76|197) - Got 100% of valid prices | Good job!
## HHS | yahoo (77|197) - Got 100% of valid prices | Well done!
## HIMX | yahoo (78|197) - Got 100% of valid prices | Youre doing good!
## HOLD | yahoo (79|197) - Got 100% of valid prices | Looking good!
## HUT | yahoo (80|197) - Got 100% of valid prices | Good job!
## HYG | yahoo (81|197) - Got 100% of valid prices | Well done!
## IBB | yahoo (82|197) - Got 100% of valid prices | Nice!
## IG | yahoo (83|197) - Got 100% of valid prices | Nice!
## IMO | yahoo (84|197) - Got 100% of valid prices | Youre doing good!
## IP | yahoo (85|197) - Got 100% of valid prices | Got it!
## IPO | yahoo (86|197) - Got 100% of valid prices | Nice!
## IS | yahoo (87|197) - Got 100% of valid prices | Well done!
## IT | yahoo (88|197) - Got 100% of valid prices | Got it!
## IWM | yahoo (89|197) - Got 100% of valid prices | Well done!
## IYH | yahoo (90|197) - Got 100% of valid prices | Boa!
## J | yahoo (91|197) - Got 100% of valid prices | Feels good!
## JD | yahoo (92|197) - Got 100% of valid prices | Youre doing good!
## JNJ | yahoo (93|197) - Got 100% of valid prices | Looking good!
## KEY | yahoo (94|197) - Got 100% of valid prices | Got it!
## L | yahoo (95|197) - Got 100% of valid prices | Looking good!
## LEAP | yahoo (96|197) - Error in download..
## LEN | yahoo (97|197) - Error in download..
## LLY | yahoo (98|197) - Error in download..
## LMT | yahoo (99|197) - Error in download..
## LNG | yahoo (100|197) - Error in download..
## LOVE | yahoo (101|197) - Error in download..
## LQD | yahoo (102|197) - Error in download..
## LYFT | yahoo (103|197) - Error in download..
## MA | yahoo (104|197) - Got 100% of valid prices | Boa!
## MBB | yahoo (105|197) - Error in download..
## MCO | yahoo (106|197) - Error in download..
## MCR | yahoo (107|197) - Error in download..
## MD | yahoo (108|197) - Error in download..
## ME | yahoo (109|197) - Error in download..
## MGPI | yahoo (110|197) - Error in download..
## MPC | yahoo (111|197) - Error in download..
## MRNA | yahoo (112|197) - Error in download..
## MRO | yahoo (113|197) - Error in download..
## MSCI | yahoo (114|197) - Error in download..
## MSFT | yahoo (115|197) - Error in download..
## MSM | yahoo (116|197) - Error in download..
## NEXT | yahoo (117|197) - Error in download..
## NGL | yahoo (118|197) - Error in download..
## NKLA | yahoo (119|197) - Error in download..
## NOW | yahoo (120|197) - Error in download..
## NVAX | yahoo (121|197) - Got 100% of valid prices | Boa!
## O | yahoo (122|197) - Error in download..
## OI | yahoo (123|197) - Error in download..
## ON | yahoo (124|197) - Error in download..
## OUT | yahoo (125|197) - Error in download..
## OXY | yahoo (126|197) - Error in download..
## PANW | yahoo (127|197) - Error in download..
## PEG | yahoo (128|197) - Error in download..
## PENN | yahoo (129|197) - Error in download..
## PFE | yahoo (130|197) - Error in download..
## PLAY | yahoo (131|197) - Error in download..
## PLTR | yahoo (132|197) - Error in download..
## PM | yahoo (133|197) - Error in download..
## PST | yahoo (134|197) - Error in download..
## PYPL | yahoo (135|197) - Error in download..
## QQQ | yahoo (136|197) - Error in download..
## R | yahoo (137|197) - Error in download..
## RAYS | yahoo (138|197) - Error in download..
## RC | yahoo (139|197) - Error in download..
## RH | yahoo (140|197) - Error in download..
## RICO | yahoo (141|197) - Error in download..
## RIVN | yahoo (142|197) - Error in download..
## RNA | yahoo (143|197) - Error in download..
## ROC | yahoo (144|197) - Got 100% of valid prices | Good job!
## ROKU | yahoo (145|197) - Error in download..
## RSI | yahoo (146|197) - Error in download..
## S | yahoo (147|197) - Error in download..
## SHE | yahoo (148|197) - Error in download..
## SHOP | yahoo (149|197) - Got 100% of valid prices | OK!
## SNDL | yahoo (150|197) - Error in download..
## SO | yahoo (151|197) - Error in download..
## SOFI | yahoo (152|197) - Error in download..
## SP | yahoo (153|197) - Error in download..
## SPCE | yahoo (154|197) - Error in download..
## SPOT | yahoo (155|197) - Error in download..
## SPY | yahoo (156|197) - Error in download..
## SQQQ | yahoo (157|197) - Error in download..
## STAR | yahoo (158|197) - Error in download..
## T | yahoo (159|197) - Error in download..
## TA | yahoo (160|197) - Error in download..
## TAN | yahoo (161|197) - Error in download..
## TIGO | yahoo (162|197) - Error in download..
## TLRY | yahoo (163|197) - Error in download..
## TLT | yahoo (164|197) - Error in download..
## TQQQ | yahoo (165|197) - Error in download..
## TRUE | yahoo (166|197) - Error in download..
## TSLA | yahoo (167|197) - Error in download..
## TV | yahoo (168|197) - Error in download..
## TWTR | yahoo (169|197) - Error in download..
## UK | yahoo (170|197) - Error in download..
## UNH | yahoo (171|197) - Error in download..
## UP | yahoo (172|197) - Error in download..
## UPST | yahoo (173|197) - Error in download..
## USA | yahoo (174|197) - Error in download..
## USD | yahoo (175|197) - Error in download..
## USO | yahoo (176|197) - Error in download..
## UVXY | yahoo (177|197) - Error in download..
## UWMC | yahoo (178|197) - Error in download..
## VC | yahoo (179|197) - Error in download..
## VERY | yahoo (180|197) - Error in download..
## VMBS | yahoo (181|197) - Error in download..
## VTI | yahoo (182|197) - Error in download..
## VXX | yahoo (183|197) - Error in download..
## W | yahoo (184|197) - Error in download..
## WE | yahoo (185|197) - Error in download..
## WGO | yahoo (186|197) - Error in download..
## WISH | yahoo (187|197) - Error in download..
## WOW | yahoo (188|197) - Error in download..
## WTI | yahoo (189|197) - Error in download..
## XBI | yahoo (190|197) - Error in download..
## XHB | yahoo (191|197) - Error in download..
## XLE | yahoo (192|197) - Error in download..
## XLI | yahoo (193|197) - Error in download..
## XLU | yahoo (194|197) - Error in download..
## Y | yahoo (195|197) - Error in download..
## YOLO | yahoo (196|197) - Error in download..
## ZIM | yahoo (197|197) - Error in download..l.out## $df.control
## # A tibble: 99 x 6
## ticker src download.status total.obs perc.benchmark.dates threshold.decisi~
## <chr> <chr> <chr> <int> <dbl> <chr>
## 1 A yahoo OK 7 1 KEEP
## 2 AAPL yahoo OK 7 1 KEEP
## 3 ABNB yahoo OK 7 1 KEEP
## 4 ADM yahoo OK 7 1 KEEP
## 5 AGRO yahoo OK 7 1 KEEP
## 6 AI yahoo OK 7 1 KEEP
## 7 ALL yahoo OK 7 1 KEEP
## 8 AM yahoo OK 7 1 KEEP
## 9 AMC yahoo OK 7 1 KEEP
## 10 AMD yahoo OK 7 1 KEEP
## # ... with 89 more rows
##
## $df.tickers
## price.open price.high price.low price.close volume price.adjusted
## 1 118.380 120.340 116.490 119.570 1756200 119.570000
## 2 119.720 123.980 119.090 122.400 3217800 122.400002
## 3 121.690 126.690 121.440 126.300 2460400 126.300003
## 4 124.620 125.210 120.800 122.150 2123600 122.150002
## 5 120.880 121.880 118.000 121.080 1629000 121.080002
## 6 119.130 119.130 112.640 113.110 1861700 113.110001
## 7 115.440 117.940 113.140 116.640 2141800 116.639999
## 8 156.710 158.230 153.270 157.960 123055300 157.728256
## 9 158.150 160.710 156.320 159.480 88966500 159.246017
## 10 159.670 166.480 159.260 166.020 108256500 165.776428
## 11 163.850 164.080 154.950 156.770 130525300 156.540009
## 12 156.010 159.440 154.180 157.280 116055700 157.279999
## 13 154.930 155.830 151.490 152.060 131577900 152.059998
## 14 155.520 156.740 152.930 154.510 115366700 154.509995
## 15 153.210 155.130 147.211 152.780 5945300 152.779999
## 16 154.090 154.490 141.580 145.000 16774700 145.000000
## 17 152.550 158.740 145.872 156.180 20598100 156.179993
## 18 152.190 153.880 140.858 143.090 11367200 143.089996
## 19 142.700 143.110 133.040 135.840 9564300 135.839996
## 20 131.760 131.885 118.830 119.370 14430900 119.370003
## 21 122.950 123.460 113.530 116.130 13638500 116.129997
## 22 90.210 90.450 88.000 89.310 3578500 89.309998
## 23 89.290 90.880 88.840 89.760 3859500 89.760002
## 24 90.240 91.300 88.920 91.150 3413600 91.150002
## 25 91.150 91.710 88.310 89.410 2934800 89.410004
## 26 88.910 90.140 88.370 89.730 2597500 89.730003
## 27 88.520 88.550 83.990 84.360 4329000 84.360001
## 28 85.310 88.090 84.090 84.970 4026600 84.970001
## 29 11.200 11.400 11.120 11.400 841800 11.400000
## 30 11.500 11.690 11.380 11.680 919500 11.680000
## 31 11.700 11.900 11.170 11.480 920000 11.480000
## 32 11.510 11.680 11.130 11.230 769500 11.230000
## 33 11.180 11.200 10.880 10.930 1960100 10.930000
## 34 10.810 10.850 9.890 9.890 1867900 9.890000
## 35 9.970 10.220 9.830 9.960 929900 9.960000
## 36 16.990 18.310 16.560 18.120 2501900 18.120001
## 37 17.160 17.970 16.980 17.230 2902500 17.230000
## 38 17.200 18.590 16.500 18.450 2644600 18.450001
## 39 18.190 18.200 16.710 17.080 2361100 17.080000
## 40 17.020 17.100 15.328 16.190 2607800 16.190001
## 41 15.500 15.900 14.680 14.700 3167700 14.700000
## 42 15.140 15.580 13.850 14.930 4455700 14.930000
## 43 127.390 129.410 125.430 127.730 1587800 127.730003
## 44 128.660 132.060 128.330 129.780 1662300 129.779999
## 45 129.750 133.900 128.690 133.680 1688600 133.679993
## 46 131.310 133.090 129.610 131.580 2465100 131.580002
## 47 131.260 132.000 129.460 130.560 1851900 130.559998
## 48 129.870 130.030 127.910 128.960 1405400 128.960007
## 49 129.860 132.080 128.390 129.590 1739500 129.589996
## 50 10.190 10.315 9.940 10.170 3213400 10.170000
## 51 10.150 10.665 10.150 10.590 2590200 10.590000
## 52 10.700 10.860 10.475 10.830 3267100 10.830000
## 53 10.810 10.845 10.260 10.410 4226400 10.410000
## 54 10.530 10.670 10.260 10.630 2565900 10.630000
## 55 10.440 10.450 9.840 9.890 4872700 9.890000
## 56 10.010 10.180 9.630 9.900 3460900 9.900000
## 57 15.100 15.490 14.610 15.260 23883200 15.260000
## 58 15.160 16.110 14.730 15.510 31834300 15.510000
## 59 15.220 15.910 14.680 15.720 26421700 15.720000
## 60 15.680 15.790 14.360 14.690 26987600 14.690000
## 61 14.660 14.840 13.520 13.760 32932600 13.760000
## 62 13.630 13.630 12.430 12.520 40732200 12.520000
## 63 13.150 14.010 11.500 11.840 55693400 11.840000
## 64 85.660 90.370 85.320 89.840 98304100 89.839996
## 65 89.850 92.210 89.010 91.130 126381800 91.129997
## 66 98.180 99.690 91.700 99.420 225394100 99.419998
## 67 97.650 97.840 92.170 93.870 153129800 93.870003
## 68 94.340 98.180 92.650 95.340 144211500 95.339996
## 69 92.870 93.740 85.380 86.360 144523700 86.360001
## 70 89.180 90.770 85.410 88.730 137235500 88.730003
## 71 2448.020 2493.360 2367.500 2490.000 7439400 2490.000000
## 72 2481.070 2524.410 2456.500 2485.070 3956700 2485.070068
## 73 2472.000 2520.000 2383.660 2518.570 5537300 2518.570068
## 74 2460.000 2469.980 2301.450 2328.140 7219600 2328.139893
## 75 2297.000 2381.010 2261.630 2295.450 6206700 2295.449951
## 76 2226.250 2280.000 2159.140 2175.780 6406200 2175.780029
## 77 2225.000 2252.850 2143.420 2177.180 5271700 2177.179932
## 78 505.500 509.980 488.330 497.110 1095200 497.109985
## 79 499.610 503.680 496.910 498.480 841700 498.480011
## 80 499.490 513.130 492.510 510.290 1227200 510.290009
## 81 511.060 517.180 499.080 506.860 985200 506.859985
## 82 500.880 508.070 498.240 504.640 946600 504.640015
## 83 500.320 501.660 487.640 490.880 1115100 490.880005
## 84 494.460 497.300 484.690 489.320 1296400 489.320007
## 85 182.040 182.960 174.010 178.150 1073200 178.149994
## 86 179.180 182.150 177.780 180.510 843500 180.509995
## 87 180.690 184.680 178.890 184.310 787300 184.309998
## 88 183.610 184.680 177.370 179.180 928300 179.179993
## 89 178.820 178.960 174.670 176.680 727400 176.679993
## 90 174.750 175.490 166.620 167.270 1241400 167.270004
## 91 169.270 171.310 162.660 163.160 1180200 163.160004
## 92 47.000 50.130 46.350 50.130 33584000 50.130001
## 93 49.680 51.420 49.140 49.870 21910700 49.869999
## 94 49.740 52.710 47.460 52.430 51205400 52.430000
## 95 51.230 51.230 46.950 47.750 37096800 47.750000
## 96 47.640 47.640 43.990 45.630 44955500 45.630001
## 97 44.120 44.975 40.755 41.130 43539600 41.130001
## 98 42.650 44.110 38.720 41.080 59822500 41.080002
## 99 7.490 8.140 7.435 7.960 1118600 7.960000
## 100 8.500 8.870 7.900 8.510 2488200 8.510000
## 101 8.460 8.970 8.210 8.920 800200 8.920000
## 102 8.720 8.840 8.373 8.470 566000 8.470000
## 103 8.490 8.790 7.950 8.750 791100 8.750000
## 104 8.500 8.500 7.360 7.630 1487100 7.630000
## 105 7.840 7.990 6.690 6.960 1667200 6.960000
## 106 33.500 34.300 32.760 33.360 301900 33.360001
## 107 33.490 33.880 32.850 33.520 343900 33.520000
## 108 33.560 34.600 33.270 34.530 222000 34.529999
## 109 34.080 34.130 32.940 33.350 215000 33.349998
## 110 33.400 33.400 32.320 32.730 229800 32.730000
## 111 32.400 33.370 32.350 32.950 287600 32.950001
## 112 33.370 33.370 31.870 32.240 236800 32.240002
## 113 148.020 149.450 143.380 148.610 12399200 148.610001
## 114 149.090 154.450 147.910 153.580 10149500 153.580002
## 115 152.910 157.140 150.770 156.970 9550600 156.970001
## 116 155.690 157.990 149.050 150.470 7950800 150.470001
## 117 149.960 150.900 145.850 148.900 7690000 148.899994
## 118 146.000 146.950 132.650 133.310 12593800 133.309998
## 119 136.760 137.840 130.330 132.950 11781400 132.949997
## 120 36.030 36.280 35.400 36.140 46652200 36.139999
## 121 36.340 37.630 36.330 37.130 48926000 37.130001
## 122 37.370 38.750 37.280 38.620 57860300 38.619999
## 123 38.050 38.210 36.870 37.540 48860600 37.540001
## 124 37.370 37.620 36.610 37.450 50427400 37.450001
## 125 36.870 37.060 36.060 36.370 51242000 36.369999
## 126 36.750 37.130 35.180 35.760 60235300 35.759998
## 127 5.690 5.870 5.610 5.860 6701100 5.860000
## 128 5.860 5.980 5.800 5.880 5503200 5.880000
## 129 5.890 6.130 5.720 6.120 5707100 6.120000
## 130 6.020 6.040 5.770 5.820 6448200 5.820000
## 131 5.740 5.850 5.550 5.610 7537300 5.610000
## 132 5.510 5.570 5.110 5.140 9641400 5.140000
## 133 5.220 5.310 4.990 5.190 11288900 5.190000
## 134 13.600 13.790 12.850 13.720 4258400 13.720000
## 135 13.750 14.280 13.330 14.040 3010500 14.040000
## 136 13.850 14.240 13.440 14.220 3022800 14.220000
## 137 13.860 13.950 12.530 12.760 4780500 12.760000
## 138 12.570 12.660 11.770 12.070 3963200 12.070000
## 139 11.750 11.890 10.910 10.970 4749200 10.970000
## 140 11.180 11.250 9.830 10.110 5570000 10.110000
## 141 18.230 18.850 17.880 18.760 2036300 18.760000
## 142 18.740 19.550 18.460 18.950 1982300 18.950001
## 143 19.240 20.375 18.770 20.300 2736800 20.299999
## 144 19.960 20.140 18.500 18.970 2816700 18.969999
## 145 15.820 16.610 14.530 15.130 11720700 15.130000
## 146 14.590 14.670 13.255 13.590 5668100 13.590000
## 147 14.040 14.220 12.555 13.290 4723900 13.290000
## 148 113.130 116.150 113.120 115.240 1652500 115.239998
## 149 115.000 117.670 114.560 116.770 1283000 116.769997
## 150 117.300 118.880 114.960 118.680 1863500 118.680000
## 151 118.440 118.930 114.350 114.820 1033200 114.820000
## 152 114.560 115.600 113.160 115.230 1475600 115.230003
## 153 113.210 113.800 107.570 107.830 1775500 107.830002
## 154 108.740 111.100 108.300 110.330 1703000 110.330002
## 155 19.900 20.370 18.740 19.500 241800 19.500000
## 156 19.500 20.990 19.400 20.160 252900 20.160000
## 157 20.440 22.710 20.160 22.450 171200 22.450001
## 158 22.200 22.510 20.580 21.300 126300 21.299999
## 159 23.910 26.380 22.400 25.410 441900 25.410000
## 160 25.290 26.130 23.320 23.400 241500 23.400000
## 161 23.520 23.520 20.320 21.970 175700 21.969999
## 162 28.550 28.870 28.160 28.860 12851400 28.546761
## 163 30.300 31.300 30.240 31.180 19291500 30.841579
## 164 31.550 31.930 31.120 31.850 15372200 31.504309
## 165 31.650 31.740 30.790 31.220 16744900 30.881145
## 166 31.720 31.900 31.350 31.860 17153500 31.514200
## 167 30.860 30.870 29.600 29.680 18948100 29.357861
## 168 30.220 30.440 29.250 29.890 15934800 29.565580
## 169 23.510 23.600 23.000 23.410 118400 23.321438
## 170 23.540 23.910 23.190 23.780 78900 23.690039
## 171 23.920 24.350 23.540 24.300 115400 24.208069
## 172 24.040 24.046 23.480 23.790 89400 23.700001
## 173 23.630 23.670 23.290 23.570 69300 23.570000
## 174 23.350 23.750 23.280 23.560 89500 23.559999
## 175 23.610 23.760 22.940 23.230 133700 23.230000
## 176 48.460 48.860 47.780 48.710 25904000 48.709999
## 177 49.330 50.810 49.080 50.100 25374500 50.099998
## 178 50.170 52.400 50.040 52.230 26643600 52.230000
## 179 51.440 52.130 50.690 51.310 25756000 51.310001
## 180 51.240 52.000 50.580 51.620 25912000 51.619999
## 181 50.990 51.220 49.590 49.890 28888400 49.889999
## 182 50.540 50.690 47.660 48.750 31054700 48.750000
## 183 263.120 293.080 259.700 280.560 1696000 280.559998
## 184 302.000 307.950 261.650 285.280 2095900 285.279999
## 185 286.080 299.000 270.770 291.210 1076700 291.209991
## 186 283.950 289.000 269.270 273.700 637000 273.700012
## 187 269.330 270.010 249.010 255.860 936200 255.860001
## 188 250.910 252.450 223.780 227.260 882500 227.259995
## 189 230.880 241.360 221.360 226.980 796400 226.979996
## 190 43.950 44.680 42.120 43.340 374300 43.340000
## 191 43.210 43.990 42.650 42.970 401800 42.970001
## 192 43.130 44.330 41.950 44.120 304400 44.119999
## 193 43.500 43.670 41.740 42.160 223300 42.160000
## 194 42.090 42.100 40.570 41.050 234500 41.049999
## 195 40.330 41.250 39.260 39.510 304200 39.509998
## 196 40.210 41.710 37.810 38.690 339400 38.689999
## 197 33.620 33.869 32.100 33.100 2133600 32.881775
## 198 35.830 39.200 35.755 38.910 5212200 38.653473
## 199 39.420 42.000 39.110 41.510 3740900 41.236332
## 200 40.918 41.790 39.585 39.890 4137200 39.627010
## 201 39.850 40.640 38.670 40.060 2511600 39.795895
## 202 39.390 40.250 38.790 38.910 2382500 38.653473
## 203 39.110 39.530 36.770 37.600 1938100 37.352108
## 204 25.320 25.670 24.670 25.450 6287600 25.450001
## 205 25.470 26.270 25.470 25.750 6326100 25.750000
## 206 25.940 26.660 25.030 26.380 7458600 26.379999
## 207 26.470 27.610 24.080 24.480 14922500 24.480000
## 208 24.470 24.500 22.960 23.840 10710400 23.840000
## 209 23.160 23.160 20.720 21.020 13156900 21.020000
## 210 21.700 22.300 20.980 21.520 7932900 21.520000
## 211 69.610 70.060 68.350 69.440 301000 69.372696
## 212 69.770 70.677 69.500 70.060 159700 69.992096
## 213 70.310 71.906 70.110 71.870 224400 71.800346
## 214 71.460 71.530 69.960 70.570 197200 70.501602
## 215 70.440 70.920 69.930 70.750 214000 70.681427
## 216 70.260 70.799 69.729 70.160 228500 70.092003
## 217 70.500 70.800 68.810 69.380 442800 69.379997
## 218 247.210 249.480 241.610 246.110 1497500 246.110001
## 219 246.740 250.650 246.320 247.290 1115900 247.289993
## 220 248.140 256.710 245.900 255.670 1130700 255.669998
## 221 253.900 255.810 249.790 252.080 1628500 252.080002
## 222 255.800 267.510 255.040 266.900 2208100 266.899994
## 223 266.800 268.470 259.720 261.410 2228400 261.410004
## 224 262.020 264.440 258.630 260.650 1612900 260.649994
## 225 5.820 5.920 5.580 5.810 4460600 5.810000
## 226 5.810 6.180 5.800 6.040 2701000 6.040000
## 227 6.180 6.290 5.780 6.280 2972400 6.280000
## 228 6.220 6.240 5.780 5.940 2789400 5.940000
## 229 5.720 5.720 4.550 5.130 7333700 5.130000
## 230 4.970 4.990 4.220 4.230 6455300 4.230000
## 231 4.450 4.550 4.030 4.220 5619900 4.220000
## 232 2.670 2.826 2.655 2.820 6599100 2.820000
## 233 2.810 2.880 2.713 2.780 4710100 2.780000
## 234 2.780 2.940 2.595 2.930 8561900 2.930000
## 235 2.840 2.920 2.770 2.830 5129900 2.830000
## 236 2.770 2.810 2.610 2.690 8019800 2.690000
## 237 2.620 2.620 2.410 2.410 13758200 2.410000
## 238 2.760 2.890 2.300 2.370 21326400 2.370000
## 239 48.520 48.520 48.270 48.330 35100 48.330002
## 240 48.070 48.420 48.070 48.350 246300 48.349998
## 241 48.340 48.780 48.190 48.570 42500 48.570000
## 242 48.300 48.360 48.080 48.330 97100 48.330002
## 243 48.150 48.340 48.110 48.340 97700 48.340000
## 244 48.260 48.590 48.260 48.570 37900 48.570000
## 245 48.460 48.480 48.240 48.380 82500 48.380001
## 246 69.160 69.560 67.220 67.800 2015400 67.346954
## 247 67.980 69.170 67.390 67.490 2112100 67.039017
## 248 67.530 69.000 67.480 68.840 2247400 68.379997
## 249 68.210 68.520 66.990 67.480 1370900 67.480003
## 250 67.200 68.010 66.920 67.750 2060700 67.750000
## 251 67.450 69.690 67.190 69.180 2055600 69.180000
## 252 69.150 70.200 67.660 68.280 1880100 68.279999
## 253 80.990 81.460 78.130 79.060 3344500 79.059998
## 254 80.890 82.320 80.160 80.340 2976300 80.339996
## 255 81.150 83.350 79.610 82.910 2306000 82.910004
## 256 82.170 85.930 82.110 84.820 4679500 84.820000
## 257 84.480 85.130 82.410 84.030 2252800 84.029999
## 258 83.270 83.500 78.670 79.190 3382100 79.190002
## 259 80.550 81.180 78.660 79.960 2544200 79.959999
## 260 113.070 122.290 111.800 121.340 6229400 121.339996
## 261 120.230 129.400 119.970 123.560 5053200 123.559998
## 262 124.000 132.810 116.200 130.150 6492800 130.149994
## 263 125.000 125.640 112.050 114.250 7324400 114.250000
## 264 112.500 112.500 100.250 103.740 9014600 103.739998
## 265 96.000 96.430 81.780 83.510 16845400 83.510002
## 266 87.000 89.380 70.190 72.990 31780000 72.989998
## 267 94.270 96.050 92.580 95.920 6980500 95.919998
## 268 96.680 99.530 96.140 98.930 5748000 98.930000
## 269 101.000 104.190 99.110 103.860 7989800 103.860001
## 270 104.590 106.590 100.530 102.860 10593000 102.860001
## 271 104.170 107.710 102.800 107.690 9211700 107.690002
## 272 105.170 105.500 96.480 97.200 9750900 97.199997
## 273 98.880 101.520 95.970 98.000 7845900 98.000000
## 274 26.590 26.760 26.590 26.710 7300 26.709999
## 275 26.620 26.880 26.620 26.750 8300 26.750000
## 276 26.770 27.120 26.580 27.100 25600 27.100000
## 277 26.960 26.980 26.660 26.720 60200 26.719999
## 278 26.600 26.730 26.600 26.690 3500 26.690001
## 279 26.550 26.550 26.240 26.240 4000 26.240000
## 280 26.330 26.330 26.170 26.170 1900 26.170000
## 281 57.420 60.943 55.280 60.470 8982900 60.470001
## 282 58.010 59.680 54.900 57.330 9700900 57.330002
## 283 54.640 59.850 52.369 59.650 10408300 59.650002
## 284 56.800 56.995 47.450 48.920 11436900 48.919998
## 285 48.020 48.150 40.760 46.480 13184300 46.480000
## 286 46.350 46.900 38.420 38.770 14869300 38.770000
## 287 41.285 42.020 35.080 36.680 15723800 36.680000
## 288 25.670 26.796 25.360 26.740 1531400 26.740000
## 289 26.710 28.730 26.580 28.400 2900900 28.400000
## 290 27.700 31.120 26.420 30.500 3895300 30.500000
## 291 29.380 30.780 28.080 28.560 2235200 28.559999
## 292 28.940 31.080 28.130 29.390 2589200 29.389999
## 293 28.770 30.410 28.590 28.980 1460700 28.980000
## 294 29.260 29.360 27.010 27.750 1610900 27.750000
## 295 81.980 82.570 80.240 81.050 3109000 81.050003
## 296 81.550 82.500 80.730 81.230 3123900 81.230003
## 297 81.150 82.750 80.810 82.510 3719100 82.510002
## 298 82.260 83.680 81.570 83.040 4926400 83.040001
## 299 82.480 84.240 82.000 84.020 4843700 84.019997
## 300 83.550 84.690 82.350 83.770 4319600 83.769997
## 301 83.930 85.060 81.060 81.960 5273200 81.959999
## 302 4.180 4.250 3.970 4.050 430400 4.050000
## 303 4.010 4.060 4.000 4.020 85500 4.020000
## 304 4.010 4.070 4.000 4.050 96100 4.050000
## 305 4.010 4.050 3.900 3.970 202800 3.970000
## 306 4.000 4.000 3.650 3.950 282800 3.950000
## 307 3.900 3.900 3.630 3.780 138600 3.780000
## 308 3.800 3.800 3.380 3.420 165100 3.420000
## 309 8.420 8.420 8.300 8.300 24200 8.249391
## 310 8.350 8.384 8.300 8.300 36700 8.249391
## 311 8.328 8.328 8.230 8.310 30100 8.259330
## 312 8.270 8.380 8.270 8.330 19200 8.279207
## 313 8.317 8.340 8.090 8.200 25000 8.150000
## 314 8.180 8.180 7.870 7.920 21800 7.920000
## 315 7.920 7.920 7.810 7.830 56800 7.830000
## 316 65.680 66.210 64.350 65.900 3804800 65.900002
## 317 66.250 67.550 64.940 66.380 3474800 66.379997
## 318 67.220 68.940 65.550 68.780 2639500 68.779999
## 319 67.730 68.140 65.430 66.140 3273000 66.139999
## 320 65.960 66.460 64.800 65.420 3509900 65.419998
## 321 63.980 65.620 63.960 64.330 3583300 64.330002
## 322 65.120 65.660 62.210 63.320 3738300 63.320000
## 323 67.990 67.990 66.270 67.290 20400 67.290001
## 324 67.590 68.080 67.250 67.680 18200 67.680000
## 325 67.760 69.440 67.490 69.310 22800 69.309998
## 326 68.870 68.870 67.040 67.530 9000 67.529999
## 327 67.140 67.330 66.610 67.270 14100 67.269997
## 328 66.660 66.690 65.860 66.000 20200 66.000000
## 329 66.720 66.720 65.310 65.630 61000 65.629997
## 330 69.310 70.910 68.030 70.760 3554400 70.536240
## 331 70.760 71.980 69.880 71.720 2301000 71.493202
## 332 71.760 76.000 70.080 75.570 3984800 75.331024
## 333 72.810 74.200 69.970 71.150 4573800 70.925003
## 334 70.050 70.670 67.850 70.020 3513600 70.019997
## 335 68.800 71.360 68.410 69.930 3783100 69.930000
## 336 71.500 71.910 67.920 68.210 3744300 68.209999
## 337 1.900 2.000 1.820 1.990 23240400 1.990000
## 338 2.000 2.070 1.980 2.010 16329600 2.010000
## 339 1.920 2.020 1.890 2.020 24571700 2.020000
## 340 1.930 2.020 1.880 1.940 16968100 1.940000
## 341 1.870 1.890 1.740 1.740 41543400 1.740000
## 342 1.720 1.730 1.530 1.560 22768600 1.560000
## 343 1.680 1.700 1.570 1.570 23744400 1.570000
## 344 13.700 15.000 13.490 14.990 23857200 14.990000
## 345 14.852 15.560 14.750 15.080 23165100 15.080000
## 346 15.080 15.880 14.495 15.730 30428400 15.730000
## 347 15.550 15.564 13.880 14.440 19845800 14.440000
## 348 15.000 15.043 12.965 13.150 41398200 13.150000
## 349 12.715 12.880 10.920 10.990 37960100 10.990000
## 350 11.470 11.750 10.380 11.360 32385800 11.360000
## 351 3.510 3.655 3.445 3.630 6154000 3.630000
## 352 3.580 3.609 3.430 3.510 5214600 3.510000
## 353 3.800 4.085 3.650 4.040 9456000 4.040000
## 354 4.100 4.167 3.910 4.050 7888100 4.050000
## 355 4.140 4.160 3.790 3.990 8019800 3.990000
## 356 3.890 3.890 3.370 3.420 8840200 3.420000
## 357 2.710 2.720 1.260 1.330 82735600 1.330000
## 358 8.327 8.490 8.190 8.270 11900 8.270000
## 359 8.230 8.340 8.180 8.320 5900 8.320000
## 360 8.340 8.407 8.000 8.230 3800 8.230000
## 361 8.230 8.230 8.230 8.230 0 8.230000
## 362 8.230 8.250 8.210 8.210 3500 8.210000
## 363 8.210 8.260 8.190 8.190 2300 8.190000
## 364 8.190 8.240 8.100 8.240 3600 8.240000
## 365 2.900 3.150 2.792 3.130 22758500 3.130000
## 366 3.140 3.230 3.055 3.220 14162000 3.220000
## 367 3.230 3.390 3.050 3.290 23042900 3.290000
## 368 3.190 3.275 2.900 2.930 19091900 2.930000
## 369 2.950 2.950 2.650 2.710 22235300 2.710000
## 370 2.640 2.800 2.320 2.380 29680800 2.380000
## 371 2.550 2.670 2.190 2.410 29787000 2.410000
## 372 7.780 7.820 7.340 7.410 821100 7.410000
## 373 7.360 7.880 7.330 7.850 1350400 7.850000
## 374 8.050 8.260 7.784 7.990 3180900 7.990000
## 375 8.110 8.160 7.650 7.890 1179700 7.890000
## 376 7.920 7.990 7.760 7.790 2115300 7.790000
## 377 7.700 7.780 6.920 7.050 1484700 7.050000
## 378 7.150 7.300 6.650 6.690 1149000 6.690000
## 379 67.150 67.310 65.810 67.060 7250100 67.059998
## 380 67.120 68.330 67.060 68.150 4599500 68.150002
## 381 68.820 70.780 68.430 70.610 5589800 70.610001
## 382 70.260 70.360 67.530 68.470 6530600 68.470001
## 383 68.070 68.370 66.650 67.930 5807500 67.930000
## 384 66.840 67.810 66.470 66.630 7266900 66.629997
## 385 67.430 67.850 65.280 65.810 7885500 65.809998
## 386 27.880 28.120 27.610 28.030 761600 28.030001
## 387 28.260 28.660 28.260 28.600 975400 28.600000
## 388 28.930 29.280 28.670 29.220 616400 29.219999
## 389 28.940 28.940 28.200 28.490 809200 28.490000
## 390 29.190 29.260 28.730 28.980 666500 28.980000
## 391 28.180 28.180 27.420 27.490 866400 27.490000
## 392 28.150 28.340 27.640 28.070 703800 28.070000
## 393 13.250 14.290 13.030 14.270 1698900 14.270000
## 394 14.240 14.650 13.830 14.180 959200 14.180000
## 395 14.350 15.940 13.720 15.810 1692700 15.810000
## 396 15.160 15.420 13.970 14.560 1965200 14.560000
## 397 14.650 14.740 13.330 13.660 1697100 13.660000
## 398 13.120 13.360 11.100 11.110 3460300 11.110000
## 399 11.740 11.980 10.372 11.260 2656300 11.260000
## 400 159.370 168.760 158.180 168.330 1927300 168.330002
## 401 168.120 177.010 166.010 174.530 2208400 174.529999
## 402 175.480 192.900 174.280 191.940 3644700 191.940002
## 403 188.390 190.920 177.820 181.140 2194600 181.139999
## 404 179.640 179.860 164.720 165.890 2542800 165.889999
## 405 160.400 163.740 146.620 150.510 3022100 150.509995
## 406 156.790 161.980 144.320 151.650 2777100 151.649994
## 407 4.980 4.980 4.860 4.960 130600 4.960000
## 408 4.940 5.050 4.940 5.000 217900 5.000000
## 409 5.020 5.120 4.970 5.120 197300 5.120000
## 410 5.090 5.090 4.920 4.950 120300 4.950000
## 411 4.950 5.000 4.910 4.960 112400 4.960000
## 412 4.900 4.920 4.790 4.810 169100 4.810000
## 413 4.880 4.920 4.800 4.820 193400 4.820000
## 414 44.370 44.660 43.750 44.620 32800 44.619999
## 415 44.760 45.170 44.590 44.880 30500 44.880001
## 416 44.920 46.270 44.750 46.240 15600 46.240002
## 417 45.700 45.700 44.340 44.710 42200 44.709999
## 418 44.540 44.790 44.020 44.510 58400 44.509998
## 419 43.700 43.920 43.240 43.320 63200 43.320000
## 420 43.850 44.040 42.920 43.350 293900 43.349998
## 421 99.000 99.989 98.830 99.989 5000 99.988998
## 422 100.340 100.400 100.340 100.400 600 100.400002
## 423 100.450 103.456 100.450 103.456 3800 103.456001
## 424 101.980 101.980 99.350 99.401 4200 99.401001
## 425 98.302 99.120 98.090 99.120 1900 99.120003
## 426 97.250 97.400 95.513 95.513 2800 95.513000
## 427 96.810 97.130 94.790 95.687 9600 95.686996
## 428 11.020 11.300 10.900 11.280 23733300 11.090100
## 429 11.340 11.780 11.300 11.740 26734700 11.542356
## 430 11.940 12.090 11.570 12.080 32645200 11.876633
## 431 12.250 12.480 11.720 11.880 36272100 11.680000
## 432 11.800 11.840 11.360 11.630 29933300 11.630000
## 433 11.450 11.470 10.780 10.830 44115300 10.830000
## 434 11.050 11.080 10.360 10.690 31845900 10.690000
## 435 144.990 147.020 143.420 146.500 2732700 145.657272
## 436 144.510 150.960 144.510 146.580 3004900 145.736801
## 437 146.800 150.710 143.980 149.930 2558100 149.067535
## 438 148.720 150.880 147.100 148.380 3871000 147.526459
## 439 147.790 148.460 144.450 147.290 2101800 146.442719
## 440 145.340 149.310 145.050 147.960 3028900 147.108871
## 441 149.010 149.910 140.530 140.980 3543000 140.169022
## 442 92.320 97.220 90.625 97.070 5640000 97.070000
## 443 96.740 103.470 95.090 100.530 5615400 100.529999
## 444 100.000 110.950 96.101 109.330 8693700 109.330002
## 445 94.260 95.300 88.880 90.930 15386200 90.930000
## 446 89.670 90.880 81.115 86.380 9280400 86.379997
## 447 85.080 88.965 82.410 86.400 8281500 86.400002
## 448 89.310 92.670 81.565 84.060 6098500 84.059998
## 449 13.730 14.960 13.630 14.780 661400 14.780000
## 450 9.380 12.250 9.380 12.160 2715100 12.160000
## 451 11.950 13.320 11.680 13.130 796600 13.130000
## 452 12.920 13.000 12.020 12.530 320800 12.530000
## 453 12.460 12.950 11.680 12.390 296900 12.390000
## 454 12.070 12.720 11.410 11.500 497400 11.500000
## 455 11.850 11.850 10.280 10.360 275800 10.360000
## 456 174.880 178.020 169.260 174.810 5434400 174.809998
## 457 168.400 169.170 145.800 150.310 15895900 150.309998
## 458 148.990 150.670 142.810 149.560 7944100 149.559998
## 459 147.470 147.530 135.000 139.500 7577100 139.500000
## 460 139.880 139.880 131.430 132.330 5205200 132.330002
## 461 129.170 133.090 126.850 127.790 5827700 127.790001
## 462 131.140 135.330 127.180 132.340 5410100 132.339996
## 463 14.020 14.290 13.820 14.270 64734000 14.270000
## 464 14.310 14.750 14.200 14.560 55734200 14.560000
## 465 14.510 15.000 14.260 14.980 59774900 14.980000
## 466 14.820 14.820 14.340 14.530 57889200 14.530000
## 467 14.460 14.600 14.000 14.210 66528000 14.210000
## 468 13.850 14.170 13.310 13.370 71242000 13.370000
## 469 13.800 13.840 13.020 13.350 75506700 13.350000
## 470 29.340 29.790 28.900 29.770 2305100 29.770000
## 471 29.810 30.070 29.340 29.670 1346800 29.670000
## 472 29.650 30.810 29.400 30.750 1765700 30.750000
## 473 30.270 30.320 29.280 29.640 1651400 29.639999
## 474 29.340 29.830 28.080 29.490 2882900 29.490000
## 475 29.270 29.740 28.200 28.340 2370600 28.340000
## 476 28.490 28.670 26.840 27.630 2921300 27.629999
## 477 19.510 19.568 19.510 19.568 400 19.568001
## 478 19.620 19.625 19.620 19.625 100 19.625000
## 479 19.550 19.805 19.550 19.805 1900 19.805000
## 480 19.613 19.613 19.613 19.613 0 19.613001
## 481 19.580 19.618 19.580 19.610 700 19.610001
## 482 19.367 19.367 19.367 19.367 100 19.367001
## 483 19.310 19.315 19.310 19.315 400 19.315001
## 484 16.450 16.640 16.000 16.420 160800 16.420000
## 485 16.450 16.690 16.220 16.530 52700 16.530001
## 486 16.500 16.740 16.070 16.670 56200 16.670000
## 487 16.420 16.510 15.590 15.880 70300 15.880000
## 488 15.910 15.910 15.270 15.400 51300 15.400000
## 489 15.070 15.400 14.910 15.160 115300 15.160000
## 490 15.450 15.570 14.670 14.800 87100 14.800000
## 491 6.920 7.040 6.800 7.030 222500 7.030000
## 492 7.020 7.130 6.980 7.130 217600 7.130000
## 493 7.100 7.160 6.620 6.890 217000 6.890000
## 494 6.790 6.850 6.550 6.640 214900 6.640000
## 495 6.660 6.740 6.320 6.330 171600 6.330000
## 496 6.270 6.430 6.200 6.260 356300 6.260000
## 497 6.470 6.700 6.030 6.480 307600 6.480000
## 498 1.350 1.350 1.300 1.340 15700 1.340000
## 499 1.360 1.430 1.360 1.430 13100 1.430000
## 500 1.470 1.528 1.420 1.510 12100 1.510000
## 501 1.470 1.470 1.400 1.440 20400 1.440000
## 502 1.420 1.435 1.370 1.370 5400 1.370000
## 503 1.360 1.360 1.320 1.330 3900 1.330000
## 504 1.331 1.360 1.320 1.340 4500 1.340000
## 505 123.650 125.390 112.700 119.570 2543000 119.570000
## 506 118.480 124.430 114.420 120.430 1828200 120.430000
## 507 119.210 127.750 115.720 127.080 1662800 127.080002
## 508 123.940 124.680 115.120 119.130 1753900 119.129997
## 509 117.280 120.560 110.230 114.700 1786800 114.699997
## 510 110.780 110.780 98.080 98.790 3316200 98.790001
## 511 102.980 106.060 88.000 93.500 4150800 93.500000
## 512 33.500 33.975 32.710 33.310 745000 33.310001
## 513 33.540 34.320 33.240 33.850 951700 33.849998
## 514 33.610 34.310 33.220 34.150 830200 34.150002
## 515 33.740 34.270 31.860 32.460 820600 32.459999
## 516 32.730 33.040 31.805 32.150 718200 32.150002
## 517 31.910 32.540 31.640 32.250 775500 32.250000
## 518 32.270 32.570 30.570 31.070 1403900 31.070000
## 519 21.090 21.300 20.450 20.740 356600 20.740000
## 520 20.780 21.180 20.680 20.990 164200 20.990000
## 521 21.000 21.370 20.780 21.370 192400 21.370001
## 522 21.220 21.220 20.330 20.490 231000 20.490000
## 523 20.460 20.670 20.190 20.440 217600 20.440001
## 524 20.240 20.320 19.080 19.170 519000 19.170000
## 525 19.350 19.500 18.600 18.790 372000 18.790001
## 526 95.950 96.390 91.220 94.250 1514800 94.250000
## 527 94.150 94.430 87.610 89.450 2223300 89.449997
## 528 89.700 91.500 85.800 90.220 1669300 90.220001
## 529 88.550 90.790 85.210 86.470 1641200 86.470001
## 530 86.580 86.580 82.750 85.500 1061700 85.500000
## 531 84.270 84.490 79.230 79.790 1486000 79.790001
## 532 81.460 85.690 80.500 84.840 1462200 84.839996
## 533 7.470 7.970 7.470 7.920 17300 7.920000
## 534 7.870 7.980 7.820 7.970 28300 7.970000
## 535 8.010 8.180 7.760 8.080 10600 8.080000
## 536 8.140 8.180 7.970 8.040 8100 8.040000
## 537 8.040 8.040 7.940 7.980 2800 7.980000
## 538 7.700 7.750 7.370 7.750 15800 7.750000
## 539 7.530 7.740 7.510 7.700 5300 7.700000
## 540 9.030 9.290 8.950 9.280 2328300 9.280000
## 541 9.210 9.400 9.160 9.330 2109300 9.330000
## 542 9.400 9.540 9.060 9.510 1638300 9.510000
## 543 9.410 9.460 9.060 9.210 1937900 9.210000
## 544 9.100 9.140 8.680 8.780 3409400 8.780000
## 545 8.600 8.700 8.060 8.190 4106500 8.190000
## 546 8.330 8.470 8.110 8.380 2482500 8.380000
## 547 97.680 97.680 97.680 97.680 100 97.680000
## 548 97.690 97.690 97.690 97.690 100 97.690002
## 549 97.670 97.670 97.670 97.670 100 97.669998
## 550 97.710 97.710 97.710 97.710 0 97.709999
## 551 97.690 97.690 97.690 97.690 100 97.690002
## 552 97.720 97.720 97.720 97.720 100 97.720001
## 553 97.730 97.730 97.670 97.670 700 97.669998
## 554 3.560 3.725 3.490 3.700 5275900 3.700000
## 555 3.670 3.810 3.630 3.700 4654600 3.700000
## 556 3.740 4.010 3.585 4.010 7112900 4.010000
## 557 3.900 3.900 3.530 3.630 5429400 3.630000
## 558 3.520 3.590 3.290 3.410 7626800 3.410000
## 559 3.170 3.270 2.780 2.830 9492500 2.830000
## 560 3.030 3.130 2.700 2.800 7514500 2.800000
## 561 78.160 78.300 77.830 78.230 38674400 78.230003
## 562 78.400 78.760 78.350 78.640 42665700 78.639999
## 563 78.650 79.650 78.080 79.440 55154900 79.440002
## 564 78.970 79.020 77.810 78.030 53807900 78.029999
## 565 77.630 78.000 77.410 77.590 39256900 77.589996
## 566 77.130 77.310 76.720 76.770 38442700 76.769997
## 567 77.390 77.530 76.840 77.210 48419700 77.209999
## 568 116.200 118.550 115.350 118.360 3763000 118.360001
## 569 118.740 120.260 118.160 119.440 2267100 119.440002
## 570 120.020 122.290 116.680 121.860 3208500 121.860001
## 571 120.970 120.970 115.940 117.360 3228600 117.360001
## 572 115.770 116.060 112.330 113.170 4535000 113.169998
## 573 111.500 112.160 106.820 107.280 4404000 107.279999
## 574 110.110 111.780 108.220 110.140 6190700 110.139999
## 575 22.395 22.400 22.335 22.378 2000 22.378000
## 576 22.595 22.595 22.498 22.498 2400 22.497999
## 577 22.459 22.701 22.459 22.701 4500 22.701000
## 578 22.390 22.390 22.350 22.358 500 22.358000
## 579 22.280 22.300 22.170 22.220 4600 22.219999
## 580 22.162 22.266 22.162 22.266 6500 22.266001
## 581 22.400 22.410 22.330 22.344 14000 22.344000
## 582 50.190 50.730 48.210 50.690 1298200 50.689999
## 583 50.970 53.130 50.650 53.070 776900 53.070000
## 584 53.500 54.150 52.110 53.130 856600 53.130001
## 585 53.540 53.770 51.240 52.510 700500 52.509998
## 586 52.710 53.130 51.450 52.760 566300 52.759998
## 587 52.030 52.030 48.400 48.770 759000 48.770000
## 588 49.510 50.200 47.420 48.290 747300 48.290001
## 589 46.560 46.860 45.710 46.550 2771400 46.549999
## 590 46.550 47.430 46.490 46.820 2836700 46.820000
## 591 46.950 48.500 46.800 48.490 2791700 48.490002
## 592 48.020 48.480 47.430 48.110 2924800 48.110001
## 593 48.010 48.300 47.330 48.160 2517000 48.160000
## 594 47.750 48.800 47.650 47.810 4134800 47.810001
## 595 48.260 48.630 46.980 47.850 3329700 47.849998
## 596 35.400 36.370 35.070 36.340 190300 36.340000
## 597 36.320 36.740 35.510 35.860 80000 35.860001
## 598 35.470 36.700 33.850 36.600 175300 36.599998
## 599 35.810 35.860 33.260 33.820 72100 33.820000
## 600 33.160 33.280 31.160 32.050 91200 32.049999
## 601 30.970 31.330 28.770 28.950 162600 28.950001
## 602 29.690 30.230 27.560 28.790 106800 28.790001
## 603 3.850 4.060 3.740 4.060 2640100 4.060000
## 604 4.030 4.100 3.920 3.970 2308800 3.970000
## 605 3.990 4.180 3.910 4.150 3276900 4.150000
## 606 4.090 4.090 3.770 3.810 3280300 3.810000
## 607 3.820 3.850 3.565 3.740 5307800 3.740000
## 608 3.640 3.721 3.510 3.650 4492900 3.650000
## 609 3.760 3.760 3.295 3.340 9787300 3.340000
## 610 289.030 291.500 281.900 290.040 572700 290.040009
## 611 289.930 299.510 273.670 281.130 1019800 281.130005
## 612 282.450 282.450 265.660 280.060 792300 280.059998
## 613 276.550 279.040 256.610 259.550 817100 259.549988
## 614 257.900 257.900 248.880 252.810 789500 252.809998
## 615 249.190 251.300 237.740 239.320 842000 239.320007
## 616 245.260 249.190 239.260 246.010 957500 246.009995
## 617 184.900 187.820 182.380 186.890 38002100 186.889999
## 618 186.920 189.510 185.680 188.490 30246300 188.490005
## 619 189.050 193.930 185.690 193.520 38834700 193.520004
## 620 191.530 191.560 183.380 185.670 41468700 185.669998
## 621 184.960 185.420 180.550 182.580 45408800 182.580002
## 622 179.860 182.650 174.100 174.900 53682200 174.899994
## 623 177.570 178.910 171.200 174.950 53650800 174.949997
## 624 272.300 274.240 267.460 271.500 87700 271.500000
## 625 272.310 274.640 271.440 272.290 37500 272.290009
## 626 272.200 278.790 269.500 277.940 68400 277.940002
## 627 276.840 276.940 269.690 272.110 45700 272.109985
## 628 270.080 271.020 267.960 270.550 83600 270.549988
## 629 267.670 267.670 261.800 262.790 97500 262.790009
## 630 265.140 266.510 261.450 263.830 90300 263.829987
## 631 138.850 139.850 134.910 137.840 1077100 137.839996
## 632 138.260 139.340 135.190 138.600 1321300 138.600006
## 633 138.840 142.920 136.900 142.430 874900 142.429993
## 634 140.740 141.680 136.610 137.570 867800 137.570007
## 635 137.220 138.230 134.000 137.810 690500 137.809998
## 636 135.950 136.160 129.630 130.260 823200 130.259995
## 637 131.930 133.430 128.110 130.160 712800 130.160004
## 638 61.640 63.570 60.900 63.370 10728800 63.369999
## 639 62.800 63.960 61.645 62.170 9119100 62.169998
## 640 60.230 63.330 59.110 63.180 10050900 63.180000
## 641 60.580 61.243 58.260 59.390 11266500 59.389999
## 642 58.110 58.710 55.450 55.610 15133200 55.610001
## 643 53.700 54.000 50.120 51.040 22233000 51.040001
## 644 53.695 53.850 50.180 51.650 18345800 51.650002
## 645 180.470 181.410 177.030 178.640 7145400 178.639999
## 646 178.800 180.630 177.680 178.290 5898700 178.289993
## 647 178.150 180.500 177.150 180.200 5923000 180.199997
## 648 179.420 179.710 175.270 176.760 7089200 176.759995
## 649 175.140 176.870 174.690 176.370 6433700 176.369995
## 650 175.450 178.560 174.590 177.330 7855200 177.330002
## 651 178.230 179.180 176.500 177.090 8186700 177.089996
## 652 19.390 19.550 19.020 19.470 10348400 19.469999
## 653 19.660 19.870 19.460 19.710 8193300 19.709999
## 654 19.670 20.340 19.580 20.280 10343100 20.280001
## 655 19.990 20.100 19.400 19.780 9991500 19.780001
## 656 19.770 19.790 19.190 19.540 8197000 19.540001
## 657 19.280 19.430 18.900 19.180 9018300 19.180000
## 658 19.480 19.500 18.610 18.920 12488300 18.920000
## 659 62.930 63.050 60.450 61.570 1123200 61.570000
## 660 62.070 63.250 61.670 62.790 1143700 62.790001
## 661 63.060 64.890 62.970 64.850 645000 64.849998
## 662 64.250 64.710 63.120 63.760 604900 63.759998
## 663 63.720 64.770 63.230 64.440 917200 64.440002
## 664 64.050 64.530 62.810 63.080 825500 63.080002
## 665 63.450 64.220 62.280 62.730 1022700 62.730000
## 666 363.000 364.930 350.590 359.040 3903800 359.040009
## 667 361.590 363.440 353.440 357.790 2686900 357.790009
## 668 359.370 369.240 353.660 368.520 3346600 368.519989
## 669 362.100 367.770 349.030 353.370 3424800 353.369995
## 670 346.250 351.260 340.780 347.120 3635200 347.119995
## 671 341.000 342.390 324.890 327.990 5777400 327.989990
## 672 332.310 333.680 323.050 325.330 5003500 325.329987
## 673 44.900 53.790 44.680 53.750 8693900 53.750000
## 674 53.500 58.910 52.220 58.890 8046900 58.889999
## 675 59.220 62.740 56.020 62.730 6536100 62.730000
## 676 61.990 63.230 57.360 58.660 3893300 58.660000
## 677 58.660 58.780 54.030 57.300 3449500 57.299999
## 678 57.350 60.370 52.740 53.260 5909800 53.259998
## 679 42.100 55.440 41.740 53.860 13801500 53.860001
## 680 9.950 9.950 9.950 9.950 6100 9.950000
## 681 9.950 9.950 9.950 9.950 0 9.950000
## 682 9.950 9.950 9.950 9.950 0 9.950000
## 683 9.960 9.965 9.960 9.960 1900 9.960000
## 684 9.960 9.960 9.960 9.960 0 9.960000
## 685 9.975 9.975 9.950 9.950 4800 9.950000
## 686 9.970 9.970 9.960 9.960 200 9.960000
## 687 421.150 454.140 421.150 452.980 3371900 452.980011
## 688 451.750 475.350 449.450 465.200 3736300 465.200012
## 689 457.660 487.990 439.100 485.490 4470800 485.489990
## 690 407.640 424.880 395.860 413.090 11360800 413.089996
## 691 401.060 401.490 355.130 377.490 10265300 377.489990
## 692 362.000 371.710 337.290 340.040 6412700 340.040009
## 693 354.900 366.100 318.000 335.390 6086200 335.390015
## ref.date ticker ret.adjusted.prices ret.closing.prices
## 1 2022-05-02 A NA NA
## 2 2022-05-03 A 0.0236681609 0.0236681609
## 3 2022-05-04 A 0.0318627527 0.0318627527
## 4 2022-05-05 A -0.0328582811 -0.0328582811
## 5 2022-05-06 A -0.0087597215 -0.0087597215
## 6 2022-05-09 A -0.0658242556 -0.0658242556
## 7 2022-05-10 A 0.0312085401 0.0312085401
## 8 2022-05-02 AAPL NA NA
## 9 2022-05-03 AAPL 0.0096226322 0.0096226192
## 10 2022-05-04 AAPL 0.0410083161 0.0410083281
## 11 2022-05-05 AAPL -0.0557161179 -0.0557161774
## 12 2022-05-06 AAPL 0.0047271621 0.0032531415
## 13 2022-05-09 AAPL -0.0331892233 -0.0331892233
## 14 2022-05-10 AAPL 0.0161120415 0.0161120415
## 15 2022-05-02 ABNB NA NA
## 16 2022-05-03 ABNB -0.0509228895 -0.0509228895
## 17 2022-05-04 ABNB 0.0771034000 0.0771034000
## 18 2022-05-05 ABNB -0.0838135330 -0.0838135330
## 19 2022-05-06 ABNB -0.0506674135 -0.0506674135
## 20 2022-05-09 ABNB -0.1212455351 -0.1212455351
## 21 2022-05-10 ABNB -0.0271425477 -0.0271425477
## 22 2022-05-02 ADM NA NA
## 23 2022-05-03 ADM 0.0050386744 0.0050386744
## 24 2022-05-04 ADM 0.0154857394 0.0154857394
## 25 2022-05-05 ADM -0.0190893907 -0.0190893907
## 26 2022-05-06 ADM 0.0035790067 0.0035790067
## 27 2022-05-09 ADM -0.0598462256 -0.0598462256
## 28 2022-05-10 ADM 0.0072309150 0.0072309150
## 29 2022-05-02 AGRO NA NA
## 30 2022-05-03 AGRO 0.0245614035 0.0245614035
## 31 2022-05-04 AGRO -0.0171232877 -0.0171232877
## 32 2022-05-05 AGRO -0.0217770035 -0.0217770035
## 33 2022-05-06 AGRO -0.0267141585 -0.0267141585
## 34 2022-05-09 AGRO -0.0951509607 -0.0951509607
## 35 2022-05-10 AGRO 0.0070778564 0.0070778564
## 36 2022-05-02 AI NA NA
## 37 2022-05-03 AI -0.0491170503 -0.0491170503
## 38 2022-05-04 AI 0.0708067905 0.0708067905
## 39 2022-05-05 AI -0.0742547927 -0.0742547927
## 40 2022-05-06 AI -0.0521076698 -0.0521076698
## 41 2022-05-09 AI -0.0920321747 -0.0920321747
## 42 2022-05-10 AI 0.0156462585 0.0156462585
## 43 2022-05-02 ALL NA NA
## 44 2022-05-03 ALL 0.0160494477 0.0160494477
## 45 2022-05-04 ALL 0.0300508093 0.0300508093
## 46 2022-05-05 ALL -0.0157090897 -0.0157090897
## 47 2022-05-06 ALL -0.0077519683 -0.0077519683
## 48 2022-05-09 ALL -0.0122548332 -0.0122548332
## 49 2022-05-10 ALL 0.0048851502 0.0048851502
## 50 2022-05-02 AM NA NA
## 51 2022-05-03 AM 0.0412979351 0.0412979351
## 52 2022-05-04 AM 0.0226628895 0.0226628895
## 53 2022-05-05 AM -0.0387811634 -0.0387811634
## 54 2022-05-06 AM 0.0211335255 0.0211335255
## 55 2022-05-09 AM -0.0696142992 -0.0696142992
## 56 2022-05-10 AM 0.0010111223 0.0010111223
## 57 2022-05-02 AMC NA NA
## 58 2022-05-03 AMC 0.0163826999 0.0163826999
## 59 2022-05-04 AMC 0.0135396518 0.0135396518
## 60 2022-05-05 AMC -0.0655216285 -0.0655216285
## 61 2022-05-06 AMC -0.0633083730 -0.0633083730
## 62 2022-05-09 AMC -0.0901162791 -0.0901162791
## 63 2022-05-10 AMC -0.0543130990 -0.0543130990
## 64 2022-05-02 AMD NA NA
## 65 2022-05-03 AMD 0.0143588720 0.0143588720
## 66 2022-05-04 AMD 0.0909689594 0.0909689594
## 67 2022-05-05 AMD -0.0558237287 -0.0558237287
## 68 2022-05-06 AMD 0.0156598802 0.0156598802
## 69 2022-05-09 AMD -0.0941891690 -0.0941891690
## 70 2022-05-10 AMD 0.0274432836 0.0274432836
## 71 2022-05-02 AMZN NA NA
## 72 2022-05-03 AMZN -0.0019798924 -0.0019798924
## 73 2022-05-04 AMZN 0.0134805052 0.0134805052
## 74 2022-05-05 AMZN -0.0756104336 -0.0756104336
## 75 2022-05-06 AMZN -0.0140412275 -0.0140412275
## 76 2022-05-09 AMZN -0.0521335357 -0.0521335357
## 77 2022-05-10 AMZN 0.0006434028 0.0006434028
## 78 2022-05-02 ANTM NA NA
## 79 2022-05-03 ANTM 0.0027559817 0.0027559817
## 80 2022-05-04 ANTM 0.0236920192 0.0236920192
## 81 2022-05-05 ANTM -0.0067217150 -0.0067217150
## 82 2022-05-06 ANTM -0.0043798486 -0.0043798486
## 83 2022-05-09 ANTM -0.0272669816 -0.0272669816
## 84 2022-05-10 ANTM -0.0031779620 -0.0031779620
## 85 2022-05-02 ARE NA NA
## 86 2022-05-03 ARE 0.0132472696 0.0132472696
## 87 2022-05-04 ARE 0.0210514825 0.0210514825
## 88 2022-05-05 ARE -0.0278335687 -0.0278335687
## 89 2022-05-06 ARE -0.0139524506 -0.0139524506
## 90 2022-05-09 ARE -0.0532600712 -0.0532600712
## 91 2022-05-10 ARE -0.0245710522 -0.0245710522
## 92 2022-05-02 ARKK NA NA
## 93 2022-05-03 ARKK -0.0051865549 -0.0051865549
## 94 2022-05-04 ARKK 0.0513334881 0.0513334881
## 95 2022-05-05 ARKK -0.0892618730 -0.0892618730
## 96 2022-05-06 ARKK -0.0443978848 -0.0443978848
## 97 2022-05-09 ARKK -0.0986193272 -0.0986193272
## 98 2022-05-10 ARKK -0.0012156333 -0.0012156333
## 99 2022-05-02 ASTS NA NA
## 100 2022-05-03 ASTS 0.0690954774 0.0690954774
## 101 2022-05-04 ASTS 0.0481786134 0.0481786134
## 102 2022-05-05 ASTS -0.0504484305 -0.0504484305
## 103 2022-05-06 ASTS 0.0330578512 0.0330578512
## 104 2022-05-09 ASTS -0.1280000000 -0.1280000000
## 105 2022-05-10 ASTS -0.0878112713 -0.0878112713
## 106 2022-05-02 B NA NA
## 107 2022-05-03 B 0.0047961329 0.0047961329
## 108 2022-05-04 B 0.0301312351 0.0301312351
## 109 2022-05-05 B -0.0341732127 -0.0341732127
## 110 2022-05-06 B -0.0185906458 -0.0185906458
## 111 2022-05-09 B 0.0067216926 0.0067216926
## 112 2022-05-10 B -0.0215477687 -0.0215477687
## 113 2022-05-02 BA NA NA
## 114 2022-05-03 BA 0.0334432472 0.0334432472
## 115 2022-05-04 BA 0.0220731798 0.0220731798
## 116 2022-05-05 BA -0.0414091862 -0.0414091862
## 117 2022-05-06 BA -0.0104340200 -0.0104340200
## 118 2022-05-09 BA -0.1047011191 -0.1047011191
## 119 2022-05-10 BA -0.0027004801 -0.0027004801
## 120 2022-05-02 BAC NA NA
## 121 2022-05-03 BAC 0.0273935259 0.0273935259
## 122 2022-05-04 BAC 0.0401292206 0.0401292206
## 123 2022-05-05 BAC -0.0279647340 -0.0279647340
## 124 2022-05-06 BAC -0.0023974427 -0.0023974427
## 125 2022-05-09 BAC -0.0288385039 -0.0288385039
## 126 2022-05-10 BAC -0.0167720928 -0.0167720928
## 127 2022-05-02 BB NA NA
## 128 2022-05-03 BB 0.0034129693 0.0034129693
## 129 2022-05-04 BB 0.0408163265 0.0408163265
## 130 2022-05-05 BB -0.0490196078 -0.0490196078
## 131 2022-05-06 BB -0.0360824742 -0.0360824742
## 132 2022-05-09 BB -0.0837789661 -0.0837789661
## 133 2022-05-10 BB 0.0097276265 0.0097276265
## 134 2022-05-02 BBBY NA NA
## 135 2022-05-03 BBBY 0.0233236152 0.0233236152
## 136 2022-05-04 BBBY 0.0128205128 0.0128205128
## 137 2022-05-05 BBBY -0.1026722925 -0.1026722925
## 138 2022-05-06 BBBY -0.0540752351 -0.0540752351
## 139 2022-05-09 BBBY -0.0911350456 -0.0911350456
## 140 2022-05-10 BBBY -0.0783956244 -0.0783956244
## 141 2022-05-02 BE NA NA
## 142 2022-05-03 BE 0.0101279851 0.0101279851
## 143 2022-05-04 BE 0.0712399962 0.0712399962
## 144 2022-05-05 BE -0.0655172446 -0.0655172446
## 145 2022-05-06 BE -0.2024248393 -0.2024248393
## 146 2022-05-09 BE -0.1017845340 -0.1017845340
## 147 2022-05-10 BE -0.0220750552 -0.0220750552
## 148 2022-05-02 BG NA NA
## 149 2022-05-03 BG 0.0132766316 0.0132766316
## 150 2022-05-04 BG 0.0163569671 0.0163569671
## 151 2022-05-05 BG -0.0325244355 -0.0325244355
## 152 2022-05-06 BG 0.0035708326 0.0035708326
## 153 2022-05-09 BG -0.0642193943 -0.0642193943
## 154 2022-05-10 BG 0.0231846421 0.0231846421
## 155 2022-05-02 BOOM NA NA
## 156 2022-05-03 BOOM 0.0338461538 0.0338461538
## 157 2022-05-04 BOOM 0.1135913194 0.1135913194
## 158 2022-05-05 BOOM -0.0512250311 -0.0512250311
## 159 2022-05-06 BOOM 0.1929578025 0.1929578025
## 160 2022-05-09 BOOM -0.0791027155 -0.0791027155
## 161 2022-05-10 BOOM -0.0611111538 -0.0611111538
## 162 2022-05-02 BP NA NA
## 163 2022-05-03 BP 0.0803880342 0.0803880430
## 164 2022-05-04 BP 0.0214881994 0.0214881334
## 165 2022-05-05 BP -0.0197802783 -0.0197802512
## 166 2022-05-06 BP 0.0204997256 0.0204997444
## 167 2022-05-09 BP -0.0684243611 -0.0684243858
## 168 2022-05-10 BP 0.0070754133 0.0070754380
## 169 2022-05-02 BY NA NA
## 170 2022-05-03 BY 0.0158052432 0.0158052542
## 171 2022-05-04 BY 0.0218669965 0.0218670302
## 172 2022-05-05 BY -0.0209875476 -0.0209875729
## 173 2022-05-06 BY -0.0054852740 -0.0092476247
## 174 2022-05-09 BY -0.0004243106 -0.0004243106
## 175 2022-05-10 BY -0.0140067493 -0.0140067493
## 176 2022-05-02 C NA NA
## 177 2022-05-03 C 0.0285362149 0.0285362149
## 178 2022-05-04 C 0.0425150117 0.0425150117
## 179 2022-05-05 C -0.0176143787 -0.0176143787
## 180 2022-05-06 C 0.0060416682 0.0060416682
## 181 2022-05-09 C -0.0335141425 -0.0335141425
## 182 2022-05-10 C -0.0228502510 -0.0228502510
## 183 2022-05-02 CAR NA NA
## 184 2022-05-03 CAR 0.0168234995 0.0168234995
## 185 2022-05-04 CAR 0.0207865677 0.0207865677
## 186 2022-05-05 CAR -0.0601283594 -0.0601283594
## 187 2022-05-06 CAR -0.0651808923 -0.0651808923
## 188 2022-05-09 CAR -0.1117799026 -0.1117799026
## 189 2022-05-10 CAR -0.0012320646 -0.0012320646
## 190 2022-05-02 CASH NA NA
## 191 2022-05-03 CASH -0.0085371251 -0.0085371251
## 192 2022-05-04 CASH 0.0267628106 0.0267628106
## 193 2022-05-05 CASH -0.0444242757 -0.0444242757
## 194 2022-05-06 CASH -0.0263282970 -0.0263282970
## 195 2022-05-09 CASH -0.0375152506 -0.0375152506
## 196 2022-05-10 CASH -0.0207542152 -0.0207542152
## 197 2022-05-02 CC NA NA
## 198 2022-05-03 CC 0.1755287846 0.1755287719
## 199 2022-05-04 CC 0.0668208779 0.0668208173
## 200 2022-05-05 CC -0.0390267980 -0.0390267183
## 201 2022-05-06 CC 0.0042618658 0.0042617700
## 202 2022-05-09 CC -0.0287070312 -0.0287069638
## 203 2022-05-10 CC -0.0336674792 -0.0336674891
## 204 2022-05-02 CCJ NA NA
## 205 2022-05-03 CCJ 0.0117877795 0.0117877795
## 206 2022-05-04 CCJ 0.0244659806 0.0244659806
## 207 2022-05-05 CCJ -0.0720242256 -0.0720242256
## 208 2022-05-06 CCJ -0.0261437908 -0.0261437908
## 209 2022-05-09 CCJ -0.1182885906 -0.1182885906
## 210 2022-05-10 CCJ 0.0237868696 0.0237868696
## 211 2022-05-02 CDC NA NA
## 212 2022-05-03 CDC 0.0089285848 0.0089285136
## 213 2022-05-04 CDC 0.0258350600 0.0258350707
## 214 2022-05-05 CDC -0.0180882694 -0.0180882558
## 215 2022-05-06 CDC 0.0025506513 0.0025506589
## 216 2022-05-09 CDC -0.0083391638 -0.0083391661
## 217 2022-05-10 CDC -0.0101581631 -0.0111175450
## 218 2022-05-02 CI NA NA
## 219 2022-05-03 CI 0.0047945715 0.0047945715
## 220 2022-05-04 CI 0.0338873599 0.0338873599
## 221 2022-05-05 CI -0.0140415224 -0.0140415224
## 222 2022-05-06 CI 0.0587908278 0.0587908278
## 223 2022-05-09 CI -0.0205694647 -0.0205694647
## 224 2022-05-10 CI -0.0029073486 -0.0029073486
## 225 2022-05-02 CLNE NA NA
## 226 2022-05-03 CLNE 0.0395869191 0.0395869191
## 227 2022-05-04 CLNE 0.0397350993 0.0397350993
## 228 2022-05-05 CLNE -0.0541401274 -0.0541401274
## 229 2022-05-06 CLNE -0.1363636364 -0.1363636364
## 230 2022-05-09 CLNE -0.1754385965 -0.1754385965
## 231 2022-05-10 CLNE -0.0023640662 -0.0023640662
## 232 2022-05-02 CLOV NA NA
## 233 2022-05-03 CLOV -0.0141843972 -0.0141843972
## 234 2022-05-04 CLOV 0.0539568345 0.0539568345
## 235 2022-05-05 CLOV -0.0341296928 -0.0341296928
## 236 2022-05-06 CLOV -0.0494699647 -0.0494699647
## 237 2022-05-09 CLOV -0.1040892193 -0.1040892193
## 238 2022-05-10 CLOV -0.0165975104 -0.0165975104
## 239 2022-05-02 CMBS NA NA
## 240 2022-05-03 CMBS 0.0004137389 0.0004137389
## 241 2022-05-04 CMBS 0.0045501967 0.0045501967
## 242 2022-05-05 CMBS -0.0049412806 -0.0049412806
## 243 2022-05-06 CMBS 0.0002068694 0.0002068694
## 244 2022-05-09 CMBS 0.0047579644 0.0047579644
## 245 2022-05-10 CMBS -0.0039118592 -0.0039118592
## 246 2022-05-02 CMS NA NA
## 247 2022-05-03 CMS -0.0045723968 -0.0045723449
## 248 2022-05-04 CMS 0.0200029783 0.0200029344
## 249 2022-05-05 CMS -0.0131616560 -0.0197558553
## 250 2022-05-06 CMS 0.0040011409 0.0040011409
## 251 2022-05-09 CMS 0.0211070111 0.0211070111
## 252 2022-05-10 CMS -0.0130095548 -0.0130095548
## 253 2022-05-02 CNC NA NA
## 254 2022-05-03 CNC 0.0161902104 0.0161902104
## 255 2022-05-04 CNC 0.0319891477 0.0319891477
## 256 2022-05-05 CNC 0.0230369787 0.0230369787
## 257 2022-05-06 CNC -0.0093138529 -0.0093138529
## 258 2022-05-09 CNC -0.0575984417 -0.0575984417
## 259 2022-05-10 CNC 0.0097234118 0.0097234118
## 260 2022-05-02 COIN NA NA
## 261 2022-05-03 COIN 0.0182957151 0.0182957151
## 262 2022-05-04 COIN 0.0533343809 0.0533343809
## 263 2022-05-05 COIN -0.1221666902 -0.1221666902
## 264 2022-05-06 COIN -0.0919912648 -0.0919912648
## 265 2022-05-09 COIN -0.1950067128 -0.1950067128
## 266 2022-05-10 COIN -0.1259729823 -0.1259729823
## 267 2022-05-02 COP NA NA
## 268 2022-05-03 COP 0.0313803384 0.0313803384
## 269 2022-05-04 COP 0.0498332255 0.0498332255
## 270 2022-05-05 COP -0.0096283458 -0.0096283458
## 271 2022-05-06 COP 0.0469570382 0.0469570382
## 272 2022-05-09 COP -0.0974092748 -0.0974092748
## 273 2022-05-10 COP 0.0082304838 0.0082304838
## 274 2022-05-02 CPI NA NA
## 275 2022-05-03 CPI 0.0014976039 0.0014976039
## 276 2022-05-04 CPI 0.0130841121 0.0130841121
## 277 2022-05-05 CPI -0.0140221771 -0.0140221771
## 278 2022-05-06 CPI -0.0011226797 -0.0011226797
## 279 2022-05-09 CPI -0.0168602841 -0.0168602841
## 280 2022-05-10 CPI -0.0026676829 -0.0026676829
## 281 2022-05-02 CVNA NA NA
## 282 2022-05-03 CVNA -0.0519265578 -0.0519265578
## 283 2022-05-04 CVNA 0.0404674676 0.0404674676
## 284 2022-05-05 CVNA -0.1798827098 -0.1798827098
## 285 2022-05-06 CVNA -0.0498773119 -0.0498773119
## 286 2022-05-09 CVNA -0.1658777969 -0.1658777969
## 287 2022-05-10 CVNA -0.0539076606 -0.0539076606
## 288 2022-05-02 CWH NA NA
## 289 2022-05-03 CWH 0.0620792820 0.0620792820
## 290 2022-05-04 CWH 0.0739436620 0.0739436620
## 291 2022-05-05 CWH -0.0636065902 -0.0636065902
## 292 2022-05-06 CWH 0.0290616257 0.0290616257
## 293 2022-05-09 CWH -0.0139502897 -0.0139502897
## 294 2022-05-10 CWH -0.0424430642 -0.0424430642
## 295 2022-05-02 D NA NA
## 296 2022-05-03 D 0.0022208512 0.0022208512
## 297 2022-05-04 D 0.0157577121 0.0157577121
## 298 2022-05-05 D 0.0064234515 0.0064234515
## 299 2022-05-06 D 0.0118014931 0.0118014931
## 300 2022-05-09 D -0.0029754821 -0.0029754821
## 301 2022-05-10 D -0.0216067574 -0.0216067574
## 302 2022-05-02 DC NA NA
## 303 2022-05-03 DC -0.0074074074 -0.0074074074
## 304 2022-05-04 DC 0.0074626866 0.0074626866
## 305 2022-05-05 DC -0.0197530864 -0.0197530864
## 306 2022-05-06 DC -0.0050377834 -0.0050377834
## 307 2022-05-09 DC -0.0430379747 -0.0430379747
## 308 2022-05-10 DC -0.0952380952 -0.0952380952
## 309 2022-05-02 DCF NA NA
## 310 2022-05-03 DCF 0.0000000000 0.0000000000
## 311 2022-05-04 DCF 0.0012048162 0.0012048193
## 312 2022-05-05 DCF 0.0024066117 0.0024067389
## 313 2022-05-06 DCF -0.0156062048 -0.0156062425
## 314 2022-05-09 DCF -0.0282208589 -0.0341463415
## 315 2022-05-10 DCF -0.0113636364 -0.0113636364
## 316 2022-05-02 DD NA NA
## 317 2022-05-03 DD 0.0072836872 0.0072836872
## 318 2022-05-04 DD 0.0361555003 0.0361555003
## 319 2022-05-05 DD -0.0383832515 -0.0383832515
## 320 2022-05-06 DD -0.0108860147 -0.0108860147
## 321 2022-05-09 DD -0.0166615108 -0.0166615108
## 322 2022-05-10 DD -0.0157003260 -0.0157003260
## 323 2022-05-02 DEF NA NA
## 324 2022-05-03 DEF 0.0057957942 0.0057957942
## 325 2022-05-04 DEF 0.0240838948 0.0240838948
## 326 2022-05-05 DEF -0.0256817061 -0.0256817061
## 327 2022-05-06 DEF -0.0038501704 -0.0038501704
## 328 2022-05-09 DEF -0.0188791000 -0.0188791000
## 329 2022-05-10 DEF -0.0056061061 -0.0056061061
## 330 2022-05-02 DHI NA NA
## 331 2022-05-03 DHI 0.0135669551 0.0135669725
## 332 2022-05-04 DHI 0.0536809360 0.0536809669
## 333 2022-05-05 DHI -0.0584887974 -0.0584887918
## 334 2022-05-06 DHI -0.0127600418 -0.0158820094
## 335 2022-05-09 DHI -0.0012853043 -0.0012853043
## 336 2022-05-10 DHI -0.0245960389 -0.0245960389
## 337 2022-05-02 DIDI NA NA
## 338 2022-05-03 DIDI 0.0100502513 0.0100502513
## 339 2022-05-04 DIDI 0.0049751244 0.0049751244
## 340 2022-05-05 DIDI -0.0396039604 -0.0396039604
## 341 2022-05-06 DIDI -0.1030927835 -0.1030927835
## 342 2022-05-09 DIDI -0.1034482759 -0.1034482759
## 343 2022-05-10 DIDI 0.0064102564 0.0064102564
## 344 2022-05-02 DKNG NA NA
## 345 2022-05-03 DKNG 0.0060040027 0.0060040027
## 346 2022-05-04 DKNG 0.0431034483 0.0431034483
## 347 2022-05-05 DKNG -0.0820089002 -0.0820089002
## 348 2022-05-06 DKNG -0.0893351801 -0.0893351801
## 349 2022-05-09 DKNG -0.1642585551 -0.1642585551
## 350 2022-05-10 DKNG 0.0336669700 0.0336669700
## 351 2022-05-02 DM NA NA
## 352 2022-05-03 DM -0.0330578512 -0.0330578512
## 353 2022-05-04 DM 0.1509971510 0.1509971510
## 354 2022-05-05 DM 0.0024752475 0.0024752475
## 355 2022-05-06 DM -0.0148148148 -0.0148148148
## 356 2022-05-09 DM -0.1428571429 -0.1428571429
## 357 2022-05-10 DM -0.6111111111 -0.6111111111
## 358 2022-05-02 DMA NA NA
## 359 2022-05-03 DMA 0.0060459492 0.0060459492
## 360 2022-05-04 DMA -0.0108173077 -0.0108173077
## 361 2022-05-05 DMA 0.0000000000 0.0000000000
## 362 2022-05-06 DMA -0.0024301337 -0.0024301337
## 363 2022-05-09 DMA -0.0024360536 -0.0024360536
## 364 2022-05-10 DMA 0.0061050061 0.0061050061
## 365 2022-05-02 DNA NA NA
## 366 2022-05-03 DNA 0.0287539936 0.0287539936
## 367 2022-05-04 DNA 0.0217391304 0.0217391304
## 368 2022-05-05 DNA -0.1094224924 -0.1094224924
## 369 2022-05-06 DNA -0.0750853242 -0.0750853242
## 370 2022-05-09 DNA -0.1217712177 -0.1217712177
## 371 2022-05-10 DNA 0.0126050420 0.0126050420
## 372 2022-05-02 DO NA NA
## 373 2022-05-03 DO 0.0593792173 0.0593792173
## 374 2022-05-04 DO 0.0178343949 0.0178343949
## 375 2022-05-05 DO -0.0125156446 -0.0125156446
## 376 2022-05-06 DO -0.0126742712 -0.0126742712
## 377 2022-05-09 DO -0.0949935815 -0.0949935815
## 378 2022-05-10 DO -0.0510638298 -0.0510638298
## 379 2022-05-02 DOW NA NA
## 380 2022-05-03 DOW 0.0162541609 0.0162541609
## 381 2022-05-04 DOW 0.0360968295 0.0360968295
## 382 2022-05-05 DOW -0.0303073215 -0.0303073215
## 383 2022-05-06 DOW -0.0078866802 -0.0078866802
## 384 2022-05-09 DOW -0.0191373914 -0.0191373914
## 385 2022-05-10 DOW -0.0123067543 -0.0123067543
## 386 2022-05-02 E NA NA
## 387 2022-05-03 E 0.0203353186 0.0203353186
## 388 2022-05-04 E 0.0216782867 0.0216782867
## 389 2022-05-05 E -0.0249828551 -0.0249828551
## 390 2022-05-06 E 0.0171990172 0.0171990172
## 391 2022-05-09 E -0.0514147688 -0.0514147688
## 392 2022-05-10 E 0.0210985813 0.0210985813
## 393 2022-05-02 EDIT NA NA
## 394 2022-05-03 EDIT -0.0063069376 -0.0063069376
## 395 2022-05-04 EDIT 0.1149506347 0.1149506347
## 396 2022-05-05 EDIT -0.0790638836 -0.0790638836
## 397 2022-05-06 EDIT -0.0618131868 -0.0618131868
## 398 2022-05-09 EDIT -0.1866764275 -0.1866764275
## 399 2022-05-10 EDIT 0.0135013501 0.0135013501
## 400 2022-05-02 ENPH NA NA
## 401 2022-05-03 ENPH 0.0368323943 0.0368323943
## 402 2022-05-04 ENPH 0.0997536418 0.0997536418
## 403 2022-05-05 ENPH -0.0562675987 -0.0562675987
## 404 2022-05-06 ENPH -0.0841890255 -0.0841890255
## 405 2022-05-09 ENPH -0.0927120628 -0.0927120628
## 406 2022-05-10 ENPH 0.0075742412 0.0075742412
## 407 2022-05-02 EOD NA NA
## 408 2022-05-03 EOD 0.0080645161 0.0080645161
## 409 2022-05-04 EOD 0.0240000000 0.0240000000
## 410 2022-05-05 EOD -0.0332031250 -0.0332031250
## 411 2022-05-06 EOD 0.0020202020 0.0020202020
## 412 2022-05-09 EOD -0.0302419355 -0.0302419355
## 413 2022-05-10 EOD 0.0020790021 0.0020790021
## 414 2022-05-02 EPS NA NA
## 415 2022-05-03 EPS 0.0058270284 0.0058270284
## 416 2022-05-04 EPS 0.0303030519 0.0303030519
## 417 2022-05-05 EPS -0.0330882987 -0.0330882987
## 418 2022-05-06 EPS -0.0044732947 -0.0044732947
## 419 2022-05-09 EPS -0.0267355213 -0.0267355213
## 420 2022-05-10 EPS 0.0006924746 0.0006924746
## 421 2022-05-02 ESG NA NA
## 422 2022-05-03 ESG 0.0041104922 0.0041104922
## 423 2022-05-04 ESG 0.0304382364 0.0304382364
## 424 2022-05-05 ESG -0.0391954064 -0.0391954064
## 425 2022-05-06 ESG -0.0028269132 -0.0028269132
## 426 2022-05-09 ESG -0.0363902632 -0.0363902632
## 427 2022-05-10 ESG 0.0018216997 0.0018216997
## 428 2022-05-02 ET NA NA
## 429 2022-05-03 ET 0.0407801553 0.0407801418
## 430 2022-05-04 ET 0.0289608985 0.0289608177
## 431 2022-05-05 ET -0.0165562917 -0.0165562914
## 432 2022-05-06 ET -0.0042808219 -0.0210437710
## 433 2022-05-09 ET -0.0687876182 -0.0687876182
## 434 2022-05-10 ET -0.0129270545 -0.0129270545
## 435 2022-05-02 ETN NA NA
## 436 2022-05-03 ETN 0.0005460009 0.0005460887
## 437 2022-05-04 ETN 0.0228544470 0.0228543523
## 438 2022-05-05 ETN -0.0103381061 -0.0103380783
## 439 2022-05-06 ETN -0.0073460721 -0.0073460841
## 440 2022-05-09 ETN 0.0045488912 0.0045489445
## 441 2022-05-10 ETN -0.0471749185 -0.0471749843
## 442 2022-05-02 ETSY NA NA
## 443 2022-05-03 ETSY 0.0356443700 0.0356443700
## 444 2022-05-04 ETSY 0.0875360896 0.0875360896
## 445 2022-05-05 ETSY -0.1682978292 -0.1682978292
## 446 2022-05-06 ETSY -0.0500385241 -0.0500385241
## 447 2022-05-09 ETSY 0.0002315930 0.0002315930
## 448 2022-05-10 ETSY -0.0270833790 -0.0270833790
## 449 2022-05-02 EVER NA NA
## 450 2022-05-03 EVER -0.1772665765 -0.1772665765
## 451 2022-05-04 EVER 0.0797697368 0.0797697368
## 452 2022-05-05 EVER -0.0456968774 -0.0456968774
## 453 2022-05-06 EVER -0.0111731844 -0.0111731844
## 454 2022-05-09 EVER -0.0718321227 -0.0718321227
## 455 2022-05-10 EVER -0.0991304348 -0.0991304348
## 456 2022-05-02 EXPE NA NA
## 457 2022-05-03 EXPE -0.1401521668 -0.1401521668
## 458 2022-05-04 EXPE -0.0049896880 -0.0049896880
## 459 2022-05-05 EXPE -0.0672639619 -0.0672639619
## 460 2022-05-06 EXPE -0.0513978351 -0.0513978351
## 461 2022-05-09 EXPE -0.0343081760 -0.0343081760
## 462 2022-05-10 EXPE 0.0356052505 0.0356052505
## 463 2022-05-02 F NA NA
## 464 2022-05-03 F 0.0203223546 0.0203223546
## 465 2022-05-04 F 0.0288461538 0.0288461538
## 466 2022-05-05 F -0.0300400534 -0.0300400534
## 467 2022-05-06 F -0.0220233999 -0.0220233999
## 468 2022-05-09 F -0.0591133005 -0.0591133005
## 469 2022-05-10 F -0.0014958863 -0.0014958863
## 470 2022-05-02 FL NA NA
## 471 2022-05-03 FL -0.0033590863 -0.0033590863
## 472 2022-05-04 FL 0.0364004044 0.0364004044
## 473 2022-05-05 FL -0.0360975935 -0.0360975935
## 474 2022-05-06 FL -0.0050606952 -0.0050606952
## 475 2022-05-09 FL -0.0389962699 -0.0389962699
## 476 2022-05-10 FL -0.0250529640 -0.0250529640
## 477 2022-05-02 FOMO NA NA
## 478 2022-05-03 FOMO 0.0029128678 0.0029128678
## 479 2022-05-04 FOMO 0.0091719745 0.0091719745
## 480 2022-05-05 FOMO -0.0096944711 -0.0096944711
## 481 2022-05-06 FOMO -0.0001529598 -0.0001529598
## 482 2022-05-09 FOMO -0.0123916363 -0.0123916363
## 483 2022-05-10 FOMO -0.0026849795 -0.0026849795
## 484 2022-05-02 FOR NA NA
## 485 2022-05-03 FOR 0.0066992083 0.0066992083
## 486 2022-05-04 FOR 0.0084693885 0.0084693885
## 487 2022-05-05 FOR -0.0473905219 -0.0473905219
## 488 2022-05-06 FOR -0.0302267003 -0.0302267003
## 489 2022-05-09 FOR -0.0155844156 -0.0155844156
## 490 2022-05-10 FOR -0.0237467018 -0.0237467018
## 491 2022-05-02 FREE NA NA
## 492 2022-05-03 FREE 0.0142247511 0.0142247511
## 493 2022-05-04 FREE -0.0336605891 -0.0336605891
## 494 2022-05-05 FREE -0.0362844702 -0.0362844702
## 495 2022-05-06 FREE -0.0466867470 -0.0466867470
## 496 2022-05-09 FREE -0.0110584518 -0.0110584518
## 497 2022-05-10 FREE 0.0351437700 0.0351437700
## 498 2022-05-02 GET NA NA
## 499 2022-05-03 GET 0.0671641791 0.0671641791
## 500 2022-05-04 GET 0.0559440559 0.0559440559
## 501 2022-05-05 GET -0.0463576159 -0.0463576159
## 502 2022-05-06 GET -0.0486111111 -0.0486111111
## 503 2022-05-09 GET -0.0291970803 -0.0291970803
## 504 2022-05-10 GET 0.0075187970 0.0075187970
## 505 2022-05-02 GME NA NA
## 506 2022-05-03 GME 0.0071924396 0.0071924396
## 507 2022-05-04 GME 0.0552188159 0.0552188159
## 508 2022-05-05 GME -0.0625590563 -0.0625590563
## 509 2022-05-06 GME -0.0371862680 -0.0371862680
## 510 2022-05-09 GME -0.1387096462 -0.1387096462
## 511 2022-05-10 GME -0.0535479395 -0.0535479395
## 512 2022-05-02 GO NA NA
## 513 2022-05-03 GO 0.0162112574 0.0162112574
## 514 2022-05-04 GO 0.0088627479 0.0088627479
## 515 2022-05-05 GO -0.0494876399 -0.0494876399
## 516 2022-05-06 GO -0.0095501235 -0.0095501235
## 517 2022-05-09 GO 0.0031103575 0.0031103575
## 518 2022-05-10 GO -0.0365891473 -0.0365891473
## 519 2022-05-02 GOOD NA NA
## 520 2022-05-03 GOOD 0.0120540019 0.0120540019
## 521 2022-05-04 GOOD 0.0181039066 0.0181039066
## 522 2022-05-05 GOOD -0.0411792681 -0.0411792681
## 523 2022-05-06 GOOD -0.0024401659 -0.0024401659
## 524 2022-05-09 GOOD -0.0621331183 -0.0621331183
## 525 2022-05-10 GOOD -0.0198225874 -0.0198225874
## 526 2022-05-02 H NA NA
## 527 2022-05-03 H -0.0509284138 -0.0509284138
## 528 2022-05-04 H 0.0086082060 0.0086082060
## 529 2022-05-05 H -0.0415650627 -0.0415650627
## 530 2022-05-06 H -0.0112177748 -0.0112177748
## 531 2022-05-09 H -0.0667836140 -0.0667836140
## 532 2022-05-10 H 0.0632910758 0.0632910758
## 533 2022-05-02 HHS NA NA
## 534 2022-05-03 HHS 0.0063131313 0.0063131313
## 535 2022-05-04 HHS 0.0138017566 0.0138017566
## 536 2022-05-05 HHS -0.0049504950 -0.0049504950
## 537 2022-05-06 HHS -0.0074626866 -0.0074626866
## 538 2022-05-09 HHS -0.0288220551 -0.0288220551
## 539 2022-05-10 HHS -0.0064516129 -0.0064516129
## 540 2022-05-02 HIMX NA NA
## 541 2022-05-03 HIMX 0.0053879310 0.0053879310
## 542 2022-05-04 HIMX 0.0192926045 0.0192926045
## 543 2022-05-05 HIMX -0.0315457413 -0.0315457413
## 544 2022-05-06 HIMX -0.0466883822 -0.0466883822
## 545 2022-05-09 HIMX -0.0671981777 -0.0671981777
## 546 2022-05-10 HIMX 0.0231990232 0.0231990232
## 547 2022-05-02 HOLD NA NA
## 548 2022-05-03 HOLD 0.0001023956 0.0001023956
## 549 2022-05-04 HOLD -0.0002047702 -0.0002047702
## 550 2022-05-05 HOLD 0.0004095526 0.0004095526
## 551 2022-05-06 HOLD -0.0002046566 -0.0002046566
## 552 2022-05-09 HOLD 0.0003070836 0.0003070836
## 553 2022-05-10 HOLD -0.0005116967 -0.0005116967
## 554 2022-05-02 HUT NA NA
## 555 2022-05-03 HUT 0.0000000000 0.0000000000
## 556 2022-05-04 HUT 0.0837837838 0.0837837838
## 557 2022-05-05 HUT -0.0947630923 -0.0947630923
## 558 2022-05-06 HUT -0.0606060606 -0.0606060606
## 559 2022-05-09 HUT -0.1700879765 -0.1700879765
## 560 2022-05-10 HUT -0.0106007067 -0.0106007067
## 561 2022-05-02 HYG NA NA
## 562 2022-05-03 HYG 0.0052409048 0.0052409048
## 563 2022-05-04 HYG 0.0101729783 0.0101729783
## 564 2022-05-05 HYG -0.0177492820 -0.0177492820
## 565 2022-05-06 HYG -0.0056388954 -0.0056388954
## 566 2022-05-09 HYG -0.0105683599 -0.0105683599
## 567 2022-05-10 HYG 0.0057314318 0.0057314318
## 568 2022-05-02 IBB NA NA
## 569 2022-05-03 IBB 0.0091247127 0.0091247127
## 570 2022-05-04 IBB 0.0202612103 0.0202612103
## 571 2022-05-05 IBB -0.0369276216 -0.0369276216
## 572 2022-05-06 IBB -0.0357021384 -0.0357021384
## 573 2022-05-09 IBB -0.0520455872 -0.0520455872
## 574 2022-05-10 IBB 0.0266592098 0.0266592098
## 575 2022-05-02 IG NA NA
## 576 2022-05-03 IG 0.0053623648 0.0053623648
## 577 2022-05-04 IG 0.0090230691 0.0090230691
## 578 2022-05-05 IG -0.0151094665 -0.0151094665
## 579 2022-05-06 IG -0.0061723321 -0.0061723321
## 580 2022-05-09 IG 0.0020702971 0.0020702971
## 581 2022-05-10 IG 0.0035030538 0.0035030538
## 582 2022-05-02 IMO NA NA
## 583 2022-05-03 IMO 0.0469520822 0.0469520822
## 584 2022-05-04 IMO 0.0011306011 0.0011306011
## 585 2022-05-05 IMO -0.0116695462 -0.0116695462
## 586 2022-05-06 IMO 0.0047609981 0.0047609981
## 587 2022-05-09 IMO -0.0756254388 -0.0756254388
## 588 2022-05-10 IMO -0.0098420956 -0.0098420956
## 589 2022-05-02 IP NA NA
## 590 2022-05-03 IP 0.0058002364 0.0058002364
## 591 2022-05-04 IP 0.0356685604 0.0356685604
## 592 2022-05-05 IP -0.0078366877 -0.0078366877
## 593 2022-05-06 IP 0.0010392642 0.0010392642
## 594 2022-05-09 IP -0.0072674211 -0.0072674211
## 595 2022-05-10 IP 0.0008365823 0.0008365823
## 596 2022-05-02 IPO NA NA
## 597 2022-05-03 IPO -0.0132085581 -0.0132085581
## 598 2022-05-04 IPO 0.0206357217 0.0206357217
## 599 2022-05-05 IPO -0.0759562337 -0.0759562337
## 600 2022-05-06 IPO -0.0523359255 -0.0523359255
## 601 2022-05-09 IPO -0.0967238096 -0.0967238096
## 602 2022-05-10 IPO -0.0055267701 -0.0055267701
## 603 2022-05-02 IS NA NA
## 604 2022-05-03 IS -0.0221674877 -0.0221674877
## 605 2022-05-04 IS 0.0453400504 0.0453400504
## 606 2022-05-05 IS -0.0819277108 -0.0819277108
## 607 2022-05-06 IS -0.0183727034 -0.0183727034
## 608 2022-05-09 IS -0.0240641711 -0.0240641711
## 609 2022-05-10 IS -0.0849315068 -0.0849315068
## 610 2022-05-02 IT NA NA
## 611 2022-05-03 IT -0.0307199135 -0.0307199135
## 612 2022-05-04 IT -0.0038060932 -0.0038060932
## 613 2022-05-05 IT -0.0732343432 -0.0732343432
## 614 2022-05-06 IT -0.0259679842 -0.0259679842
## 615 2022-05-09 IT -0.0533601958 -0.0533601958
## 616 2022-05-10 IT 0.0279541526 0.0279541526
## 617 2022-05-02 IWM NA NA
## 618 2022-05-03 IWM 0.0085612179 0.0085612179
## 619 2022-05-04 IWM 0.0266857598 0.0266857598
## 620 2022-05-05 IWM -0.0405643129 -0.0405643129
## 621 2022-05-06 IWM -0.0166424088 -0.0166424088
## 622 2022-05-09 IWM -0.0420637962 -0.0420637962
## 623 2022-05-10 IWM 0.0002858948 0.0002858948
## 624 2022-05-02 IYH NA NA
## 625 2022-05-03 IYH 0.0029097937 0.0029097937
## 626 2022-05-04 IYH 0.0207499093 0.0207499093
## 627 2022-05-05 IYH -0.0209758112 -0.0209758112
## 628 2022-05-06 IYH -0.0057329649 -0.0057329649
## 629 2022-05-09 IYH -0.0286822375 -0.0286822375
## 630 2022-05-10 IYH 0.0039574488 0.0039574488
## 631 2022-05-02 J NA NA
## 632 2022-05-03 J 0.0055137117 0.0055137117
## 633 2022-05-04 J 0.0276333826 0.0276333826
## 634 2022-05-05 J -0.0341219282 -0.0341219282
## 635 2022-05-06 J 0.0017445009 0.0017445009
## 636 2022-05-09 J -0.0547855969 -0.0547855969
## 637 2022-05-10 J -0.0007676263 -0.0007676263
## 638 2022-05-02 JD NA NA
## 639 2022-05-03 JD -0.0189364213 -0.0189364213
## 640 2022-05-04 JD 0.0162458104 0.0162458104
## 641 2022-05-05 JD -0.0599873536 -0.0599873536
## 642 2022-05-06 JD -0.0636470460 -0.0636470460
## 643 2022-05-09 JD -0.0821794626 -0.0821794626
## 644 2022-05-10 JD 0.0119514300 0.0119514300
## 645 2022-05-02 JNJ NA NA
## 646 2022-05-03 JNJ -0.0019592812 -0.0019592812
## 647 2022-05-04 JNJ 0.0107129064 0.0107129064
## 648 2022-05-05 JNJ -0.0190899115 -0.0190899115
## 649 2022-05-06 JNJ -0.0022063816 -0.0022063816
## 650 2022-05-09 JNJ 0.0054431424 0.0054431424
## 651 2022-05-10 JNJ -0.0013534427 -0.0013534427
## 652 2022-05-02 KEY NA NA
## 653 2022-05-03 KEY 0.0123266570 0.0123266570
## 654 2022-05-04 KEY 0.0289194332 0.0289194332
## 655 2022-05-05 KEY -0.0246548311 -0.0246548311
## 656 2022-05-06 KEY -0.0121334675 -0.0121334675
## 657 2022-05-09 KEY -0.0184237964 -0.0184237964
## 658 2022-05-10 KEY -0.0135557873 -0.0135557873
## 659 2022-05-02 L NA NA
## 660 2022-05-03 L 0.0198148611 0.0198148611
## 661 2022-05-04 L 0.0328077236 0.0328077236
## 662 2022-05-05 L -0.0168080190 -0.0168080190
## 663 2022-05-06 L 0.0106650568 0.0106650568
## 664 2022-05-09 L -0.0211049031 -0.0211049031
## 665 2022-05-10 L -0.0055485414 -0.0055485414
## 666 2022-05-02 MA NA NA
## 667 2022-05-03 MA -0.0034815062 -0.0034815062
## 668 2022-05-04 MA 0.0299896021 0.0299896021
## 669 2022-05-05 MA -0.0411103724 -0.0411103724
## 670 2022-05-06 MA -0.0176868441 -0.0176868441
## 671 2022-05-09 MA -0.0551106398 -0.0551106398
## 672 2022-05-10 MA -0.0081100127 -0.0081100127
## 673 2022-05-02 NVAX NA NA
## 674 2022-05-03 NVAX 0.0956278884 0.0956278884
## 675 2022-05-04 NVAX 0.0652063350 0.0652063350
## 676 2022-05-05 NVAX -0.0648812370 -0.0648812370
## 677 2022-05-06 NVAX -0.0231844698 -0.0231844698
## 678 2022-05-09 NVAX -0.0705061269 -0.0705061269
## 679 2022-05-10 NVAX 0.0112655468 0.0112655468
## 680 2022-05-02 ROC NA NA
## 681 2022-05-03 ROC 0.0000000000 0.0000000000
## 682 2022-05-04 ROC 0.0000000000 0.0000000000
## 683 2022-05-05 ROC 0.0010050251 0.0010050251
## 684 2022-05-06 ROC 0.0000000000 0.0000000000
## 685 2022-05-09 ROC -0.0010040161 -0.0010040161
## 686 2022-05-10 ROC 0.0010050251 0.0010050251
## 687 2022-05-02 SHOP NA NA
## 688 2022-05-03 SHOP 0.0269769100 0.0269769100
## 689 2022-05-04 SHOP 0.0436156008 0.0436156008
## 690 2022-05-05 SHOP -0.1491276761 -0.1491276761
## 691 2022-05-06 SHOP -0.0861797825 -0.0861797825
## 692 2022-05-09 SHOP -0.0992078783 -0.0992078783
## 693 2022-05-10 SHOP -0.0136748438 -0.0136748438priceData <- l.out$df.tickers Here we have the sentiment data and the price data as raw dataframes we can poke and prod!
priceDatasentimentHolderAt this point we’re going to merge the sentiment with the pricing data.
We will also create a summary to ensure we didn’t create any data integrity issues!
mergedData <- merge(priceData, sentimentHolder, all.x = TRUE)
mergedData$`mean(sentiment)`[is.na(mergedData$`mean(sentiment)`)] <- 0
mergedData$sentiment <- mergedData$`mean(sentiment)`
summary(comparedf(mergedData, priceData, by = "ticker"))##
##
## Table: Summary of data.frames
##
## version arg ncol nrow
## -------- ----------- ----- -----
## x mergedData 12 693
## y priceData 10 693
##
##
##
## Table: Summary of overall comparison
##
## statistic value
## ------------------------------------------------------------ ------
## Number of by-variables 1
## Number of non-by variables in common 9
## Number of variables compared 9
## Number of variables in x but not y 2
## Number of variables in y but not x 0
## Number of variables compared with some values unequal 9
## Number of variables compared with all values equal 0
## Number of observations in common 4851
## Number of observations in x but not y 0
## Number of observations in y but not x 0
## Number of observations with some compared variables unequal 693
## Number of observations with all compared variables equal 4158
## Number of values unequal 37202
##
##
##
## Table: Variables not shared
##
## version variable position class
## -------- ---------------- --------- --------
## x mean(sentiment) 11 numeric
## x sentiment 12 numeric
##
##
##
## Table: Other variables not compared
##
##
## --------------------------------
## No other variables not compared
## --------------------------------
##
##
##
## Table: Observations not shared
##
##
## ---------------------------
## No observations not shared
## ---------------------------
##
##
##
## Table: Differences detected by variable
##
## var.x var.y n NAs
## -------------------- -------------------- ----- -----
## ref.date ref.date 4158 0
## price.open price.open 4124 0
## price.high price.high 4136 0
## price.low price.low 4120 0
## price.close price.close 4118 0
## volume volume 4128 0
## price.adjusted price.adjusted 4118 0
## ret.adjusted.prices ret.adjusted.prices 4150 1188
## ret.closing.prices ret.closing.prices 4150 1188
##
##
##
## Table: Differences detected (37152 not shown)
##
## var.x var.y ticker values.x values.y row.x row.y
## ------------ ------------ ------- ----------- ----------- ------ ------
## ref.date ref.date A 2022-05-02 2022-05-03 1 2
## ref.date ref.date A 2022-05-02 2022-05-04 1 3
## ref.date ref.date A 2022-05-02 2022-05-05 1 4
## ref.date ref.date A 2022-05-02 2022-05-06 1 5
## ref.date ref.date A 2022-05-02 2022-05-09 1 6
## ref.date ref.date A 2022-05-02 2022-05-10 1 7
## ref.date ref.date A 2022-05-05 2022-05-02 298 1
## ref.date ref.date A 2022-05-05 2022-05-03 298 2
## ref.date ref.date A 2022-05-05 2022-05-04 298 3
## ref.date ref.date A 2022-05-05 2022-05-06 298 5
## price.open price.open A 118.38 119.72 1 2
## price.open price.open A 118.38 121.69 1 3
## price.open price.open A 118.38 124.62 1 4
## price.open price.open A 118.38 120.88 1 5
## price.open price.open A 118.38 119.13 1 6
## price.open price.open A 118.38 115.44 1 7
## price.open price.open A 124.62 118.38 298 1
## price.open price.open A 124.62 119.72 298 2
## price.open price.open A 124.62 121.69 298 3
## price.open price.open A 124.62 120.88 298 5
## price.high price.high A 120.34 123.98 1 2
## price.high price.high A 120.34 126.69 1 3
## price.high price.high A 120.34 125.21 1 4
## price.high price.high A 120.34 121.88 1 5
## price.high price.high A 120.34 119.13 1 6
## price.high price.high A 120.34 117.94 1 7
## price.high price.high A 125.21 120.34 298 1
## price.high price.high A 125.21 123.98 298 2
## price.high price.high A 125.21 126.69 298 3
## price.high price.high A 125.21 121.88 298 5
## price.low price.low A 116.49 119.09 1 2
## price.low price.low A 116.49 121.44 1 3
## price.low price.low A 116.49 120.8 1 4
## price.low price.low A 116.49 118 1 5
## price.low price.low A 116.49 112.64 1 6
## price.low price.low A 116.49 113.14 1 7
## price.low price.low A 120.8 116.49 298 1
## price.low price.low A 120.8 119.09 298 2
## price.low price.low A 120.8 121.44 298 3
## price.low price.low A 120.8 118 298 5
## price.close price.close A 119.57 122.4 1 2
## price.close price.close A 119.57 126.3 1 3
## price.close price.close A 119.57 122.15 1 4
## price.close price.close A 119.57 121.08 1 5
## price.close price.close A 119.57 113.11 1 6
## price.close price.close A 119.57 116.64 1 7
## price.close price.close A 122.15 119.57 298 1
## price.close price.close A 122.15 122.4 298 2
## price.close price.close A 122.15 126.3 298 3
## price.close price.close A 122.15 121.08 298 5
##
##
##
## Table: Non-identical attributes
##
##
## ----------------------------
## No non-identical attributes
## ----------------------------mergedDataWhats life like without some fun plots!
First things first, lets make a basic chart and then create a subplot of it and itself just to ensure I can figure out how to make subplots!
dateSentiment <- mergedData[c("ref.date","ticker", "sentiment")]
t <- ggplot(dateSentiment[dateSentiment$sentiment != 0,]) + aes(x=ref.date, y=sentiment, color = ticker) + geom_boxplot() + stat_summary(fun = "median",
geom = "point",
color = "Orange") +
stat_summary(fun = "mean",
geom = "point",
colour = "red")
plot1 <- ggplotly(t)
fig <- subplot(plot1, plot1, nrows = 2, shareX = TRUE) %>% layout(hovermode = "x unified")
figAt this point, we have a lot of pricing data, along with ticker symbol and sentiment, so let’s combine a subset onto one workspace!
We can easily use price high and low for one chart, along with the asociated sentiment!
We can also make this shiny deployable with a higher degree of flexibility in terms of job post count!
datePrice <- mergedData[c("ref.date","ticker", "price.open", "price.close")]
plot2 <- ggplotly(ggplot(datePrice, aes(x = ref.date, y = price.open, colour = ticker)) +
geom_line(show.legend=FALSE)) %>% layout(title = 'Sentiment')
plot3 <- ggplotly(ggplot(datePrice, aes(x = ref.date, y = price.close, colour = ticker), show.legend = FALSE) +
geom_line(show.legend = FALSE))%>% layout(title = 'Sentiment2')
fig <- subplot(plot1, plot2, plot3, nrows = 3, shareX = TRUE) %>% layout(hovermode = "x unified")
figFirst things first, there are a billion pages of R documentation that made this totally possible:
https://shiny.rstudio.com/tutorial/ https://shiny.rstudio.com/reference/shiny/1.0.4/downloadButton.html https://cran.r-project.org/web/packages/quanteda/quanteda.pdf https://cran.r-project.org/web/packages/SnowballC/index.html https://cran.r-project.org/web/packages/BatchGetSymbols/index.html https://cran.r-project.org/web/packages/sentimentr/sentimentr.pdf https://cran.r-project.org/web/packages/arsenal/index.html https://cran.r-project.org/web/packages/tm/vignettes/tm.pdf https://cran.r-project.org/web/packages/lubridate/index.html
Not to mention Yahoo for the financial data
Please also check out the shiny app included in this!