PREVIEW / stock_daily / 2010-09-17

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-17.parquet
  size:    193 KB
  rows:    5,984
  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-17	AAPL	Stock	9.9175	9.9271	9.7743	9.8346	634477200.0
2010-09-17	MSFT	Stock	25.4	25.53	25.08	25.22	70341600.0
2010-09-17	NVDA	Stock	0.2668	0.267	0.263	0.2638	416884000.0
2010-09-17	AMZN	Stock	7.445	7.449	7.325	7.416	145192000.0
2010-09-17	TSLA	Stock	1.4013	1.4213	1.32	1.3487	17977500.0
2010-09-17	TLT	Stock	101.83	102.1581	101.32	101.67	9203852.0
2010-09-17	ES	Stock	29.4	29.43	29.0	29.12	1518900.0
2010-09-17	CL	Stock	38.34	38.715	38.34	38.685	9000400.0
2010-09-17	A	Stock	21.6881	22.1245	21.6094	21.8526	6663148.0
2010-09-17	AABA-DELISTED	Stock	14.33	14.34	13.88	13.95	75920600.0
2010-09-17	AACC-DELISTED	Stock	3.66	3.69	3.55	3.69	64550.0
2010-09-17	AACG	Stock	2.8	3.0	2.8	2.85	110500.0
2010-09-17	AAI-DELISTED	Stock	4.46	4.48	4.34	4.34	2214104.0
2010-09-17	AAIC-DELISTED	Stock	22.58	22.58	21.88	21.88	63915.0
2010-09-17	AAME	Stock	1.62	1.64	1.5	1.64	6100.0
2010-09-17	AAON	Stock	4.6677	4.7269	4.5827	4.6598	649519.0
2010-09-17	AAP	Stock	57.37	58.24	57.27	58.15	1079200.0
2010-09-17	AATI-DELISTED	Stock	3.36	3.43	3.26	3.41	309791.0
2010-09-17	AAU-DELISTED	Stock	2.56	2.7	2.56	2.69	438001.0
2010-09-17	AAUAF-DELISTED	Stock	2.59	2.7	2.56	2.69	439212.0
2010-09-17	AAV-DELISTED	Stock	6.38	6.39	6.27	6.29	185727.0
2010-09-17	AAWW-DELISTED	Stock	48.78	49.0	47.31	48.245	330482.0
2010-09-17	AAXJ	Stock	58.42	58.58	58.2	58.25	138124.0
2010-09-17	AAXN-DELISTED	Stock	3.95	3.96	3.8	3.87	718066.0
2010-09-17	AB	Stock	25.89	25.99	25.43	25.74	193200.0
2010-09-17	ABAC-DELISTED	Stock	4.05	4.05	3.8	3.8	5553.0
2010-09-17	ABAX-DELISTED	Stock	20.46	20.89	20.1625	20.82	150200.0
2010-09-17	ABB-DELISTED	Stock	20.68	20.7	20.47	20.59	1231039.0
2010-09-17	ABBC-DELISTED	Stock	10.42	10.49	10.33	10.39	78649.0
2010-09-17	ABBNY-DELISTED	Stock	20.67	20.7	20.47	20.6	1257701.0
2010-09-17	ABC-DELISTED	Stock	30.26	30.5	30.05	30.16	2648257.0
2010-09-17	ABCB	Stock	8.78	8.82	8.53	8.65	83000.0
2010-09-17	ABCD-DELISTED	Stock	3.18	3.18	3.13	3.16	88137.0
2010-09-17	ABCO-DELISTED	Stock	21.33	21.44	21.0	21.23	153640.0
2010-09-17	ABCW-DELISTED	Stock	0.74	0.74	0.68	0.68	105890.0
2010-09-17	ABD-DELISTED	Stock	6.01	6.07	5.77	5.91	305430.0
2010-09-17	ABE-DELISTED	Stock	17.62	17.7199	17.62	17.7199	2910.0
2010-09-17	ABEO	Stock	2500.0	2750.0	2437.5	2750.0	48.0
2010-09-17	ABFS-DELISTED	Stock	24.77	24.86	23.33	23.57	771095.0
2010-09-17	ABG	Stock	12.52	12.6	12.08	12.24	189200.0
2010-09-17	ABII-DELISTED	Stock	75.18	75.2	74.93	75.08	18191.0
2010-09-17	ABK-DELISTED	Stock	0.5302	0.56	0.5302	0.56	4641281.0
2010-09-17	ABM	Stock	21.68	21.71	21.14	21.57	327000.0
2010-09-17	ABMD-DELISTED	Stock	9.97	10.03	9.8	9.99	172729.0
2010-09-17	ABR	Stock	4.83	4.96	4.73	4.82	121700.0
2010-09-17	ABT	Stock	24.844	24.916	24.7241	24.7769	15078366.0
2010-09-17	ABTL-DELISTED	Stock	4.5542	4.5542	4.0482	4.2	78659.0
2010-09-17	ABV-DELISTED	Stock	121.0	121.5499	118.85	120.02	471082.0
2010-09-17	ABVA-DELISTED	Stock	2.75	2.75	2.65	2.67	16543.0
2010-09-17	ABVT-DELISTED	Stock	51.66	52.2975	51.15	51.97	153108.0

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

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