PREVIEW / stock_daily / 2014-07-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-22.parquet
  size:    220 KB
  rows:    6,600
  symbols: 3,573

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-07-22	AAPL	Stock	23.67	23.7225	23.53	23.68	220788000.0
2014-07-22	MSFT	Stock	45.0	45.15	44.59	44.83	43095800.0
2014-07-22	NVDA	Stock	0.4673	0.4698	0.4608	0.4618	298816000.0
2014-07-22	AMZN	Stock	17.7625	18.1465	17.7625	18.042	57778000.0
2014-07-22	GOOGL	Stock	29.985	30.4445	29.9629	30.1785	37633300.0
2014-07-22	META	Stock	69.76	69.77	68.61	69.27	40398000.0
2014-07-22	TSLA	Stock	14.8127	14.8867	14.6073	14.6387	40950000.0
2014-07-22	TLT	Stock	115.09	115.46	114.6501	115.33	5753405.0
2014-07-22	ES	Stock	45.54	45.69	45.34	45.55	1450200.0
2014-07-22	CL	Stock	68.76	68.99	68.4	68.59	1965700.0
2014-07-22	A	Stock	40.7725	41.6094	40.7368	41.2876	3371557.0
2014-07-22	AABA-DELISTED	Stock	33.48	33.84	33.4	33.59	17351951.0
2014-07-22	AACG	Stock	4.4	4.85	4.4	4.6	17800.0
2014-07-22	AAIC-DELISTED	Stock	26.75	26.93	26.67	26.85	84753.0
2014-07-22	AAL	Stock	42.7	42.89	42.15	42.38	6456900.0
2014-07-22	AAMC-DELISTED	Stock	230.5882	232.3529	195.8118	202.5441	81280.0
2014-07-22	AAME	Stock	3.86	3.97	3.77	3.86	6100.0
2014-07-22	AAOI	Stock	22.4	23.232	22.138	22.73	204100.0
2014-07-22	AAON	Stock	14.1733	14.7	14.1533	14.5533	306150.0
2014-07-22	AAP	Stock	128.22	128.34	123.89	124.15	1547900.0
2014-07-22	AAT	Stock	35.53	35.77	35.51	35.71	73900.0
2014-07-22	AAU-DELISTED	Stock	1.43	1.4645	1.3934	1.4	134398.0
2014-07-22	AAUAF-DELISTED	Stock	1.41	1.4399	1.37	1.4	143242.0
2014-07-22	AAV-DELISTED	Stock	5.31	5.5	5.31	5.43	429544.0
2014-07-22	AAWW-DELISTED	Stock	35.84	36.49	35.77	36.09	171580.0
2014-07-22	AAXJ	Stock	64.77	64.91	64.74	64.78	800352.0
2014-07-22	AAXN-DELISTED	Stock	11.51	11.72	11.43	11.53	557036.0
2014-07-22	AB	Stock	27.85	28.18	27.5	27.5	293700.0
2014-07-22	ABAC-DELISTED	Stock	2.1	2.1	2.03	2.05	74886.0
2014-07-22	ABAX-DELISTED	Stock	42.34	42.78	41.865	42.14	150944.0
2014-07-22	ABB-DELISTED	Stock	23.17	23.51	23.14	23.43	4713921.0
2014-07-22	ABBNY-DELISTED	Stock	23.17	23.51	23.14	23.43	6845866.0
2014-07-22	ABBV	Stock	53.82	54.38	53.75	54.05	14724300.0
2014-07-22	ABC-DELISTED	Stock	73.06	73.88	73.02	73.715	1081685.0
2014-07-22	ABCB	Stock	21.11	21.56	21.07	21.19	26500.0
2014-07-22	ABCD-DELISTED	Stock	1.83	1.8799	1.8	1.84	68605.0
2014-07-22	ABCO-DELISTED	Stock	50.33	51.18	49.96	50.24	102534.0
2014-07-22	ABDC-DELISTED	Stock	13.65	13.6767	13.3501	13.49	103891.0
2014-07-22	ABE-DELISTED	Stock	14.66	14.69	14.66	14.6741	8100.0
2014-07-22	ABEO	Stock	350.0	412.5	350.0	375.0	120.0
2014-07-22	ABEV	Stock	7.5	7.53	7.43	7.48	7973700.0
2014-07-22	ABG	Stock	72.89	73.35	69.3	70.78	526300.0
2014-07-22	ABGB-DELISTED	Stock	26.73	26.73	26.54	26.54	1186.0
2014-07-22	ABIL-DELISTED	Stock	9.76	9.8	9.75	9.78	6700.0
2014-07-22	ABM	Stock	25.66	25.92	25.55	25.63	98500.0
2014-07-22	ABMD-DELISTED	Stock	25.39	26.07	25.26	25.77	180664.0
2014-07-22	ABR	Stock	7.12	7.19	7.09	7.17	175500.0
2014-07-22	ABR.A-DELISTED	Stock	24.89	24.94	24.8801	24.8801	14450.0
2014-07-22	ABR.B-DELISTED	Stock	24.5463	24.57	24.46	24.4664	1774.0
2014-07-22	ABR.C-DELISTED	Stock	25.3201	25.4	25.3201	25.4	750.0

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

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