PREVIEW / stock_daily / 2010-09-27

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-27.parquet
  size:    191 KB
  rows:    5,974
  symbols: 3,510

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-27	AAPL	Stock	10.4993	10.5261	10.3932	10.3986	482834800.0
2010-09-27	MSFT	Stock	24.85	24.99	24.59	24.73	43603300.0
2010-09-27	NVDA	Stock	0.3088	0.309	0.296	0.3	999504000.0
2010-09-27	AMZN	Stock	8.011	8.06	7.894	7.9685	128926000.0
2010-09-27	TSLA	Stock	1.36	1.3873	1.3367	1.3687	6279000.0
2010-09-27	TLT	Stock	104.5299	105.445	104.48	105.3	7061568.0
2010-09-27	ES	Stock	29.55	29.84	29.4	29.7	1709300.0
2010-09-27	CL	Stock	39.125	39.595	39.07	39.465	4768000.0
2010-09-27	A	Stock	22.9399	22.99	22.6609	22.8898	3866868.0
2010-09-27	AABA-DELISTED	Stock	14.46	14.525	14.25	14.28	20523030.0
2010-09-27	AACC-DELISTED	Stock	4.58	4.7	4.18	4.65	33552.0
2010-09-27	AACG	Stock	2.9	2.98	2.9	2.97	1900.0
2010-09-27	AAI-DELISTED	Stock	7.19	7.41	7.17	7.34	90087457.0
2010-09-27	AAIC-DELISTED	Stock	24.18	24.23	23.86	23.87	68930.0
2010-09-27	AAME	Stock	1.81	1.85	1.61	1.77	13900.0
2010-09-27	AAON	Stock	4.7427	4.7447	4.6341	4.7249	130106.0
2010-09-27	AAP	Stock	59.49	59.75	59.17	59.38	486200.0
2010-09-27	AATI-DELISTED	Stock	3.46	3.6575	3.46	3.62	184851.0
2010-09-27	AAU-DELISTED	Stock	2.52	2.71	2.51	2.54	320031.0
2010-09-27	AAUAF-DELISTED	Stock	2.52	2.71	2.51	2.54	320831.0
2010-09-27	AAV-DELISTED	Stock	6.09	6.14	6.08	6.11	186912.0
2010-09-27	AAWW-DELISTED	Stock	54.87	55.3	54.27	55.03	266710.0
2010-09-27	AAXJ	Stock	59.93	60.0825	59.7419	59.8	618617.0
2010-09-27	AAXN-DELISTED	Stock	3.85	3.93	3.84	3.9	267373.0
2010-09-27	AB	Stock	25.68	25.86	25.5	25.59	203000.0
2010-09-27	ABAC-DELISTED	Stock	3.76	3.88	3.63	3.66	37000.0
2010-09-27	ABAX-DELISTED	Stock	22.45	22.65	22.1	22.18	75130.0
2010-09-27	ABB-DELISTED	Stock	21.12	21.13	20.97	21.0	2567735.0
2010-09-27	ABBC-DELISTED	Stock	10.27	10.3199	10.09	10.12	12062.0
2010-09-27	ABBNY-DELISTED	Stock	21.12	21.13	20.97	20.97	2601389.0
2010-09-27	ABC-DELISTED	Stock	31.2	31.82	30.53	30.96	4512990.0
2010-09-27	ABCB	Stock	9.24	9.3	9.04	9.2	34400.0
2010-09-27	ABCD-DELISTED	Stock	3.27	3.3	3.23	3.25	8094.0
2010-09-27	ABCO-DELISTED	Stock	21.5	21.72	21.41	21.66	149204.0
2010-09-27	ABCW-DELISTED	Stock	0.67	0.6996	0.67	0.67	37710.0
2010-09-27	ABD-DELISTED	Stock	5.96	5.96	5.6209	5.67	269930.0
2010-09-27	ABE-DELISTED	Stock	18.23	18.26	18.15	18.15	11531.0
2010-09-27	ABEO	Stock	2687.5	2687.5	2625.0	2625.0	3.0
2010-09-27	ABFS-DELISTED	Stock	24.11	25.23	23.74	24.19	433619.0
2010-09-27	ABG	Stock	13.5	13.81	13.38	13.72	184300.0
2010-09-27	ABII-DELISTED	Stock	76.54	76.58	76.32	76.44	16249.0
2010-09-27	ABK-DELISTED	Stock	0.5556	0.575	0.55	0.554	3504727.0
2010-09-27	ABM	Stock	21.7	21.7	21.29	21.5	186600.0
2010-09-27	ABMD-DELISTED	Stock	10.45	10.55	10.23	10.29	55048.0
2010-09-27	ABR	Stock	4.92	4.99	4.91	4.96	59200.0
2010-09-27	ABT	Stock	24.9256	25.0743	24.8488	24.9976	10238433.0
2010-09-27	ABTL-DELISTED	Stock	4.2986	4.3964	4.25	4.25	1972.0
2010-09-27	ABV-DELISTED	Stock	119.94	122.2	119.63	121.1	590833.0
2010-09-27	ABVT-DELISTED	Stock	53.14	53.285	51.95	52.65	150722.0
2010-09-27	ABX-DELISTED	Stock	46.64	46.8	45.66	45.76	6123780.0

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

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