PREVIEW / stock_daily / 2011-04-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-20.parquet
  size:    199 KB
  rows:    6,124
  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
2011-04-20	AAPL	Stock	12.2682	12.3482	12.1964	12.2289	700666400.0
2011-04-20	MSFT	Stock	25.54	26.0	25.51	25.76	61608600.0
2011-04-20	NVDA	Stock	0.467	0.4738	0.4568	0.4643	650516000.0
2011-04-20	AMZN	Stock	9.081	9.25	9.0795	9.1935	81350000.0
2011-04-20	TSLA	Stock	1.7133	1.7393	1.6867	1.7167	12558000.0
2011-04-20	TLT	Stock	93.07	93.26	92.61	92.68	6759430.0
2011-04-20	ES	Stock	33.94	34.21	33.9	34.15	1781300.0
2011-04-20	CL	Stock	41.065	41.065	40.55	40.635	5601800.0
2011-04-20	A	Stock	33.9628	34.9285	33.9127	34.7926	5067750.0
2011-04-20	AABA-DELISTED	Stock	16.75	17.23	16.59	16.89	34179414.0
2011-04-20	AACC-DELISTED	Stock	5.42	5.46	5.32	5.45	171623.0
2011-04-20	AACG	Stock	7.49	7.56	6.8	7.0	48500.0
2011-04-20	AAI-DELISTED	Stock	7.37	7.4	7.33	7.35	4024233.0
2011-04-20	AAIC-DELISTED	Stock	29.26	29.91	29.25	29.9	15834.0
2011-04-20	AAME	Stock	2.04	2.05	1.97	2.05	1300.0
2011-04-20	AAON	Stock	6.4178	6.5284	6.4158	6.5264	144787.0
2011-04-20	AAP	Stock	65.5	66.17	65.2	66.13	914900.0
2011-04-20	AAT	Stock	21.43	21.69	21.22	21.67	159600.0
2011-04-20	AATI-DELISTED	Stock	4.25	4.25	4.14	4.2	86643.0
2011-04-20	AAU-DELISTED	Stock	4.36	4.81	4.35	4.6601	1161320.0
2011-04-20	AAUAF-DELISTED	Stock	4.36	4.81	4.35	4.65	1163720.0
2011-04-20	AAV-DELISTED	Stock	8.39	8.7	8.37	8.55	470409.0
2011-04-20	AAWW-DELISTED	Stock	63.45	63.73	61.54	61.98	357817.0
2011-04-20	AAXJ	Stock	64.74	64.78	64.44	64.77	242712.0
2011-04-20	AAXN-DELISTED	Stock	3.96	4.1	3.96	4.08	772160.0
2011-04-20	AB	Stock	21.61	21.62	21.18	21.5	381300.0
2011-04-20	ABAC-DELISTED	Stock	3.4	3.5201	3.35	3.38	89013.0
2011-04-20	ABAX-DELISTED	Stock	28.66	28.87	28.62	28.81	69962.0
2011-04-20	ABB-DELISTED	Stock	24.84	24.97	24.81	24.96	2825744.0
2011-04-20	ABBC-DELISTED	Stock	12.08	12.21	11.94	12.07	36749.0
2011-04-20	ABBNY-DELISTED	Stock	24.84	24.97	24.81	24.97	2883679.0
2011-04-20	ABC-DELISTED	Stock	40.14	40.67	40.06	40.48	1528453.0
2011-04-20	ABCB	Stock	9.61	9.63	9.47	9.58	27100.0
2011-04-20	ABCD-DELISTED	Stock	3.32	3.34	3.3	3.34	25160.0
2011-04-20	ABCO-DELISTED	Stock	23.09	23.82	23.05	23.73	221915.0
2011-04-20	ABCW-DELISTED	Stock	0.92	0.93	0.87	0.87	47550.0
2011-04-20	ABD-DELISTED	Stock	9.81	10.04	9.78	9.89	187030.0
2011-04-20	ABE-DELISTED	Stock	19.01	19.55	19.01	19.13	12990.0
2011-04-20	ABEO	Stock	2862.5	2875.0	2750.0	2875.0	10.0
2011-04-20	ABFS-DELISTED	Stock	25.53	25.65	25.3	25.49	255919.0
2011-04-20	ABG	Stock	17.01	17.4	17.01	17.2	267500.0
2011-04-20	ABH-DELISTED	Stock	26.02	26.08	25.57	26.03	495633.0
2011-04-20	ABM	Stock	24.53	24.58	24.07	24.27	194200.0
2011-04-20	ABMD-DELISTED	Stock	16.89	16.91	16.47	16.63	160400.0
2011-04-20	ABR	Stock	5.25	5.26	5.07	5.14	76900.0
2011-04-20	ABT	Stock	24.8632	24.94	24.014	24.3738	27179033.0
2011-04-20	ABTL-DELISTED	Stock	6.95	6.95	6.696	6.9	42018.0
2011-04-20	ABUS	Stock	2.75	2.86	2.72	2.72	2300.0
2011-04-20	ABV-DELISTED	Stock	31.27	31.31	30.74	31.15	2188691.0
2011-04-20	ABVA-DELISTED	Stock	6.25	6.6	6.249	6.25	46200.0

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

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