PREVIEW / stock_daily / 2014-01-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-17.parquet
  size:    218 KB
  rows:    6,461
  symbols: 3,537

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-01-17	AAPL	Stock	19.6957	19.7168	19.2821	19.3096	426739600.0
2014-01-17	MSFT	Stock	36.83	36.83	36.15	36.38	46267500.0
2014-01-17	NVDA	Stock	0.4015	0.4062	0.3973	0.3998	340400000.0
2014-01-17	AMZN	Stock	19.713	20.1745	19.683	19.9805	90102000.0
2014-01-17	META	Stock	57.3	57.82	56.07	56.3	40849200.0
2014-01-17	TSLA	Stock	11.346	11.5467	11.1967	11.334	138093000.0
2014-01-17	TLT	Stock	104.86	105.52	104.79	105.48	7590772.0
2014-01-17	ES	Stock	42.35	42.61	42.18	42.59	1928400.0
2014-01-17	CL	Stock	64.91	65.11	64.68	64.7	3937400.0
2014-01-17	A	Stock	43.5122	43.5122	43.1545	43.4263	2375901.0
2014-01-17	AABA-DELISTED	Stock	40.12	40.44	39.471	40.0	18454027.0
2014-01-17	AACG	Stock	3.99	3.99	3.9	3.9	11400.0
2014-01-17	AAIC-DELISTED	Stock	26.35	26.41	26.26	26.3	103835.0
2014-01-17	AAL	Stock	29.3	30.02	29.17	30.02	18276700.0
2014-01-17	AAMC-DELISTED	Stock	338.2353	350.0	330.8853	346.9941	115682.0
2014-01-17	AAME	Stock	4.02	4.04	4.0	4.02	5300.0
2014-01-17	AAOI	Stock	14.15	14.5	14.15	14.42	45000.0
2014-01-17	AAON	Stock	14.4756	14.5689	14.2933	14.4133	146025.0
2014-01-17	AAP	Stock	117.81	119.02	117.09	118.44	692400.0
2014-01-17	AAT	Stock	31.93	31.93	31.53	31.62	83400.0
2014-01-17	AAU-DELISTED	Stock	1.45	1.59	1.45	1.54	353575.0
2014-01-17	AAUAF-DELISTED	Stock	1.45	1.59	1.45	1.54	357728.0
2014-01-17	AAV-DELISTED	Stock	4.19	4.35	4.19	4.33	80889.0
2014-01-17	AAWW-DELISTED	Stock	36.0	38.08	35.25	38.035	2223550.0
2014-01-17	AAXJ	Stock	58.45	58.47	58.06	58.18	752629.0
2014-01-17	AAXN-DELISTED	Stock	17.6	17.79	17.32	17.66	832779.0
2014-01-17	AB	Stock	22.85	23.0	22.66	22.81	345500.0
2014-01-17	ABAC-DELISTED	Stock	2.03	2.12	2.01	2.06	55277.0
2014-01-17	ABAX-DELISTED	Stock	44.64	44.87	44.325	44.63	108853.0
2014-01-17	ABB-DELISTED	Stock	26.95	27.25	26.9	27.1	1428337.0
2014-01-17	ABBNY-DELISTED	Stock	26.95	27.25	26.9	27.09	1774673.0
2014-01-17	ABBV	Stock	50.64	50.66	50.01	50.06	8606800.0
2014-01-17	ABC-DELISTED	Stock	70.68	70.94	70.32	70.51	1411121.0
2014-01-17	ABCB	Stock	20.25	20.91	20.25	20.72	75500.0
2014-01-17	ABCD-DELISTED	Stock	2.08	2.1	2.03	2.03	13340.0
2014-01-17	ABCO-DELISTED	Stock	60.77	61.72	60.18	61.54	158134.0
2014-01-17	ABE-DELISTED	Stock	13.48	13.58	13.25	13.26	32651.0
2014-01-17	ABEO	Stock	337.5	387.5	337.5	387.5	4.0
2014-01-17	ABEV	Stock	7.07	7.12	7.03	7.08	5074600.0
2014-01-17	ABFS-DELISTED	Stock	34.91	35.0	34.01	34.24	229697.0
2014-01-17	ABG	Stock	49.06	49.5	48.91	49.44	277200.0
2014-01-17	ABGB-DELISTED	Stock	17.31	17.31	16.9899	16.9899	4921.0
2014-01-17	ABM	Stock	27.7	27.86	27.65	27.8	101800.0
2014-01-17	ABMD-DELISTED	Stock	27.82	28.0	27.51	27.745	1978138.0
2014-01-17	ABR	Stock	6.9	6.91	6.85	6.88	29800.0
2014-01-17	ABR.A-DELISTED	Stock	25.02	25.02	24.73	24.9	1900.0
2014-01-17	ABR.B-DELISTED	Stock	22.69	22.93	22.69	22.9146	2000.0
2014-01-17	ABT	Stock	39.86	39.86	39.21	39.4	7216400.0
2014-01-17	ABTL-DELISTED	Stock	17.79	18.47	16.5	16.76	349343.0
2014-01-17	ABUS	Stock	12.28	12.82	12.22	12.73	375700.0

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

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