PREVIEW / stock_daily / 2010-09-24

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-24.parquet
  size:    192 KB
  rows:    5,978
  symbols: 3,511

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-24	AAPL	Stock	10.4321	10.4832	10.3768	10.44	649488000.0
2010-09-24	MSFT	Stock	24.64	24.8	24.58	24.78	51948800.0
2010-09-24	NVDA	Stock	0.297	0.3075	0.2948	0.3065	1086976000.0
2010-09-24	AMZN	Stock	7.7715	8.0445	7.771	8.0365	211812000.0
2010-09-24	TSLA	Stock	1.33	1.346	1.31	1.34	8683500.0
2010-09-24	TLT	Stock	103.96	104.115	103.5	103.5	8942492.0
2010-09-24	ES	Stock	29.3	29.6	29.26	29.6	1069500.0
2010-09-24	CL	Stock	39.32	39.495	39.065	39.26	5762800.0
2010-09-24	A	Stock	22.1531	23.0043	22.1531	22.9542	5083967.0
2010-09-24	AABA-DELISTED	Stock	14.28	14.51	14.24	14.49	24105477.0
2010-09-24	AACC-DELISTED	Stock	4.52	4.66	4.52	4.58	42141.0
2010-09-24	AAI-DELISTED	Stock	4.46	4.53	4.45	4.53	1091932.0
2010-09-24	AAIC-DELISTED	Stock	23.17	24.08	23.08	24.01	42280.0
2010-09-24	AAME	Stock	1.81	1.85	1.81	1.84	800.0
2010-09-24	AAON	Stock	4.5926	4.7368	4.5412	4.7289	185794.0
2010-09-24	AAP	Stock	59.27	59.9	58.97	59.61	870800.0
2010-09-24	AATI-DELISTED	Stock	3.49	3.49	3.43	3.47	145251.0
2010-09-24	AAU-DELISTED	Stock	2.7698	2.82	2.57	2.58	360215.0
2010-09-24	AAUAF-DELISTED	Stock	2.7698	2.82	2.57	2.58	361325.0
2010-09-24	AAV-DELISTED	Stock	6.07	6.14	6.0	6.12	358350.0
2010-09-24	AAWW-DELISTED	Stock	54.82	55.26	54.27	55.01	249445.0
2010-09-24	AAXJ	Stock	59.45	59.97	59.41	59.91	617620.0
2010-09-24	AAXN-DELISTED	Stock	3.9	4.0	3.89	3.98	313454.0
2010-09-24	AB	Stock	25.39	26.0	25.39	25.72	326100.0
2010-09-24	ABAC-DELISTED	Stock	3.76	3.95	3.68	3.76	45372.0
2010-09-24	ABAX-DELISTED	Stock	22.03	22.582	21.76	22.37	118153.0
2010-09-24	ABB-DELISTED	Stock	21.04	21.21	21.0	21.11	4280595.0
2010-09-24	ABBC-DELISTED	Stock	10.14	10.3	10.01	10.275	77922.0
2010-09-24	ABBNY-DELISTED	Stock	21.04	21.21	21.0	21.11	4314689.0
2010-09-24	ABC-DELISTED	Stock	30.61	31.37	30.61	31.34	2259158.0
2010-09-24	ABCB	Stock	8.91	9.25	8.86	9.24	62200.0
2010-09-24	ABCD-DELISTED	Stock	3.25	3.29	3.15	3.25	38751.0
2010-09-24	ABCO-DELISTED	Stock	21.55	21.72	21.36	21.53	130523.0
2010-09-24	ABCW-DELISTED	Stock	0.71	0.71	0.68	0.68	114900.0
2010-09-24	ABD-DELISTED	Stock	5.6649	5.9651	5.6148	5.9451	412730.0
2010-09-24	ABE-DELISTED	Stock	18.01	18.13	18.01	18.13	9059.0
2010-09-24	ABEO	Stock	2725.0	2762.5	2625.0	2737.5	25.0
2010-09-24	ABFS-DELISTED	Stock	23.2	24.11	23.08	23.82	208166.0
2010-09-24	ABG	Stock	12.95	13.44	12.85	13.41	177800.0
2010-09-24	ABII-DELISTED	Stock	76.0	76.82	76.0	76.82	60719.0
2010-09-24	ABK-DELISTED	Stock	0.5544	0.57	0.54	0.554	4845017.0
2010-09-24	ABM	Stock	21.8	21.8	21.41	21.65	440800.0
2010-09-24	ABMD-DELISTED	Stock	10.32	10.44	10.11	10.44	114613.0
2010-09-24	ABR	Stock	4.94	5.04	4.89	4.98	101900.0
2010-09-24	ABT	Stock	24.9448	25.1079	24.8296	24.9208	13700500.0
2010-09-24	ABTL-DELISTED	Stock	4.2	4.25	4.1115	4.25	3300.0
2010-09-24	ABV-DELISTED	Stock	120.7	122.5	119.46	119.86	628689.0
2010-09-24	ABVT-DELISTED	Stock	52.88	53.1	52.24	53.08	88299.0
2010-09-24	ABX-DELISTED	Stock	47.51	47.51	46.19	46.34	7085885.0
2010-09-24	ACAD	Stock	0.98	1.0	0.96	0.98	197000.0

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

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