PREVIEW / stock_daily / 2014-10-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-28.parquet
  size:    222 KB
  rows:    6,624
  symbols: 3,562

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-28	AAPL	Stock	26.35	26.685	26.3375	26.685	192243600.0
2014-10-28	MSFT	Stock	45.86	46.5	45.77	46.49	29049800.0
2014-10-28	NVDA	Stock	0.461	0.4738	0.4605	0.4732	192580000.0
2014-10-28	AMZN	Stock	14.488	14.9	14.488	14.7795	111452000.0
2014-10-28	GOOGL	Stock	27.5855	27.96	27.5215	27.947	34793320.0
2014-10-28	META	Stock	80.18	81.16	79.57	80.77	74212000.0
2014-10-28	TSLA	Stock	15.3067	16.3067	15.2167	16.1847	157744500.0
2014-10-28	TLT	Stock	119.48	119.65	119.08	119.19	5141976.0
2014-10-28	ES	Stock	48.56	48.78	48.2	48.78	1403300.0
2014-10-28	CL	Stock	66.37	66.43	65.58	65.79	2840000.0
2014-10-28	A	Stock	38.7124	39.1059	38.5408	39.0987	2394774.0
2014-10-28	AA.B-DELISTED	Stock	51.5	51.77	51.32	51.586	110137.0
2014-10-28	AABA-DELISTED	Stock	45.0	46.15	44.88	45.87	33184532.0
2014-10-28	AAC-DELISTED	Stock	21.97	22.1	21.8218	21.935	53588.0
2014-10-28	AACG	Stock	4.28	4.28	4.16	4.23	3900.0
2014-10-28	AAIC-DELISTED	Stock	27.0	27.3	26.73	27.3	372175.0
2014-10-28	AAL	Stock	40.11	40.76	39.75	40.24	12185300.0
2014-10-28	AAMC-DELISTED	Stock	166.6441	167.3559	161.7647	167.3559	20070.0
2014-10-28	AAME	Stock	3.85	3.95	3.85	3.95	1300.0
2014-10-28	AAMI	Stock	14.66	15.01	14.31	15.0	150500.0
2014-10-28	AAOI	Stock	15.2	15.58	15.145	15.34	231400.0
2014-10-28	AAON	Stock	12.3133	12.8933	12.1733	12.86	268800.0
2014-10-28	AAP	Stock	145.0	146.23	143.75	145.78	664300.0
2014-10-28	AAT	Stock	36.96	37.61	36.84	37.54	212000.0
2014-10-28	AAU-DELISTED	Stock	1.18	1.23	1.16	1.23	79592.0
2014-10-28	AAUAF-DELISTED	Stock	1.18	1.25	1.16	1.25	80501.0
2014-10-28	AAV-DELISTED	Stock	4.21	4.27	4.13	4.24	348096.0
2014-10-28	AAVL-DELISTED	Stock	33.9	33.9	33.03	33.39	62127.0
2014-10-28	AAWW-DELISTED	Stock	35.81	36.82	35.71	36.74	203334.0
2014-10-28	AAXJ	Stock	61.82	62.18	61.49	62.11	359411.0
2014-10-28	AAXN-DELISTED	Stock	15.72	16.35	15.33	16.27	1660342.0
2014-10-28	AB	Stock	26.0	26.76	25.9	26.75	246700.0
2014-10-28	ABAC-DELISTED	Stock	2.27	2.3499	2.2318	2.3499	40135.0
2014-10-28	ABAX-DELISTED	Stock	49.09	50.46	48.76	49.99	209931.0
2014-10-28	ABB-DELISTED	Stock	21.59	21.78	21.56	21.76	1172387.0
2014-10-28	ABBNY-DELISTED	Stock	21.59	21.78	21.56	21.77	1234420.0
2014-10-28	ABBV	Stock	60.76	61.13	60.44	60.93	9412500.0
2014-10-28	ABC-DELISTED	Stock	79.97	79.99	78.935	79.64	1984760.0
2014-10-28	ABCB	Stock	24.0	24.54	23.64	24.49	144600.0
2014-10-28	ABCD-DELISTED	Stock	1.4701	1.5	1.47	1.5	23434.0
2014-10-28	ABCO-DELISTED	Stock	52.23	53.73	51.82	53.42	152336.0
2014-10-28	ABCW-DELISTED	Stock	30.87	31.21	30.01	30.01	5355.0
2014-10-28	ABDC-DELISTED	Stock	12.67	12.7	12.47	12.58	23164.0
2014-10-28	ABE-DELISTED	Stock	13.81	13.97	13.81	13.97	1850.0
2014-10-28	ABEO	Stock	190.0	221.25	187.5	221.25	16.0
2014-10-28	ABEV	Stock	6.22	6.39	6.2	6.31	11541000.0
2014-10-28	ABG	Stock	66.86	69.67	66.42	69.35	515300.0
2014-10-28	ABGB-DELISTED	Stock	20.83	21.6	20.83	21.55	21407.0
2014-10-28	ABM	Stock	26.62	27.12	26.61	27.1	278300.0
2014-10-28	ABMD-DELISTED	Stock	24.73	24.94	24.4	24.93	188747.0

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

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