PREVIEW / stock_daily / 2009-11-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-11-09.parquet
  size:    187 KB
  rows:    5,871
  symbols: 3,491

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-11-09	AAPL	Stock	7.0336	7.2107	7.0093	7.195	528855600.0
2009-11-09	MSFT	Stock	28.62	29.0	28.53	28.99	57518000.0
2009-11-09	NVDA	Stock	0.3335	0.3413	0.3333	0.3365	818124000.0
2009-11-09	AMZN	Stock	6.3555	6.416	6.2795	6.3335	172484000.0
2009-11-09	TLT	Stock	93.28	93.7	93.13	93.44	1697715.0
2009-11-09	ES	Stock	23.22	23.32	23.1	23.27	1321700.0
2009-11-09	CL	Stock	40.02	40.655	39.575	40.615	6299400.0
2009-11-09	A	Stock	18.9056	19.2847	18.8484	19.2847	2661512.0
2009-11-09	AABA-DELISTED	Stock	16.12	16.19	15.97	16.0	14759500.0
2009-11-09	AACC-DELISTED	Stock	5.35	5.67	5.3001	5.42	63421.0
2009-11-09	AACG	Stock	4.94	4.94	4.12	4.4	221900.0
2009-11-09	AAI-DELISTED	Stock	4.71	4.79	4.49	4.67	3875740.0
2009-11-09	AAIC-DELISTED	Stock	11.78	12.87	11.63	12.68	150816.0
2009-11-09	AAME	Stock	1.26	1.48	1.25	1.48	10200.0
2009-11-09	AAON	Stock	3.8519	3.9249	3.8459	3.921	324506.0
2009-11-09	AAP	Stock	38.22	38.62	38.0	38.19	2695500.0
2009-11-09	AATI-DELISTED	Stock	3.1	3.14	3.06	3.07	404480.0
2009-11-09	AAU-DELISTED	Stock	0.76	0.76	0.691	0.7	140556.0
2009-11-09	AAUAF-DELISTED	Stock	0.76	0.76	0.691	0.7	143656.0
2009-11-09	AAV-DELISTED	Stock	6.55	6.71	6.51	6.53	576434.0
2009-11-09	AAWW-DELISTED	Stock	27.4	28.5991	27.32	28.32	578842.0
2009-11-09	AAXJ	Stock	54.24	55.0	54.04	55.0	174187.0
2009-11-09	AAXN-DELISTED	Stock	4.42	4.47	4.37	4.41	383935.0
2009-11-09	AB	Stock	26.48	27.2	26.41	27.0	348700.0
2009-11-09	ABAX-DELISTED	Stock	23.04	23.69	22.96	23.39	85710.0
2009-11-09	ABB-DELISTED	Stock	19.81	20.02	19.8	19.92	2804364.0
2009-11-09	ABBC-DELISTED	Stock	6.84	6.84	6.55	6.67	58795.0
2009-11-09	ABBNY-DELISTED	Stock	19.81	20.02	19.8	19.92	2942989.0
2009-11-09	ABC-DELISTED	Stock	23.75	23.855	23.53	23.83	2370672.0
2009-11-09	ABCB	Stock	5.3221	5.8808	5.3221	5.871	43260.0
2009-11-09	ABCO-DELISTED	Stock	13.01	13.275	12.91	13.27	90400.0
2009-11-09	ABCW-DELISTED	Stock	0.61	0.61	0.5	0.53	355040.0
2009-11-09	ABD-DELISTED	Stock	6.38	6.95	6.36	6.79	304790.0
2009-11-09	ABE-DELISTED	Stock	16.7	16.8	16.63	16.8	22612.0
2009-11-09	ABEO	Stock	4000.0	4000.0	3750.0	3875.0	23.0
2009-11-09	ABFS-DELISTED	Stock	24.3	24.3	23.85	23.92	267614.0
2009-11-09	ABG	Stock	10.53	10.87	10.5	10.75	307900.0
2009-11-09	ABII-DELISTED	Stock	34.9	35.56	34.045	35.44	50772.0
2009-11-09	ABK-DELISTED	Stock	1.21	1.22	1.17	1.18	15670646.0
2009-11-09	ABM	Stock	19.08	19.27	18.96	19.27	100600.0
2009-11-09	ABMD-DELISTED	Stock	9.3	9.63	9.3	9.49	661136.0
2009-11-09	ABR	Stock	1.86	2.0	1.82	1.98	135100.0
2009-11-09	ABT	Stock	24.844	25.1415	24.7337	25.1175	10869529.0
2009-11-09	ABTL-DELISTED	Stock	4.15	4.3	3.9995	4.25	8297.0
2009-11-09	ABV-DELISTED	Stock	97.53	101.17	97.25	99.71	921414.0
2009-11-09	ABVA-DELISTED	Stock	2.2	2.2	2.2	2.2	1000.0
2009-11-09	ABVT-DELISTED	Stock	54.29	55.96	53.665	54.79	135842.0
2009-11-09	ABX-DELISTED	Stock	42.92	43.47	42.48	42.95	16015174.0
2009-11-09	ACAD	Stock	1.4	1.44	1.33	1.39	489100.0
2009-11-09	ACAP-DELISTED	Stock	28.62	29.52	28.49	29.52	40979.0

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

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