PREVIEW / stock_daily / 2012-01-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-27.parquet
  size:    196 KB
  rows:    6,101
  symbols: 3,518

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-01-27	AAPL	Stock	15.8693	16.0171	15.8489	15.9743	299709200.0
2012-01-27	MSFT	Stock	29.45	29.53	29.17	29.23	44187700.0
2012-01-27	NVDA	Stock	0.3655	0.3748	0.3625	0.3728	449996000.0
2012-01-27	AMZN	Stock	9.6545	9.825	9.6165	9.7685	93180000.0
2012-01-27	TSLA	Stock	1.9	1.9813	1.9	1.9553	11226000.0
2012-01-27	TLT	Stock	117.83	118.33	117.01	118.08	5165361.0
2012-01-27	ES	Stock	35.2	35.2	34.57	34.73	1431000.0
2012-01-27	CL	Stock	45.39	45.45	45.02	45.2	5654600.0
2012-01-27	A	Stock	30.3147	30.7225	30.2361	30.5293	3394344.0
2012-01-27	AABA-DELISTED	Stock	15.48	15.8	15.46	15.75	10462947.0
2012-01-27	AACC-DELISTED	Stock	4.49	4.88	4.4	4.64	40806.0
2012-01-27	AACG	Stock	6.3	6.3	6.3	6.3	600.0
2012-01-27	AAIC-DELISTED	Stock	23.1	23.1	22.66	22.73	40299.0
2012-01-27	AAME	Stock	2.02	2.05	2.02	2.05	2600.0
2012-01-27	AAMRQ-DELISTED	Stock	0.667	0.719	0.66	0.692	18712208.0
2012-01-27	AAON	Stock	5.9911	6.2222	5.9852	6.2222	121500.0
2012-01-27	AAP	Stock	74.93	75.59	74.67	75.35	379800.0
2012-01-27	AAT	Stock	21.79	22.3	21.79	22.07	123700.0
2012-01-27	AAU-DELISTED	Stock	2.53	2.61	2.5099	2.52	195770.0
2012-01-27	AAUAF-DELISTED	Stock	2.52	2.6	2.5	2.53	197044.0
2012-01-27	AAV-DELISTED	Stock	3.75	3.76	3.63	3.66	633656.0
2012-01-27	AAWW-DELISTED	Stock	46.48	47.49	46.09	47.13	268590.0
2012-01-27	AAXJ	Stock	55.46	55.77	55.18	55.65	1091510.0
2012-01-27	AAXN-DELISTED	Stock	4.66	4.7295	4.6	4.7	403452.0
2012-01-27	AB	Stock	14.94	15.11	14.94	15.03	243300.0
2012-01-27	ABAC-DELISTED	Stock	1.6499	1.6499	1.579	1.58	32811.0
2012-01-27	ABAX-DELISTED	Stock	26.58	27.5	25.77	27.46	343924.0
2012-01-27	ABB-DELISTED	Stock	21.14	21.31	21.08	21.24	1219426.0
2012-01-27	ABBNY-DELISTED	Stock	21.14	21.31	21.08	21.24	1239648.0
2012-01-27	ABC-DELISTED	Stock	38.91	39.65	38.56	38.99	3133773.0
2012-01-27	ABCB	Stock	10.75	10.93	10.68	10.83	135700.0
2012-01-27	ABCD-DELISTED	Stock	3.19	3.25	3.18	3.25	26709.0
2012-01-27	ABCO-DELISTED	Stock	39.61	40.37	39.58	39.59	106114.0
2012-01-27	ABCW-DELISTED	Stock	0.3213	0.3213	0.3213	0.3213	2800.0
2012-01-27	ABD-DELISTED	Stock	9.635	9.805	9.635	9.795	484920.0
2012-01-27	ABE-DELISTED	Stock	18.42	18.63	18.42	18.535	4658.0
2012-01-27	ABEO	Stock	1625.0	1650.0	1600.0	1650.0	43.0
2012-01-27	ABFS-DELISTED	Stock	20.0	20.96	18.68	19.13	1288842.0
2012-01-27	ABG	Stock	22.87	23.48	22.87	23.4	247700.0
2012-01-27	ABH-DELISTED	Stock	14.29	14.44	14.21	14.27	2154278.0
2012-01-27	ABM	Stock	21.6	21.9	21.58	21.8	214900.0
2012-01-27	ABMD-DELISTED	Stock	18.0	18.19	17.52	17.65	621595.0
2012-01-27	ABR	Stock	4.2	4.28	4.2	4.21	35400.0
2012-01-27	ABT	Stock	26.3314	26.4994	26.2451	26.3986	13322009.0
2012-01-27	ABTL-DELISTED	Stock	4.2992	4.5008	4.2007	4.3508	27489.0
2012-01-27	ABUS	Stock	2.21	2.41	2.21	2.35	3800.0
2012-01-27	ABV-DELISTED	Stock	37.24	37.33	36.57	36.78	2376603.0
2012-01-27	ABVA-DELISTED	Stock	3.5	3.53	3.5	3.52	1000.0
2012-01-27	ABVT-DELISTED	Stock	66.12	67.03	66.05	66.88	55092.0
2012-01-27	ABX-DELISTED	Stock	48.81	49.88	48.74	49.49	8053022.0

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

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