PREVIEW / stock_daily / 2010-09-14

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-14.parquet
  size:    190 KB
  rows:    5,942
  symbols: 3,492

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-09-14	AAPL	Stock	9.5075	9.6132	9.4829	9.5736	408150400.0
2010-09-14	MSFT	Stock	25.04	25.35	24.89	25.03	87160400.0
2010-09-14	NVDA	Stock	0.2638	0.267	0.2612	0.2635	698536000.0
2010-09-14	AMZN	Stock	7.225	7.335	7.1915	7.2875	86388000.0
2010-09-14	TSLA	Stock	1.3693	1.44	1.3687	1.408	9820500.0
2010-09-14	TLT	Stock	103.03	103.82	102.97	103.81	5978667.0
2010-09-14	ES	Stock	29.8	30.15	29.59	29.92	1453000.0
2010-09-14	CL	Stock	37.515	37.895	37.515	37.715	5886600.0
2010-09-14	A	Stock	20.7582	21.0014	20.4936	20.8655	3676740.0
2010-09-14	AABA-DELISTED	Stock	13.76	13.76	13.6	13.63	22754997.0
2010-09-14	AACC-DELISTED	Stock	3.83	3.83	3.65	3.68	15134.0
2010-09-14	AAI-DELISTED	Stock	4.32	4.46	4.29	4.39	1307410.0
2010-09-14	AAIC-DELISTED	Stock	22.38	22.4499	22.08	22.14	21196.0
2010-09-14	AAME	Stock	1.5	1.53	1.5	1.52	7900.0
2010-09-14	AAON	Stock	4.5906	4.6341	4.557	4.6123	245531.0
2010-09-14	AAP	Stock	56.58	57.58	56.42	57.36	827900.0
2010-09-14	AATI-DELISTED	Stock	3.45	3.47	3.4	3.4	159961.0
2010-09-14	AAU-DELISTED	Stock	2.52	2.6847	2.51	2.52	388081.0
2010-09-14	AAUAF-DELISTED	Stock	2.53	2.69	2.51	2.51	394163.0
2010-09-14	AAV-DELISTED	Stock	6.36	6.4117	6.25	6.27	327626.0
2010-09-14	AAWW-DELISTED	Stock	47.66	48.43	47.35	47.37	110816.0
2010-09-14	AAXJ	Stock	57.99	58.5	57.92	58.35	1314678.0
2010-09-14	AAXN-DELISTED	Stock	4.03	4.04	3.95	3.98	243379.0
2010-09-14	AB	Stock	25.93	26.36	25.5	26.17	402900.0
2010-09-14	ABAC-DELISTED	Stock	4.097	4.097	3.99	4.0	20400.0
2010-09-14	ABAX-DELISTED	Stock	19.89	20.21	19.75	19.91	70850.0
2010-09-14	ABB-DELISTED	Stock	20.4	20.69	20.32	20.55	917391.0
2010-09-14	ABBC-DELISTED	Stock	10.47	10.5	10.32	10.33	36296.0
2010-09-14	ABBNY-DELISTED	Stock	20.4	20.69	20.32	20.54	933465.0
2010-09-14	ABC-DELISTED	Stock	28.38	29.14	28.38	29.09	2790404.0
2010-09-14	ABCB	Stock	8.54	8.82	8.5	8.61	35900.0
2010-09-14	ABCD-DELISTED	Stock	3.12	3.15	3.05	3.13	28979.0
2010-09-14	ABCO-DELISTED	Stock	21.91	21.92	21.55	21.59	138894.0
2010-09-14	ABCW-DELISTED	Stock	0.72	0.72	0.68	0.69	44110.0
2010-09-14	ABD-DELISTED	Stock	6.43	6.6001	6.36	6.51	251570.0
2010-09-14	ABE-DELISTED	Stock	17.75	17.9	17.65	17.758	9325.0
2010-09-14	ABEO	Stock	2500.0	2625.0	2462.5	2500.0	37.0
2010-09-14	ABFS-DELISTED	Stock	23.35	23.46	23.02	23.37	222804.0
2010-09-14	ABG	Stock	12.77	12.82	12.65	12.69	383600.0
2010-09-14	ABII-DELISTED	Stock	74.6	75.0	74.6	74.81	11699.0
2010-09-14	ABK-DELISTED	Stock	0.52	0.57	0.5199	0.5501	8279423.0
2010-09-14	ABM	Stock	21.86	22.01	21.71	21.87	161200.0
2010-09-14	ABMD-DELISTED	Stock	9.94	10.21	9.865	10.12	107929.0
2010-09-14	ABR	Stock	4.64	4.64	4.47	4.57	23700.0
2010-09-14	ABT	Stock	24.6713	24.7721	24.5226	24.6665	11609421.0
2010-09-14	ABTL-DELISTED	Stock	4.0245	4.2761	3.9239	4.1	13962.0
2010-09-14	ABV-DELISTED	Stock	116.27	119.52	115.701	118.98	618261.0
2010-09-14	ABVA-DELISTED	Stock	2.75	2.75	2.75	2.75	230.0
2010-09-14	ABVT-DELISTED	Stock	52.54	52.54	51.91	52.09	54882.0
2010-09-14	ABX-DELISTED	Stock	45.13	45.87	44.93	45.21	12822197.0

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

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