PREVIEW / stock_daily / 2013-10-31

all stock daily files

  file:    by_date/stock_daily/2013/2013-10-31.parquet
  size:    216 KB
  rows:    6,435
  symbols: 3,548

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
2013-10-31	AAPL	Stock	18.75	18.8389	18.6168	18.6679	275696400.0
2013-10-31	MSFT	Stock	35.66	35.69	35.34	35.41	41682300.0
2013-10-31	NVDA	Stock	0.381	0.3838	0.379	0.3798	293368000.0
2013-10-31	AMZN	Stock	18.0865	18.3	17.95	18.2015	49336000.0
2013-10-31	META	Stock	47.16	52.0	46.5	50.21	248809000.0
2013-10-31	TSLA	Stock	10.378	10.8293	10.22	10.6627	140007000.0
2013-10-31	TLT	Stock	107.91	108.01	107.1401	107.64	11452117.0
2013-10-31	ES	Stock	43.13	43.28	42.42	42.89	1278700.0
2013-10-31	CL	Stock	65.0	65.23	64.67	64.73	3944900.0
2013-10-31	A	Stock	36.588	36.7167	36.0873	36.309	2649909.0
2013-10-31	AABA-DELISTED	Stock	32.43	33.12	32.28	32.94	14936638.0
2013-10-31	AACG	Stock	4.11	4.21	4.1	4.15	11200.0
2013-10-31	AAIC-DELISTED	Stock	24.85	24.91	24.5	24.67	147724.0
2013-10-31	AAMC-DELISTED	Stock	183.7941	188.1412	183.7941	188.1412	36853.0
2013-10-31	AAME	Stock	4.03	4.05	4.03	4.05	2500.0
2013-10-31	AAMRQ-DELISTED	Stock	7.385	7.48	7.17	7.35	8296748.0
2013-10-31	AAOI	Stock	12.65	13.02	12.55	12.68	89300.0
2013-10-31	AAON	Stock	12.0756	12.32	11.9956	12.0044	203850.0
2013-10-31	AAP	Stock	100.0	101.0	99.18	99.18	981500.0
2013-10-31	AAT	Stock	33.68	33.88	33.25	33.29	184100.0
2013-10-31	AAU-DELISTED	Stock	1.37	1.4	1.34	1.36	104202.0
2013-10-31	AAUAF-DELISTED	Stock	1.37	1.4	1.34	1.36	104302.0
2013-10-31	AAV-DELISTED	Stock	3.95	4.1	3.95	4.09	278157.0
2013-10-31	AAWW-DELISTED	Stock	41.44	41.52	36.97	36.98	2768979.0
2013-10-31	AAXJ	Stock	60.81	60.88	60.21	60.21	369936.0
2013-10-31	AAXN-DELISTED	Stock	18.0	18.52	17.6001	17.77	2834738.0
2013-10-31	AB	Stock	21.83	22.42	21.7	22.22	381400.0
2013-10-31	ABAC-DELISTED	Stock	1.49	1.4901	1.3	1.41	123351.0
2013-10-31	ABAX-DELISTED	Stock	35.46	36.13	35.46	35.73	118246.0
2013-10-31	ABB-DELISTED	Stock	25.59	25.64	25.47	25.47	1228310.0
2013-10-31	ABBNY-DELISTED	Stock	25.59	25.64	25.47	25.47	1280699.0
2013-10-31	ABBV	Stock	48.68	49.0	48.44	48.45	4563700.0
2013-10-31	ABC-DELISTED	Stock	65.05	65.98	64.62	65.35	1800483.0
2013-10-31	ABCB	Stock	18.81	18.81	18.29	18.3	68900.0
2013-10-31	ABCD-DELISTED	Stock	1.38	1.46	1.29	1.46	44263.0
2013-10-31	ABCO-DELISTED	Stock	68.83	69.68	68.41	68.59	144704.0
2013-10-31	ABE-DELISTED	Stock	20.48	20.5	20.28	20.4699	3893.0
2013-10-31	ABEO	Stock	400.0	400.0	375.0	400.0	31.0
2013-10-31	ABFS-DELISTED	Stock	28.25	28.4	25.43	27.37	878364.0
2013-10-31	ABG	Stock	47.54	48.48	47.04	48.05	272600.0
2013-10-31	ABGB-DELISTED	Stock	12.17	12.24	11.94	12.12	14409.0
2013-10-31	ABM	Stock	27.45	27.9	27.38	27.51	252100.0
2013-10-31	ABMD-DELISTED	Stock	21.63	24.13	21.446	23.97	1209623.0
2013-10-31	ABR	Stock	6.5	6.69	6.42	6.65	273100.0
2013-10-31	ABR.A-DELISTED	Stock	24.92	25.18	24.92	25.18	4150.0
2013-10-31	ABR.B-DELISTED	Stock	23.4975	23.5	23.4	23.5	2800.0
2013-10-31	ABT	Stock	37.01	37.14	36.55	36.55	8172100.0
2013-10-31	ABTL-DELISTED	Stock	8.11	8.28	7.9	8.15	75447.0
2013-10-31	ABUS	Stock	8.87	9.17	8.45	8.95	249400.0
2013-10-31	ABV-DELISTED	Stock	37.85	38.21	37.01	37.21	5301865.0

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

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