PREVIEW / stock_daily / 2011-03-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-28.parquet
  size:    198 KB
  rows:    6,103
  symbols: 3,559

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-03-28	AAPL	Stock	12.6125	12.6543	12.5157	12.5157	309355200.0
2011-03-28	MSFT	Stock	25.66	25.72	25.38	25.41	48973200.0
2011-03-28	NVDA	Stock	0.4768	0.491	0.4725	0.483	1204284000.0
2011-03-28	AMZN	Stock	8.59	8.625	8.4625	8.4675	68016000.0
2011-03-28	TSLA	Stock	1.5133	1.5693	1.5033	1.55	15871500.0
2011-03-28	TLT	Stock	92.12	92.67	92.0	92.3	3997481.0
2011-03-28	ES	Stock	34.18	34.39	33.84	33.86	1305600.0
2011-03-28	CL	Stock	40.07	40.475	40.07	40.245	6445600.0
2011-03-28	A	Stock	31.6452	31.9528	31.3805	31.4449	4169815.0
2011-03-28	AABA-DELISTED	Stock	16.98	17.06	16.575	16.58	15622921.0
2011-03-28	AACC-DELISTED	Stock	5.35	5.35	5.26	5.32	8907.0
2011-03-28	AACG	Stock	7.91	8.1	7.9	7.91	7600.0
2011-03-28	AAI-DELISTED	Stock	7.43	7.45	7.39	7.42	1752995.0
2011-03-28	AAIC-DELISTED	Stock	30.66	31.0304	30.6	30.62	45062.0
2011-03-28	AAME	Stock	2.13	2.13	2.13	2.13	500.0
2011-03-28	AAON	Stock	6.1452	6.1807	6.1215	6.1432	86062.0
2011-03-28	AAP	Stock	66.51	66.54	65.55	65.62	645200.0
2011-03-28	AAT	Stock	21.55	21.56	21.42	21.45	142600.0
2011-03-28	AATI-DELISTED	Stock	3.76	3.8006	3.68	3.69	121551.0
2011-03-28	AAU-DELISTED	Stock	3.87	3.99	3.84	3.97	182134.0
2011-03-28	AAUAF-DELISTED	Stock	3.88	4.0	3.85	3.96	181867.0
2011-03-28	AAV-DELISTED	Stock	8.89	9.23	8.89	8.98	1047257.0
2011-03-28	AAWW-DELISTED	Stock	68.58	69.02	67.88	68.0	210568.0
2011-03-28	AAXJ	Stock	61.5	61.76	61.42	61.51	304504.0
2011-03-28	AAXN-DELISTED	Stock	4.13	4.2	3.69	3.95	1033585.0
2011-03-28	AB	Stock	21.57	21.73	21.49	21.66	290600.0
2011-03-28	ABAC-DELISTED	Stock	4.28	4.4	4.15	4.16	41940.0
2011-03-28	ABAX-DELISTED	Stock	29.36	29.48	29.02	29.1	183659.0
2011-03-28	ABB-DELISTED	Stock	23.76	23.85	23.64	23.64	1210282.0
2011-03-28	ABBC-DELISTED	Stock	11.64	11.81	11.63	11.67	25651.0
2011-03-28	ABBNY-DELISTED	Stock	23.77	23.85	23.64	23.64	1211578.0
2011-03-28	ABC-DELISTED	Stock	39.34	39.485	39.07	39.38	1963422.0
2011-03-28	ABCB	Stock	10.06	10.16	10.06	10.08	20000.0
2011-03-28	ABCD-DELISTED	Stock	3.34	3.35	3.3	3.32	7743.0
2011-03-28	ABCO-DELISTED	Stock	24.82	25.29	24.81	25.24	297708.0
2011-03-28	ABCW-DELISTED	Stock	0.9632	1.05	0.9632	1.03	79790.0
2011-03-28	ABD-DELISTED	Stock	9.125	9.235	9.095	9.105	250900.0
2011-03-28	ABE-DELISTED	Stock	18.32	18.38	18.27	18.28	2802.0
2011-03-28	ABEO	Stock	2562.5	2725.0	2512.5	2687.5	20.0
2011-03-28	ABFS-DELISTED	Stock	24.92	25.045	24.51	24.72	331592.0
2011-03-28	ABG	Stock	18.88	19.07	18.32	18.48	284000.0
2011-03-28	ABH-DELISTED	Stock	27.05	27.1	26.75	26.88	202173.0
2011-03-28	ABM	Stock	25.43	25.5	25.19	25.21	131000.0
2011-03-28	ABMD-DELISTED	Stock	14.5	14.75	14.3	14.51	410244.0
2011-03-28	ABR	Stock	5.64	5.69	5.6	5.67	27200.0
2011-03-28	ABT	Stock	23.0928	23.1216	23.0304	23.0688	9457065.0
2011-03-28	ABTL-DELISTED	Stock	7.3	7.85	6.9	7.15	300686.0
2011-03-28	ABUS	Stock	3.2	3.28	2.94	2.96	68500.0
2011-03-28	ABV-DELISTED	Stock	27.22	27.25	26.6099	26.75	3516491.0
2011-03-28	ABVA-DELISTED	Stock	5.5	5.508	5.5	5.5001	2400.0

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

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