PREVIEW / stock_daily / 2010-05-27

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-27.parquet
  size:    190 KB
  rows:    5,950
  symbols: 3,502

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
2010-05-27	AAPL	Stock	8.95	9.0675	8.8968	9.0482	666282400.0
2010-05-27	MSFT	Stock	25.73	26.36	25.73	26.0	136433600.0
2010-05-27	NVDA	Stock	0.3268	0.3375	0.326	0.3375	713560000.0
2010-05-27	AMZN	Stock	6.249	6.3425	6.03	6.335	94954000.0
2010-05-27	TLT	Stock	96.83	96.99	95.88	96.06	7653111.0
2010-05-27	ES	Stock	25.99	25.99	25.64	25.82	1425900.0
2010-05-27	CL	Stock	39.405	39.61	39.135	39.385	5342000.0
2010-05-27	A	Stock	23.0401	23.4478	22.9685	23.4263	3739091.0
2010-05-27	AABA-DELISTED	Stock	15.81	15.84	15.36	15.71	30940082.0
2010-05-27	AACC-DELISTED	Stock	6.04	6.11	5.36	6.02	29938.0
2010-05-27	AACG	Stock	3.28	3.28	3.22	3.22	2000.0
2010-05-27	AAI-DELISTED	Stock	5.6	5.72	5.53	5.6901	2902580.0
2010-05-27	AAIC-DELISTED	Stock	18.48	18.88	17.97	18.86	17863.0
2010-05-27	AAON	Stock	4.7012	4.9047	4.6242	4.8988	481950.0
2010-05-27	AAP	Stock	50.88	51.37	50.48	51.33	1106900.0
2010-05-27	AATI-DELISTED	Stock	3.5	3.53	3.4	3.49	145379.0
2010-05-27	AAU-DELISTED	Stock	1.0	1.04	0.9903	1.02	166200.0
2010-05-27	AAUAF-DELISTED	Stock	1.0	1.04	0.9903	1.02	166800.0
2010-05-27	AAV-DELISTED	Stock	5.84	6.02	5.83	6.0	347479.0
2010-05-27	AAWW-DELISTED	Stock	51.03	52.55	50.29	52.51	390634.0
2010-05-27	AAXJ	Stock	51.36	53.02	51.36	53.02	772473.0
2010-05-27	AAXN-DELISTED	Stock	4.44	4.53	4.35	4.53	425923.0
2010-05-27	AB	Stock	28.52	29.13	28.13	29.11	334100.0
2010-05-27	ABAX-DELISTED	Stock	22.35	22.99	22.29	22.94	71398.0
2010-05-27	ABB-DELISTED	Stock	17.0	17.39	16.92	17.39	3274123.0
2010-05-27	ABBC-DELISTED	Stock	9.19	9.19	9.0	9.02	114820.0
2010-05-27	ABBNY-DELISTED	Stock	17.0	17.39	16.92	17.39	3296114.0
2010-05-27	ABC-DELISTED	Stock	30.88	31.59	30.85	31.59	4065790.0
2010-05-27	ABCB	Stock	10.6891	11.4057	10.4701	11.3261	248880.0
2010-05-27	ABCD-DELISTED	Stock	4.59	4.9	4.57	4.815	124567.0
2010-05-27	ABCO-DELISTED	Stock	19.025	19.175	18.795	19.155	126796.0
2010-05-27	ABCW-DELISTED	Stock	0.8	0.8	0.75	0.75	56960.0
2010-05-27	ABD-DELISTED	Stock	6.87	7.33	6.85	7.3	421750.0
2010-05-27	ABE-DELISTED	Stock	15.35	15.69	15.33	15.68	17237.0
2010-05-27	ABEO	Stock	3112.5	3112.5	2812.5	2875.0	33.0
2010-05-27	ABFS-DELISTED	Stock	22.03	23.17	22.03	23.08	580457.0
2010-05-27	ABG	Stock	13.25	13.7	13.14	13.39	332400.0
2010-05-27	ABII-DELISTED	Stock	45.17	45.69	43.98	44.27	51287.0
2010-05-27	ABK-DELISTED	Stock	0.9747	0.9747	0.93	0.95	9131954.0
2010-05-27	ABM	Stock	21.2	21.84	21.14	21.8	511300.0
2010-05-27	ABMD-DELISTED	Stock	9.7	9.87	9.45	9.85	176560.0
2010-05-27	ABR	Stock	3.56	3.64	3.39	3.62	92600.0
2010-05-27	ABT	Stock	22.9584	23.0928	22.6753	22.968	16778033.0
2010-05-27	ABTL-DELISTED	Stock	5.5	6.9	5.4	6.35	104413.0
2010-05-27	ABV-DELISTED	Stock	96.01	97.47	95.9501	97.37	950324.0
2010-05-27	ABVA-DELISTED	Stock	2.48	3.0024	2.48	2.9	5025.0
2010-05-27	ABVT-DELISTED	Stock	45.89	47.05	45.75	46.71	258846.0
2010-05-27	ABX-DELISTED	Stock	42.22	42.92	42.13	42.44	7642455.0
2010-05-27	ACAD	Stock	1.3	1.32	1.27	1.29	297100.0
2010-05-27	ACAP-DELISTED	Stock	30.43	31.71	30.31	31.69	35056.0

> showing 50 of 5,950 rows — these rows as CSV

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