PREVIEW / stock_daily / 2010-10-20

all stock daily files

  file:    by_date/stock_daily/2010/2010-10-20.parquet
  size:    193 KB
  rows:    5,992
  symbols: 3,517

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
2010-10-20	AAPL	Stock	11.0357	11.2232	10.9596	11.0904	721624400.0
2010-10-20	MSFT	Stock	25.26	25.4	25.1	25.31	56283600.0
2010-10-20	NVDA	Stock	0.2825	0.29	0.2775	0.2822	763532000.0
2010-10-20	AMZN	Stock	7.939	7.9935	7.8285	7.9335	115808000.0
2010-10-20	TSLA	Stock	1.344	1.3793	1.336	1.3767	4687500.0
2010-10-20	TLT	Stock	101.37	102.2801	101.21	101.91	5515783.0
2010-10-20	ES	Stock	30.81	31.01	30.74	30.9	1741600.0
2010-10-20	CL	Stock	38.235	38.76	38.15	38.59	6251600.0
2010-10-20	A	Stock	24.4206	24.9285	24.3848	24.7926	3486612.0
2010-10-20	AABA-DELISTED	Stock	15.79	16.25	15.785	15.8	37151409.0
2010-10-20	AACC-DELISTED	Stock	5.63	5.75	5.44	5.75	16642.0
2010-10-20	AACG	Stock	3.5	3.5	3.25	3.25	200.0
2010-10-20	AAI-DELISTED	Stock	7.37	7.46	7.365	7.43	15367759.0
2010-10-20	AAIC-DELISTED	Stock	23.31	23.54	23.27	23.45	47359.0
2010-10-20	AAME	Stock	1.71	1.71	1.71	1.71	100.0
2010-10-20	AAON	Stock	4.8928	4.9363	4.8553	4.8711	82012.0
2010-10-20	AAP	Stock	60.56	61.16	60.21	61.15	757600.0
2010-10-20	AATI-DELISTED	Stock	3.82	3.89	3.73	3.86	89123.0
2010-10-20	AAU-DELISTED	Stock	2.52	2.6699	2.51	2.56	248029.0
2010-10-20	AAUAF-DELISTED	Stock	2.52	2.6699	2.51	2.56	249129.0
2010-10-20	AAV-DELISTED	Stock	6.14	6.34	6.14	6.26	288824.0
2010-10-20	AAWW-DELISTED	Stock	53.09	55.17	52.77	54.74	149418.0
2010-10-20	AAXJ	Stock	62.19	62.9	62.08	62.5	749580.0
2010-10-20	AAXN-DELISTED	Stock	4.29	4.535	4.29	4.45	459224.0
2010-10-20	AB	Stock	26.15	26.68	26.15	26.42	259700.0
2010-10-20	ABAC-DELISTED	Stock	5.4	5.86	5.33	5.45	139295.0
2010-10-20	ABAX-DELISTED	Stock	23.67	24.4	23.67	23.81	74467.0
2010-10-20	ABB-DELISTED	Stock	22.11	22.6	22.11	22.46	1565345.0
2010-10-20	ABBC-DELISTED	Stock	10.67	10.84	10.59	10.67	23813.0
2010-10-20	ABBNY-DELISTED	Stock	22.11	22.6	22.11	22.45	1725021.0
2010-10-20	ABC-DELISTED	Stock	31.66	31.98	31.65	31.83	1950007.0
2010-10-20	ABCB	Stock	9.2	9.39	9.03	9.23	30900.0
2010-10-20	ABCD-DELISTED	Stock	3.32	3.38	3.29	3.32	12621.0
2010-10-20	ABCO-DELISTED	Stock	23.37	23.42	23.19	23.22	96575.0
2010-10-20	ABCW-DELISTED	Stock	0.6806	0.6893	0.6494	0.6794	9990.0
2010-10-20	ABD-DELISTED	Stock	5.83	6.1409	5.83	6.0	286450.0
2010-10-20	ABE-DELISTED	Stock	19.25	19.31	19.16	19.3	16860.0
2010-10-20	ABEO	Stock	3600.0	3687.5	3587.5	3687.5	55.0
2010-10-20	ABFS-DELISTED	Stock	24.95	25.85	24.8	25.59	247374.0
2010-10-20	ABG	Stock	14.58	14.75	14.46	14.66	83600.0
2010-10-20	ABK-DELISTED	Stock	1.11	1.14	0.9534	0.9806	52372256.0
2010-10-20	ABM	Stock	22.37	22.81	22.36	22.49	150400.0
2010-10-20	ABMD-DELISTED	Stock	10.68	10.9	10.6501	10.7	86669.0
2010-10-20	ABR	Stock	5.34	5.48	5.22	5.24	50500.0
2010-10-20	ABT	Stock	25.036	25.2135	24.7913	25.1511	22703210.0
2010-10-20	ABTL-DELISTED	Stock	4.2001	4.2001	4.0829	4.1	8175.0
2010-10-20	ABV-DELISTED	Stock	138.53	140.45	138.16	139.36	554255.0
2010-10-20	ABVA-DELISTED	Stock	2.701	2.96	2.701	2.78	7258.0
2010-10-20	ABVT-DELISTED	Stock	54.5	55.03	54.29	54.74	108154.0
2010-10-20	ABX-DELISTED	Stock	45.49	46.5	45.42	45.95	9494294.0

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

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