PREVIEW / stock_daily / 2014-10-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-17.parquet
  size:    221 KB
  rows:    6,635
  symbols: 3,559

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-17	AAPL	Stock	24.375	24.75	24.2025	24.4175	272718800.0
2014-10-17	MSFT	Stock	43.2	43.94	42.79	43.63	40683300.0
2014-10-17	NVDA	Stock	0.4415	0.4465	0.4338	0.4355	290716000.0
2014-10-17	AMZN	Stock	15.3575	15.46	15.136	15.182	88102000.0
2014-10-17	GOOGL	Stock	27.0225	27.1725	25.9205	26.1485	119974800.0
2014-10-17	META	Stock	74.23	76.0	73.75	75.95	76342000.0
2014-10-17	TSLA	Stock	15.5587	15.6513	15.1033	15.1653	158241000.0
2014-10-17	TLT	Stock	121.19	121.71	120.48	121.07	8524257.0
2014-10-17	ES	Stock	47.1	47.31	46.3	47.18	2106700.0
2014-10-17	CL	Stock	63.5	63.88	63.02	63.73	3832000.0
2014-10-17	A	Stock	37.3176	38.2046	37.2103	37.3891	5327498.0
2014-10-17	AA.B-DELISTED	Stock	45.0	49.47	45.0	49.37	1710828.0
2014-10-17	AABA-DELISTED	Stock	38.74	38.98	38.31	38.45	23005149.0
2014-10-17	AAC-DELISTED	Stock	19.62	19.65	18.86	19.08	86163.0
2014-10-17	AACG	Stock	4.36	4.36	4.31	4.31	2300.0
2014-10-17	AAIC-DELISTED	Stock	25.83	26.095	25.76	25.99	244214.0
2014-10-17	AAL	Stock	33.88	34.34	32.81	33.38	16001100.0
2014-10-17	AAMC-DELISTED	Stock	196.2029	209.0853	194.1206	195.5912	15783.0
2014-10-17	AAME	Stock	3.88	3.94	3.77	3.92	5700.0
2014-10-17	AAMI	Stock	13.83	14.05	13.821	13.96	308200.0
2014-10-17	AAOI	Stock	15.36	15.6	14.44	14.86	368700.0
2014-10-17	AAON	Stock	12.1267	12.2	11.7533	11.9067	294450.0
2014-10-17	AAP	Stock	133.84	136.03	132.69	135.79	719000.0
2014-10-17	AAT	Stock	35.35	35.36	34.76	34.86	154900.0
2014-10-17	AAU-DELISTED	Stock	1.341	1.341	1.27	1.28	39834.0
2014-10-17	AAUAF-DELISTED	Stock	1.32	1.32	1.25	1.28	40985.0
2014-10-17	AAV-DELISTED	Stock	4.5	4.78	4.49	4.57	302340.0
2014-10-17	AAVL-DELISTED	Stock	30.93	31.69	30.02	30.12	68530.0
2014-10-17	AAWW-DELISTED	Stock	33.38	33.57	32.86	32.9	197782.0
2014-10-17	AAXJ	Stock	60.45	60.82	60.24	60.38	575347.0
2014-10-17	AAXN-DELISTED	Stock	15.19	15.46	14.99	15.05	1440050.0
2014-10-17	AB	Stock	23.99	24.93	23.69	24.27	628700.0
2014-10-17	ABAC-DELISTED	Stock	2.1	2.11	1.96	2.11	98074.0
2014-10-17	ABAX-DELISTED	Stock	48.75	48.85	47.49	47.83	100735.0
2014-10-17	ABB-DELISTED	Stock	20.51	20.62	20.38	20.4401	1604773.0
2014-10-17	ABBNY-DELISTED	Stock	20.51	20.62	20.38	20.44	1668685.0
2014-10-17	ABBV	Stock	53.78	53.9	52.9	53.37	31891900.0
2014-10-17	ABC-DELISTED	Stock	75.47	76.18	75.32	75.83	1421937.0
2014-10-17	ABCB	Stock	24.0	24.0	23.1	23.75	202400.0
2014-10-17	ABCD-DELISTED	Stock	1.5	1.54	1.41	1.47	48830.0
2014-10-17	ABCO-DELISTED	Stock	50.96	50.96	49.52	49.62	187514.0
2014-10-17	ABDC-DELISTED	Stock	12.31	12.918	12.08	12.32	34104.0
2014-10-17	ABE-DELISTED	Stock	13.58	13.7	13.58	13.66	20986.0
2014-10-17	ABEO	Stock	225.0	275.0	225.0	275.0	15.0
2014-10-17	ABEV	Stock	6.39	6.68	6.35	6.65	16237600.0
2014-10-17	ABG	Stock	64.84	66.37	64.05	65.19	602600.0
2014-10-17	ABGB-DELISTED	Stock	20.91	20.975	20.6814	20.84	26918.0
2014-10-17	ABM	Stock	26.05	26.34	25.66	25.78	203400.0
2014-10-17	ABMD-DELISTED	Stock	23.22	23.336	22.83	22.98	141459.0
2014-10-17	ABR	Stock	6.51	6.6	6.43	6.46	86100.0

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

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