PREVIEW / stock_daily / 2010-11-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-11-09.parquet
  size:    195 KB
  rows:    6,047
  symbols: 3,546

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-09	AAPL	Stock	11.4661	11.475	11.2321	11.2886	383544000.0
2010-11-09	MSFT	Stock	26.81	27.11	26.71	26.95	58538600.0
2010-11-09	NVDA	Stock	0.3165	0.319	0.313	0.3148	633964000.0
2010-11-09	AMZN	Stock	8.6335	8.657	8.453	8.5135	79572000.0
2010-11-09	TSLA	Stock	1.6667	1.7127	1.6033	1.642	14346000.0
2010-11-09	TLT	Stock	98.49	98.52	96.19	96.25	15064277.0
2010-11-09	ES	Stock	31.51	31.6	31.1	31.26	1403700.0
2010-11-09	CL	Stock	38.64	38.825	38.395	38.495	5745000.0
2010-11-09	A	Stock	25.8798	25.8798	25.2074	25.3791	4461158.0
2010-11-09	AABA-DELISTED	Stock	17.22	17.6	16.86	16.96	52476113.0
2010-11-09	AACC-DELISTED	Stock	5.93	5.93	5.76	5.79	7726.0
2010-11-09	AACG	Stock	3.36	3.36	3.31	3.31	4500.0
2010-11-09	AAI-DELISTED	Stock	7.45	7.47	7.42	7.45	4161890.0
2010-11-09	AAIC-DELISTED	Stock	25.49	25.49	24.82	24.92	25595.0
2010-11-09	AAME	Stock	1.78	1.85	1.66	1.8	8400.0
2010-11-09	AAON	Stock	4.9146	4.9165	4.8375	4.8849	189337.0
2010-11-09	AAP	Stock	66.2	66.3	65.52	66.01	1394600.0
2010-11-09	AATI-DELISTED	Stock	3.82	3.82	3.7	3.72	87015.0
2010-11-09	AAU-DELISTED	Stock	3.15	3.28	2.82	2.84	915021.0
2010-11-09	AAUAF-DELISTED	Stock	3.15	3.28	2.82	2.84	915421.0
2010-11-09	AAV-DELISTED	Stock	6.66	6.77	6.53	6.56	490203.0
2010-11-09	AAWW-DELISTED	Stock	62.0	62.0	58.82	59.23	165142.0
2010-11-09	AAXJ	Stock	65.61	65.8	64.7	64.91	397216.0
2010-11-09	AAXN-DELISTED	Stock	4.11	4.27	4.08	4.21	346393.0
2010-11-09	AB	Stock	25.02	25.33	24.61	24.67	390200.0
2010-11-09	ABAC-DELISTED	Stock	8.2	8.3599	7.2	7.2312	272244.0
2010-11-09	ABAX-DELISTED	Stock	25.93	26.36	25.6	25.83	64169.0
2010-11-09	ABB-DELISTED	Stock	21.58	21.725	21.27	21.38	2472645.0
2010-11-09	ABBC-DELISTED	Stock	11.44	12.41	11.23	12.14	470936.0
2010-11-09	ABBNY-DELISTED	Stock	21.57	21.725	21.27	21.38	2947823.0
2010-11-09	ABC-DELISTED	Stock	31.48	31.49	30.73	30.83	3876627.0
2010-11-09	ABCB	Stock	8.95	8.95	8.7	8.73	71100.0
2010-11-09	ABCD-DELISTED	Stock	3.15	3.1501	3.07	3.1	9814.0
2010-11-09	ABCO-DELISTED	Stock	23.99	24.46	23.6	24.2	192979.0
2010-11-09	ABCW-DELISTED	Stock	0.79	0.95	0.78	0.82	371190.0
2010-11-09	ABD-DELISTED	Stock	6.39	6.8	6.39	6.76	1045670.0
2010-11-09	ABE-DELISTED	Stock	19.46	19.49	19.16	19.17	12158.0
2010-11-09	ABEO	Stock	3787.5	3875.0	3775.0	3875.0	25.0
2010-11-09	ABFS-DELISTED	Stock	24.96	25.3	24.52	24.65	259474.0
2010-11-09	ABG	Stock	16.04	16.12	15.72	15.86	183400.0
2010-11-09	ABM	Stock	23.9	24.25	23.71	23.9	167000.0
2010-11-09	ABMD-DELISTED	Stock	12.03	12.06	11.72	11.79	146611.0
2010-11-09	ABR	Stock	5.5	5.78	5.5	5.54	56600.0
2010-11-09	ABT	Stock	24.2203	24.2587	23.9372	24.014	17928303.0
2010-11-09	ABTL-DELISTED	Stock	4.2	4.2	4.0	4.05	6760.0
2010-11-09	ABV-DELISTED	Stock	144.42	144.51	138.53	139.66	788701.0
2010-11-09	ABVA-DELISTED	Stock	3.19	3.3	3.19	3.2	2225.0
2010-11-09	ABVT-DELISTED	Stock	62.75	63.47	62.75	63.06	167064.0
2010-11-09	ABX-DELISTED	Stock	52.08	53.44	50.35	50.9	23356490.0
2010-11-09	ACAD	Stock	0.72	0.75	0.7	0.74	257300.0

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

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