PREVIEW / stock_daily / 2016-03-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-22.parquet
  size:    218 KB
  rows:    6,557
  symbols: 3,319

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
2016-03-22	AAPL	Stock	26.3125	26.8225	26.3025	26.68	129777600.0
2016-03-22	MSFT	Stock	53.61	54.25	53.46	54.07	23124100.0
2016-03-22	NVDA	Stock	0.845	0.8523	0.8358	0.8462	242012000.0
2016-03-22	AMZN	Stock	27.2555	28.138	27.2525	28.024	80012000.0
2016-03-22	GOOGL	Stock	37.922	38.25	37.8938	38.0025	22095680.0
2016-03-22	META	Stock	111.36	112.88	111.17	112.25	19001100.0
2016-03-22	TSLA	Stock	15.814	15.9327	15.504	15.616	64740000.0
2016-03-22	TLT	Stock	128.83	129.02	127.921	128.04	4997933.0
2016-03-22	ES	Stock	57.35	57.67	57.07	57.48	2030800.0
2016-03-22	CL	Stock	70.0	70.3	69.28	69.56	3637400.0
2016-03-22	A	Stock	39.56	40.04	39.45	39.88	1552300.0
2016-03-22	AA.B-DELISTED	Stock	32.94	33.0	32.19	32.85	8852.0
2016-03-22	AAAP-DELISTED	Stock	37.5	37.75	36.51	36.8	16766.0
2016-03-22	AABA-DELISTED	Stock	34.68	35.61	34.68	35.41	10842371.0
2016-03-22	AAC-DELISTED	Stock	20.0	20.1699	19.03	19.16	208460.0
2016-03-22	AACG	Stock	5.39	5.39	5.01	5.11	1100.0
2016-03-22	AAIC-DELISTED	Stock	13.62	13.63	13.43	13.49	281367.0
2016-03-22	AAL	Stock	42.0	43.02	41.84	42.76	6721600.0
2016-03-22	AAMC-DELISTED	Stock	4.1029	4.1618	3.9765	4.1118	57729.0
2016-03-22	AAME	Stock	4.02	4.2	4.0	4.2	2300.0
2016-03-22	AAMI	Stock	12.84	12.99	12.51	12.58	137000.0
2016-03-22	AAOI	Stock	17.28	17.32	15.81	16.16	540200.0
2016-03-22	AAON	Stock	18.02	18.5933	17.9467	18.2467	248400.0
2016-03-22	AAP	Stock	157.98	159.27	157.47	158.19	404200.0
2016-03-22	AAT	Stock	37.63	38.14	37.26	38.07	99000.0
2016-03-22	AAU-DELISTED	Stock	0.73	0.7344	0.6944	0.7108	170925.0
2016-03-22	AAUAF-DELISTED	Stock	0.73	0.7344	0.6944	0.7108	172194.0
2016-03-22	AAV-DELISTED	Stock	5.39	5.47	5.32	5.37	56307.0
2016-03-22	AAVL-DELISTED	Stock	5.34	5.56	5.19	5.39	209949.0
2016-03-22	AAWW-DELISTED	Stock	42.52	43.1592	41.2305	41.53	184989.0
2016-03-22	AAXJ	Stock	54.09	54.44	54.02	54.25	377667.0
2016-03-22	AAXN-DELISTED	Stock	18.89	19.21	18.71	18.73	578252.0
2016-03-22	AB	Stock	22.8	22.87	22.1	22.73	174900.0
2016-03-22	ABAC-DELISTED	Stock	0.64	0.68	0.64	0.68	917.0
2016-03-22	ABAX-DELISTED	Stock	41.46	42.51	41.32	42.39	131223.0
2016-03-22	ABB-DELISTED	Stock	19.16	19.3	19.12	19.24	1218975.0
2016-03-22	ABBNY-DELISTED	Stock	19.16	19.3	19.12	19.24	1251660.0
2016-03-22	ABBV	Stock	55.75	57.54	55.75	57.5	7661600.0
2016-03-22	ABC-DELISTED	Stock	87.27	87.5315	86.62	87.18	1489841.0
2016-03-22	ABCB	Stock	28.97	29.68	28.11	28.91	75900.0
2016-03-22	ABCD-DELISTED	Stock	4.34	4.47	4.3	4.41	9398.0
2016-03-22	ABCO-DELISTED	Stock	30.49	31.0	30.1	30.74	260503.0
2016-03-22	ABCW-DELISTED	Stock	43.99	44.07	43.69	43.73	19401.0
2016-03-22	ABDC-DELISTED	Stock	10.95	11.59	10.95	11.13	85579.0
2016-03-22	ABE-DELISTED	Stock	11.48	11.53	11.47	11.5	2736.0
2016-03-22	ABEO	Stock	73.5	74.5	72.0	72.25	1044.0
2016-03-22	ABEOW-DELISTED	Stock	0.71	0.71	0.71	0.71	100.0
2016-03-22	ABEV	Stock	5.1	5.18	5.06	5.15	26053800.0
2016-03-22	ABG	Stock	60.6	61.33	60.3	60.37	360900.0
2016-03-22	ABGB-DELISTED	Stock	1.38	1.5688	1.38	1.5199	43628.0

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

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