PREVIEW / stock_daily / 2014-04-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-22.parquet
  size:    219 KB
  rows:    6,552
  symbols: 3,563

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-04-22	AAPL	Stock	18.8682	18.9939	18.8036	18.9893	202563200.0
2014-04-22	MSFT	Stock	39.96	40.14	39.83	39.99	27056700.0
2014-04-22	NVDA	Stock	0.4685	0.4748	0.466	0.4718	255120000.0
2014-04-22	AMZN	Stock	16.6	16.875	16.447	16.466	74232000.0
2014-04-22	GOOGL	Stock	26.8	27.3998	26.8	27.275	46622420.0
2014-04-22	META	Stock	62.65	63.44	62.22	63.03	60631000.0
2014-04-22	TSLA	Stock	13.7573	14.622	13.6673	14.576	147070500.0
2014-04-22	TLT	Stock	109.66	110.49	109.61	110.33	5748723.0
2014-04-22	ES	Stock	45.71	45.95	45.47	45.81	1220200.0
2014-04-22	CL	Stock	66.91	67.09	66.35	66.36	3283700.0
2014-04-22	A	Stock	39.1273	39.7711	39.0057	39.3205	2062749.0
2014-04-22	AABA-DELISTED	Stock	36.7	36.85	36.11	36.14	17244813.0
2014-04-22	AACG	Stock	4.12	4.27	3.88	3.88	101600.0
2014-04-22	AAIC-DELISTED	Stock	25.73	26.06	25.7	25.93	91793.0
2014-04-22	AAL	Stock	35.76	36.74	35.75	36.16	8941800.0
2014-04-22	AAMC-DELISTED	Stock	282.3559	294.1176	282.3559	289.7059	39012.0
2014-04-22	AAME	Stock	3.63	3.68	3.48	3.54	25800.0
2014-04-22	AAOI	Stock	23.34	23.95	23.04	23.85	250600.0
2014-04-22	AAON	Stock	11.9822	12.2311	11.92	12.2222	191700.0
2014-04-22	AAP	Stock	121.53	125.37	121.53	121.61	1221900.0
2014-04-22	AAT	Stock	33.34	33.72	33.08	33.71	144600.0
2014-04-22	AAU-DELISTED	Stock	1.39	1.39	1.35	1.36	80506.0
2014-04-22	AAUAF-DELISTED	Stock	1.39	1.39	1.35	1.36	81986.0
2014-04-22	AAV-DELISTED	Stock	5.73	5.92	5.7	5.88	1023843.0
2014-04-22	AAWW-DELISTED	Stock	35.05	36.16	35.05	35.83	206881.0
2014-04-22	AAXJ	Stock	60.6	60.74	60.4	60.4	1392876.0
2014-04-22	AAXN-DELISTED	Stock	17.74	18.42	17.68	18.22	703562.0
2014-04-22	AB	Stock	25.71	26.63	25.4	26.34	592100.0
2014-04-22	ABAC-DELISTED	Stock	2.1	2.35	2.0996	2.17	361560.0
2014-04-22	ABAX-DELISTED	Stock	39.46	39.84	39.12	39.21	192776.0
2014-04-22	ABB-DELISTED	Stock	26.1	26.195	26.01	26.02	1316687.0
2014-04-22	ABBNY-DELISTED	Stock	26.1	26.195	26.01	26.02	1448425.0
2014-04-22	ABBV	Stock	49.49	50.42	49.35	50.01	6613200.0
2014-04-22	ABC-DELISTED	Stock	64.8	65.49	64.66	64.68	1338294.0
2014-04-22	ABCB	Stock	22.19	22.7	22.13	22.48	69200.0
2014-04-22	ABCD-DELISTED	Stock	2.2	2.2	2.153	2.163	22655.0
2014-04-22	ABCO-DELISTED	Stock	60.32	61.81	59.53	60.95	95929.0
2014-04-22	ABE-DELISTED	Stock	13.44	13.44	13.3841	13.39	7236.0
2014-04-22	ABEO	Stock	562.5	562.5	500.0	562.5	14.0
2014-04-22	ABEV	Stock	7.75	7.91	7.69	7.9	9724500.0
2014-04-22	ABFS-DELISTED	Stock	38.43	39.79	38.31	38.99	328770.0
2014-04-22	ABG	Stock	55.03	55.29	54.51	54.93	241600.0
2014-04-22	ABGB-DELISTED	Stock	22.8499	23.1199	22.75	23.0199	13408.0
2014-04-22	ABIL-DELISTED	Stock	9.65	9.68	9.64	9.64	1337.0
2014-04-22	ABM	Stock	27.68	28.08	27.63	27.83	161900.0
2014-04-22	ABMD-DELISTED	Stock	25.06	25.5599	24.85	25.45	247924.0
2014-04-22	ABR	Stock	7.0	7.03	6.86	7.01	144000.0
2014-04-22	ABR.A-DELISTED	Stock	24.8501	25.0299	24.8501	25.0299	9891.0
2014-04-22	ABR.B-DELISTED	Stock	23.529	23.53	23.27	23.42	143947.0
2014-04-22	ABR.C-DELISTED	Stock	24.95	25.18	24.9	25.06	133573.0

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

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