PREVIEW / stock_daily / 2012-11-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-06.parquet
  size:    199 KB
  rows:    6,160
  symbols: 3,488

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-06	AAPL	Stock	21.0796	21.0979	20.7175	20.8161	374917200.0
2012-11-06	MSFT	Stock	29.82	30.2	29.61	29.86	43401500.0
2012-11-06	NVDA	Stock	0.3263	0.3263	0.3198	0.3253	350804000.0
2012-11-06	AMZN	Stock	11.7705	11.8875	11.7225	11.878	53226000.0
2012-11-06	META	Stock	21.24	21.37	20.99	21.17	29062700.0
2012-11-06	TSLA	Stock	2.0407	2.08	1.9967	2.0767	34860000.0
2012-11-06	TLT	Stock	122.55	122.86	121.78	121.79	4484592.0
2012-11-06	ES	Stock	39.06	39.4	38.97	39.18	1183900.0
2012-11-06	CL	Stock	52.745	53.005	52.535	52.82	2978400.0
2012-11-06	A	Stock	26.917	27.525	26.8598	27.382	5208389.0
2012-11-06	AABA-DELISTED	Stock	17.44	17.53	17.32	17.47	25614433.0
2012-11-06	AACC-DELISTED	Stock	6.3	6.7	6.15	6.31	35398.0
2012-11-06	AACG	Stock	4.73	4.8	4.6	4.78	2100.0
2012-11-06	AAIC-DELISTED	Stock	22.1	22.26	21.81	21.89	168035.0
2012-11-06	AAME	Stock	2.9	2.94	2.87	2.94	2700.0
2012-11-06	AAMRQ-DELISTED	Stock	0.382	0.387	0.376	0.3766	505573.0
2012-11-06	AAON	Stock	6.1037	6.2341	6.083	6.1274	156938.0
2012-11-06	AAP	Stock	80.8	81.76	80.16	80.44	1306300.0
2012-11-06	AAT	Stock	27.03	27.95	26.93	27.45	92300.0
2012-11-06	AAU-DELISTED	Stock	2.55	2.55	2.5	2.55	109345.0
2012-11-06	AAUAF-DELISTED	Stock	2.55	2.55	2.5	2.55	125685.0
2012-11-06	AAV-DELISTED	Stock	3.6	3.61	3.53	3.6	93794.0
2012-11-06	AAWW-DELISTED	Stock	43.96	44.7699	43.96	44.46	220649.0
2012-11-06	AAXJ	Stock	57.37	57.81	57.31	57.71	153863.0
2012-11-06	AAXN-DELISTED	Stock	8.15	8.41	7.97	8.25	771580.0
2012-11-06	AB	Stock	16.63	16.68	16.48	16.66	424200.0
2012-11-06	ABAC-DELISTED	Stock	1.17	1.26	1.17	1.2432	5787.0
2012-11-06	ABAX-DELISTED	Stock	37.45	38.19	37.06	37.2	85746.0
2012-11-06	ABB-DELISTED	Stock	18.53	18.67	18.49	18.56	1291133.0
2012-11-06	ABBNY-DELISTED	Stock	18.53	18.67	18.49	18.57	1316038.0
2012-11-06	ABC-DELISTED	Stock	40.25	40.62	40.0	40.33	1764458.0
2012-11-06	ABCB	Stock	11.05	11.27	10.84	11.24	26200.0
2012-11-06	ABCD-DELISTED	Stock	0.8	0.85	0.8	0.8	9968.0
2012-11-06	ABCO-DELISTED	Stock	48.77	48.96	47.92	48.4	129661.0
2012-11-06	ABCW-DELISTED	Stock	0.35	0.42	0.35	0.37	69543.0
2012-11-06	ABE-DELISTED	Stock	20.63	20.75	20.55	20.55	16795.0
2012-11-06	ABEO	Stock	437.5	437.5	387.5	437.5	32.0
2012-11-06	ABFS-DELISTED	Stock	8.18	8.66	8.11	8.65	479550.0
2012-11-06	ABG	Stock	31.51	31.8	31.28	31.44	219600.0
2012-11-06	ABM	Stock	19.28	19.63	19.15	19.48	171000.0
2012-11-06	ABMD-DELISTED	Stock	13.58	13.7	13.17	13.36	925978.0
2012-11-06	ABR	Stock	5.41	5.51	5.39	5.42	161400.0
2012-11-06	ABT	Stock	31.2206	31.3309	31.0766	31.1006	11469571.0
2012-11-06	ABTL-DELISTED	Stock	4.0	4.3	4.0	4.29	8170.0
2012-11-06	ABUS	Stock	4.32	4.55	4.2	4.23	29300.0
2012-11-06	ABV-DELISTED	Stock	40.73	41.05	40.37	40.92	995826.0
2012-11-06	ABVA-DELISTED	Stock	4.35	4.4	4.35	4.4	27727.0
2012-11-06	ABX-DELISTED	Stock	35.59	36.07	35.17	35.56	9536050.0
2012-11-06	ACAD	Stock	2.4	2.67	2.34	2.42	6420000.0
2012-11-06	ACAS-DELISTED	Stock	11.8	12.01	11.75	11.93	6533256.0

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

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