PREVIEW / stock_daily / 2012-03-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-13.parquet
  size:    199 KB
  rows:    6,167
  symbols: 3,554

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-03-13	AAPL	Stock	19.9121	20.2921	19.8482	20.2893	690855200.0
2012-03-13	MSFT	Stock	32.24	32.69	32.15	32.67	48951700.0
2012-03-13	NVDA	Stock	0.3662	0.3718	0.3645	0.3698	553288000.0
2012-03-13	AMZN	Stock	9.196	9.2435	9.0385	9.2295	88116000.0
2012-03-13	TSLA	Stock	2.434	2.4393	2.3667	2.406	15024000.0
2012-03-13	TLT	Stock	115.27	115.41	113.89	113.91	14414919.0
2012-03-13	ES	Stock	37.29	37.57	37.09	37.55	2050100.0
2012-03-13	CL	Stock	47.4	47.625	47.225	47.615	4342200.0
2012-03-13	A	Stock	31.4449	32.3104	31.3019	32.2675	3270901.0
2012-03-13	AABA-DELISTED	Stock	14.54	14.62	14.39	14.55	16998575.0
2012-03-13	AACC-DELISTED	Stock	4.82	4.82	4.6	4.69	117986.0
2012-03-13	AACG	Stock	6.3	6.31	6.3	6.3	12000.0
2012-03-13	AAIC-DELISTED	Stock	24.23	25.0	24.1008	25.0	110514.0
2012-03-13	AAME	Stock	2.9	3.02	2.85	2.85	25100.0
2012-03-13	AAMRQ-DELISTED	Stock	0.472	0.515	0.472	0.489	1213262.0
2012-03-13	AAON	Stock	5.5348	5.6889	5.5022	5.6622	180900.0
2012-03-13	AAP	Stock	88.14	88.55	87.66	88.48	876800.0
2012-03-13	AAT	Stock	21.57	22.3	21.52	22.24	98600.0
2012-03-13	AAU-DELISTED	Stock	2.91	2.91	2.775	2.8	111018.0
2012-03-13	AAUAF-DELISTED	Stock	2.92	2.92	2.78	2.79	111028.0
2012-03-13	AAV-DELISTED	Stock	3.61	3.73	3.6	3.72	1015343.0
2012-03-13	AAWW-DELISTED	Stock	43.95	46.84	43.95	46.33	491769.0
2012-03-13	AAXJ	Stock	57.61	58.415	57.37	58.35	315943.0
2012-03-13	AAXN-DELISTED	Stock	4.09	4.14	4.05	4.12	296258.0
2012-03-13	AB	Stock	15.52	15.7	15.3	15.63	398500.0
2012-03-13	ABAC-DELISTED	Stock	1.65	1.69	1.51	1.59	38923.0
2012-03-13	ABAX-DELISTED	Stock	27.46	27.8	27.17	27.76	66230.0
2012-03-13	ABB-DELISTED	Stock	20.49	20.7	20.42	20.68	2013595.0
2012-03-13	ABBNY-DELISTED	Stock	20.49	20.7	20.42	20.66	2212695.0
2012-03-13	ABC-DELISTED	Stock	38.0	38.1	37.65	38.02	3124238.0
2012-03-13	ABCB	Stock	11.98	12.3	11.89	12.3	83100.0
2012-03-13	ABCD-DELISTED	Stock	3.02	3.05	2.76	3.05	21290.0
2012-03-13	ABCO-DELISTED	Stock	42.1	42.53	41.75	42.47	183240.0
2012-03-13	ABCW-DELISTED	Stock	0.5121	0.5573	0.4518	0.4619	55720.0
2012-03-13	ABD-DELISTED	Stock	12.03	12.39	11.9	12.33	552140.0
2012-03-13	ABE-DELISTED	Stock	19.3	19.6	19.3	19.6	33298.0
2012-03-13	ABEO	Stock	1375.0	1450.0	1375.0	1437.5	42.0
2012-03-13	ABFS-DELISTED	Stock	18.49	18.78	18.33	18.68	366583.0
2012-03-13	ABG	Stock	27.21	27.56	26.81	27.44	214100.0
2012-03-13	ABH-DELISTED	Stock	15.17	15.62	15.1119	15.61	220938.0
2012-03-13	ABM	Stock	23.57	23.69	23.17	23.68	380400.0
2012-03-13	ABMD-DELISTED	Stock	22.03	22.48	21.97	22.48	532180.0
2012-03-13	ABR	Stock	5.32	5.41	5.31	5.33	61300.0
2012-03-13	ABT	Stock	28.0443	28.2986	27.9867	28.2746	17408712.0
2012-03-13	ABTL-DELISTED	Stock	5.0048	5.1606	4.8489	4.9	17608.0
2012-03-13	ABUS	Stock	2.39	2.68	2.1	2.35	36000.0
2012-03-13	ABV-DELISTED	Stock	41.29	41.69	41.04	41.67	2045863.0
2012-03-13	ABVA-DELISTED	Stock	4.17	4.17	4.06	4.139	2100.0
2012-03-13	ABVT-DELISTED	Stock	72.49	72.5	71.265	72.19	143256.0
2012-03-13	ABX-DELISTED	Stock	45.5	46.01	45.05	45.36	6793989.0

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

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