PREVIEW / stock_daily / 2012-05-01

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-01.parquet
  size:    200 KB
  rows:    6,205
  symbols: 3,574

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-05-01	AAPL	Stock	20.8893	21.3129	20.7582	20.7904	610999200.0
2012-05-01	MSFT	Stock	32.05	32.34	31.95	32.01	43832300.0
2012-05-01	NVDA	Stock	0.3233	0.3342	0.3233	0.3308	408680000.0
2012-05-01	AMZN	Stock	11.47	11.6485	11.42	11.502	135098000.0
2012-05-01	TSLA	Stock	2.2087	2.2807	2.2087	2.252	9885000.0
2012-05-01	TLT	Stock	117.43	117.62	116.0714	116.43	7215001.0
2012-05-01	ES	Stock	36.83	37.25	36.79	37.09	1766900.0
2012-05-01	CL	Stock	49.485	49.795	49.27	49.55	3598200.0
2012-05-01	A	Stock	30.0644	30.9514	29.8999	30.7368	3615508.0
2012-05-01	AABA-DELISTED	Stock	15.51	15.725	15.5	15.63	9555857.0
2012-05-01	AACC-DELISTED	Stock	5.37	5.49	5.35	5.38	52165.0
2012-05-01	AACG	Stock	6.38	7.0	6.3	7.0	1800.0
2012-05-01	AAIC-DELISTED	Stock	23.57	23.75	23.34	23.45	89017.0
2012-05-01	AAME	Stock	2.94	2.96	2.94	2.96	2500.0
2012-05-01	AAMRQ-DELISTED	Stock	0.576	0.58	0.561	0.561	1474490.0
2012-05-01	AAON	Stock	6.0444	6.2074	5.8844	5.9111	195750.0
2012-05-01	AAP	Stock	91.26	92.48	90.6	90.75	1094300.0
2012-05-01	AAT	Stock	23.63	23.89	23.49	23.58	296100.0
2012-05-01	AAU-DELISTED	Stock	2.36	2.39	2.25	2.26	110313.0
2012-05-01	AAUAF-DELISTED	Stock	2.36	2.39	2.25	2.26	111219.0
2012-05-01	AAV-DELISTED	Stock	3.17	3.49	3.17	3.49	588088.0
2012-05-01	AAWW-DELISTED	Stock	45.98	47.54	45.39	46.62	350957.0
2012-05-01	AAXJ	Stock	56.28	56.89	56.11	56.54	146141.0
2012-05-01	AAXN-DELISTED	Stock	4.61	4.7	4.52	4.65	934625.0
2012-05-01	AB	Stock	14.06	14.26	13.93	14.03	293100.0
2012-05-01	ABAC-DELISTED	Stock	1.7899	1.79	1.65	1.72	79002.0
2012-05-01	ABAX-DELISTED	Stock	35.5	36.13	35.27	35.35	211483.0
2012-05-01	ABB-DELISTED	Stock	18.15	18.378	18.15	18.25	3013704.0
2012-05-01	ABBNY-DELISTED	Stock	18.16	18.378	18.15	18.26	3022804.0
2012-05-01	ABC-DELISTED	Stock	37.06	37.58	36.9	37.31	3743534.0
2012-05-01	ABCB	Stock	12.35	12.8	12.05	12.08	97000.0
2012-05-01	ABCD-DELISTED	Stock	2.27	2.36	2.13	2.25	39933.0
2012-05-01	ABCO-DELISTED	Stock	45.21	46.51	45.19	45.75	287074.0
2012-05-01	ABCW-DELISTED	Stock	0.6848	0.6848	0.6426	0.6426	2050.0
2012-05-01	ABE-DELISTED	Stock	19.5	19.6155	19.48	19.55	1314.0
2012-05-01	ABEO	Stock	1312.5	1362.5	1225.0	1350.0	59.0
2012-05-01	ABFS-DELISTED	Stock	15.39	15.45	15.1	15.34	498230.0
2012-05-01	ABG	Stock	28.53	29.62	28.08	28.19	662800.0
2012-05-01	ABH-DELISTED	Stock	13.0	13.27	12.45	12.62	473510.0
2012-05-01	ABM	Stock	23.32	23.41	22.76	22.81	299800.0
2012-05-01	ABMD-DELISTED	Stock	24.28	25.07	24.04	24.5	890548.0
2012-05-01	ABR	Stock	5.57	5.75	5.57	5.65	29400.0
2012-05-01	ABT	Stock	29.7572	30.0211	29.5317	29.858	12816382.0
2012-05-01	ABTL-DELISTED	Stock	4.6517	4.6517	4.4494	4.5	9744.0
2012-05-01	ABUS	Stock	2.42	2.5	2.42	2.49	2700.0
2012-05-01	ABV-DELISTED	Stock	42.13	42.43	41.7	42.16	2301096.0
2012-05-01	ABVT-DELISTED	Stock	83.22	83.22	82.97	83.07	808212.0
2012-05-01	ABX-DELISTED	Stock	40.58	40.76	40.1	40.42	4559305.0
2012-05-01	ACAD	Stock	1.51	1.58	1.5	1.56	191000.0
2012-05-01	ACAS-DELISTED	Stock	9.81	9.99	9.67	9.68	4810782.0

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

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