PREVIEW / stock_daily / 2015-06-12

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-12.parquet
  size:    223 KB
  rows:    6,622
  symbols: 3,484

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
2015-06-12	AAPL	Stock	32.0475	32.0825	31.7775	31.7925	147544800.0
2015-06-12	MSFT	Stock	46.22	46.47	45.9	45.97	23931000.0
2015-06-12	NVDA	Stock	0.539	0.5422	0.5265	0.5278	323728000.0
2015-06-12	AMZN	Stock	21.5625	21.618	21.413	21.496	41088000.0
2015-06-12	GOOGL	Stock	27.3575	27.4425	27.2815	27.3735	25467660.0
2015-06-12	META	Stock	81.37	82.09	81.2	81.53	11417900.0
2015-06-12	TSLA	Stock	16.6807	16.8973	16.6807	16.7127	21334500.0
2015-06-12	TLT	Stock	117.59	119.07	117.55	117.95	7863117.0
2015-06-12	ES	Stock	46.46	46.54	46.1	46.1	593000.0
2015-06-12	CL	Stock	66.44	66.44	66.05	66.29	2543300.0
2015-06-12	A	Stock	40.33	40.49	39.74	39.84	2769600.0
2015-06-12	AA.B-DELISTED	Stock	42.71	42.9831	42.56	42.8	26485.0
2015-06-12	AABA-DELISTED	Stock	40.77	41.11	40.455	40.52	8549185.0
2015-06-12	AAC-DELISTED	Stock	43.32	43.62	41.88	43.08	75342.0
2015-06-12	AACG	Stock	5.27	5.44	5.25	5.33	28100.0
2015-06-12	AAIC-DELISTED	Stock	20.81	20.9	20.76	20.86	176650.0
2015-06-12	AAL	Stock	39.84	41.0	39.76	40.71	10333800.0
2015-06-12	AAMC-DELISTED	Stock	48.7029	48.7029	47.0174	48.5706	12053.0
2015-06-12	AAME	Stock	3.73	3.8	3.53	3.75	1300.0
2015-06-12	AAMI	Stock	18.77	18.77	18.43	18.51	41000.0
2015-06-12	AAOI	Stock	18.33	18.59	18.05	18.43	119000.0
2015-06-12	AAON	Stock	15.88	16.12	15.86	16.0	77100.0
2015-06-12	AAP	Stock	160.29	161.65	159.98	161.21	438500.0
2015-06-12	AAT	Stock	39.63	39.9	39.39	39.59	121800.0
2015-06-12	AAU-DELISTED	Stock	0.89	0.912	0.8792	0.88	43952.0
2015-06-12	AAUAF-DELISTED	Stock	0.88	0.903	0.87	0.88	44967.0
2015-06-12	AAV-DELISTED	Stock	6.22	6.34	6.19	6.31	70575.0
2015-06-12	AAVL-DELISTED	Stock	40.45	41.6	39.79	41.49	433385.0
2015-06-12	AAWW-DELISTED	Stock	55.01	55.29	54.4	54.72	201713.0
2015-06-12	AAXJ	Stock	64.61	64.79	64.47	64.66	2041315.0
2015-06-12	AAXN-DELISTED	Stock	34.74	34.77	33.75	34.0	2022099.0
2015-06-12	AB	Stock	30.99	31.42	30.59	31.07	187600.0
2015-06-12	ABAC-DELISTED	Stock	1.51	1.52	1.43	1.5	10311.0
2015-06-12	ABAX-DELISTED	Stock	51.48	51.839	51.27	51.35	76008.0
2015-06-12	ABB-DELISTED	Stock	22.74	22.86	22.67	22.76	1190764.0
2015-06-12	ABBNY-DELISTED	Stock	22.74	22.86	22.67	22.77	1271111.0
2015-06-12	ABBV	Stock	67.89	67.93	66.59	67.05	8249900.0
2015-06-12	ABC-DELISTED	Stock	111.0	111.0	109.81	110.15	1020774.0
2015-06-12	ABCB	Stock	26.15	26.25	25.99	26.24	91600.0
2015-06-12	ABCD-DELISTED	Stock	4.2699	4.3	4.2001	4.27	62601.0
2015-06-12	ABCO-DELISTED	Stock	53.01	53.43	52.38	52.67	270040.0
2015-06-12	ABCW-DELISTED	Stock	36.97	37.1	36.95	37.0	25086.0
2015-06-12	ABDC-DELISTED	Stock	13.81	14.02	13.65	13.75	58631.0
2015-06-12	ABE-DELISTED	Stock	12.8173	12.8173	12.79	12.8	2289.0
2015-06-12	ABEO	Stock	183.0	189.75	180.25	183.25	24044.0
2015-06-12	ABEOW-DELISTED	Stock	3.07	3.07	2.8903	2.99	12770.0
2015-06-12	ABEV	Stock	6.02	6.02	5.96	5.96	9106100.0
2015-06-12	ABG	Stock	87.88	88.0	86.9	87.62	291400.0
2015-06-12	ABGB-DELISTED	Stock	16.85	16.92	16.75	16.82	12791.0
2015-06-12	ABM	Stock	33.19	33.19	32.85	33.03	140600.0

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

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