PREVIEW / stock_daily / 2014-11-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-11.parquet
  size:    221 KB
  rows:    6,611
  symbols: 3,538

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-11	AAPL	Stock	27.175	27.4375	27.1	27.425	109769200.0
2014-11-11	MSFT	Stock	48.85	48.95	48.65	48.87	23445200.0
2014-11-11	NVDA	Stock	0.4975	0.5003	0.4902	0.4945	212992000.0
2014-11-11	AMZN	Stock	15.297	15.619	15.1825	15.6005	76072000.0
2014-11-11	GOOGL	Stock	27.926	28.125	27.8121	28.0645	22003580.0
2014-11-11	META	Stock	74.95	74.98	74.03	74.61	18715700.0
2014-11-11	TSLA	Stock	16.17	16.788	16.1333	16.7387	119232000.0
2014-11-11	TLT	Stock	118.48	118.81	118.34	118.73	2416470.0
2014-11-11	ES	Stock	50.64	50.92	50.35	50.54	1296600.0
2014-11-11	CL	Stock	68.51	68.7	68.3	68.47	1510000.0
2014-11-11	A	Stock	41.52	42.11	41.34	41.66	2163800.0
2014-11-11	AA.B-DELISTED	Stock	50.98	51.53	50.86	51.41	16421.0
2014-11-11	AABA-DELISTED	Stock	48.57	49.18	48.095	49.06	29509416.0
2014-11-11	AAC-DELISTED	Stock	26.78	27.0	24.2	24.94	171050.0
2014-11-11	AACG	Stock	3.96	3.97	3.8	3.87	12400.0
2014-11-11	AAIC-DELISTED	Stock	27.41	27.51	27.21	27.34	204065.0
2014-11-11	AAL	Stock	44.0	44.47	43.32	43.44	11048700.0
2014-11-11	AAMC-DELISTED	Stock	157.4559	171.3	151.4226	171.3	48946.0
2014-11-11	AAME	Stock	3.77	3.88	3.58	3.88	3400.0
2014-11-11	AAMI	Stock	15.35	16.01	15.12	15.37	393600.0
2014-11-11	AAOI	Stock	13.0	13.93	11.51	11.74	3403100.0
2014-11-11	AAON	Stock	13.8667	14.1467	13.7467	14.0867	172500.0
2014-11-11	AAP	Stock	145.0	145.39	144.23	144.98	524800.0
2014-11-11	AAT	Stock	38.75	39.01	38.59	38.96	221100.0
2014-11-11	AAU-DELISTED	Stock	1.09	1.123	1.0615	1.12	100321.0
2014-11-11	AAUAF-DELISTED	Stock	1.08	1.12	1.0501	1.12	103096.0
2014-11-11	AAV-DELISTED	Stock	4.61	4.78	4.51	4.68	166043.0
2014-11-11	AAVL-DELISTED	Stock	34.48	35.25	33.02	33.03	46925.0
2014-11-11	AAWW-DELISTED	Stock	42.08	42.08	41.05	41.61	159090.0
2014-11-11	AAXJ	Stock	62.21	62.48	62.17	62.33	1408634.0
2014-11-11	AAXN-DELISTED	Stock	19.05	19.95	19.02	19.5	3206856.0
2014-11-11	AB	Stock	26.25	26.51	26.01	26.4	138400.0
2014-11-11	ABAC-DELISTED	Stock	2.24	2.3	2.1801	2.25	17075.0
2014-11-11	ABAX-DELISTED	Stock	52.91	53.98	52.2	53.5	166739.0
2014-11-11	ABB-DELISTED	Stock	22.26	22.4166	22.23	22.4	952325.0
2014-11-11	ABBNY-DELISTED	Stock	22.26	22.4166	22.23	22.4	1001142.0
2014-11-11	ABBV	Stock	63.69	64.2	63.5	63.85	5041200.0
2014-11-11	ABC-DELISTED	Stock	87.71	88.44	87.64	87.92	998791.0
2014-11-11	ABCB	Stock	25.74	26.22	25.66	26.08	166200.0
2014-11-11	ABCD-DELISTED	Stock	1.7	1.94	1.7	1.85	38452.0
2014-11-11	ABCO-DELISTED	Stock	47.44	47.51	46.25	47.23	325731.0
2014-11-11	ABCW-DELISTED	Stock	31.06	31.06	30.8	30.95	2439.0
2014-11-11	ABDC-DELISTED	Stock	13.36	13.36	12.8061	12.82	92572.0
2014-11-11	ABE-DELISTED	Stock	13.86	13.89	13.7779	13.89	2868.0
2014-11-11	ABEO	Stock	201.25	201.25	175.0	176.5	144.0
2014-11-11	ABEV	Stock	6.24	6.28	6.18	6.28	8647200.0
2014-11-11	ABG	Stock	73.42	74.73	73.37	73.87	227100.0
2014-11-11	ABGB-DELISTED	Stock	18.07	18.21	17.8601	18.21	18700.0
2014-11-11	ABM	Stock	27.26	27.39	27.14	27.32	141100.0
2014-11-11	ABMD-DELISTED	Stock	33.0	33.18	32.76	33.11	257702.0

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

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