PREVIEW / stock_daily / 2012-10-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-18.parquet
  size:    200 KB
  rows:    6,132
  symbols: 3,467

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-10-18	AAPL	Stock	22.8425	22.9307	22.5	22.5943	476624400.0
2012-10-18	MSFT	Stock	29.65	29.73	29.26	29.5	59238500.0
2012-10-18	NVDA	Stock	0.3258	0.3258	0.3203	0.3215	254772000.0
2012-10-18	AMZN	Stock	12.3885	12.5455	12.135	12.2425	106106000.0
2012-10-18	META	Stock	19.7	19.79	18.89	18.98	52157400.0
2012-10-18	TSLA	Stock	1.9327	1.9327	1.852	1.8693	11115000.0
2012-10-18	TLT	Stock	121.12	121.53	119.87	120.11	8558559.0
2012-10-18	ES	Stock	39.5	39.83	39.41	39.8	1046600.0
2012-10-18	CL	Stock	55.275	55.445	54.89	55.31	2506200.0
2012-10-18	A	Stock	26.8884	26.8956	26.073	26.2089	9045340.0
2012-10-18	AABA-DELISTED	Stock	16.23	16.24	15.83	16.01	26204399.0
2012-10-18	AACC-DELISTED	Stock	7.72	7.75	7.586	7.63	5837.0
2012-10-18	AACG	Stock	4.54	4.6	4.54	4.55	600.0
2012-10-18	AAIC-DELISTED	Stock	22.4	22.41	22.19	22.2	76765.0
2012-10-18	AAME	Stock	2.8	2.8	2.8	2.8	300.0
2012-10-18	AAMRQ-DELISTED	Stock	0.371	0.383	0.365	0.367	1172730.0
2012-10-18	AAON	Stock	5.7748	5.8637	5.7541	5.7867	113738.0
2012-10-18	AAP	Stock	68.18	68.92	67.22	68.31	1012900.0
2012-10-18	AAT	Stock	27.94	28.45	27.94	28.41	69600.0
2012-10-18	AAU-DELISTED	Stock	2.52	2.54	2.5	2.5	101383.0
2012-10-18	AAUAF-DELISTED	Stock	2.52	2.54	2.5	2.5	101583.0
2012-10-18	AAV-DELISTED	Stock	3.93	4.07	3.9	3.96	586324.0
2012-10-18	AAWW-DELISTED	Stock	53.22	53.34	52.4696	52.53	177114.0
2012-10-18	AAXJ	Stock	57.29	57.5	57.0414	57.23	243862.0
2012-10-18	AAXN-DELISTED	Stock	6.38	6.47	6.27	6.43	513159.0
2012-10-18	AB	Stock	16.59	16.7	16.53	16.6	168600.0
2012-10-18	ABAC-DELISTED	Stock	1.29	1.38	1.29	1.36	4250.0
2012-10-18	ABAX-DELISTED	Stock	37.59	37.75	36.31	37.05	69030.0
2012-10-18	ABB-DELISTED	Stock	19.66	19.855	19.63	19.76	1811738.0
2012-10-18	ABBNY-DELISTED	Stock	19.66	19.855	19.63	19.75	1826220.0
2012-10-18	ABC-DELISTED	Stock	40.43	40.85	40.38	40.67	1531074.0
2012-10-18	ABCB	Stock	12.46	12.47	12.13	12.2	36700.0
2012-10-18	ABCD-DELISTED	Stock	0.98	0.98	0.98	0.98	100.0
2012-10-18	ABCO-DELISTED	Stock	48.36	48.92	48.0	48.66	88575.0
2012-10-18	ABCW-DELISTED	Stock	0.39	0.39	0.3601	0.3601	11034.0
2012-10-18	ABE-DELISTED	Stock	20.76	20.921	20.66	20.915	29491.0
2012-10-18	ABEO	Stock	287.5	400.0	287.5	362.5	83.0
2012-10-18	ABFS-DELISTED	Stock	8.21	8.33	8.16	8.19	161483.0
2012-10-18	ABG	Stock	30.52	31.1	30.29	31.02	204100.0
2012-10-18	ABM	Stock	18.51	18.59	18.45	18.52	154000.0
2012-10-18	ABMD-DELISTED	Stock	20.15	20.59	19.87	20.32	573521.0
2012-10-18	ABR	Stock	5.55	5.56	5.52	5.56	147300.0
2012-10-18	ABT	Stock	31.7052	32.0554	30.9567	31.9739	70934556.0
2012-10-18	ABTL-DELISTED	Stock	3.91	4.0214	3.91	3.94	10526.0
2012-10-18	ABUS	Stock	3.88	3.91	3.88	3.88	1200.0
2012-10-18	ABV-DELISTED	Stock	41.29	42.05	41.09	41.82	1810591.0
2012-10-18	ABX-DELISTED	Stock	39.46	39.68	38.85	38.93	6473517.0
2012-10-18	ACAD	Stock	2.59	2.63	2.46	2.48	1093100.0
2012-10-18	ACAS-DELISTED	Stock	11.86	12.24	11.86	12.05	3860038.0
2012-10-18	ACAT-DELISTED	Stock	41.45	42.61	40.5	42.38	258104.0

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

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