PREVIEW / stock_daily / 2014-10-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-24.parquet
  size:    220 KB
  rows:    6,590
  symbols: 3,537

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-24	AAPL	Stock	26.295	26.3725	26.1325	26.305	188215600.0
2014-10-24	MSFT	Stock	46.83	46.9	45.18	46.13	61076700.0
2014-10-24	NVDA	Stock	0.46	0.4648	0.4572	0.462	210156000.0
2014-10-24	AMZN	Stock	14.22	14.6905	14.2	14.353	396022000.0
2014-10-24	GOOGL	Stock	27.749	27.75	27.258	27.445	43515340.0
2014-10-24	META	Stock	80.2	80.82	79.32	80.67	32248000.0
2014-10-24	TSLA	Stock	15.7513	15.8533	15.4133	15.6827	51949500.0
2014-10-24	TLT	Stock	119.93	120.41	119.47	119.72	5704911.0
2014-10-24	ES	Stock	48.51	48.71	48.34	48.59	1180500.0
2014-10-24	CL	Stock	64.17	65.8	64.0	65.35	4384400.0
2014-10-24	A	Stock	38.412	38.7053	38.2761	38.6624	2108464.0
2014-10-24	AA.B-DELISTED	Stock	50.99	51.5	50.91	51.31	65449.0
2014-10-24	AABA-DELISTED	Stock	42.53	43.65	42.4	43.5	31953139.0
2014-10-24	AAC-DELISTED	Stock	21.24	22.32	21.06	22.0	153757.0
2014-10-24	AACG	Stock	4.18	4.27	4.18	4.19	8600.0
2014-10-24	AAIC-DELISTED	Stock	26.78	27.04	26.68	27.03	250163.0
2014-10-24	AAL	Stock	38.6	39.95	38.58	39.82	17834100.0
2014-10-24	AAMC-DELISTED	Stock	161.7794	166.1735	161.5853	162.6471	41364.0
2014-10-24	AAME	Stock	3.83	3.95	3.83	3.95	2300.0
2014-10-24	AAMI	Stock	14.43	15.01	14.22	14.9	221700.0
2014-10-24	AAOI	Stock	14.82	15.6	14.82	15.22	327100.0
2014-10-24	AAON	Stock	12.4533	12.5267	11.82	12.1733	311700.0
2014-10-24	AAP	Stock	141.25	142.13	139.48	142.04	958300.0
2014-10-24	AAT	Stock	36.95	37.15	36.44	36.73	111800.0
2014-10-24	AAU-DELISTED	Stock	1.21	1.21	1.15	1.16	97354.0
2014-10-24	AAUAF-DELISTED	Stock	1.21	1.21	1.15	1.17	98471.0
2014-10-24	AAV-DELISTED	Stock	4.34	4.35	4.19	4.21	211169.0
2014-10-24	AAVL-DELISTED	Stock	33.93	34.24	33.68	34.23	21597.0
2014-10-24	AAWW-DELISTED	Stock	34.95	35.195	34.17	34.8	122957.0
2014-10-24	AAXJ	Stock	61.15	61.63	61.15	61.49	2054459.0
2014-10-24	AAXN-DELISTED	Stock	15.25	15.57	15.11	15.47	848680.0
2014-10-24	AB	Stock	25.4	26.21	24.98	26.07	148800.0
2014-10-24	ABAC-DELISTED	Stock	2.24	2.3	2.21	2.27	108909.0
2014-10-24	ABAX-DELISTED	Stock	50.37	50.5	49.0	49.06	335647.0
2014-10-24	ABB-DELISTED	Stock	21.31	21.48	21.2399	21.43	1536853.0
2014-10-24	ABBNY-DELISTED	Stock	21.31	21.48	21.2399	21.43	1597560.0
2014-10-24	ABBV	Stock	59.34	60.41	59.34	60.29	10391600.0
2014-10-24	ABC-DELISTED	Stock	77.71	78.33	77.43	78.29	1273474.0
2014-10-24	ABCB	Stock	23.6	23.96	23.6	23.79	70200.0
2014-10-24	ABCD-DELISTED	Stock	1.401	1.51	1.401	1.4776	41903.0
2014-10-24	ABCO-DELISTED	Stock	49.63	50.96	49.313	50.72	187946.0
2014-10-24	ABCW-DELISTED	Stock	29.52	31.9853	29.0	31.0	8018.0
2014-10-24	ABDC-DELISTED	Stock	12.72	12.75	12.6011	12.71	20171.0
2014-10-24	ABE-DELISTED	Stock	13.77	13.91	13.75	13.91	6792.0
2014-10-24	ABEO	Stock	250.0	250.0	250.0	250.0	24.0
2014-10-24	ABEV	Stock	6.16	6.46	6.14	6.38	24480500.0
2014-10-24	ABG	Stock	65.18	67.19	64.52	66.56	513400.0
2014-10-24	ABGB-DELISTED	Stock	20.95	20.95	20.7201	20.92	6243.0
2014-10-24	ABM	Stock	26.38	26.46	26.17	26.46	89700.0
2014-10-24	ABMD-DELISTED	Stock	24.14	24.61	24.07	24.19	139744.0

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

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