PREVIEW / stock_daily / 2012-10-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-19.parquet
  size:    199 KB
  rows:    6,148
  symbols: 3,484

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-19	AAPL	Stock	22.5375	22.5632	21.7721	21.78	744086000.0
2012-10-19	MSFT	Stock	29.05	29.08	28.5	28.64	90470800.0
2012-10-19	NVDA	Stock	0.3168	0.319	0.301	0.3028	709412000.0
2012-10-19	AMZN	Stock	12.258	12.341	11.947	12.0	87906000.0
2012-10-19	META	Stock	19.0	19.06	18.8	19.0	34835000.0
2012-10-19	TSLA	Stock	1.8553	1.88	1.82	1.8493	15411000.0
2012-10-19	TLT	Stock	120.34	121.81	120.28	121.74	7618211.0
2012-10-19	ES	Stock	39.9	40.05	39.7	39.71	1989200.0
2012-10-19	CL	Stock	54.88	54.9	53.72	53.87	4758400.0
2012-10-19	A	Stock	26.0873	26.0944	25.4936	25.5722	5577041.0
2012-10-19	AABA-DELISTED	Stock	16.0	16.03	15.83	15.845	32547397.0
2012-10-19	AACC-DELISTED	Stock	7.57	7.64	7.02	7.14	26940.0
2012-10-19	AACG	Stock	4.63	5.18	4.63	4.83	1900.0
2012-10-19	AAIC-DELISTED	Stock	22.15	22.166	21.87	22.02	118630.0
2012-10-19	AAME	Stock	2.78	2.8	2.68	2.75	4500.0
2012-10-19	AAMRQ-DELISTED	Stock	0.366	0.376	0.366	0.366	904938.0
2012-10-19	AAON	Stock	5.7244	5.8548	5.6919	5.8311	171788.0
2012-10-19	AAP	Stock	68.23	68.63	67.85	68.43	515400.0
2012-10-19	AAT	Stock	28.25	28.38	27.91	27.97	94400.0
2012-10-19	AAU-DELISTED	Stock	2.5	2.5704	2.5	2.54	98469.0
2012-10-19	AAUAF-DELISTED	Stock	2.5	2.54	2.49	2.54	102842.0
2012-10-19	AAV-DELISTED	Stock	3.95	3.95	3.89	3.94	408599.0
2012-10-19	AAWW-DELISTED	Stock	51.91	52.66	50.9101	51.32	125759.0
2012-10-19	AAXJ	Stock	56.69	56.77	56.13	56.19	197946.0
2012-10-19	AAXN-DELISTED	Stock	6.37	6.45	6.27	6.39	457578.0
2012-10-19	AB	Stock	16.57	16.57	16.18	16.35	337200.0
2012-10-19	ABAC-DELISTED	Stock	1.39	1.39	1.31	1.38	6872.0
2012-10-19	ABAX-DELISTED	Stock	36.67	37.23	35.72	35.9	113650.0
2012-10-19	ABB-DELISTED	Stock	19.63	19.63	19.27	19.3395	1350647.0
2012-10-19	ABBNY-DELISTED	Stock	19.63	19.63	19.27	19.32	1388073.0
2012-10-19	ABC-DELISTED	Stock	40.64	40.64	40.04	40.2	2117204.0
2012-10-19	ABCB	Stock	12.09	12.26	11.95	12.07	43400.0
2012-10-19	ABCD-DELISTED	Stock	1.0	1.0	0.94	0.94	17370.0
2012-10-19	ABCO-DELISTED	Stock	48.52	48.81	46.88	47.03	140979.0
2012-10-19	ABCW-DELISTED	Stock	0.38	0.38	0.36	0.365	19911.0
2012-10-19	ABE-DELISTED	Stock	20.7301	20.78	20.65	20.7	12479.0
2012-10-19	ABEO	Stock	362.5	362.5	300.0	312.5	78.0
2012-10-19	ABFS-DELISTED	Stock	8.14	8.14	7.52	7.61	624500.0
2012-10-19	ABG	Stock	31.0	31.15	30.2	30.34	236300.0
2012-10-19	ABM	Stock	18.41	18.56	18.26	18.47	269000.0
2012-10-19	ABMD-DELISTED	Stock	20.17	20.215	19.62	19.65	751182.0
2012-10-19	ABR	Stock	5.57	5.57	5.48	5.5	135000.0
2012-10-19	ABT	Stock	32.3289	32.3433	31.6476	31.7388	24333681.0
2012-10-19	ABTL-DELISTED	Stock	4.01	4.08	3.94	4.0	4150.0
2012-10-19	ABUS	Stock	3.87	3.87	3.79	3.84	12300.0
2012-10-19	ABV-DELISTED	Stock	42.09	42.12	41.23	41.34	2022669.0
2012-10-19	ABVA-DELISTED	Stock	4.63	4.63	4.36	4.5	3389.0
2012-10-19	ABX-DELISTED	Stock	38.93	39.1	38.24	38.78	10221873.0
2012-10-19	ACAD	Stock	2.55	2.55	2.35	2.4	1428400.0
2012-10-19	ACAS-DELISTED	Stock	12.06	12.12	11.85	11.89	3209213.0

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

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