PREVIEW / stock_daily / 2014-10-23

all stock daily files

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

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-23	AAPL	Stock	26.02	26.2625	25.9075	26.2075	284298800.0
2014-10-23	MSFT	Stock	44.62	45.45	44.53	45.02	45451900.0
2014-10-23	NVDA	Stock	0.455	0.4605	0.4518	0.4572	214476000.0
2014-10-23	AMZN	Stock	15.67	15.84	15.57	15.659	180764000.0
2014-10-23	GOOGL	Stock	27.414	27.87	27.275	27.6825	43073560.0
2014-10-23	META	Stock	79.38	80.63	79.01	80.04	35056000.0
2014-10-23	TSLA	Stock	15.644	15.752	15.4667	15.686	52386000.0
2014-10-23	TLT	Stock	120.04	120.18	119.06	119.6	10936825.0
2014-10-23	ES	Stock	48.25	48.67	47.96	48.41	1702400.0
2014-10-23	CL	Stock	65.74	65.77	64.84	65.05	4083000.0
2014-10-23	A	Stock	38.3333	38.7768	38.3333	38.4192	2453071.0
2014-10-23	AA.B-DELISTED	Stock	51.15	51.32	50.56	50.8	92791.0
2014-10-23	AABA-DELISTED	Stock	42.4	42.83	42.26	42.6	28996531.0
2014-10-23	AAC-DELISTED	Stock	20.41	22.23	20.41	21.11	78269.0
2014-10-23	AACG	Stock	4.17	4.22	4.17	4.22	10800.0
2014-10-23	AAIC-DELISTED	Stock	26.86	26.93	26.66	26.76	336330.0
2014-10-23	AAL	Stock	37.43	40.18	36.8	38.48	33292000.0
2014-10-23	AAMC-DELISTED	Stock	169.1176	174.85	161.7647	166.1735	89872.0
2014-10-23	AAME	Stock	3.92	3.92	3.83	3.83	5100.0
2014-10-23	AAMI	Stock	14.75	14.83	14.26	14.5	172600.0
2014-10-23	AAOI	Stock	14.9	15.38	14.53	14.81	280700.0
2014-10-23	AAON	Stock	12.1067	12.4733	12.08	12.4067	170550.0
2014-10-23	AAP	Stock	141.15	143.61	140.64	140.78	1624900.0
2014-10-23	AAT	Stock	36.81	37.13	36.61	36.81	198700.0
2014-10-23	AAU-DELISTED	Stock	1.2101	1.24	1.2	1.2	202805.0
2014-10-23	AAUAF-DELISTED	Stock	1.2	1.23	1.19	1.2	207651.0
2014-10-23	AAV-DELISTED	Stock	4.4	4.47	4.33	4.36	103503.0
2014-10-23	AAVL-DELISTED	Stock	32.58	35.3	32.5201	33.9	74561.0
2014-10-23	AAWW-DELISTED	Stock	34.06	35.48	33.69	34.78	183354.0
2014-10-23	AAXJ	Stock	61.48	61.72	61.34	61.43	622307.0
2014-10-23	AAXN-DELISTED	Stock	15.07	15.42	14.8954	15.26	971868.0
2014-10-23	AB	Stock	26.99	26.99	25.17	25.49	298500.0
2014-10-23	ABAC-DELISTED	Stock	2.2	2.24	2.1601	2.24	77676.0
2014-10-23	ABAX-DELISTED	Stock	51.35	51.8572	50.43	50.52	213117.0
2014-10-23	ABB-DELISTED	Stock	21.32	21.54	21.31	21.39	1756191.0
2014-10-23	ABBNY-DELISTED	Stock	21.32	21.54	21.31	21.39	1895553.0
2014-10-23	ABBV	Stock	58.1	59.7	57.88	59.52	14729300.0
2014-10-23	ABC-DELISTED	Stock	77.32	77.9	77.18	77.43	1792826.0
2014-10-23	ABCB	Stock	23.59	23.8	23.33	23.49	83700.0
2014-10-23	ABCD-DELISTED	Stock	1.43	1.46	1.4	1.45	17900.0
2014-10-23	ABCO-DELISTED	Stock	49.8	50.519	49.3466	49.74	237118.0
2014-10-23	ABCW-DELISTED	Stock	30.18	31.0	28.36	30.11	26938.0
2014-10-23	ABDC-DELISTED	Stock	12.49	12.887	12.403	12.79	53144.0
2014-10-23	ABE-DELISTED	Stock	13.83	13.84	13.75	13.81	30115.0
2014-10-23	ABEO	Stock	250.0	287.5	237.5	275.0	117.0
2014-10-23	ABEV	Stock	6.1	6.14	5.94	6.08	23678200.0
2014-10-23	ABG	Stock	62.38	66.37	62.09	64.98	825100.0
2014-10-23	ABGB-DELISTED	Stock	20.63	21.001	20.52	20.83	11046.0
2014-10-23	ABIL-DELISTED	Stock	9.75	9.75	9.69	9.69	200.0
2014-10-23	ABM	Stock	26.3	26.45	26.17	26.28	155700.0

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

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