PREVIEW / stock_daily / 2015-01-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-27.parquet
  size:    221 KB
  rows:    6,609
  symbols: 3,507

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
2015-01-27	AAPL	Stock	28.105	28.12	27.2575	27.285	382274800.0
2015-01-27	MSFT	Stock	42.95	43.2	42.11	42.66	169164000.0
2015-01-27	NVDA	Stock	0.5075	0.508	0.4898	0.4908	357948000.0
2015-01-27	AMZN	Stock	15.315	15.512	15.1315	15.3375	58406000.0
2015-01-27	GOOGL	Stock	26.57	26.639	26.0431	26.0595	39148800.0
2015-01-27	META	Stock	76.71	76.88	75.63	75.78	20110000.0
2015-01-27	TSLA	Stock	13.628	13.8687	13.5533	13.732	41715000.0
2015-01-27	TLT	Stock	135.73	136.13	134.15	134.57	8079582.0
2015-01-27	ES	Stock	55.51	56.11	55.5	55.81	1052100.0
2015-01-27	CL	Stock	65.69	65.93	64.87	65.66	5951000.0
2015-01-27	A	Stock	38.7	39.25	38.58	38.75	1703500.0
2015-01-27	AA.B-DELISTED	Stock	51.29	51.41	50.625	51.27	38486.0
2015-01-27	AABA-DELISTED	Stock	49.14	49.28	47.66	47.985	43385642.0
2015-01-27	AAC-DELISTED	Stock	28.16	28.94	27.69	27.7	27183.0
2015-01-27	AACG	Stock	4.63	4.9	4.63	4.84	12300.0
2015-01-27	AAIC-DELISTED	Stock	26.93	27.18	26.85	27.0	131498.0
2015-01-27	AAL	Stock	53.99	54.52	52.54	52.7	19810700.0
2015-01-27	AAMC-DELISTED	Stock	67.6618	67.6618	64.7059	64.8235	37998.0
2015-01-27	AAME	Stock	3.97	3.99	3.97	3.99	700.0
2015-01-27	AAMI	Stock	15.32	15.67	15.12	15.29	136800.0
2015-01-27	AAOI	Stock	9.12	9.49	9.05	9.41	194800.0
2015-01-27	AAON	Stock	15.02	15.26	14.8267	15.22	125850.0
2015-01-27	AAP	Stock	158.09	159.53	156.87	159.03	540800.0
2015-01-27	AAT	Stock	44.49	44.67	44.41	44.52	57600.0
2015-01-27	AAU-DELISTED	Stock	1.22	1.22	1.18	1.2	194014.0
2015-01-27	AAUAF-DELISTED	Stock	1.22	1.22	1.18	1.2	195037.0
2015-01-27	AAV-DELISTED	Stock	4.09	4.345	4.06	4.28	130155.0
2015-01-27	AAVL-DELISTED	Stock	42.61	43.46	41.85	42.06	343194.0
2015-01-27	AAWW-DELISTED	Stock	46.56	47.16	45.64	46.73	125936.0
2015-01-27	AAXJ	Stock	63.53	63.72	63.33	63.55	1271411.0
2015-01-27	AAXN-DELISTED	Stock	27.47	28.03	27.38	27.69	1485528.0
2015-01-27	AB	Stock	25.67	25.96	25.62	25.8	211900.0
2015-01-27	ABAC-DELISTED	Stock	1.43	1.52	1.33	1.52	4600.0
2015-01-27	ABAX-DELISTED	Stock	59.29	60.62	58.4901	60.5	262204.0
2015-01-27	ABB-DELISTED	Stock	19.62	19.7548	19.58	19.68	1433219.0
2015-01-27	ABBNY-DELISTED	Stock	19.62	19.7548	19.58	19.68	1485928.0
2015-01-27	ABBV	Stock	62.33	63.5	62.2	63.1	6532300.0
2015-01-27	ABC-DELISTED	Stock	95.17	96.49	94.705	95.99	2509558.0
2015-01-27	ABCB	Stock	23.92	23.92	23.39	23.5	66400.0
2015-01-27	ABCD-DELISTED	Stock	2.6	2.6	2.53	2.53	13308.0
2015-01-27	ABCO-DELISTED	Stock	47.6	48.02	46.93	47.12	264646.0
2015-01-27	ABCW-DELISTED	Stock	34.41	34.41	32.5	34.17	8748.0
2015-01-27	ABDC-DELISTED	Stock	12.86	13.02	12.86	12.96	16841.0
2015-01-27	ABE-DELISTED	Stock	13.21	13.24	13.16	13.24	6977.0
2015-01-27	ABEO	Stock	79.0	81.25	77.5	80.75	800.0
2015-01-27	ABEV	Stock	6.53	6.61	6.53	6.6	11386600.0
2015-01-27	ABG	Stock	76.45	77.26	75.36	76.51	357100.0
2015-01-27	ABGB-DELISTED	Stock	15.54	15.68	15.45	15.579	54840.0
2015-01-27	ABM	Stock	29.19	29.41	29.02	29.33	146600.0
2015-01-27	ABMD-DELISTED	Stock	39.03	39.86	38.54	38.64	353965.0

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

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