PREVIEW / stock_daily / 2011-06-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-01.parquet
  size:    200 KB
  rows:    6,151
  symbols: 3,587

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-06-01	AAPL	Stock	12.4596	12.5761	12.3089	12.3396	554682800.0
2011-06-01	MSFT	Stock	24.99	25.1	24.37	24.43	74033500.0
2011-06-01	NVDA	Stock	0.4988	0.4995	0.4775	0.4785	762208000.0
2011-06-01	AMZN	Stock	9.803	9.863	9.6025	9.62	68904000.0
2011-06-01	TSLA	Stock	2.0	2.0067	1.892	1.9013	22948500.0
2011-06-01	TLT	Stock	96.92	97.718	96.89	97.64	12747959.0
2011-06-01	ES	Stock	35.13	35.28	34.9	34.9	1557400.0
2011-06-01	CL	Stock	43.525	43.655	43.385	43.455	5999800.0
2011-06-01	A	Stock	35.6152	35.6152	34.2489	34.3348	5815261.0
2011-06-01	AABA-DELISTED	Stock	16.34	16.43	15.79	15.845	39587024.0
2011-06-01	AACC-DELISTED	Stock	4.15	4.15	3.85	3.87	65537.0
2011-06-01	AACG	Stock	11.8	13.09	11.55	12.62	170000.0
2011-06-01	AAIC-DELISTED	Stock	28.85	28.85	27.5	27.51	47573.0
2011-06-01	AAME	Stock	2.05	2.05	1.95	2.05	800.0
2011-06-01	AAON	Stock	6.6311	6.7062	6.4454	6.4652	577125.0
2011-06-01	AAP	Stock	62.14	62.14	60.86	61.02	1554100.0
2011-06-01	AAT	Stock	22.43	22.43	21.94	21.94	260100.0
2011-06-01	AATI-DELISTED	Stock	6.03	6.05	6.03	6.03	1816684.0
2011-06-01	AAU-DELISTED	Stock	3.67	3.8	3.56	3.64	361044.0
2011-06-01	AAUAF-DELISTED	Stock	3.67	3.8	3.56	3.64	361344.0
2011-06-01	AAV-DELISTED	Stock	8.39	8.48	8.21	8.25	585965.0
2011-06-01	AAWW-DELISTED	Stock	63.01	63.3	60.32	60.38	284599.0
2011-06-01	AAXJ	Stock	63.91	63.91	62.9	63.0	305439.0
2011-06-01	AAXN-DELISTED	Stock	4.53	4.54	4.4	4.47	601146.0
2011-06-01	AB	Stock	20.71	20.82	20.03	20.13	912800.0
2011-06-01	ABAC-DELISTED	Stock	2.76	2.7699	2.74	2.74	17900.0
2011-06-01	ABAX-DELISTED	Stock	31.01	31.17	29.89	29.89	161902.0
2011-06-01	ABB-DELISTED	Stock	27.08	27.09	26.22	26.26	2651140.0
2011-06-01	ABBC-DELISTED	Stock	11.36	11.45	10.81	10.81	81934.0
2011-06-01	ABBNY-DELISTED	Stock	27.08	27.09	26.22	26.27	2728440.0
2011-06-01	ABC-DELISTED	Stock	41.09	41.4	40.7	40.72	1622099.0
2011-06-01	ABCB	Stock	9.29	9.29	8.71	8.71	74000.0
2011-06-01	ABCD-DELISTED	Stock	3.34	3.34	3.24	3.25	46200.0
2011-06-01	ABCO-DELISTED	Stock	26.18	26.35	25.6	25.6	129607.0
2011-06-01	ABCW-DELISTED	Stock	0.76	0.78	0.74	0.74	31450.0
2011-06-01	ABD-DELISTED	Stock	8.255	8.395	7.995	8.015	430660.0
2011-06-01	ABE-DELISTED	Stock	18.8	18.9	18.7	18.75	16460.0
2011-06-01	ABEO	Stock	2637.5	2812.5	2637.5	2800.0	10.0
2011-06-01	ABFS-DELISTED	Stock	24.49	24.558	23.05	23.1	357147.0
2011-06-01	ABG	Stock	16.78	16.78	16.04	16.06	507600.0
2011-06-01	ABH-DELISTED	Stock	24.89	24.89	23.96	23.98	580518.0
2011-06-01	ABM	Stock	22.78	22.87	22.44	22.45	826700.0
2011-06-01	ABMD-DELISTED	Stock	18.55	18.76	18.06	18.06	341368.0
2011-06-01	ABR	Stock	5.01	5.09	4.8	4.8	33900.0
2011-06-01	ABT	Stock	25.0552	25.1751	24.8296	24.9112	13972697.0
2011-06-01	ABTL-DELISTED	Stock	5.85	6.2	5.6	5.75	32546.0
2011-06-01	ABUS	Stock	3.34	3.37	3.27	3.27	2800.0
2011-06-01	ABV-DELISTED	Stock	31.34	31.5	30.99	31.02	1818535.0
2011-06-01	ABVA-DELISTED	Stock	5.41	5.41	5.2	5.2	4384.0
2011-06-01	ABVT-DELISTED	Stock	77.59	77.85	75.32	75.37	318457.0

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

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