PREVIEW / stock_daily / 2012-11-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-21.parquet
  size:    198 KB
  rows:    6,137
  symbols: 3,466

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-21	AAPL	Stock	20.1518	20.2632	19.8786	20.0607	373002000.0
2012-11-21	MSFT	Stock	26.71	27.17	26.67	26.95	66360300.0
2012-11-21	NVDA	Stock	0.2872	0.2962	0.287	0.2955	422312000.0
2012-11-21	AMZN	Stock	11.692	11.9335	11.6375	11.9015	59186000.0
2012-11-21	META	Stock	23.22	24.53	23.05	24.32	89862400.0
2012-11-21	TSLA	Stock	2.174	2.2313	2.1527	2.1647	14448000.0
2012-11-21	TLT	Stock	124.19	124.42	124.02	124.33	2424159.0
2012-11-21	ES	Stock	38.11	38.18	37.55	37.89	1670600.0
2012-11-21	CL	Stock	53.42	53.525	53.04	53.4	2120200.0
2012-11-21	A	Stock	25.98	26.0873	25.4936	25.6366	5597452.0
2012-11-21	AABA-DELISTED	Stock	18.24	18.5	18.195	18.39	18426775.0
2012-11-21	AACC-DELISTED	Stock	4.37	4.38	4.18	4.29	9023.0
2012-11-21	AACG	Stock	4.52	4.66	4.37	4.37	6300.0
2012-11-21	AAIC-DELISTED	Stock	20.81	21.01	20.58	20.99	77781.0
2012-11-21	AAME	Stock	2.94	2.94	2.93	2.93	2700.0
2012-11-21	AAMRQ-DELISTED	Stock	0.38	0.427	0.379	0.427	2126058.0
2012-11-21	AAON	Stock	5.9911	6.0356	5.92	6.0178	85725.0
2012-11-21	AAP	Stock	77.62	78.19	77.16	77.93	238600.0
2012-11-21	AAT	Stock	27.74	28.23	27.27	27.43	42100.0
2012-11-21	AAU-DELISTED	Stock	2.5	2.57	2.5	2.54	41369.0
2012-11-21	AAUAF-DELISTED	Stock	2.5	2.57	2.5	2.54	41869.0
2012-11-21	AAV-DELISTED	Stock	3.35	3.36	3.33	3.33	157050.0
2012-11-21	AAWW-DELISTED	Stock	42.27	42.4	40.55	42.24	145749.0
2012-11-21	AAXJ	Stock	56.27	56.55	56.19	56.42	112990.0
2012-11-21	AAXN-DELISTED	Stock	8.05	8.25	8.0111	8.13	302970.0
2012-11-21	AB	Stock	17.28	17.99	17.09	17.99	958600.0
2012-11-21	ABAC-DELISTED	Stock	0.83	0.83	0.8	0.81	5300.0
2012-11-21	ABAX-DELISTED	Stock	36.65	36.71	36.14	36.67	33792.0
2012-11-21	ABB-DELISTED	Stock	18.27	18.3	18.16	18.3	2881739.0
2012-11-21	ABBNY-DELISTED	Stock	18.27	18.3	18.16	18.28	2982718.0
2012-11-21	ABC-DELISTED	Stock	40.78	40.91	40.69	40.84	1585183.0
2012-11-21	ABCB	Stock	10.92	10.92	10.6	10.82	20800.0
2012-11-21	ABCD-DELISTED	Stock	0.94	1.15	0.87	0.93	29650.0
2012-11-21	ABCO-DELISTED	Stock	43.23	43.46	42.72	43.35	138063.0
2012-11-21	ABCW-DELISTED	Stock	0.37	0.43	0.37	0.43	16145.0
2012-11-21	ABE-DELISTED	Stock	20.32	20.32	20.0873	20.11	1502.0
2012-11-21	ABEO	Stock	300.0	312.5	300.0	312.5	4.0
2012-11-21	ABFS-DELISTED	Stock	7.21	7.43	7.19	7.4	132464.0
2012-11-21	ABG	Stock	29.65	30.09	29.47	30.0	206000.0
2012-11-21	ABM	Stock	18.56	18.73	18.38	18.69	108100.0
2012-11-21	ABMD-DELISTED	Stock	13.86	13.98	13.76	13.97	334461.0
2012-11-21	ABR	Stock	5.14	5.22	5.11	5.18	110300.0
2012-11-21	ABT	Stock	30.3569	30.4577	30.2274	30.3857	9191121.0
2012-11-21	ABTL-DELISTED	Stock	3.93	3.93	3.825	3.86	54984.0
2012-11-21	ABUS	Stock	5.15	5.16	4.91	5.08	72800.0
2012-11-21	ABV-DELISTED	Stock	40.23	40.73	40.15	40.63	1015045.0
2012-11-21	ABVA-DELISTED	Stock	4.48	4.48	4.4799	4.4799	1100.0
2012-11-21	ABX-DELISTED	Stock	34.19	34.86	34.08	34.82	4934862.0
2012-11-21	ACAD	Stock	2.19	2.24	2.13	2.15	1712000.0
2012-11-21	ACAS-DELISTED	Stock	11.685	11.695	11.605	11.68	1201828.0

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

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