PREVIEW / stock_daily / 2012-11-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-14.parquet
  size:    200 KB
  rows:    6,206
  symbols: 3,495

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-14	AAPL	Stock	19.4821	19.5518	19.1493	19.1743	477170400.0
2012-11-14	MSFT	Stock	27.24	27.29	26.8	26.84	76086100.0
2012-11-14	NVDA	Stock	0.2975	0.3005	0.2882	0.2885	619300000.0
2012-11-14	AMZN	Stock	11.325	11.3705	11.1255	11.1475	60682000.0
2012-11-14	META	Stock	20.1	22.5	19.93	22.36	229751000.0
2012-11-14	TSLA	Stock	2.1307	2.1413	2.08	2.092	13069500.0
2012-11-14	TLT	Stock	125.72	126.79	125.6	126.73	4694693.0
2012-11-14	ES	Stock	38.29	38.39	37.69	37.99	1584200.0
2012-11-14	CL	Stock	52.245	52.48	51.58	51.765	3215200.0
2012-11-14	A	Stock	26.0515	26.2876	25.8226	25.8512	4431101.0
2012-11-14	AABA-DELISTED	Stock	17.94	18.075	17.75	17.83	35414057.0
2012-11-14	AACC-DELISTED	Stock	5.19	5.19	4.57	4.61	28882.0
2012-11-14	AAIC-DELISTED	Stock	19.59	19.72	17.84	18.44	599742.0
2012-11-14	AAME	Stock	2.92	2.92	2.88	2.92	1900.0
2012-11-14	AAMRQ-DELISTED	Stock	0.372	0.382	0.364	0.376	569201.0
2012-11-14	AAON	Stock	5.7659	5.7659	5.6385	5.6415	118463.0
2012-11-14	AAP	Stock	79.65	80.1	77.3	77.85	1043900.0
2012-11-14	AAT	Stock	27.13	27.21	26.17	26.25	234400.0
2012-11-14	AAU-DELISTED	Stock	2.54	2.56	2.495	2.4951	216417.0
2012-11-14	AAUAF-DELISTED	Stock	2.55	2.57	2.49	2.49	216242.0
2012-11-14	AAV-DELISTED	Stock	3.4	3.41	3.35	3.35	71414.0
2012-11-14	AAWW-DELISTED	Stock	41.78	41.92	40.15	40.23	168630.0
2012-11-14	AAXJ	Stock	56.23	56.38	55.5	55.63	392268.0
2012-11-14	AAXN-DELISTED	Stock	8.0	8.07	7.8	7.88	582828.0
2012-11-14	AB	Stock	16.53	16.78	16.16	16.5	393100.0
2012-11-14	ABAC-DELISTED	Stock	0.89	0.9868	0.83	0.85	30903.0
2012-11-14	ABAX-DELISTED	Stock	36.12	36.29	35.26	35.47	81764.0
2012-11-14	ABB-DELISTED	Stock	18.09	18.1	17.73	17.81	2945311.0
2012-11-14	ABBNY-DELISTED	Stock	18.09	18.1	17.73	17.8	3182422.0
2012-11-14	ABC-DELISTED	Stock	40.34	40.94	40.12	40.21	2079681.0
2012-11-14	ABCB	Stock	10.5	10.52	10.31	10.5	60400.0
2012-11-14	ABCD-DELISTED	Stock	0.84	0.95	0.84	0.9	36160.0
2012-11-14	ABCO-DELISTED	Stock	46.79	46.79	45.1	45.22	80069.0
2012-11-14	ABCW-DELISTED	Stock	0.43	0.43	0.3801	0.3801	14100.0
2012-11-14	ABE-DELISTED	Stock	20.15	20.15	19.54	19.6975	11498.0
2012-11-14	ABEO	Stock	325.0	325.0	287.5	325.0	115.0
2012-11-14	ABFS-DELISTED	Stock	7.22	7.33	6.9	6.96	343308.0
2012-11-14	ABG	Stock	29.33	29.37	27.61	27.83	440100.0
2012-11-14	ABM	Stock	18.94	19.01	18.69	18.77	185600.0
2012-11-14	ABMD-DELISTED	Stock	13.61	13.73	13.48	13.51	396805.0
2012-11-14	ABR	Stock	5.2	5.32	5.07	5.07	172900.0
2012-11-14	ABT	Stock	31.0575	31.2206	30.5009	30.5825	14034181.0
2012-11-14	ABTL-DELISTED	Stock	4.01	4.02	3.85	4.0	25731.0
2012-11-14	ABUS	Stock	5.84	5.9	5.47	5.48	231400.0
2012-11-14	ABV-DELISTED	Stock	39.65	39.7	38.93	39.06	1162817.0
2012-11-14	ABVA-DELISTED	Stock	4.39	4.39	4.39	4.39	100.0
2012-11-14	ABX-DELISTED	Stock	35.26	35.33	33.81	33.92	10475823.0
2012-11-14	ACAD	Stock	2.09	2.19	1.9	1.94	2367400.0
2012-11-14	ACAS-DELISTED	Stock	11.56	11.639	11.12	11.2	5690866.0
2012-11-14	ACAT-DELISTED	Stock	33.65	34.13	32.27	32.67	300029.0

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

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