PREVIEW / stock_daily / 2010-06-08

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-08.parquet
  size:    189 KB
  rows:    5,935
  symbols: 3,490

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-06-08	AAPL	Stock	9.0443	9.0643	8.7732	8.9046	1000770400.0
2010-06-08	MSFT	Stock	25.25	25.26	24.65	25.11	87355000.0
2010-06-08	NVDA	Stock	0.2862	0.2862	0.2723	0.2795	967636000.0
2010-06-08	AMZN	Stock	6.1	6.1	5.79	5.942	229688000.0
2010-06-08	TLT	Stock	97.93	98.51	97.76	98.05	5510785.0
2010-06-08	ES	Stock	25.27	25.55	25.11	25.52	1260200.0
2010-06-08	CL	Stock	38.82	39.445	38.75	39.38	4894400.0
2010-06-08	A	Stock	21.588	21.7239	20.9657	21.3448	8392054.0
2010-06-08	AABA-DELISTED	Stock	15.05	15.12	14.62	14.78	32498731.0
2010-06-08	AACC-DELISTED	Stock	4.82	4.9	4.73	4.84	192128.0
2010-06-08	AACG	Stock	3.36	3.48	3.36	3.43	3400.0
2010-06-08	AAI-DELISTED	Stock	5.63	5.71	5.49	5.62	3061745.0
2010-06-08	AAIC-DELISTED	Stock	18.68	18.9799	18.545	18.9799	26928.0
2010-06-08	AAME	Stock	1.4	1.42	1.4	1.42	6900.0
2010-06-08	AAON	Stock	4.5353	4.561	4.4267	4.5254	312862.0
2010-06-08	AAP	Stock	48.53	49.63	47.76	49.46	2290800.0
2010-06-08	AATI-DELISTED	Stock	3.43	3.46	3.3	3.35	198086.0
2010-06-08	AAU-DELISTED	Stock	0.9812	0.9911	0.9445	0.9788	143530.0
2010-06-08	AAUAF-DELISTED	Stock	0.9801	0.99	0.9434	0.9777	145684.0
2010-06-08	AAV-DELISTED	Stock	6.14	6.25	5.91	6.03	487003.0
2010-06-08	AAWW-DELISTED	Stock	47.52	48.43	46.38	47.84	330144.0
2010-06-08	AAXJ	Stock	50.54	51.52	50.47	51.48	309853.0
2010-06-08	AAXN-DELISTED	Stock	4.15	4.19	4.07	4.11	664309.0
2010-06-08	AB	Stock	27.78	28.15	26.91	27.69	307400.0
2010-06-08	ABAX-DELISTED	Stock	21.27	21.34	20.47	20.7	156575.0
2010-06-08	ABB-DELISTED	Stock	16.66	16.87	16.4	16.72	7607397.0
2010-06-08	ABBC-DELISTED	Stock	8.7	8.84	8.51	8.61	79320.0
2010-06-08	ABBNY-DELISTED	Stock	16.66	16.87	16.4	16.73	7705704.0
2010-06-08	ABC-DELISTED	Stock	30.78	30.94	30.31	30.6	5165180.0
2010-06-08	ABCB	Stock	10.4303	10.49	10.072	10.3209	94046.0
2010-06-08	ABCD-DELISTED	Stock	4.63	4.66	4.52	4.6	10623.0
2010-06-08	ABCO-DELISTED	Stock	18.875	19.375	18.775	19.36	262292.0
2010-06-08	ABCW-DELISTED	Stock	0.7995	0.7996	0.76	0.76	63800.0
2010-06-08	ABD-DELISTED	Stock	6.15	6.21	5.76	5.83	857760.0
2010-06-08	ABE-DELISTED	Stock	14.95	15.24	14.95	15.24	30603.0
2010-06-08	ABEO	Stock	2987.5	2987.5	2812.5	2987.5	9.0
2010-06-08	ABFS-DELISTED	Stock	20.97	21.15	20.55	21.04	428501.0
2010-06-08	ABG	Stock	11.75	11.86	11.31	11.63	412800.0
2010-06-08	ABII-DELISTED	Stock	54.0	54.85	53.25	53.97	121100.0
2010-06-08	ABK-DELISTED	Stock	1.19	1.27	1.03	1.07	57246432.0
2010-06-08	ABM	Stock	20.33	20.46	19.9	20.2	1304800.0
2010-06-08	ABMD-DELISTED	Stock	9.59	9.63	9.43	9.55	320886.0
2010-06-08	ABR	Stock	4.35	4.4	4.08	4.14	241000.0
2010-06-08	ABT	Stock	22.1092	22.2723	21.9125	22.2195	22759275.0
2010-06-08	ABTL-DELISTED	Stock	5.75	5.9	5.5	5.75	42509.0
2010-06-08	ABV-DELISTED	Stock	95.85	97.82	95.78	97.33	1081736.0
2010-06-08	ABVT-DELISTED	Stock	43.52	43.78	41.12	42.56	382974.0
2010-06-08	ABX-DELISTED	Stock	43.53	44.6	43.22	43.35	14235219.0
2010-06-08	ACAD	Stock	1.27	1.28	1.13	1.21	447800.0
2010-06-08	ACAP-DELISTED	Stock	29.87	29.87	29.02	29.42	57594.0

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

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