PREVIEW / stock_daily / 2010-09-29

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-29.parquet
  size:    192 KB
  rows:    5,973
  symbols: 3,501

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-29	AAPL	Stock	10.2582	10.3504	10.2143	10.2632	469644000.0
2010-09-29	MSFT	Stock	24.63	24.66	24.4	24.5	44318900.0
2010-09-29	NVDA	Stock	0.2965	0.3058	0.2938	0.297	974904000.0
2010-09-29	AMZN	Stock	7.9515	8.089	7.8875	7.9495	145750000.0
2010-09-29	TSLA	Stock	1.4127	1.4687	1.4087	1.4653	29539500.0
2010-09-29	TLT	Stock	106.17	106.27	105.3505	105.58	5507043.0
2010-09-29	ES	Stock	29.84	29.98	29.53	29.87	807700.0
2010-09-29	CL	Stock	39.37	39.5	39.07	39.155	4592400.0
2010-09-29	A	Stock	22.9614	23.3619	22.9614	23.3047	4729015.0
2010-09-29	AABA-DELISTED	Stock	14.36	14.39	14.06	14.34	23622375.0
2010-09-29	AACC-DELISTED	Stock	4.88	5.1	4.85	5.09	40967.0
2010-09-29	AACG	Stock	2.9	2.98	2.9	2.93	4400.0
2010-09-29	AAI-DELISTED	Stock	7.31	7.35	7.3	7.33	13995161.0
2010-09-29	AAIC-DELISTED	Stock	23.6	23.69	22.51	23.01	57604.0
2010-09-29	AAME	Stock	1.74	1.75	1.74	1.74	1300.0
2010-09-29	AAON	Stock	4.717	4.804	4.7032	4.7407	183262.0
2010-09-29	AAP	Stock	59.25	59.79	59.25	59.66	717500.0
2010-09-29	AATI-DELISTED	Stock	3.6	3.6	3.49	3.59	88185.0
2010-09-29	AAU-DELISTED	Stock	2.6	2.92	2.6	2.86	781560.0
2010-09-29	AAUAF-DELISTED	Stock	2.6	2.92	2.6	2.86	783160.0
2010-09-29	AAV-DELISTED	Stock	6.12	6.26	6.1	6.25	443117.0
2010-09-29	AAWW-DELISTED	Stock	54.7	55.17	54.17	54.29	357580.0
2010-09-29	AAXJ	Stock	60.05	60.48	60.04	60.28	314536.0
2010-09-29	AAXN-DELISTED	Stock	3.81	3.905	3.81	3.82	289651.0
2010-09-29	AB	Stock	26.01	26.22	25.77	26.13	198000.0
2010-09-29	ABAC-DELISTED	Stock	3.7	3.9	3.7	3.86	30600.0
2010-09-29	ABAX-DELISTED	Stock	22.72	23.03	22.56	22.88	63713.0
2010-09-29	ABB-DELISTED	Stock	21.33	21.44	21.22	21.28	3744505.0
2010-09-29	ABBC-DELISTED	Stock	10.25	10.54	10.21	10.5	52273.0
2010-09-29	ABBNY-DELISTED	Stock	21.33	21.44	21.22	21.28	4161339.0
2010-09-29	ABC-DELISTED	Stock	31.04	31.13	30.71	30.74	3026385.0
2010-09-29	ABCB	Stock	9.29	9.55	9.12	9.48	55800.0
2010-09-29	ABCD-DELISTED	Stock	3.26	3.27	3.2	3.25	16345.0
2010-09-29	ABCO-DELISTED	Stock	21.44	21.84	21.44	21.61	140786.0
2010-09-29	ABCW-DELISTED	Stock	0.68	0.69	0.68	0.68	87870.0
2010-09-29	ABD-DELISTED	Stock	5.81	5.9001	5.7198	5.84	189820.0
2010-09-29	ABE-DELISTED	Stock	18.24	18.55	18.24	18.55	41763.0
2010-09-29	ABEO	Stock	2375.0	2500.0	2375.0	2500.0	5.0
2010-09-29	ABFS-DELISTED	Stock	23.94	24.41	23.6	24.27	461444.0
2010-09-29	ABG	Stock	13.66	13.97	13.53	13.96	147200.0
2010-09-29	ABII-DELISTED	Stock	76.48	76.59	76.25	76.5599	40275.0
2010-09-29	ABK-DELISTED	Stock	0.5684	0.57	0.55	0.56	3141783.0
2010-09-29	ABM	Stock	21.35	21.68	21.32	21.59	241900.0
2010-09-29	ABMD-DELISTED	Stock	10.35	10.35	10.14	10.31	76833.0
2010-09-29	ABR	Stock	4.83	4.93	4.78	4.9	29700.0
2010-09-29	ABT	Stock	25.1319	25.2231	25.0024	25.1847	11276574.0
2010-09-29	ABTL-DELISTED	Stock	4.4533	4.6105	4.2495	4.25	13404.0
2010-09-29	ABV-DELISTED	Stock	122.65	124.96	122.4201	123.91	543131.0
2010-09-29	ABVA-DELISTED	Stock	2.82	2.82	2.8	2.8	1659.0
2010-09-29	ABVT-DELISTED	Stock	52.1	52.41	51.92	52.03	84592.0

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

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