PREVIEW / stock_daily / 2011-06-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-27.parquet
  size:    198 KB
  rows:    6,140
  symbols: 3,570

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
2011-06-27	AAPL	Stock	11.6996	11.925	11.6875	11.8586	339813600.0
2011-06-27	MSFT	Stock	24.23	25.46	24.23	25.2	92044200.0
2011-06-27	NVDA	Stock	0.3935	0.396	0.3715	0.3853	1142152000.0
2011-06-27	AMZN	Stock	9.725	10.129	9.7015	10.0625	122014000.0
2011-06-27	TSLA	Stock	1.8487	1.8853	1.8207	1.8307	27141000.0
2011-06-27	TLT	Stock	96.85	96.87	95.55	95.65	9331437.0
2011-06-27	ES	Stock	34.67	35.07	34.65	35.02	1400300.0
2011-06-27	CL	Stock	42.815	42.915	42.705	42.705	4582600.0
2011-06-27	A	Stock	34.5851	35.1574	34.2275	34.9428	4281515.0
2011-06-27	AABA-DELISTED	Stock	14.87	14.98	14.77	14.88	13125132.0
2011-06-27	AACC-DELISTED	Stock	3.69	4.04	3.54	3.86	76551.0
2011-06-27	AACG	Stock	9.69	9.69	9.05	9.2	47800.0
2011-06-27	AAIC-DELISTED	Stock	31.77	32.63	31.66	32.51	118644.0
2011-06-27	AAME	Stock	1.95	2.05	1.95	2.05	3300.0
2011-06-27	AAON	Stock	6.3052	6.5422	6.3022	6.5304	212288.0
2011-06-27	AAP	Stock	58.1	58.47	57.7	58.03	1132600.0
2011-06-27	AAT	Stock	22.21	22.54	22.16	22.25	139400.0
2011-06-27	AATI-DELISTED	Stock	6.05	6.08	6.04	6.04	252652.0
2011-06-27	AAU-DELISTED	Stock	3.17	3.21	3.15	3.19	118390.0
2011-06-27	AAUAF-DELISTED	Stock	3.17	3.21	3.15	3.19	118690.0
2011-06-27	AAV-DELISTED	Stock	7.7	7.83	7.69	7.8	262159.0
2011-06-27	AAWW-DELISTED	Stock	57.22	59.03	56.61	58.91	118713.0
2011-06-27	AAXJ	Stock	59.79	60.37	59.66	60.16	391103.0
2011-06-27	AAXN-DELISTED	Stock	4.31	4.4	4.24	4.4	219912.0
2011-06-27	AB	Stock	18.73	18.95	18.43	18.82	462000.0
2011-06-27	ABAC-DELISTED	Stock	2.41	2.41	2.2	2.2799	26307.0
2011-06-27	ABAX-DELISTED	Stock	27.76	28.1	27.6	27.88	60224.0
2011-06-27	ABB-DELISTED	Stock	24.77	25.18	24.73	25.01	4066386.0
2011-06-27	ABBC-DELISTED	Stock	9.94	10.18	9.94	10.18	37307.0
2011-06-27	ABBNY-DELISTED	Stock	24.77	25.18	24.73	25.01	4067736.0
2011-06-27	ABC-DELISTED	Stock	39.96	40.84	39.8	40.66	2623167.0
2011-06-27	ABCB	Stock	8.9	9.04	8.76	8.76	37000.0
2011-06-27	ABCD-DELISTED	Stock	3.44	3.44	3.3	3.35	44392.0
2011-06-27	ABCO-DELISTED	Stock	27.13	28.33	27.13	28.29	210058.0
2011-06-27	ABCW-DELISTED	Stock	0.7027	0.7215	0.6916	0.7173	5600.0
2011-06-27	ABD-DELISTED	Stock	7.35	7.46	7.14	7.4	311630.0
2011-06-27	ABE-DELISTED	Stock	18.3	18.49	18.3	18.42	8704.0
2011-06-27	ABEO	Stock	2125.0	2250.0	2075.0	2225.0	11.0
2011-06-27	ABFS-DELISTED	Stock	22.85	23.15	22.73	23.15	346920.0
2011-06-27	ABG	Stock	17.29	18.09	17.2	17.97	364300.0
2011-06-27	ABH-DELISTED	Stock	21.75	21.98	21.6	21.92	330530.0
2011-06-27	ABM	Stock	22.85	23.08	22.76	23.01	173500.0
2011-06-27	ABMD-DELISTED	Stock	16.12	16.54	15.95	16.44	292274.0
2011-06-27	ABR	Stock	4.58	4.74	4.58	4.61	36200.0
2011-06-27	ABT	Stock	24.8728	25.0168	24.7769	24.9016	9557107.0
2011-06-27	ABTL-DELISTED	Stock	4.9998	5.0997	4.7998	5.0002	9395.0
2011-06-27	ABUS	Stock	2.49	2.58	2.45	2.54	3900.0
2011-06-27	ABV-DELISTED	Stock	31.88	32.56	31.82	32.33	1452695.0
2011-06-27	ABVA-DELISTED	Stock	4.77	4.79	4.742	4.79	2349.0
2011-06-27	ABVT-DELISTED	Stock	69.7	70.4	69.0029	69.85	189479.0

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

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