PREVIEW / stock_daily / 2010-09-28

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-28.parquet
  size:    191 KB
  rows:    5,954
  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-09-28	AAPL	Stock	10.4204	10.4204	9.8214	10.245	1035042400.0
2010-09-28	MSFT	Stock	24.8	24.9	24.35	24.68	56041200.0
2010-09-28	NVDA	Stock	0.3002	0.3035	0.294	0.2992	723192000.0
2010-09-28	AMZN	Stock	7.992	8.044	7.7445	7.985	169884000.0
2010-09-28	TSLA	Stock	1.4027	1.4327	1.384	1.4267	18217500.0
2010-09-28	TLT	Stock	105.38	106.32	105.34	106.02	8262812.0
2010-09-28	ES	Stock	29.66	29.88	29.5	29.81	1222700.0
2010-09-28	CL	Stock	39.58	39.595	39.165	39.405	6266000.0
2010-09-28	A	Stock	22.8612	23.2046	22.6824	23.133	3996742.0
2010-09-28	AABA-DELISTED	Stock	14.32	14.45	14.14	14.4	15809585.0
2010-09-28	AACC-DELISTED	Stock	4.68	4.89	4.64	4.86	30770.0
2010-09-28	AACG	Stock	2.91	2.94	2.9	2.94	28700.0
2010-09-28	AAI-DELISTED	Stock	7.33	7.4	7.25	7.32	30714396.0
2010-09-28	AAIC-DELISTED	Stock	23.6	23.69	23.15	23.59	28756.0
2010-09-28	AAME	Stock	1.76	1.76	1.74	1.74	7600.0
2010-09-28	AAON	Stock	4.7407	4.7407	4.6301	4.7388	135169.0
2010-09-28	AAP	Stock	59.69	59.74	58.86	59.46	945500.0
2010-09-28	AATI-DELISTED	Stock	3.63	3.65	3.57	3.62	137497.0
2010-09-28	AAU-DELISTED	Stock	2.53	2.68	2.5	2.58	406940.0
2010-09-28	AAUAF-DELISTED	Stock	2.53	2.68	2.5	2.58	407605.0
2010-09-28	AAV-DELISTED	Stock	6.07	6.2	5.99	6.17	360395.0
2010-09-28	AAWW-DELISTED	Stock	55.01	55.55	54.27	54.92	258742.0
2010-09-28	AAXJ	Stock	59.78	59.9999	59.31	59.9	321520.0
2010-09-28	AAXN-DELISTED	Stock	3.91	3.92	3.8	3.81	454360.0
2010-09-28	AB	Stock	25.84	26.3	25.36	26.0	327700.0
2010-09-28	ABAC-DELISTED	Stock	3.67	3.88	3.66	3.67	13200.0
2010-09-28	ABAX-DELISTED	Stock	22.32	22.96	22.0501	22.86	86446.0
2010-09-28	ABB-DELISTED	Stock	21.1	21.24	20.86	21.2	3446175.0
2010-09-28	ABBC-DELISTED	Stock	10.17	10.3	10.0	10.28	49516.0
2010-09-28	ABBNY-DELISTED	Stock	21.1	21.24	20.86	21.21	4407107.0
2010-09-28	ABC-DELISTED	Stock	31.09	31.21	30.605	31.16	2807378.0
2010-09-28	ABCB	Stock	9.17	9.36	9.07	9.33	70900.0
2010-09-28	ABCD-DELISTED	Stock	3.26	3.28	3.22	3.28	26230.0
2010-09-28	ABCO-DELISTED	Stock	21.72	21.79	21.48	21.57	143169.0
2010-09-28	ABCW-DELISTED	Stock	0.68	0.7	0.68	0.68	45520.0
2010-09-28	ABD-DELISTED	Stock	5.7	5.8867	5.55	5.84	210580.0
2010-09-28	ABE-DELISTED	Stock	18.12	18.33	18.081	18.33	7812.0
2010-09-28	ABEO	Stock	2687.5	2687.5	2437.5	2475.0	27.0
2010-09-28	ABFS-DELISTED	Stock	24.37	24.73	23.68	24.12	391359.0
2010-09-28	ABG	Stock	13.82	13.85	13.3	13.77	158800.0
2010-09-28	ABII-DELISTED	Stock	76.21	76.66	76.21	76.62	31841.0
2010-09-28	ABK-DELISTED	Stock	0.57	0.57	0.5532	0.561	2803397.0
2010-09-28	ABM	Stock	21.61	21.61	21.1	21.49	329400.0
2010-09-28	ABMD-DELISTED	Stock	10.32	10.41	10.07	10.35	79848.0
2010-09-28	ABR	Stock	4.91	4.91	4.73	4.9	23400.0
2010-09-28	ABT	Stock	25.0504	25.1799	24.9112	25.1319	9584202.0
2010-09-28	ABTL-DELISTED	Stock	4.5	4.5	4.114	4.25	74397.0
2010-09-28	ABV-DELISTED	Stock	122.19	123.27	119.6101	122.98	624931.0
2010-09-28	ABVT-DELISTED	Stock	52.87	52.87	52.17	52.23	115900.0
2010-09-28	ABX-DELISTED	Stock	45.49	46.86	44.76	46.79	12111639.0

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

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