PREVIEW / stock_daily / 2012-04-03

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-03.parquet
  size:    201 KB
  rows:    6,189
  symbols: 3,552

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-04-03	AAPL	Stock	22.4036	22.5789	22.2325	22.4757	834559600.0
2012-04-03	MSFT	Stock	32.16	32.19	31.66	31.94	42752100.0
2012-04-03	NVDA	Stock	0.386	0.3865	0.375	0.377	430476000.0
2012-04-03	AMZN	Stock	9.912	10.1195	9.875	9.983	100014000.0
2012-04-03	TSLA	Stock	2.4467	2.5647	2.4447	2.534	16471500.0
2012-04-03	TLT	Stock	113.01	113.44	110.57	110.58	14774279.0
2012-04-03	ES	Stock	37.05	37.38	36.87	37.34	2502600.0
2012-04-03	CL	Stock	49.245	49.38	48.995	49.115	4879600.0
2012-04-03	A	Stock	32.0029	32.2961	31.8026	32.0672	3852748.0
2012-04-03	AABA-DELISTED	Stock	15.36	15.43	15.06	15.17	17144021.0
2012-04-03	AACC-DELISTED	Stock	4.99	5.0	4.73	4.92	117734.0
2012-04-03	AACG	Stock	7.43	7.43	7.2	7.43	5000.0
2012-04-03	AAIC-DELISTED	Stock	22.76	23.13	22.62	23.08	250703.0
2012-04-03	AAME	Stock	2.92	2.92	2.83	2.83	800.0
2012-04-03	AAMRQ-DELISTED	Stock	0.461	0.492	0.461	0.489	1702412.0
2012-04-03	AAON	Stock	6.0119	6.0119	5.8993	5.9378	148500.0
2012-04-03	AAP	Stock	89.23	90.01	89.2	90.0	897300.0
2012-04-03	AAT	Stock	23.54	23.54	22.93	23.05	78700.0
2012-04-03	AAU-DELISTED	Stock	2.68	2.6848	2.5992	2.65	84765.0
2012-04-03	AAUAF-DELISTED	Stock	2.64	2.65	2.56	2.65	85972.0
2012-04-03	AAV-DELISTED	Stock	3.4	3.4	3.28	3.32	249301.0
2012-04-03	AAWW-DELISTED	Stock	49.78	50.51	49.35	49.74	193462.0
2012-04-03	AAXJ	Stock	57.1	57.4	56.65	57.01	383291.0
2012-04-03	AAXN-DELISTED	Stock	4.34	4.43	4.3	4.32	357857.0
2012-04-03	AB	Stock	15.55	15.84	15.46	15.57	215600.0
2012-04-03	ABAC-DELISTED	Stock	1.6	1.69	1.6	1.68	39189.0
2012-04-03	ABAX-DELISTED	Stock	29.39	29.53	29.061	29.27	55437.0
2012-04-03	ABB-DELISTED	Stock	20.72	20.762	20.29	20.42	2216454.0
2012-04-03	ABBNY-DELISTED	Stock	20.72	20.762	20.29	20.43	2217154.0
2012-04-03	ABC-DELISTED	Stock	39.13	39.22	38.46	38.68	2830705.0
2012-04-03	ABCB	Stock	13.39	13.39	13.09	13.2	56300.0
2012-04-03	ABCD-DELISTED	Stock	2.64	2.73	2.56	2.64	17610.0
2012-04-03	ABCO-DELISTED	Stock	43.96	44.1	43.39	43.45	211337.0
2012-04-03	ABCW-DELISTED	Stock	1.0041	1.0041	0.9448	1.0041	27320.0
2012-04-03	ABD-DELISTED	Stock	12.85	12.98	12.48	12.58	340900.0
2012-04-03	ABE-DELISTED	Stock	19.67	19.88	19.67	19.73	5269.0
2012-04-03	ABEO	Stock	1137.5	1437.5	1137.5	1437.5	41.0
2012-04-03	ABFS-DELISTED	Stock	19.01	19.3793	19.01	19.32	219810.0
2012-04-03	ABG	Stock	27.85	28.9	27.85	28.62	706000.0
2012-04-03	ABH-DELISTED	Stock	14.2	14.29	13.91	13.95	231509.0
2012-04-03	ABM	Stock	24.04	24.2	23.92	24.06	320400.0
2012-04-03	ABMD-DELISTED	Stock	22.43	22.55	22.04	22.19	123338.0
2012-04-03	ABR	Stock	5.51	5.55	5.41	5.45	25600.0
2012-04-03	ABT	Stock	29.3446	29.4597	29.2246	29.335	13714673.0
2012-04-03	ABTL-DELISTED	Stock	4.9248	4.9248	4.7995	4.85	7932.0
2012-04-03	ABUS	Stock	2.64	2.64	2.61	2.64	30500.0
2012-04-03	ABV-DELISTED	Stock	42.11	42.66	41.78	42.07	2465913.0
2012-04-03	ABVA-DELISTED	Stock	4.09	4.17	4.09	4.17	1885.0
2012-04-03	ABVT-DELISTED	Stock	82.81	82.99	82.81	82.93	360722.0
2012-04-03	ABX-DELISTED	Stock	44.26	44.34	42.48	42.96	9296686.0

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

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