PREVIEW / stock_daily / 2012-10-25

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-25.parquet
  size:    199 KB
  rows:    6,184
  symbols: 3,501

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
2012-10-25	AAPL	Stock	22.1429	22.2143	21.6268	21.7693	656325600.0
2012-10-25	MSFT	Stock	28.19	28.2	27.86	27.88	54084300.0
2012-10-25	NVDA	Stock	0.3068	0.31	0.3032	0.3045	307356000.0
2012-10-25	AMZN	Stock	11.546	11.546	11.146	11.146	134826000.0
2012-10-25	META	Stock	23.29	23.31	22.47	22.56	76142000.0
2012-10-25	TSLA	Stock	1.8533	1.8533	1.83	1.8347	8665500.0
2012-10-25	TLT	Stock	120.56	121.54	120.33	120.86	5292472.0
2012-10-25	ES	Stock	39.02	39.29	38.66	39.01	1008600.0
2012-10-25	CL	Stock	53.5	53.5	51.525	52.3	6010000.0
2012-10-25	A	Stock	25.887	25.9084	25.5722	25.8298	4598022.0
2012-10-25	AABA-DELISTED	Stock	16.72	16.77	16.49	16.6	22688796.0
2012-10-25	AACC-DELISTED	Stock	7.24	7.24	6.93	7.04	5398.0
2012-10-25	AACG	Stock	5.14	5.14	4.85	5.08	1900.0
2012-10-25	AAIC-DELISTED	Stock	21.79	21.98	21.5	21.6	73476.0
2012-10-25	AAME	Stock	2.87	2.95	2.87	2.95	2200.0
2012-10-25	AAMRQ-DELISTED	Stock	0.37	0.37	0.361	0.363	453387.0
2012-10-25	AAON	Stock	6.0296	6.077	5.9141	5.997	82350.0
2012-10-25	AAP	Stock	67.08	68.2	67.08	67.9	835100.0
2012-10-25	AAT	Stock	27.7	27.76	26.92	27.22	67900.0
2012-10-25	AAU-DELISTED	Stock	2.64	2.674	2.58	2.6	47285.0
2012-10-25	AAUAF-DELISTED	Stock	2.63	2.664	2.57	2.61	47860.0
2012-10-25	AAV-DELISTED	Stock	3.52	3.57	3.46	3.5	92568.0
2012-10-25	AAWW-DELISTED	Stock	53.16	54.68	52.39	54.21	168262.0
2012-10-25	AAXJ	Stock	56.9	57.03	56.58	56.9	495637.0
2012-10-25	AAXN-DELISTED	Stock	6.54	6.54	6.38	6.4	613608.0
2012-10-25	AB	Stock	17.13	17.67	16.57	16.69	796300.0
2012-10-25	ABAC-DELISTED	Stock	1.3	1.37	1.28	1.3	10940.0
2012-10-25	ABAX-DELISTED	Stock	34.52	35.18	34.27	34.91	81837.0
2012-10-25	ABB-DELISTED	Stock	18.66	18.71	18.43	18.51	2350516.0
2012-10-25	ABBNY-DELISTED	Stock	18.66	18.71	18.43	18.5	3161020.0
2012-10-25	ABC-DELISTED	Stock	39.98	40.36	39.41	39.77	2297279.0
2012-10-25	ABCB	Stock	11.42	11.42	10.9	10.99	86100.0
2012-10-25	ABCD-DELISTED	Stock	0.95	0.95	0.94	0.94	10000.0
2012-10-25	ABCO-DELISTED	Stock	46.48	46.89	46.26	46.89	60064.0
2012-10-25	ABCW-DELISTED	Stock	0.37	0.37	0.36	0.36	1206.0
2012-10-25	ABE-DELISTED	Stock	20.66	20.73	20.63	20.64	14774.0
2012-10-25	ABEO	Stock	337.5	500.0	337.5	450.0	500.0
2012-10-25	ABFS-DELISTED	Stock	7.76	7.89	7.63	7.7	218900.0
2012-10-25	ABG	Stock	31.52	31.65	29.62	30.34	305100.0
2012-10-25	ABM	Stock	18.24	18.53	18.21	18.53	205800.0
2012-10-25	ABMD-DELISTED	Stock	18.87	18.98	18.23	18.95	605528.0
2012-10-25	ABR	Stock	5.5	5.5	5.4	5.43	63700.0
2012-10-25	ABT	Stock	31.638	31.8107	31.4077	31.5612	17814298.0
2012-10-25	ABTL-DELISTED	Stock	3.8894	4.01	3.8894	3.96	3099.0
2012-10-25	ABUS	Stock	3.95	3.95	3.9	3.95	13700.0
2012-10-25	ABV-DELISTED	Stock	40.74	40.775	40.28	40.4	2151783.0
2012-10-25	ABVA-DELISTED	Stock	4.47	4.47	4.47	4.47	100.0
2012-10-25	ABX-DELISTED	Stock	39.21	39.63	39.07	39.49	5629294.0
2012-10-25	ACAD	Stock	2.21	2.41	2.19	2.35	1507400.0
2012-10-25	ACAS-DELISTED	Stock	11.88	11.89	11.66	11.79	1431185.0

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

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