PREVIEW / stock_daily / 2014-11-20

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-20.parquet
  size:    222 KB
  rows:    6,647
  symbols: 3,565

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-11-20	AAPL	Stock	28.7275	29.215	28.7125	29.0775	173582000.0
2014-11-20	MSFT	Stock	48.0	48.7	47.87	48.7	21510600.0
2014-11-20	NVDA	Stock	0.4968	0.509	0.4952	0.5085	220968000.0
2014-11-20	AMZN	Stock	16.2	16.6335	16.1665	16.527	68734000.0
2014-11-20	GOOGL	Stock	27.1045	27.269	27.075	27.188	35015160.0
2014-11-20	META	Stock	72.8	73.99	72.51	73.6	19154900.0
2014-11-20	TSLA	Stock	16.53	16.7287	16.4	16.5807	53808000.0
2014-11-20	TLT	Stock	119.9	119.95	119.06	119.38	5683570.0
2014-11-20	ES	Stock	49.88	50.13	49.69	49.96	1306300.0
2014-11-20	CL	Stock	68.11	68.4	67.91	68.06	1654400.0
2014-11-20	A	Stock	40.56	41.43	40.56	41.26	2303800.0
2014-11-20	AA.B-DELISTED	Stock	51.57	53.1	51.57	52.99	145755.0
2014-11-20	AABA-DELISTED	Stock	50.6	52.23	50.27	51.24	26588306.0
2014-11-20	AAC-DELISTED	Stock	29.23	29.6	26.9178	27.0	96509.0
2014-11-20	AACG	Stock	3.88	3.88	3.85	3.85	400.0
2014-11-20	AAIC-DELISTED	Stock	27.39	27.6	27.35	27.6	102603.0
2014-11-20	AAL	Stock	43.65	44.72	43.2	44.16	9431400.0
2014-11-20	AAMC-DELISTED	Stock	138.1559	144.8941	138.1559	141.1765	11176.0
2014-11-20	AAME	Stock	3.82	3.86	3.72	3.86	3700.0
2014-11-20	AAMI	Stock	15.34	15.8	15.11	15.35	122600.0
2014-11-20	AAOI	Stock	12.25	12.65	12.03	12.61	390400.0
2014-11-20	AAON	Stock	13.2867	13.6667	13.16	13.6333	216750.0
2014-11-20	AAP	Stock	144.21	146.25	144.08	145.19	485000.0
2014-11-20	AAT	Stock	38.54	38.66	38.27	38.63	53300.0
2014-11-20	AAU-DELISTED	Stock	1.1	1.1304	1.0698	1.09	102290.0
2014-11-20	AAUAF-DELISTED	Stock	1.1	1.12	1.06	1.09	103749.0
2014-11-20	AAV-DELISTED	Stock	4.84	5.03	4.81	4.98	224325.0
2014-11-20	AAVL-DELISTED	Stock	32.55	34.042	32.02	33.58	73103.0
2014-11-20	AAWW-DELISTED	Stock	42.0	43.4837	41.45	43.23	173528.0
2014-11-20	AAXJ	Stock	61.61	61.8	61.58	61.69	232688.0
2014-11-20	AAXN-DELISTED	Stock	19.93	20.94	19.76	20.57	2855780.0
2014-11-20	AB	Stock	25.95	26.48	25.62	26.4	197800.0
2014-11-20	ABAC-DELISTED	Stock	2.2799	2.28	2.22	2.2699	18230.0
2014-11-20	ABAX-DELISTED	Stock	53.76	53.78	52.47	53.24	145515.0
2014-11-20	ABB-DELISTED	Stock	22.52	22.63	22.49	22.6	946719.0
2014-11-20	ABBNY-DELISTED	Stock	22.52	22.63	22.49	22.59	1153117.0
2014-11-20	ABBV	Stock	65.04	65.68	64.93	65.19	4975500.0
2014-11-20	ABC-DELISTED	Stock	89.19	89.305	88.34	88.9	1260999.0
2014-11-20	ABCB	Stock	25.2	25.5	25.14	25.34	109300.0
2014-11-20	ABCD-DELISTED	Stock	1.84	1.87	1.79	1.79	500.0
2014-11-20	ABCO-DELISTED	Stock	41.64	41.64	40.76	41.33	499240.0
2014-11-20	ABCW-DELISTED	Stock	29.718	30.75	29.676	30.7	2600.0
2014-11-20	ABDC-DELISTED	Stock	12.46	12.74	12.46	12.65	37819.0
2014-11-20	ABE-DELISTED	Stock	13.86	13.88	13.78	13.88	3246.0
2014-11-20	ABEO	Stock	181.25	187.5	181.25	187.5	16.0
2014-11-20	ABEV	Stock	6.45	6.6	6.31	6.37	12242000.0
2014-11-20	ABG	Stock	73.49	74.3	73.2	73.86	227800.0
2014-11-20	ABGB-DELISTED	Stock	14.18	14.66	14.0	14.23	346276.0
2014-11-20	ABM	Stock	26.67	26.82	26.54	26.76	204200.0
2014-11-20	ABMD-DELISTED	Stock	34.34	35.13	34.09	35.06	606334.0

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

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