PREVIEW / stock_daily / 2012-07-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-11.parquet
  size:    197 KB
  rows:    6,107
  symbols: 3,485

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-07-11	AAPL	Stock	21.6471	21.7021	21.3293	21.5868	469322000.0
2012-07-11	MSFT	Stock	29.71	29.74	29.11	29.3	39184900.0
2012-07-11	NVDA	Stock	0.3215	0.3255	0.3138	0.3153	485216000.0
2012-07-11	AMZN	Stock	10.9475	11.087	10.767	10.9185	54694000.0
2012-07-11	META	Stock	31.48	31.56	30.55	30.97	13030300.0
2012-07-11	TSLA	Stock	2.1047	2.112	2.0673	2.1007	9579000.0
2012-07-11	TLT	Stock	128.59	129.47	128.26	128.6	5960873.0
2012-07-11	ES	Stock	38.73	38.94	38.63	38.83	1160800.0
2012-07-11	CL	Stock	52.08	52.08	51.685	51.915	3325400.0
2012-07-11	A	Stock	26.7883	26.9099	26.3376	26.6023	2699258.0
2012-07-11	AABA-DELISTED	Stock	15.82	15.94	15.68	15.8	15820762.0
2012-07-11	AACC-DELISTED	Stock	7.06	7.35	6.895	7.28	65186.0
2012-07-11	AACG	Stock	4.36	4.5	4.3	4.3	7100.0
2012-07-11	AAIC-DELISTED	Stock	22.23	22.3	21.88	22.2	40567.0
2012-07-11	AAME	Stock	2.8	2.8	2.74	2.74	6400.0
2012-07-11	AAMRQ-DELISTED	Stock	0.484	0.55	0.484	0.5404	2497227.0
2012-07-11	AAON	Stock	5.8548	5.9615	5.8163	5.9407	111713.0
2012-07-11	AAP	Stock	70.48	70.83	69.06	69.8	1240100.0
2012-07-11	AAT	Stock	25.07	25.07	24.66	24.89	89900.0
2012-07-11	AAU-DELISTED	Stock	1.96	2.02	1.89	1.91	169019.0
2012-07-11	AAUAF-DELISTED	Stock	1.96	2.02	1.89	1.91	170084.0
2012-07-11	AAV-DELISTED	Stock	3.25	3.3	3.22	3.27	178120.0
2012-07-11	AAWW-DELISTED	Stock	43.93	44.3	43.43	44.09	94425.0
2012-07-11	AAXJ	Stock	52.09	52.31	51.72	52.0	332647.0
2012-07-11	AAXN-DELISTED	Stock	5.18	5.2396	5.0	5.04	200807.0
2012-07-11	AB	Stock	12.68	12.89	12.4	12.56	152400.0
2012-07-11	ABAC-DELISTED	Stock	1.13	1.18	1.12	1.18	7300.0
2012-07-11	ABAX-DELISTED	Stock	38.9	39.274	38.61	38.91	60031.0
2012-07-11	ABB-DELISTED	Stock	15.95	16.04	15.8	15.94	1847447.0
2012-07-11	ABBNY-DELISTED	Stock	15.95	16.04	15.8	15.95	1949130.0
2012-07-11	ABC-DELISTED	Stock	38.92	39.5	38.92	39.29	2259524.0
2012-07-11	ABCB	Stock	12.75	12.82	12.61	12.68	53900.0
2012-07-11	ABCD-DELISTED	Stock	1.03	1.04	0.95	0.95	12353.0
2012-07-11	ABCO-DELISTED	Stock	49.84	50.88	49.84	50.58	204995.0
2012-07-11	ABCW-DELISTED	Stock	0.4	0.54	0.4	0.54	68516.0
2012-07-11	ABE-DELISTED	Stock	18.95	18.95	18.9001	18.91	5986.0
2012-07-11	ABEO	Stock	687.5	762.5	687.5	750.0	65.0
2012-07-11	ABFS-DELISTED	Stock	11.66	11.875	11.1	11.19	402520.0
2012-07-11	ABG	Stock	25.39	25.44	24.89	25.09	205100.0
2012-07-11	ABM	Stock	18.45	18.55	18.0	18.25	427800.0
2012-07-11	ABMD-DELISTED	Stock	23.71	24.0	23.36	23.92	394797.0
2012-07-11	ABR	Stock	5.34	5.35	5.21	5.24	55400.0
2012-07-11	ABT	Stock	31.3117	31.4269	31.1534	31.2734	15024802.0
2012-07-11	ABTL-DELISTED	Stock	3.8	3.899	3.658	3.85	1320.0
2012-07-11	ABUS	Stock	2.15	2.16	2.05	2.12	8500.0
2012-07-11	ABV-DELISTED	Stock	37.46	37.7	36.99	37.21	1639810.0
2012-07-11	ABX-DELISTED	Stock	35.57	35.67	34.47	34.95	12212283.0
2012-07-11	ACAD	Stock	1.86	1.86	1.74	1.75	466800.0
2012-07-11	ACAS-DELISTED	Stock	9.96	10.03	9.83	9.91	1397700.0
2012-07-11	ACAT-DELISTED	Stock	37.1	37.22	35.8	35.98	140911.0

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

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