PREVIEW / stock_daily / 2009-10-01

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-01.parquet
  size:    186 KB
  rows:    5,820
  symbols: 3,461

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-01	AAPL	Stock	6.6196	6.6507	6.4536	6.4593	524711600.0
2009-10-01	MSFT	Stock	25.41	25.47	24.8	24.88	75958100.0
2009-10-01	NVDA	Stock	0.3745	0.3745	0.3488	0.349	999960000.0
2009-10-01	AMZN	Stock	4.625	4.645	4.5185	4.552	132902000.0
2009-10-01	TLT	Stock	98.96	100.06	98.8016	99.7	5755859.0
2009-10-01	ES	Stock	23.62	23.89	23.35	23.35	1610900.0
2009-10-01	CL	Stock	38.3	38.3	37.73	37.91	6378800.0
2009-10-01	A	Stock	19.0486	19.5422	18.8197	19.0343	7631123.0
2009-10-01	AABA-DELISTED	Stock	17.69	17.72	17.2	17.4	24576393.0
2009-10-01	AACC-DELISTED	Stock	7.24	7.49	6.96	7.0	29621.0
2009-10-01	AACG	Stock	5.61	5.69	5.6	5.66	1700.0
2009-10-01	AAI-DELISTED	Stock	6.24	6.24	5.75	5.79	2155335.0
2009-10-01	AAIC-DELISTED	Stock	9.82	9.82	9.4	9.5	782413.0
2009-10-01	AAME	Stock	1.09	1.12	1.09	1.1	5600.0
2009-10-01	AAON	Stock	3.9585	4.0	3.7985	3.8064	373612.0
2009-10-01	AAP	Stock	39.25	39.25	37.79	37.94	2916800.0
2009-10-01	AATI-DELISTED	Stock	3.95	3.95	3.49	3.49	513886.0
2009-10-01	AAU-DELISTED	Stock	0.68	0.73	0.68	0.7	113567.0
2009-10-01	AAUAF-DELISTED	Stock	0.68	0.73	0.68	0.7	113767.0
2009-10-01	AAV-DELISTED	Stock	7.03	7.03	6.61	6.61	928832.0
2009-10-01	AAWW-DELISTED	Stock	31.66	31.86	29.47	29.5	375879.0
2009-10-01	AAXJ	Stock	52.29	52.8	51.25	51.45	514171.0
2009-10-01	AAXN-DELISTED	Stock	4.76	4.77	4.52	4.52	367733.0
2009-10-01	AB	Stock	27.16	27.72	25.76	25.84	507400.0
2009-10-01	ABAX-DELISTED	Stock	26.76	26.84	26.0	26.07	205430.0
2009-10-01	ABB-DELISTED	Stock	19.85	19.89	19.44	19.458	2481354.0
2009-10-01	ABBC-DELISTED	Stock	7.71	7.77	7.55	7.57	54107.0
2009-10-01	ABBNY-DELISTED	Stock	19.85	19.89	19.44	19.46	2502965.0
2009-10-01	ABC-DELISTED	Stock	22.36	22.49	21.85	22.0175	3927230.0
2009-10-01	ABCB	Stock	6.9589	6.9589	6.1552	6.1552	16120.0
2009-10-01	ABCO-DELISTED	Stock	12.455	13.15	12.38	12.995	156134.0
2009-10-01	ABCW-DELISTED	Stock	1.2698	1.3392	1.2301	1.24	82840.0
2009-10-01	ABD-DELISTED	Stock	7.2	7.28	6.88	6.89	453370.0
2009-10-01	ABE-DELISTED	Stock	17.63	17.63	17.15	17.2	20367.0
2009-10-01	ABEO	Stock	3687.5	3687.5	3537.5	3600.0	43.0
2009-10-01	ABFS-DELISTED	Stock	29.6	30.27	28.78	28.86	563482.0
2009-10-01	ABG	Stock	12.47	12.54	12.15	12.31	283300.0
2009-10-01	ABII-DELISTED	Stock	36.68	36.85	35.91	36.576	60311.0
2009-10-01	ABK-DELISTED	Stock	1.69	1.7	1.5	1.51	17267702.0
2009-10-01	ABM	Stock	20.91	21.0	20.13	20.2	160700.0
2009-10-01	ABMD-DELISTED	Stock	9.71	9.71	9.35	9.5	440771.0
2009-10-01	ABR	Stock	2.8	2.89	2.57	2.89	292100.0
2009-10-01	ABT	Stock	23.7309	23.87	23.3279	23.3567	22585244.0
2009-10-01	ABTL-DELISTED	Stock	3.2	3.45	3.151	3.2	7094.0
2009-10-01	ABV-DELISTED	Stock	84.09	84.35	81.59	83.18	1060682.0
2009-10-01	ABVA-DELISTED	Stock	2.59	2.59	2.59	2.59	140.0
2009-10-01	ABVT-DELISTED	Stock	48.76	48.76	46.86	47.75	143000.0
2009-10-01	ABX-DELISTED	Stock	38.11	38.12	36.075	36.17	12591740.0
2009-10-01	ACAD	Stock	1.64	1.65	1.54	1.58	1271400.0
2009-10-01	ACAP-DELISTED	Stock	28.76	29.24	28.44	28.76	43894.0

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

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