PREVIEW / stock_daily / 2012-01-10

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-10.parquet
  size:    198 KB
  rows:    6,181
  symbols: 3,560

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-10	AAPL	Stock	15.2111	15.2143	15.0536	15.1157	258196400.0
2012-01-10	MSFT	Stock	27.93	28.15	27.75	27.84	60014400.0
2012-01-10	NVDA	Stock	0.369	0.3692	0.3595	0.362	546328000.0
2012-01-10	AMZN	Stock	9.055	9.12	8.855	8.967	79716000.0
2012-01-10	TSLA	Stock	1.8293	1.8507	1.8167	1.8413	10077000.0
2012-01-10	TLT	Stock	117.73	118.87	117.68	118.32	8932484.0
2012-01-10	ES	Stock	35.05	35.05	34.44	34.47	1304300.0
2012-01-10	CL	Stock	45.005	45.075	44.625	44.725	5679200.0
2012-01-10	A	Stock	27.7682	28.1974	27.618	27.9685	4459620.0
2012-01-10	AABA-DELISTED	Stock	15.58	15.71	15.5	15.51	13874046.0
2012-01-10	AACC-DELISTED	Stock	4.16	4.24	4.11	4.23	6008.0
2012-01-10	AACG	Stock	7.4	7.59	7.4	7.56	7600.0
2012-01-10	AAIC-DELISTED	Stock	20.79	20.86	20.58	20.66	47560.0
2012-01-10	AAMRQ-DELISTED	Stock	0.375	0.3788	0.3511	0.362	8692650.0
2012-01-10	AAON	Stock	6.0474	6.1215	5.9674	6.0119	300038.0
2012-01-10	AAP	Stock	72.18	72.36	71.42	71.54	396500.0
2012-01-10	AAT	Stock	20.1	20.64	20.1	20.3	80000.0
2012-01-10	AATI-DELISTED	Stock	5.8	5.83	5.79	5.82	470062.0
2012-01-10	AAU-DELISTED	Stock	2.66	2.67	2.59	2.67	95918.0
2012-01-10	AAUAF-DELISTED	Stock	2.66	2.67	2.59	2.67	97628.0
2012-01-10	AAV-DELISTED	Stock	4.26	4.312	4.24	4.26	251207.0
2012-01-10	AAWW-DELISTED	Stock	40.64	41.69	40.53	41.44	277444.0
2012-01-10	AAXJ	Stock	51.79	52.03	51.61	51.88	327808.0
2012-01-10	AAXN-DELISTED	Stock	5.21	5.27	5.124	5.2	354438.0
2012-01-10	AB	Stock	14.93	15.2	14.9	15.02	716300.0
2012-01-10	ABAC-DELISTED	Stock	1.38	1.4	1.37	1.4	36504.0
2012-01-10	ABAX-DELISTED	Stock	27.94	28.3	27.75	28.25	81607.0
2012-01-10	ABB-DELISTED	Stock	19.77	19.83	19.64	19.76	2614428.0
2012-01-10	ABBNY-DELISTED	Stock	19.78	19.83	19.64	19.77	2644552.0
2012-01-10	ABC-DELISTED	Stock	38.85	39.16	38.68	39.01	1513493.0
2012-01-10	ABCB	Stock	10.75	10.75	10.57	10.65	36200.0
2012-01-10	ABCD-DELISTED	Stock	3.15	3.19	3.08	3.16	18552.0
2012-01-10	ABCO-DELISTED	Stock	37.19	37.35	36.7	37.25	207562.0
2012-01-10	ABCW-DELISTED	Stock	0.3815	0.3815	0.3514	0.3514	42170.0
2012-01-10	ABD-DELISTED	Stock	9.51	9.51	9.3	9.4	251560.0
2012-01-10	ABE-DELISTED	Stock	17.94	18.16	17.88	18.126	4502.0
2012-01-10	ABEO	Stock	1700.0	1737.5	1600.0	1725.0	17.0
2012-01-10	ABFS-DELISTED	Stock	20.69	21.038	20.32	20.95	376335.0
2012-01-10	ABG	Stock	22.82	22.89	22.45	22.53	361600.0
2012-01-10	ABH-DELISTED	Stock	15.31	15.409	15.15	15.18	194895.0
2012-01-10	ABM	Stock	20.63	21.0	20.63	20.87	218600.0
2012-01-10	ABMD-DELISTED	Stock	18.53	18.62	18.115	18.14	151128.0
2012-01-10	ABR	Stock	3.74	3.79	3.7	3.75	37700.0
2012-01-10	ABT	Stock	26.9648	26.9983	26.8448	26.9216	12191955.0
2012-01-10	ABTL-DELISTED	Stock	3.83	4.0343	3.8265	3.9	5044.0
2012-01-10	ABUS	Stock	1.64	1.69	1.64	1.69	300.0
2012-01-10	ABV-DELISTED	Stock	35.31	35.46	35.05	35.44	2420539.0
2012-01-10	ABVA-DELISTED	Stock	3.38	3.38	3.35	3.35	1500.0
2012-01-10	ABVT-DELISTED	Stock	65.88	67.56	65.88	67.48	346344.0
2012-01-10	ABX-DELISTED	Stock	48.57	48.87	48.26	48.35	6398114.0

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

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