PREVIEW / stock_daily / 2014-10-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-21.parquet
  size:    221 KB
  rows:    6,620
  symbols: 3,557

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
2014-10-21	AAPL	Stock	25.755	25.755	25.3175	25.6175	378495600.0
2014-10-21	MSFT	Stock	44.36	44.98	44.19	44.88	36433800.0
2014-10-21	NVDA	Stock	0.4425	0.4585	0.4412	0.458	351092000.0
2014-10-21	AMZN	Stock	15.495	15.782	15.3535	15.7665	71186000.0
2014-10-21	GOOGL	Stock	26.8635	26.9385	26.51	26.9015	49202800.0
2014-10-21	META	Stock	77.56	78.74	77.15	78.69	32252000.0
2014-10-21	TSLA	Stock	15.618	15.6927	15.3867	15.6893	61954500.0
2014-10-21	TLT	Stock	120.84	121.24	120.53	120.54	9758010.0
2014-10-21	ES	Stock	48.11	48.11	47.54	47.81	3714500.0
2014-10-21	CL	Stock	64.85	65.57	64.31	65.42	3013100.0
2014-10-21	A	Stock	37.8112	38.6481	37.8112	38.6266	3120196.0
2014-10-21	AA.B-DELISTED	Stock	49.75	51.181	49.75	50.97	166348.0
2014-10-21	AABA-DELISTED	Stock	39.63	40.48	39.455	40.17	39719976.0
2014-10-21	AAC-DELISTED	Stock	19.08	19.5	19.0	19.26	89361.0
2014-10-21	AACG	Stock	4.23	4.32	4.2	4.23	4400.0
2014-10-21	AAIC-DELISTED	Stock	26.4	26.7	26.39	26.7	334757.0
2014-10-21	AAL	Stock	36.14	37.88	36.02	37.85	26347700.0
2014-10-21	AAMC-DELISTED	Stock	205.4265	205.5882	176.4706	186.7647	187663.0
2014-10-21	AAME	Stock	3.94	3.94	3.82	3.94	3200.0
2014-10-21	AAMI	Stock	14.32	14.75	14.25	14.68	400500.0
2014-10-21	AAOI	Stock	15.1	15.46	14.72	14.91	193900.0
2014-10-21	AAON	Stock	12.1067	12.38	11.7733	12.3467	341550.0
2014-10-21	AAP	Stock	140.85	142.08	140.33	141.02	908300.0
2014-10-21	AAT	Stock	35.89	35.99	35.6	35.95	79800.0
2014-10-21	AAU-DELISTED	Stock	1.335	1.38	1.325	1.35	89225.0
2014-10-21	AAUAF-DELISTED	Stock	1.33	1.35	1.309	1.35	92732.0
2014-10-21	AAV-DELISTED	Stock	4.56	4.69	4.52	4.61	145801.0
2014-10-21	AAVL-DELISTED	Stock	30.33	32.88	30.33	32.66	93908.0
2014-10-21	AAWW-DELISTED	Stock	33.25	34.648	33.07	34.48	131840.0
2014-10-21	AAXJ	Stock	61.05	61.5	60.9	61.34	567556.0
2014-10-21	AAXN-DELISTED	Stock	14.83	15.23	14.61	15.06	1059770.0
2014-10-21	AB	Stock	25.36	26.31	25.33	26.02	394600.0
2014-10-21	ABAC-DELISTED	Stock	2.25	2.3	2.0	2.2	183669.0
2014-10-21	ABAX-DELISTED	Stock	48.74	49.64	48.09	49.36	166493.0
2014-10-21	ABB-DELISTED	Stock	20.79	20.98	20.76	20.97	1823822.0
2014-10-21	ABBNY-DELISTED	Stock	20.79	20.98	20.76	20.97	1915512.0
2014-10-21	ABBV	Stock	55.3	56.45	55.02	56.29	17522100.0
2014-10-21	ABC-DELISTED	Stock	76.2	76.86	76.02	76.63	2855659.0
2014-10-21	ABCB	Stock	24.0	24.25	23.58	24.2	117800.0
2014-10-21	ABCD-DELISTED	Stock	1.47	1.47	1.46	1.46	994.0
2014-10-21	ABCO-DELISTED	Stock	49.68	50.17	49.15	49.68	310804.0
2014-10-21	ABDC-DELISTED	Stock	12.35	12.45	12.06	12.34	29625.0
2014-10-21	ABE-DELISTED	Stock	13.77	13.84	13.5603	13.67	10143.0
2014-10-21	ABEO	Stock	250.0	275.0	237.5	275.0	6.0
2014-10-21	ABEV	Stock	6.25	6.48	6.21	6.32	20473000.0
2014-10-21	ABG	Stock	67.12	67.35	62.79	64.92	889700.0
2014-10-21	ABGB-DELISTED	Stock	21.6	22.46	21.5908	21.86	24030.0
2014-10-21	ABM	Stock	26.14	26.47	26.0	26.25	174800.0
2014-10-21	ABMD-DELISTED	Stock	23.69	24.03	23.34	23.97	132860.0
2014-10-21	ABR	Stock	6.61	6.62	6.55	6.56	65300.0

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

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