PREVIEW / stock_daily / 2009-09-01

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-01.parquet
  size:    184 KB
  rows:    5,822
  symbols: 3,471

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-09-01	AAPL	Stock	5.9996	6.0714	5.8907	5.9036	469028000.0
2009-09-01	MSFT	Stock	24.35	24.74	23.9	24.0	62608500.0
2009-09-01	NVDA	Stock	0.3628	0.373	0.3488	0.3508	736856000.0
2009-09-01	AMZN	Stock	4.037	4.121	3.95	3.958	124916000.0
2009-09-01	TLT	Stock	95.82	96.5801	95.14	96.06	3304132.0
2009-09-01	ES	Stock	23.88	24.05	23.55	23.79	1645900.0
2009-09-01	CL	Stock	36.2	36.375	35.785	35.89	4819600.0
2009-09-01	A	Stock	18.2475	18.834	18.226	18.4907	9285935.0
2009-09-01	AABA-DELISTED	Stock	14.49	14.68	14.15	14.17	29647589.0
2009-09-01	AACC-DELISTED	Stock	7.25	7.58	6.94	7.08	119597.0
2009-09-01	AACG	Stock	7.1	7.2	6.71	7.09	11100.0
2009-09-01	AAI-DELISTED	Stock	6.63	6.82	6.2	6.26	2143015.0
2009-09-01	AAIC-DELISTED	Stock	10.0	10.202	9.2	9.4	1350833.0
2009-09-01	AAME	Stock	0.78	0.78	0.75	0.76	2500.0
2009-09-01	AAON	Stock	4.1284	4.2074	4.0652	4.0988	324000.0
2009-09-01	AAP	Stock	42.04	42.75	41.16	41.54	1706300.0
2009-09-01	AATI-DELISTED	Stock	4.47	4.6	4.38	4.39	216547.0
2009-09-01	AAU-DELISTED	Stock	0.67	0.67	0.605	0.63	153482.0
2009-09-01	AAUAF-DELISTED	Stock	0.67	0.67	0.605	0.63	158817.0
2009-09-01	AAV-DELISTED	Stock	5.63	5.72	5.36	5.39	893214.0
2009-09-01	AAWW-DELISTED	Stock	24.75	25.64	24.14	24.15	279700.0
2009-09-01	AAXJ	Stock	48.17	49.0	47.34	47.44	115075.0
2009-09-01	AAXN-DELISTED	Stock	4.56	4.69	4.45	4.47	425160.0
2009-09-01	AB	Stock	22.47	23.2	21.95	22.0	829400.0
2009-09-01	ABAX-DELISTED	Stock	26.38	26.99	25.65	25.84	285875.0
2009-09-01	ABB-DELISTED	Stock	18.65	19.06	18.3	18.4	5162606.0
2009-09-01	ABBC-DELISTED	Stock	8.01	8.18	8.01	8.03	49383.0
2009-09-01	ABBNY-DELISTED	Stock	18.65	19.06	18.3	18.37	5244027.0
2009-09-01	ABC-DELISTED	Stock	21.22	21.46	21.09	21.2	2857618.0
2009-09-01	ABCB	Stock	6.1957	6.3513	6.0303	6.0401	38966.0
2009-09-01	ABCO-DELISTED	Stock	13.298	14.397	13.073	13.407	199616.0
2009-09-01	ABCW-DELISTED	Stock	1.32	1.34	1.21	1.25	68850.0
2009-09-01	ABD-DELISTED	Stock	5.63	5.8	5.5	5.61	477770.0
2009-09-01	ABE-DELISTED	Stock	16.14	16.33	16.14	16.27	55303.0
2009-09-01	ABEO	Stock	4962.5	5000.0	4700.0	4750.0	24.0
2009-09-01	ABFS-DELISTED	Stock	31.61	33.07	31.59	31.79	709319.0
2009-09-01	ABG	Stock	12.62	13.75	12.27	12.39	521100.0
2009-09-01	ABII-DELISTED	Stock	26.58	27.1299	26.5	26.86	28808.0
2009-09-01	ABK-DELISTED	Stock	1.7	1.84	1.53	1.59	37068375.0
2009-09-01	ABM	Stock	22.37	22.96	22.01	22.26	151000.0
2009-09-01	ABMD-DELISTED	Stock	8.26	8.41	7.89	7.95	196889.0
2009-09-01	ABR	Stock	1.96	2.02	1.86	1.88	194800.0
2009-09-01	ABT	Stock	21.6294	21.9461	21.5142	21.6486	15665069.0
2009-09-01	ABTL-DELISTED	Stock	3.0	3.3	3.0	3.3	23798.0
2009-09-01	ABV-DELISTED	Stock	74.42	75.26	71.81	72.18	695243.0
2009-09-01	ABVA-DELISTED	Stock	2.35	2.8	2.35	2.75	5117.0
2009-09-01	ABVT-DELISTED	Stock	91.17	92.25	85.78	87.96	71944.0
2009-09-01	ABX-DELISTED	Stock	34.91	35.44	34.42	35.05	14319249.0
2009-09-01	ACAD	Stock	1.72	2.23	1.69	2.0	50927800.0
2009-09-01	ACAP-DELISTED	Stock	29.83	33.5	29.83	32.15	96011.0

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

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