PREVIEW / stock_daily / 2014-07-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-29.parquet
  size:    221 KB
  rows:    6,603
  symbols: 3,570

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-29	AAPL	Stock	24.8325	24.86	24.5625	24.595	172572000.0
2014-07-29	MSFT	Stock	43.91	44.09	43.64	43.89	27763100.0
2014-07-29	NVDA	Stock	0.4432	0.4505	0.443	0.4445	217972000.0
2014-07-29	AMZN	Stock	16.099	16.145	15.975	16.0	57676000.0
2014-07-29	GOOGL	Stock	29.885	29.9245	29.6085	29.6975	27334580.0
2014-07-29	META	Stock	74.72	74.92	73.42	73.71	41324000.0
2014-07-29	TSLA	Stock	15.1073	15.22	14.9907	15.0007	50736000.0
2014-07-29	TLT	Stock	115.87	116.07	115.42	115.93	6579517.0
2014-07-29	ES	Stock	46.1	46.21	45.66	45.67	1163800.0
2014-07-29	CL	Stock	67.07	67.32	66.26	66.36	4919000.0
2014-07-29	A	Stock	40.2647	40.3147	39.9714	40.0787	2800334.0
2014-07-29	AABA-DELISTED	Stock	35.91	36.16	35.67	35.68	10677980.0
2014-07-29	AACG	Stock	4.72	4.9	4.72	4.9	1000.0
2014-07-29	AAIC-DELISTED	Stock	26.58	26.72	26.31	26.34	152186.0
2014-07-29	AAL	Stock	40.65	40.85	39.39	39.53	10713400.0
2014-07-29	AAMC-DELISTED	Stock	202.9412	204.4029	199.1206	202.9412	15524.0
2014-07-29	AAME	Stock	4.0	4.07	4.0	4.06	5800.0
2014-07-29	AAOI	Stock	20.3	20.3	19.11	19.16	204400.0
2014-07-29	AAON	Stock	13.38	13.64	13.3133	13.32	146100.0
2014-07-29	AAP	Stock	124.52	124.78	122.94	122.96	422200.0
2014-07-29	AAT	Stock	35.73	35.8	35.39	35.49	178400.0
2014-07-29	AAU-DELISTED	Stock	1.44	1.45	1.4	1.43	72447.0
2014-07-29	AAUAF-DELISTED	Stock	1.42	1.43	1.38	1.43	73888.0
2014-07-29	AAV-DELISTED	Stock	5.43	5.43	5.312	5.4	279002.0
2014-07-29	AAWW-DELISTED	Stock	34.84	35.12	34.38	35.1	187329.0
2014-07-29	AAXJ	Stock	65.75	65.88	65.5	65.53	639172.0
2014-07-29	AAXN-DELISTED	Stock	11.32	11.61	11.284	11.51	551617.0
2014-07-29	AB	Stock	26.64	26.99	26.18	26.35	365400.0
2014-07-29	ABAC-DELISTED	Stock	1.77	2.11	1.77	1.98	34496.0
2014-07-29	ABAX-DELISTED	Stock	47.67	48.463	47.67	47.9	354609.0
2014-07-29	ABB-DELISTED	Stock	23.84	23.89	23.56	23.57	1812109.0
2014-07-29	ABBNY-DELISTED	Stock	23.84	23.89	23.56	23.57	1916789.0
2014-07-29	ABBV	Stock	53.55	53.66	53.24	53.43	16171500.0
2014-07-29	ABC-DELISTED	Stock	77.39	77.99	77.25	77.62	1307636.0
2014-07-29	ABCB	Stock	21.05	21.32	21.05	21.26	60700.0
2014-07-29	ABCD-DELISTED	Stock	1.88	1.88	1.79	1.84	24429.0
2014-07-29	ABCO-DELISTED	Stock	51.7	52.22	51.14	51.35	328969.0
2014-07-29	ABDC-DELISTED	Stock	13.55	14.19	13.55	13.83	179359.0
2014-07-29	ABE-DELISTED	Stock	14.65	14.6581	14.56	14.57	5899.0
2014-07-29	ABEO	Stock	337.5	375.0	337.5	350.0	21.0
2014-07-29	ABEV	Stock	7.3	7.42	7.25	7.32	11467800.0
2014-07-29	ABG	Stock	69.96	70.22	69.33	69.34	125300.0
2014-07-29	ABGB-DELISTED	Stock	27.09	27.18	27.01	27.05	2600.0
2014-07-29	ABM	Stock	25.05	25.19	24.89	24.97	202100.0
2014-07-29	ABMD-DELISTED	Stock	26.46	26.46	26.06	26.31	193965.0
2014-07-29	ABR	Stock	7.09	7.12	7.05	7.07	41000.0
2014-07-29	ABR.A-DELISTED	Stock	25.0801	25.12	25.0499	25.0601	6897.0
2014-07-29	ABR.B-DELISTED	Stock	24.55	24.6	24.55	24.5988	3679.0
2014-07-29	ABR.C-DELISTED	Stock	25.43	25.43	25.4	25.4	800.0
2014-07-29	ABRN-DELISTED	Stock	25.18	25.19	25.1	25.1	42917.0

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

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