PREVIEW / stock_daily / 2014-10-20

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-20.parquet
  size:    220 KB
  rows:    6,629
  symbols: 3,566

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-20	AAPL	Stock	24.58	24.99	24.555	24.94	310069200.0
2014-10-20	MSFT	Stock	43.06	44.14	42.81	44.08	34527900.0
2014-10-20	NVDA	Stock	0.4355	0.4432	0.4325	0.4392	200336000.0
2014-10-20	AMZN	Stock	15.1475	15.3265	15.101	15.3105	64690000.0
2014-10-20	GOOGL	Stock	26.0225	26.658	25.957	26.619	54996600.0
2014-10-20	META	Stock	75.6	77.09	75.38	76.95	34701000.0
2014-10-20	TSLA	Stock	15.1147	15.4933	15.034	15.3647	52416000.0
2014-10-20	TLT	Stock	121.78	121.845	120.94	121.51	7742600.0
2014-10-20	ES	Stock	47.22	48.15	47.15	48.07	2023200.0
2014-10-20	CL	Stock	63.58	64.6	63.58	64.54	3018100.0
2014-10-20	A	Stock	37.2461	37.4678	36.3805	37.4464	6909196.0
2014-10-20	AA.B-DELISTED	Stock	49.5	49.61	49.0	49.52	183639.0
2014-10-20	AABA-DELISTED	Stock	38.46	39.4	38.25	39.28	15653853.0
2014-10-20	AAC-DELISTED	Stock	19.2	19.2	18.53	19.01	69874.0
2014-10-20	AACG	Stock	4.3	4.36	4.2	4.28	31100.0
2014-10-20	AAIC-DELISTED	Stock	25.99	26.54	25.88	26.33	411601.0
2014-10-20	AAL	Stock	34.19	35.39	34.0	35.22	13532700.0
2014-10-20	AAMC-DELISTED	Stock	203.2324	203.2324	203.2324	203.2324	2951.0
2014-10-20	AAME	Stock	3.92	3.94	3.81	3.94	1900.0
2014-10-20	AAMI	Stock	13.87	14.29	13.85	14.29	155500.0
2014-10-20	AAOI	Stock	14.81	15.13	14.53	14.89	218100.0
2014-10-20	AAON	Stock	11.82	12.0667	11.7	12.0467	299850.0
2014-10-20	AAP	Stock	135.5	139.85	135.49	139.57	900600.0
2014-10-20	AAT	Stock	34.77	35.86	34.77	35.85	86000.0
2014-10-20	AAU-DELISTED	Stock	1.32	1.37	1.2895	1.31	58388.0
2014-10-20	AAUAF-DELISTED	Stock	1.29	1.34	1.26	1.31	63484.0
2014-10-20	AAV-DELISTED	Stock	4.57	4.6	4.36	4.48	264446.0
2014-10-20	AAVL-DELISTED	Stock	30.0	30.93	29.68	30.24	47085.0
2014-10-20	AAWW-DELISTED	Stock	32.61	33.33	32.55	33.16	104551.0
2014-10-20	AAXJ	Stock	60.6	60.95	60.49	60.92	363844.0
2014-10-20	AAXN-DELISTED	Stock	14.97	15.07	14.6	14.72	1003536.0
2014-10-20	AB	Stock	24.24	25.14	24.13	25.08	347300.0
2014-10-20	ABAC-DELISTED	Stock	2.1	2.1499	2.0601	2.14	79035.0
2014-10-20	ABAX-DELISTED	Stock	47.79	48.816	47.79	48.25	133851.0
2014-10-20	ABB-DELISTED	Stock	20.61	20.67	20.475	20.63	1967064.0
2014-10-20	ABBNY-DELISTED	Stock	20.61	20.67	20.475	20.64	2036979.0
2014-10-20	ABBV	Stock	52.56	54.59	52.25	54.41	17954600.0
2014-10-20	ABC-DELISTED	Stock	75.87	76.02	75.11	75.5	2356279.0
2014-10-20	ABCB	Stock	23.73	23.99	23.6	23.99	124500.0
2014-10-20	ABCD-DELISTED	Stock	1.43	1.4401	1.43	1.4401	900.0
2014-10-20	ABCO-DELISTED	Stock	49.26	49.76	48.89	49.46	195924.0
2014-10-20	ABDC-DELISTED	Stock	12.39	12.588	12.23	12.45	35891.0
2014-10-20	ABE-DELISTED	Stock	13.66	13.69	13.644	13.6732	2720.0
2014-10-20	ABEO	Stock	275.0	275.0	237.5	250.0	63.0
2014-10-20	ABEV	Stock	6.5	6.54	6.4	6.49	11763600.0
2014-10-20	ABG	Stock	65.28	67.18	64.76	65.3	730800.0
2014-10-20	ABGB-DELISTED	Stock	20.55	20.73	20.44	20.73	35078.0
2014-10-20	ABM	Stock	25.78	26.1	25.71	26.1	134800.0
2014-10-20	ABMD-DELISTED	Stock	22.89	23.56	22.84	23.55	165346.0
2014-10-20	ABR	Stock	6.44	6.58	6.44	6.55	73800.0

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

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