PREVIEW / stock_daily / 2010-11-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-11-23.parquet
  size:    193 KB
  rows:    6,019
  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-11-23	AAPL	Stock	11.0875	11.1339	10.9486	11.0261	519447600.0
2010-11-23	MSFT	Stock	25.57	25.6	25.09	25.12	69742500.0
2010-11-23	NVDA	Stock	0.34	0.3435	0.3335	0.336	457832000.0
2010-11-23	AMZN	Stock	8.4305	8.4405	8.231	8.41	129306000.0
2010-11-23	TSLA	Stock	2.2193	2.3787	2.146	2.3047	23667000.0
2010-11-23	TLT	Stock	97.67	97.95	97.24	97.48	9566845.0
2010-11-23	ES	Stock	31.44	31.55	31.12	31.44	1508600.0
2010-11-23	CL	Stock	38.905	38.925	38.7	38.88	3700800.0
2010-11-23	A	Stock	25.6509	25.6509	25.1216	25.3433	3200302.0
2010-11-23	AABA-DELISTED	Stock	16.34	16.43	16.04	16.22	22182560.0
2010-11-23	AACC-DELISTED	Stock	5.29	5.38	5.22	5.22	21416.0
2010-11-23	AAI-DELISTED	Stock	7.43	7.46	7.43	7.43	1137651.0
2010-11-23	AAIC-DELISTED	Stock	24.15	24.15	23.01	23.46	84735.0
2010-11-23	AAME	Stock	1.95	1.95	1.85	1.86	1800.0
2010-11-23	AAON	Stock	4.9304	4.9896	4.8948	4.9798	73912.0
2010-11-23	AAP	Stock	66.12	66.34	65.41	66.27	417900.0
2010-11-23	AATI-DELISTED	Stock	3.58	3.71	3.58	3.63	112470.0
2010-11-23	AAU-DELISTED	Stock	2.89	2.99	2.86	2.92	290993.0
2010-11-23	AAUAF-DELISTED	Stock	2.89	2.99	2.86	2.92	291693.0
2010-11-23	AAV-DELISTED	Stock	6.77	6.78	6.54	6.61	323954.0
2010-11-23	AAWW-DELISTED	Stock	56.43	56.43	54.62	54.89	166839.0
2010-11-23	AAXJ	Stock	61.05	61.23	60.75	61.07	1204296.0
2010-11-23	AAXN-DELISTED	Stock	4.05	4.09	4.0	4.05	231670.0
2010-11-23	AB	Stock	23.38	23.55	22.7	22.9	635800.0
2010-11-23	ABAC-DELISTED	Stock	5.89	6.24	5.75	6.11	36713.0
2010-11-23	ABAX-DELISTED	Stock	26.19	26.5	26.13	26.42	124831.0
2010-11-23	ABB-DELISTED	Stock	19.84	19.9	19.6	19.65	5350428.0
2010-11-23	ABBC-DELISTED	Stock	11.61	11.75	11.52	11.7	25082.0
2010-11-23	ABBNY-DELISTED	Stock	19.84	19.9	19.6	19.66	6750877.0
2010-11-23	ABC-DELISTED	Stock	30.85	31.045	30.69	30.94	2360750.0
2010-11-23	ABCB	Stock	9.53	9.75	9.53	9.68	30300.0
2010-11-23	ABCD-DELISTED	Stock	2.98	3.0	2.945	2.96	12635.0
2010-11-23	ABCO-DELISTED	Stock	23.85	23.85	23.39	23.53	112486.0
2010-11-23	ABCW-DELISTED	Stock	0.83	0.88	0.8	0.84	54740.0
2010-11-23	ABD-DELISTED	Stock	6.97	7.03	6.79	6.92	175480.0
2010-11-23	ABE-DELISTED	Stock	18.76	18.86	18.4608	18.49	7789.0
2010-11-23	ABEO	Stock	3625.0	3750.0	3412.5	3750.0	29.0
2010-11-23	ABFS-DELISTED	Stock	24.44	24.56	24.0	24.01	153964.0
2010-11-23	ABG	Stock	15.31	15.6	15.29	15.45	110200.0
2010-11-23	ABM	Stock	23.36	23.46	23.02	23.4	100300.0
2010-11-23	ABMD-DELISTED	Stock	11.41	11.68	11.151	11.6	87870.0
2010-11-23	ABR	Stock	5.34	5.41	5.34	5.38	23500.0
2010-11-23	ABT	Stock	22.6322	22.6466	22.4786	22.5266	18675490.0
2010-11-23	ABTL-DELISTED	Stock	4.0	4.0	3.8	3.9	438.0
2010-11-23	ABUS	Stock	5.47	5.47	5.38	5.38	18100.0
2010-11-23	ABV-DELISTED	Stock	142.82	143.0	138.97	139.52	552272.0
2010-11-23	ABVA-DELISTED	Stock	3.3	3.59	3.25	3.5899	7575.0
2010-11-23	ABVT-DELISTED	Stock	61.25	62.06	60.69	62.05	177498.0
2010-11-23	ABX-DELISTED	Stock	50.23	50.99	50.0	50.86	9358822.0
2010-11-23	ACAD	Stock	0.68	0.71	0.67	0.7	411300.0

> showing 50 of 6,019 rows — these rows as CSV

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