PREVIEW / stock_daily / 2012-10-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-09.parquet
  size:    200 KB
  rows:    6,170
  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
2012-10-09	AAPL	Stock	22.8089	22.8746	22.2696	22.7089	838597200.0
2012-10-09	MSFT	Stock	29.68	29.74	29.18	29.28	45121100.0
2012-10-09	NVDA	Stock	0.3288	0.3298	0.3213	0.3223	366360000.0
2012-10-09	AMZN	Stock	12.9335	12.9675	12.5365	12.548	69896000.0
2012-10-09	META	Stock	20.39	20.55	19.97	20.23	27161800.0
2012-10-09	TSLA	Stock	1.9413	1.9413	1.8833	1.8913	17895000.0
2012-10-09	TLT	Stock	121.47	122.185	121.38	121.95	4753101.0
2012-10-09	ES	Stock	39.01	39.49	38.75	39.43	1585100.0
2012-10-09	CL	Stock	54.19	54.39	53.65	53.715	2794400.0
2012-10-09	A	Stock	27.6538	27.9828	27.2747	27.289	4252017.0
2012-10-09	AABA-DELISTED	Stock	16.03	16.05	15.81	15.86	13929606.0
2012-10-09	AACC-DELISTED	Stock	7.8	7.9	7.29	7.33	12573.0
2012-10-09	AACG	Stock	4.8	4.8	4.75	4.75	11500.0
2012-10-09	AAIC-DELISTED	Stock	23.89	23.95	23.18	23.29	213777.0
2012-10-09	AAME	Stock	2.89	3.0	2.89	3.0	8600.0
2012-10-09	AAMRQ-DELISTED	Stock	0.3905	0.395	0.382	0.388	1051074.0
2012-10-09	AAON	Stock	5.7867	5.7867	5.6059	5.6178	199125.0
2012-10-09	AAP	Stock	70.63	70.93	69.8	69.93	631200.0
2012-10-09	AAT	Stock	27.6	27.65	27.33	27.33	81600.0
2012-10-09	AAU-DELISTED	Stock	2.49	2.51	2.45	2.45	193446.0
2012-10-09	AAUAF-DELISTED	Stock	2.49	2.51	2.45	2.45	194446.0
2012-10-09	AAV-DELISTED	Stock	3.92	4.05	3.88	4.04	214033.0
2012-10-09	AAWW-DELISTED	Stock	51.9	52.9	50.985	52.17	387854.0
2012-10-09	AAXJ	Stock	56.54	56.69	56.06	56.17	182633.0
2012-10-09	AAXN-DELISTED	Stock	6.0	6.08	5.83	5.84	657017.0
2012-10-09	AB	Stock	15.58	15.74	15.49	15.62	182200.0
2012-10-09	ABAC-DELISTED	Stock	1.4301	1.49	1.43	1.49	624.0
2012-10-09	ABAX-DELISTED	Stock	36.94	37.2	35.88	36.37	97843.0
2012-10-09	ABB-DELISTED	Stock	19.06	19.1	18.8	18.81	1447561.0
2012-10-09	ABBNY-DELISTED	Stock	19.06	19.1	18.79	18.79	1465612.0
2012-10-09	ABC-DELISTED	Stock	39.72	39.88	39.23	39.67	2036332.0
2012-10-09	ABCB	Stock	12.55	12.65	12.34	12.4	13500.0
2012-10-09	ABCD-DELISTED	Stock	0.983	0.99	0.982	0.982	716.0
2012-10-09	ABCO-DELISTED	Stock	47.6	47.75	47.01	47.57	78175.0
2012-10-09	ABCW-DELISTED	Stock	0.405	0.405	0.38	0.38	2100.0
2012-10-09	ABE-DELISTED	Stock	20.68	20.7201	20.5801	20.6227	21470.0
2012-10-09	ABEO	Stock	475.0	562.5	475.0	525.0	9.0
2012-10-09	ABFS-DELISTED	Stock	7.92	8.27	7.8423	8.15	512255.0
2012-10-09	ABG	Stock	31.18	31.25	30.32	30.49	244100.0
2012-10-09	ABM	Stock	18.33	18.42	18.21	18.35	462000.0
2012-10-09	ABMD-DELISTED	Stock	20.39	20.39	19.9	20.01	401059.0
2012-10-09	ABR	Stock	5.76	5.76	5.65	5.69	164900.0
2012-10-09	ABT	Stock	34.1042	34.3057	33.9506	34.0178	13508962.0
2012-10-09	ABTL-DELISTED	Stock	3.9658	4.0118	3.89	3.89	1398.0
2012-10-09	ABUS	Stock	3.79	3.81	3.46	3.68	6200.0
2012-10-09	ABV-DELISTED	Stock	41.07	41.1	39.84	39.86	2021517.0
2012-10-09	ABVA-DELISTED	Stock	4.6	4.6	4.6	4.6	127.0
2012-10-09	ABX-DELISTED	Stock	41.56	41.62	40.5	40.52	5467583.0
2012-10-09	ACAD	Stock	2.63	2.68	2.48	2.5	1549500.0
2012-10-09	ACAS-DELISTED	Stock	11.78	11.85	11.57	11.67	2419214.0

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

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