PREVIEW / stock_daily / 2012-11-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-12.parquet
  size:    198 KB
  rows:    6,151
  symbols: 3,463

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-11-12	AAPL	Stock	19.7911	19.8036	19.2375	19.3868	515802000.0
2012-11-12	MSFT	Stock	28.94	29.01	28.21	28.22	61112300.0
2012-11-12	NVDA	Stock	0.3052	0.3065	0.295	0.298	643624000.0
2012-11-12	AMZN	Stock	11.3295	11.461	11.2705	11.3235	42576000.0
2012-11-12	META	Stock	19.15	20.17	18.87	20.07	67349200.0
2012-11-12	TSLA	Stock	2.0193	2.0947	2.0107	2.0713	8338500.0
2012-11-12	TLT	Stock	125.84	126.38	125.79	126.19	2072128.0
2012-11-12	ES	Stock	38.2	38.21	37.83	37.96	890000.0
2012-11-12	CL	Stock	51.995	52.435	51.755	52.155	1892000.0
2012-11-12	A	Stock	26.5093	26.5737	26.2876	26.3376	2898613.0
2012-11-12	AABA-DELISTED	Stock	17.17	17.56	17.17	17.52	21546933.0
2012-11-12	AACC-DELISTED	Stock	5.05	5.39	5.05	5.27	20840.0
2012-11-12	AACG	Stock	4.74	4.74	4.65	4.65	200.0
2012-11-12	AAIC-DELISTED	Stock	20.55	20.68	20.2716	20.53	80377.0
2012-11-12	AAME	Stock	2.9	2.92	2.89	2.92	2500.0
2012-11-12	AAMRQ-DELISTED	Stock	0.364	0.3969	0.3626	0.38	1611078.0
2012-11-12	AAON	Stock	5.6593	6.0207	5.6593	5.7185	208238.0
2012-11-12	AAP	Stock	79.48	79.82	77.89	78.27	846500.0
2012-11-12	AAT	Stock	27.58	27.75	27.32	27.48	98600.0
2012-11-12	AAU-DELISTED	Stock	2.7	2.7	2.64	2.66	156395.0
2012-11-12	AAUAF-DELISTED	Stock	2.7	2.73	2.66	2.66	154854.0
2012-11-12	AAV-DELISTED	Stock	3.42	3.45	3.38	3.42	79644.0
2012-11-12	AAWW-DELISTED	Stock	42.69	43.15	42.33	42.67	95451.0
2012-11-12	AAXJ	Stock	56.62	56.88	56.56	56.73	282918.0
2012-11-12	AAXN-DELISTED	Stock	8.03	8.06	7.865	7.96	351474.0
2012-11-12	AB	Stock	16.07	16.47	15.88	16.43	549600.0
2012-11-12	ABAC-DELISTED	Stock	0.92	1.0	0.92	0.95	10329.0
2012-11-12	ABAX-DELISTED	Stock	36.63	36.92	35.85	36.02	97188.0
2012-11-12	ABB-DELISTED	Stock	18.22	18.32	18.18	18.2	939207.0
2012-11-12	ABBNY-DELISTED	Stock	18.22	18.32	18.18	18.22	960000.0
2012-11-12	ABC-DELISTED	Stock	40.6	40.6	39.92	40.06	1807240.0
2012-11-12	ABCB	Stock	10.64	10.75	10.51	10.51	8600.0
2012-11-12	ABCD-DELISTED	Stock	0.84	1.01	0.84	0.96	24536.0
2012-11-12	ABCO-DELISTED	Stock	45.65	46.463	44.5902	45.96	179594.0
2012-11-12	ABCW-DELISTED	Stock	0.3999	0.42	0.38	0.42	36474.0
2012-11-12	ABE-DELISTED	Stock	20.02	20.06	20.02	20.02	6714.0
2012-11-12	ABEO	Stock	375.0	375.0	325.0	337.5	57.0
2012-11-12	ABFS-DELISTED	Stock	7.34	7.46	7.24	7.27	164484.0
2012-11-12	ABG	Stock	29.45	29.76	29.18	29.23	167000.0
2012-11-12	ABM	Stock	19.01	19.08	18.8	18.87	98600.0
2012-11-12	ABMD-DELISTED	Stock	13.26	13.59	13.13	13.5	441465.0
2012-11-12	ABR	Stock	5.4	5.51	5.33	5.36	92400.0
2012-11-12	ABT	Stock	31.1726	31.3405	31.1006	31.1246	13703627.0
2012-11-12	ABTL-DELISTED	Stock	3.8601	4.21	3.8601	4.13	9945.0
2012-11-12	ABUS	Stock	5.1	5.25	4.95	5.12	83800.0
2012-11-12	ABV-DELISTED	Stock	39.5	39.64	39.12	39.3	1270458.0
2012-11-12	ABX-DELISTED	Stock	36.07	36.35	35.56	35.83	4534362.0
2012-11-12	ACAD	Stock	2.29	2.32	2.15	2.18	1447100.0
2012-11-12	ACAS-DELISTED	Stock	11.45	11.64	11.45	11.63	3756960.0
2012-11-12	ACAT-DELISTED	Stock	35.1	35.66	33.61	33.65	284826.0

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

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