PREVIEW / stock_daily / 2009-10-08

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-08.parquet
  size:    186 KB
  rows:    5,823
  symbols: 3,467

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
2009-10-08	AAPL	Stock	6.8093	6.8375	6.7461	6.7596	438211200.0
2009-10-08	MSFT	Stock	25.44	25.9	25.22	25.67	60521300.0
2009-10-08	NVDA	Stock	0.3495	0.3505	0.3373	0.3498	1241524000.0
2009-10-08	AMZN	Stock	4.74	4.836	4.7115	4.761	193486000.0
2009-10-08	TLT	Stock	99.71	99.76	97.68	98.15	5871552.0
2009-10-08	ES	Stock	23.28	23.43	23.24	23.43	1201700.0
2009-10-08	CL	Stock	39.065	39.515	38.91	39.355	4960000.0
2009-10-08	A	Stock	19.671	19.8498	19.5351	19.5994	4704969.0
2009-10-08	AABA-DELISTED	Stock	17.63	17.86	17.5404	17.59	27904399.0
2009-10-08	AACC-DELISTED	Stock	7.11	7.29	7.0713	7.18	29453.0
2009-10-08	AACG	Stock	6.18	6.19	6.01	6.03	2600.0
2009-10-08	AAI-DELISTED	Stock	5.13	5.485	5.12	5.23	30379108.0
2009-10-08	AAIC-DELISTED	Stock	11.49	11.64	10.545	11.35	173631.0
2009-10-08	AAME	Stock	1.39	1.45	1.25	1.33	24000.0
2009-10-08	AAON	Stock	3.7807	3.7965	3.6326	3.6425	617625.0
2009-10-08	AAP	Stock	38.78	39.21	38.26	38.38	2232000.0
2009-10-08	AATI-DELISTED	Stock	3.23	3.3	3.2	3.2	528154.0
2009-10-08	AAU-DELISTED	Stock	0.78	0.8	0.76	0.79	354875.0
2009-10-08	AAUAF-DELISTED	Stock	0.77	0.79	0.75	0.79	359733.0
2009-10-08	AAV-DELISTED	Stock	6.59	7.08	6.55	7.02	1385757.0
2009-10-08	AAWW-DELISTED	Stock	32.05	33.9	32.0	33.9	268113.0
2009-10-08	AAXJ	Stock	53.06	53.49	52.975	53.4	852318.0
2009-10-08	AAXN-DELISTED	Stock	4.56	4.62	4.5	4.5	344134.0
2009-10-08	AB	Stock	26.83	27.36	26.56	27.24	329800.0
2009-10-08	ABAX-DELISTED	Stock	27.23	27.97	26.98	27.04	227072.0
2009-10-08	ABB-DELISTED	Stock	20.53	20.87	20.36	20.64	3206690.0
2009-10-08	ABBC-DELISTED	Stock	7.99	7.99	7.9	7.91	59455.0
2009-10-08	ABBNY-DELISTED	Stock	20.53	20.87	20.36	20.62	3212273.0
2009-10-08	ABC-DELISTED	Stock	22.55	22.64	22.38	22.41	2292260.0
2009-10-08	ABCB	Stock	7.0176	7.0176	6.7138	6.7138	16324.0
2009-10-08	ABCO-DELISTED	Stock	12.977	13.203	12.942	13.083	120041.0
2009-10-08	ABCW-DELISTED	Stock	1.3	1.305	1.25	1.27	51340.0
2009-10-08	ABD-DELISTED	Stock	7.36	7.48	7.18	7.33	355730.0
2009-10-08	ABE-DELISTED	Stock	17.71	17.77	17.55	17.724	19035.0
2009-10-08	ABEO	Stock	4375.0	4437.5	4162.5	4262.5	38.0
2009-10-08	ABFS-DELISTED	Stock	28.61	29.43	28.56	29.04	426268.0
2009-10-08	ABG	Stock	12.77	13.4	12.37	12.89	430300.0
2009-10-08	ABII-DELISTED	Stock	38.2	38.54	37.594	38.419	64247.0
2009-10-08	ABK-DELISTED	Stock	1.55	1.57	1.5	1.51	8304340.0
2009-10-08	ABM	Stock	20.08	20.55	20.05	20.28	165400.0
2009-10-08	ABMD-DELISTED	Stock	10.26	10.41	10.1	10.28	215586.0
2009-10-08	ABR	Stock	2.61	2.76	2.61	2.71	162600.0
2009-10-08	ABT	Stock	24.1483	24.3498	23.9228	24.0428	12311588.0
2009-10-08	ABTL-DELISTED	Stock	3.2485	3.3015	2.9514	3.2015	18366.0
2009-10-08	ABV-DELISTED	Stock	89.6	90.83	89.29	90.55	414210.0
2009-10-08	ABVA-DELISTED	Stock	2.19	2.55	2.15	2.16	11695.0
2009-10-08	ABVT-DELISTED	Stock	48.99	49.1	48.401	48.7	246196.0
2009-10-08	ABX-DELISTED	Stock	39.66	40.21	39.0	39.52	18571404.0
2009-10-08	ACAD	Stock	1.85	1.87	1.79	1.79	936700.0
2009-10-08	ACAP-DELISTED	Stock	29.52	29.7699	29.241	29.26	55864.0

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

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