PREVIEW / stock_daily / 2012-11-01

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-01.parquet
  size:    200 KB
  rows:    6,178
  symbols: 3,498

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
2012-11-01	AAPL	Stock	21.365	21.5357	21.2204	21.305	361298000.0
2012-11-01	MSFT	Stock	28.84	29.56	28.82	29.52	72047900.0
2012-11-01	NVDA	Stock	0.301	0.314	0.3008	0.3138	473220000.0
2012-11-01	AMZN	Stock	11.7115	11.7275	11.567	11.607	78102000.0
2012-11-01	META	Stock	21.08	21.44	21.01	21.21	37713900.0
2012-11-01	TSLA	Stock	1.8833	1.966	1.88	1.95	15361500.0
2012-11-01	TLT	Stock	122.77	122.88	122.08	122.35	3659628.0
2012-11-01	ES	Stock	39.16	39.4	38.96	39.24	1380000.0
2012-11-01	CL	Stock	52.34	53.07	52.12	52.935	3944800.0
2012-11-01	A	Stock	25.7797	26.5737	25.7153	26.5379	4462975.0
2012-11-01	AABA-DELISTED	Stock	16.89	17.05	16.86	16.95	19582423.0
2012-11-01	AACC-DELISTED	Stock	6.4	6.85	6.2805	6.41	26445.0
2012-11-01	AACG	Stock	4.68	4.75	4.66	4.74	4200.0
2012-11-01	AAIC-DELISTED	Stock	22.3	22.5498	22.12	22.3	118508.0
2012-11-01	AAME	Stock	2.89	2.93	2.78	2.92	2400.0
2012-11-01	AAMRQ-DELISTED	Stock	0.381	0.412	0.375	0.379	1450640.0
2012-11-01	AAON	Stock	6.2044	6.237	6.16	6.2252	142425.0
2012-11-01	AAP	Stock	70.64	84.0	70.08	81.0	4395200.0
2012-11-01	AAT	Stock	27.21	27.44	26.1	27.22	201200.0
2012-11-01	AAU-DELISTED	Stock	2.62	2.71	2.57	2.67	86296.0
2012-11-01	AAUAF-DELISTED	Stock	2.58	2.67	2.53	2.67	87996.0
2012-11-01	AAV-DELISTED	Stock	3.61	3.61	3.56	3.59	75362.0
2012-11-01	AAWW-DELISTED	Stock	49.9	49.9	44.845	45.55	1758763.0
2012-11-01	AAXJ	Stock	57.0	57.42	56.84	57.32	533312.0
2012-11-01	AAXN-DELISTED	Stock	7.8	8.15	7.8	8.06	914807.0
2012-11-01	AB	Stock	16.47	16.79	16.29	16.45	290500.0
2012-11-01	ABAC-DELISTED	Stock	1.2	1.36	1.2	1.28	4533.0
2012-11-01	ABAX-DELISTED	Stock	36.86	38.04	36.748	37.45	183537.0
2012-11-01	ABB-DELISTED	Stock	18.17	18.33	18.12	18.295	1750237.0
2012-11-01	ABBNY-DELISTED	Stock	18.17	18.33	18.12	18.3	1872812.0
2012-11-01	ABC-DELISTED	Stock	39.55	41.12	39.51	40.91	4235699.0
2012-11-01	ABCB	Stock	10.7	10.97	10.7	10.89	49400.0
2012-11-01	ABCD-DELISTED	Stock	0.91	0.94	0.8	0.86	21874.0
2012-11-01	ABCO-DELISTED	Stock	47.63	49.64	47.55	47.69	226486.0
2012-11-01	ABCW-DELISTED	Stock	0.359	0.38	0.359	0.38	31373.0
2012-11-01	ABE-DELISTED	Stock	20.65	20.74	20.64	20.74	11324.0
2012-11-01	ABEO	Stock	475.0	475.0	437.5	437.5	19.0
2012-11-01	ABFS-DELISTED	Stock	8.0	8.54	7.7	8.4	673619.0
2012-11-01	ABG	Stock	31.94	32.77	31.51	32.35	414500.0
2012-11-01	ABM	Stock	18.99	19.15	18.8	19.14	497100.0
2012-11-01	ABMD-DELISTED	Stock	15.8	15.9	13.12	13.61	9011926.0
2012-11-01	ABR	Stock	5.53	5.57	5.47	5.56	64400.0
2012-11-01	ABT	Stock	31.5516	31.8011	31.3741	31.4029	14941851.0
2012-11-01	ABTL-DELISTED	Stock	3.97	4.0	3.89	4.0	15965.0
2012-11-01	ABUS	Stock	4.09	4.23	4.09	4.22	15800.0
2012-11-01	ABV-DELISTED	Stock	40.92	41.16	40.51	40.78	1841535.0
2012-11-01	ABVA-DELISTED	Stock	4.42	4.47	4.42	4.47	1558.0
2012-11-01	ABX-DELISTED	Stock	37.49	38.0	36.56	36.67	22217456.0
2012-11-01	ACAD	Stock	2.35	2.36	2.29	2.33	451800.0
2012-11-01	ACAS-DELISTED	Stock	11.79	11.92	11.78	11.8	6296650.0

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

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