PREVIEW / stock_daily / 2016-01-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-22.parquet
  size:    219 KB
  rows:    6,649
  symbols: 3,388

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2016-01-22	AAPL	Stock	24.6575	25.365	24.5925	25.355	263202000.0
2016-01-22	MSFT	Stock	51.41	52.33	51.26	52.29	37555800.0
2016-01-22	NVDA	Stock	0.7083	0.716	0.7068	0.7113	257996000.0
2016-01-22	AMZN	Stock	29.4365	30.005	29.2055	29.819	102402000.0
2016-01-22	GOOGL	Stock	37.1	37.428	37.025	37.273	47146300.0
2016-01-22	META	Stock	96.41	98.07	95.49	97.94	30495400.0
2016-01-22	TSLA	Stock	13.6533	13.7	13.2687	13.5033	46861500.0
2016-01-22	TLT	Stock	124.91	125.53	124.52	125.34	10164328.0
2016-01-22	ES	Stock	50.63	51.63	50.16	51.58	1836500.0
2016-01-22	CL	Stock	64.33	64.91	63.87	64.61	4360100.0
2016-01-22	A	Stock	37.91	38.18	37.58	37.98	1834500.0
2016-01-22	AA.B-DELISTED	Stock	25.78	25.78	24.6	25.18	79854.0
2016-01-22	AAAP-DELISTED	Stock	27.04	27.89	26.28	27.89	25542.0
2016-01-22	AABA-DELISTED	Stock	29.97	30.52	29.31	29.75	15561903.0
2016-01-22	AAC-DELISTED	Stock	16.94	17.155	16.51	16.7	102243.0
2016-01-22	AACG	Stock	5.35	5.55	5.09	5.47	28700.0
2016-01-22	AAIC-DELISTED	Stock	10.44	10.87	10.34	10.62	218710.0
2016-01-22	AAL	Stock	40.0	40.72	39.57	40.16	7247000.0
2016-01-22	AAMC-DELISTED	Stock	4.6882	5.5412	4.5941	5.1118	341493.0
2016-01-22	AAME	Stock	4.22	4.28	4.09	4.28	1400.0
2016-01-22	AAMI	Stock	11.36	11.55	11.29	11.38	257600.0
2016-01-22	AAOI	Stock	13.25	14.283	13.08	13.89	334200.0
2016-01-22	AAON	Stock	13.6733	13.98	13.3333	13.8533	244650.0
2016-01-22	AAP	Stock	144.94	145.85	142.59	144.43	990400.0
2016-01-22	AAT	Stock	36.66	37.27	36.4	37.21	133100.0
2016-01-22	AAU-DELISTED	Stock	0.5606	0.57	0.5419	0.5485	41273.0
2016-01-22	AAUAF-DELISTED	Stock	0.5606	0.57	0.5419	0.5485	42098.0
2016-01-22	AAV-DELISTED	Stock	5.3	5.44	5.19	5.23	263966.0
2016-01-22	AAVL-DELISTED	Stock	6.38	6.62	6.17	6.42	269297.0
2016-01-22	AAWW-DELISTED	Stock	36.92	37.215	35.405	36.07	334162.0
2016-01-22	AAXJ	Stock	48.56	48.67	48.27	48.61	1215718.0
2016-01-22	AAXN-DELISTED	Stock	16.06	16.206	15.28	15.43	1156941.0
2016-01-22	AB	Stock	18.92	19.79	18.72	19.75	218300.0
2016-01-22	ABAC-DELISTED	Stock	0.67	0.67	0.6106	0.6501	4200.0
2016-01-22	ABAX-DELISTED	Stock	52.99	53.78	52.15	53.6099	94135.0
2016-01-22	ABB-DELISTED	Stock	16.62	16.69	16.35	16.54	2054390.0
2016-01-22	ABBNY-DELISTED	Stock	16.62	16.69	16.35	16.54	2119228.0
2016-01-22	ABBV	Stock	59.1	59.43	57.82	58.83	10383800.0
2016-01-22	ABC-DELISTED	Stock	91.89	92.08	90.84	91.0	1773741.0
2016-01-22	ABCB	Stock	28.29	29.65	26.68	27.61	977800.0
2016-01-22	ABCD-DELISTED	Stock	4.3	4.61	4.11	4.56	81165.0
2016-01-22	ABCO-DELISTED	Stock	44.36	45.4199	44.19	44.54	317031.0
2016-01-22	ABCW-DELISTED	Stock	41.9	41.9	41.5	41.56	91945.0
2016-01-22	ABDC-DELISTED	Stock	9.91	11.08	9.48	10.97	37345.0
2016-01-22	ABE-DELISTED	Stock	9.88	10.16	9.88	10.11	6260.0
2016-01-22	ABEO	Stock	72.75	76.0	69.0	71.0	1716.0
2016-01-22	ABEV	Stock	3.98	4.11	3.95	4.11	24032600.0
2016-01-22	ABG	Stock	48.27	49.09	47.59	47.97	347200.0
2016-01-22	ABGB-DELISTED	Stock	0.911	0.93	0.852	0.87	58217.0
2016-01-22	ABIL-DELISTED	Stock	9.12	9.12	9.04	9.09	45561.0

> showing 50 of 6,649 rows — these rows as CSV

> unlock the full archive -- $79 one-time