PREVIEW / stock_daily / 2012-09-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-14.parquet
  size:    203 KB
  rows:    6,213
  symbols: 3,525

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-09-14	AAPL	Stock	24.6414	24.8921	24.5675	24.6886	600474000.0
2012-09-14	MSFT	Stock	31.01	31.25	30.81	31.21	51422800.0
2012-09-14	NVDA	Stock	0.3418	0.352	0.3418	0.346	339468000.0
2012-09-14	AMZN	Stock	13.07	13.2055	12.9885	13.0635	73324000.0
2012-09-14	META	Stock	21.13	22.08	20.9	22.0	72819800.0
2012-09-14	TSLA	Stock	2.0	2.0433	1.9767	2.026	23049000.0
2012-09-14	TLT	Stock	119.76	119.85	118.05	118.3	16871543.0
2012-09-14	ES	Stock	38.28	38.35	37.66	37.75	2201100.0
2012-09-14	CL	Stock	52.215	52.375	51.75	51.875	5587600.0
2012-09-14	A	Stock	27.4964	28.7124	27.4678	28.4192	9415670.0
2012-09-14	AABA-DELISTED	Stock	15.7	15.84	15.62	15.78	17216524.0
2012-09-14	AACC-DELISTED	Stock	7.47	7.55	6.98	7.41	21899.0
2012-09-14	AACG	Stock	4.4	4.4	4.38	4.38	1000.0
2012-09-14	AAIC-DELISTED	Stock	24.46	24.74	24.22	24.5	162403.0
2012-09-14	AAME	Stock	2.55	2.75	2.55	2.74	3300.0
2012-09-14	AAMRQ-DELISTED	Stock	0.451	0.453	0.4301	0.434	6313024.0
2012-09-14	AAON	Stock	5.7867	6.0741	5.7156	6.0593	302063.0
2012-09-14	AAP	Stock	69.47	69.47	67.59	68.0	1585800.0
2012-09-14	AAT	Stock	27.74	27.9	27.48	27.86	403700.0
2012-09-14	AAU-DELISTED	Stock	2.95	3.04	2.85	2.9	500147.0
2012-09-14	AAUAF-DELISTED	Stock	2.96	3.05	2.86	2.89	503421.0
2012-09-14	AAV-DELISTED	Stock	3.7	3.9	3.7	3.79	418897.0
2012-09-14	AAWW-DELISTED	Stock	56.97	57.0	56.27	56.6	310892.0
2012-09-14	AAXJ	Stock	56.89	57.37	56.69	56.87	489320.0
2012-09-14	AAXN-DELISTED	Stock	5.42	5.77	5.41	5.75	987453.0
2012-09-14	AB	Stock	15.0	15.64	14.99	15.56	590600.0
2012-09-14	ABAC-DELISTED	Stock	1.01	1.2	1.0	1.2	36114.0
2012-09-14	ABAX-DELISTED	Stock	35.97	36.4699	35.35	35.57	98639.0
2012-09-14	ABB-DELISTED	Stock	20.1	20.31	19.88	20.02	3349852.0
2012-09-14	ABBNY-DELISTED	Stock	20.1	20.31	19.88	20.03	3730489.0
2012-09-14	ABC-DELISTED	Stock	38.08	38.19	37.12	37.37	6138557.0
2012-09-14	ABCB	Stock	12.82	12.87	12.74	12.75	53500.0
2012-09-14	ABCD-DELISTED	Stock	0.9701	1.08	0.9701	1.07	9415.0
2012-09-14	ABCO-DELISTED	Stock	47.34	47.52	46.75	47.3	144960.0
2012-09-14	ABCW-DELISTED	Stock	0.43	0.45	0.37	0.43	9530.0
2012-09-14	ABE-DELISTED	Stock	20.46	20.7	20.46	20.7	19174.0
2012-09-14	ABEO	Stock	687.5	712.5	650.0	650.0	24.0
2012-09-14	ABFS-DELISTED	Stock	8.33	8.48	8.31	8.42	405499.0
2012-09-14	ABG	Stock	29.11	30.02	29.08	29.93	402900.0
2012-09-14	ABM	Stock	18.91	19.0	18.78	18.83	342100.0
2012-09-14	ABMD-DELISTED	Stock	21.26	21.4499	20.17	20.29	972833.0
2012-09-14	ABR	Stock	5.65	6.29	5.64	6.22	254900.0
2012-09-14	ABT	Stock	33.1974	33.1974	32.6072	32.7559	14726136.0
2012-09-14	ABTL-DELISTED	Stock	3.66	3.71	3.599	3.67	20603.0
2012-09-14	ABUS	Stock	3.3	3.76	3.3	3.63	24600.0
2012-09-14	ABV-DELISTED	Stock	38.2	39.0	38.02	38.26	2588776.0
2012-09-14	ABX-DELISTED	Stock	42.24	42.75	42.09	42.39	12458863.0
2012-09-14	ACAD	Stock	2.09	2.15	2.06	2.12	957300.0
2012-09-14	ACAS-DELISTED	Stock	11.82	12.0	11.8	11.91	4436817.0
2012-09-14	ACAT-DELISTED	Stock	44.79	46.16	44.04	44.35	150248.0

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

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