PREVIEW / stock_daily / 2009-10-29

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-29.parquet
  size:    187 KB
  rows:    5,872
  symbols: 3,485

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-29	AAPL	Stock	6.9643	7.0289	6.8621	7.0125	570270400.0
2009-10-29	MSFT	Stock	28.07	28.41	27.85	28.22	65225500.0
2009-10-29	NVDA	Stock	0.3052	0.3153	0.3025	0.3138	637100000.0
2009-10-29	AMZN	Stock	6.195	6.215	6.006	6.129	256436000.0
2009-10-29	TLT	Stock	94.82	95.0599	93.95	94.41	4645491.0
2009-10-29	ES	Stock	22.9	23.3	22.75	23.2	2023700.0
2009-10-29	CL	Stock	38.425	39.735	38.035	39.47	8522400.0
2009-10-29	A	Stock	18.2332	18.5336	18.133	18.4049	3485773.0
2009-10-29	AABA-DELISTED	Stock	16.16	16.38	15.74	16.13	37736309.0
2009-10-29	AACC-DELISTED	Stock	7.01	7.31	7.01	7.3	38073.0
2009-10-29	AACG	Stock	5.27	5.28	5.16	5.16	5000.0
2009-10-29	AAI-DELISTED	Stock	4.49	4.585	4.25	4.3	5983375.0
2009-10-29	AAIC-DELISTED	Stock	11.57	12.589	11.48	12.27	71778.0
2009-10-29	AAME	Stock	1.4	1.46	1.28	1.28	2100.0
2009-10-29	AAON	Stock	3.6286	3.7393	3.5951	3.6543	288562.0
2009-10-29	AAP	Stock	37.1	37.97	36.67	37.25	2939600.0
2009-10-29	AATI-DELISTED	Stock	3.46	3.535	3.11	3.17	2575393.0
2009-10-29	AAU-DELISTED	Stock	0.67	0.69	0.67	0.68	238960.0
2009-10-29	AAUAF-DELISTED	Stock	0.67	0.69	0.67	0.68	239910.0
2009-10-29	AAV-DELISTED	Stock	6.45	6.71	6.38	6.58	951959.0
2009-10-29	AAWW-DELISTED	Stock	26.55	27.445	25.88	26.38	2897635.0
2009-10-29	AAXJ	Stock	51.82	53.01	51.82	52.94	326953.0
2009-10-29	AAXN-DELISTED	Stock	4.08	4.23	4.06	4.21	573529.0
2009-10-29	AB	Stock	25.74	26.4	25.52	26.37	409100.0
2009-10-29	ABAX-DELISTED	Stock	23.6	24.16	23.24	23.31	325185.0
2009-10-29	ABB-DELISTED	Stock	19.37	19.68	19.12	19.59	9645544.0
2009-10-29	ABBC-DELISTED	Stock	6.96	6.98	6.81	6.93	47541.0
2009-10-29	ABBNY-DELISTED	Stock	19.37	19.68	19.12	19.56	9832949.0
2009-10-29	ABC-DELISTED	Stock	22.47	22.69	22.29	22.64	2834991.0
2009-10-29	ABCB	Stock	5.9983	6.1258	5.8808	6.116	56421.0
2009-10-29	ABCO-DELISTED	Stock	12.305	12.63	12.175	12.555	128441.0
2009-10-29	ABCW-DELISTED	Stock	0.7703	0.8098	0.7703	0.79	67900.0
2009-10-29	ABD-DELISTED	Stock	6.22	6.63	6.13	6.48	309370.0
2009-10-29	ABE-DELISTED	Stock	16.02	16.48	16.02	16.48	12958.0
2009-10-29	ABEO	Stock	3725.0	3825.0	3225.0	3562.5	81.0
2009-10-29	ABFS-DELISTED	Stock	26.04	26.8	25.9	26.65	335819.0
2009-10-29	ABG	Stock	12.08	12.44	11.02	11.26	492800.0
2009-10-29	ABII-DELISTED	Stock	32.02	33.35	31.8	32.07	35298.0
2009-10-29	ABK-DELISTED	Stock	1.13	1.19	1.08	1.18	11850329.0
2009-10-29	ABM	Stock	19.21	19.31	18.87	19.27	125100.0
2009-10-29	ABMD-DELISTED	Stock	9.43	9.73	9.3367	9.68	147210.0
2009-10-29	ABR	Stock	1.82	2.17	1.82	2.12	204600.0
2009-10-29	ABT	Stock	24.4794	24.4794	24.1243	24.4026	14063360.0
2009-10-29	ABTL-DELISTED	Stock	3.7	3.7755	3.6507	3.7	13468.0
2009-10-29	ABV-DELISTED	Stock	89.77	95.38	89.77	95.13	746162.0
2009-10-29	ABVA-DELISTED	Stock	2.45	2.45	2.45	2.45	200.0
2009-10-29	ABVT-DELISTED	Stock	52.2	52.56	50.88	51.05	104645.0
2009-10-29	ABX-DELISTED	Stock	35.34	37.23	35.32	37.04	15541390.0
2009-10-29	ACAD	Stock	1.39	1.41	1.33	1.36	493900.0
2009-10-29	ACAP-DELISTED	Stock	29.9	30.05	29.24	29.61	30936.0

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

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