PREVIEW / stock_daily / 2012-01-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-18.parquet
  size:    198 KB
  rows:    6,145
  symbols: 3,547

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-18	AAPL	Stock	15.2486	15.3382	15.225	15.3254	276791200.0
2012-01-18	MSFT	Stock	28.31	28.4	27.97	28.23	64860600.0
2012-01-18	NVDA	Stock	0.3445	0.3522	0.3428	0.3495	632676000.0
2012-01-18	AMZN	Stock	9.097	9.5125	9.056	9.472	149470000.0
2012-01-18	TSLA	Stock	1.7793	1.792	1.75	1.7873	18903000.0
2012-01-18	TLT	Stock	121.53	121.612	119.91	119.97	5803975.0
2012-01-18	ES	Stock	34.18	34.2	33.89	34.12	1258500.0
2012-01-18	CL	Stock	44.875	45.25	44.77	45.155	3905400.0
2012-01-18	A	Stock	28.6123	29.5637	28.505	29.5207	4432778.0
2012-01-18	AABA-DELISTED	Stock	15.91	16.0	15.69	15.92	33861158.0
2012-01-18	AACC-DELISTED	Stock	4.2	4.23	3.98	4.22	15000.0
2012-01-18	AACG	Stock	7.05	7.1	6.73	6.75	7700.0
2012-01-18	AAIC-DELISTED	Stock	21.53	21.91	21.361	21.77	33412.0
2012-01-18	AAME	Stock	2.0	2.01	2.0	2.0	1500.0
2012-01-18	AAMRQ-DELISTED	Stock	0.401	0.42	0.4	0.415	6898961.0
2012-01-18	AAON	Stock	5.8844	5.9793	5.763	5.9644	129600.0
2012-01-18	AAP	Stock	72.01	73.63	71.8	73.63	646100.0
2012-01-18	AAT	Stock	20.71	21.23	20.71	21.22	78800.0
2012-01-18	AAU-DELISTED	Stock	2.53	2.6104	2.5	2.51	89546.0
2012-01-18	AAUAF-DELISTED	Stock	2.52	2.6	2.5	2.52	90969.0
2012-01-18	AAV-DELISTED	Stock	3.43	3.46	3.39	3.44	798849.0
2012-01-18	AAWW-DELISTED	Stock	40.72	42.0	40.34	41.7	388692.0
2012-01-18	AAXJ	Stock	52.7	53.65	52.66	53.58	410748.0
2012-01-18	AAXN-DELISTED	Stock	5.13	5.29	5.13	5.26	298696.0
2012-01-18	AB	Stock	14.52	14.65	14.41	14.6	450400.0
2012-01-18	ABAC-DELISTED	Stock	1.68	1.7	1.51	1.6	17835.0
2012-01-18	ABAX-DELISTED	Stock	26.92	28.11	26.92	28.1	72222.0
2012-01-18	ABB-DELISTED	Stock	20.59	20.99	20.529	20.97	2726505.0
2012-01-18	ABBNY-DELISTED	Stock	20.58	20.99	20.529	20.98	2732154.0
2012-01-18	ABC-DELISTED	Stock	38.4699	39.04	38.2	39.02	1611698.0
2012-01-18	ABCB	Stock	10.36	10.5	10.32	10.46	38300.0
2012-01-18	ABCD-DELISTED	Stock	3.16	3.22	3.02	3.21	24661.0
2012-01-18	ABCO-DELISTED	Stock	37.74	38.92	37.14	38.91	353341.0
2012-01-18	ABCW-DELISTED	Stock	0.3012	0.3012	0.2912	0.3012	83500.0
2012-01-18	ABD-DELISTED	Stock	9.35	9.71	9.282	9.66	369920.0
2012-01-18	ABE-DELISTED	Stock	17.93	17.99	17.77	17.99	20419.0
2012-01-18	ABEO	Stock	1662.5	1725.0	1612.5	1725.0	16.0
2012-01-18	ABFS-DELISTED	Stock	21.15	21.39	21.0	21.38	401163.0
2012-01-18	ABG	Stock	22.64	23.73	22.39	23.58	352000.0
2012-01-18	ABH-DELISTED	Stock	15.18	15.49	14.79	15.0	314097.0
2012-01-18	ABM	Stock	20.38	20.75	20.27	20.74	133100.0
2012-01-18	ABMD-DELISTED	Stock	18.04	18.23	17.94	18.19	164747.0
2012-01-18	ABR	Stock	4.12	4.47	4.09	4.17	58100.0
2012-01-18	ABT	Stock	26.6001	26.7632	26.4562	26.5617	14803668.0
2012-01-18	ABTL-DELISTED	Stock	4.0054	4.037	3.9	3.9	3716.0
2012-01-18	ABUS	Stock	2.42	2.45	2.27	2.45	8500.0
2012-01-18	ABV-DELISTED	Stock	36.62	37.25	36.54	37.24	2992474.0
2012-01-18	ABVA-DELISTED	Stock	3.31	3.36	3.31	3.35	1230.0
2012-01-18	ABVT-DELISTED	Stock	65.29	66.64	64.92	66.5	110537.0
2012-01-18	ABX-DELISTED	Stock	47.92	48.36	47.52	47.95	5763726.0

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

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