PREVIEW / stock_daily / 2012-01-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-17.parquet
  size:    198 KB
  rows:    6,170
  symbols: 3,553

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-17	AAPL	Stock	15.15	15.2139	15.1057	15.1679	242897200.0
2012-01-17	MSFT	Stock	28.4	28.65	28.17	28.26	72395300.0
2012-01-17	NVDA	Stock	0.3485	0.3485	0.3375	0.338	627176000.0
2012-01-17	AMZN	Stock	9.0075	9.165	8.9255	9.083	112890000.0
2012-01-17	TSLA	Stock	1.7747	1.8227	1.7607	1.7733	69774000.0
2012-01-17	TLT	Stock	120.95	121.63	120.826	121.44	5449836.0
2012-01-17	ES	Stock	34.42	34.58	34.04	34.21	866500.0
2012-01-17	CL	Stock	44.515	44.94	44.515	44.865	14860200.0
2012-01-17	A	Stock	28.4406	28.8913	28.3977	28.6052	5812884.0
2012-01-17	AABA-DELISTED	Stock	15.63	15.66	15.39	15.435	15287538.0
2012-01-17	AACC-DELISTED	Stock	4.25	4.25	4.07	4.1	30623.0
2012-01-17	AACG	Stock	7.46	7.46	7.03	7.07	2700.0
2012-01-17	AAIC-DELISTED	Stock	21.95	22.41	21.3329	21.58	89525.0
2012-01-17	AAME	Stock	2.05	2.05	1.99	2.01	2000.0
2012-01-17	AAMRQ-DELISTED	Stock	0.4167	0.429	0.39	0.402	7942571.0
2012-01-17	AAON	Stock	5.9496	6.0207	5.8519	5.8874	234900.0
2012-01-17	AAP	Stock	72.05	72.45	71.95	72.08	619300.0
2012-01-17	AAT	Stock	20.78	20.92	20.55	20.68	106500.0
2012-01-17	AAU-DELISTED	Stock	2.68	2.73	2.48	2.55	142454.0
2012-01-17	AAUAF-DELISTED	Stock	2.68	2.73	2.48	2.55	144354.0
2012-01-17	AAV-DELISTED	Stock	3.7	3.73	3.38	3.41	752421.0
2012-01-17	AAWW-DELISTED	Stock	41.11	41.16	40.2	40.66	241647.0
2012-01-17	AAXJ	Stock	52.72	52.87	52.44	52.62	440826.0
2012-01-17	AAXN-DELISTED	Stock	5.13	5.32	5.07	5.07	417149.0
2012-01-17	AB	Stock	14.53	14.72	14.4	14.63	360900.0
2012-01-17	ABAC-DELISTED	Stock	1.71	1.71	1.6	1.68	6850.0
2012-01-17	ABAX-DELISTED	Stock	28.03	28.21	27.62	27.79	91557.0
2012-01-17	ABB-DELISTED	Stock	20.39	20.48	20.3	20.35	2745986.0
2012-01-17	ABBNY-DELISTED	Stock	20.39	20.48	20.3	20.33	2758052.0
2012-01-17	ABC-DELISTED	Stock	38.3	38.57	38.1	38.28	1529469.0
2012-01-17	ABCB	Stock	10.6	10.6	10.27	10.34	37100.0
2012-01-17	ABCD-DELISTED	Stock	3.18	3.24	3.1	3.13	41650.0
2012-01-17	ABCO-DELISTED	Stock	37.67	38.09	37.25	37.57	143525.0
2012-01-17	ABCW-DELISTED	Stock	0.3213	0.3213	0.3012	0.3012	40490.0
2012-01-17	ABD-DELISTED	Stock	9.71	9.83	9.38	9.39	177410.0
2012-01-17	ABE-DELISTED	Stock	17.97	17.97	17.65	17.83	11690.0
2012-01-17	ABEO	Stock	1637.5	1725.0	1612.5	1662.5	21.0
2012-01-17	ABFS-DELISTED	Stock	21.28	21.289	20.72	20.74	188305.0
2012-01-17	ABG	Stock	23.03	23.1	22.51	22.63	215300.0
2012-01-17	ABH-DELISTED	Stock	15.45	15.72	15.12	15.13	710257.0
2012-01-17	ABM	Stock	20.93	21.05	20.38	20.43	222800.0
2012-01-17	ABMD-DELISTED	Stock	18.23	18.35	17.9601	18.02	139256.0
2012-01-17	ABR	Stock	4.11	4.22	4.11	4.11	28800.0
2012-01-17	ABT	Stock	26.8256	26.984	26.7249	26.7297	15592747.0
2012-01-17	ABTL-DELISTED	Stock	3.8742	3.9	3.8742	3.9	2851.0
2012-01-17	ABUS	Stock	2.28	2.45	2.15	2.42	27200.0
2012-01-17	ABV-DELISTED	Stock	36.42	36.78	36.32	36.45	2905590.0
2012-01-17	ABVA-DELISTED	Stock	3.33	3.47	3.33	3.47	4799.0
2012-01-17	ABVT-DELISTED	Stock	65.64	66.53	65.216	65.25	98382.0
2012-01-17	ABX-DELISTED	Stock	48.63	48.94	47.41	47.99	6561829.0

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

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