PREVIEW / stock_daily / 2016-03-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-14.parquet
  size:    217 KB
  rows:    6,544
  symbols: 3,318

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-14	AAPL	Stock	25.4775	25.7275	25.445	25.63	100304400.0
2016-03-14	MSFT	Stock	52.71	53.59	52.63	53.17	24083600.0
2016-03-14	NVDA	Stock	0.8018	0.8108	0.798	0.8075	190312000.0
2016-03-14	AMZN	Stock	28.35	28.8445	28.1525	28.6685	69084000.0
2016-03-14	GOOGL	Stock	37.2485	37.713	37.1831	37.512	32823780.0
2016-03-14	META	Stock	109.28	110.33	108.77	109.89	17249400.0
2016-03-14	TSLA	Stock	14.1767	14.448	14.0427	14.3433	60985500.0
2016-03-14	TLT	Stock	127.82	128.39	127.66	127.76	5176989.0
2016-03-14	ES	Stock	56.59	56.83	56.15	56.74	1581400.0
2016-03-14	CL	Stock	68.34	68.59	67.83	68.24	2280100.0
2016-03-14	A	Stock	38.98	39.17	38.41	39.02	929600.0
2016-03-14	AA.B-DELISTED	Stock	31.5	32.3899	31.164	32.2673	13414.0
2016-03-14	AAAP-DELISTED	Stock	32.91	34.25	32.91	33.38	45414.0
2016-03-14	AABA-DELISTED	Stock	33.75	34.085	33.51	33.58	7781089.0
2016-03-14	AAC-DELISTED	Stock	18.0	18.3	17.62	18.0	132538.0
2016-03-14	AACG	Stock	4.78	4.98	4.78	4.98	7100.0
2016-03-14	AAIC-DELISTED	Stock	13.21	13.28	12.85	13.07	213251.0
2016-03-14	AAL	Stock	42.31	42.7	42.12	42.59	4568000.0
2016-03-14	AAMC-DELISTED	Stock	3.8235	4.0147	3.8235	3.9412	64114.0
2016-03-14	AAME	Stock	4.22	4.23	4.22	4.23	200.0
2016-03-14	AAMI	Stock	12.24	12.24	11.9	12.12	216200.0
2016-03-14	AAOI	Stock	17.57	18.09	17.44	17.45	163100.0
2016-03-14	AAON	Stock	16.9	17.6533	16.78	17.4067	418500.0
2016-03-14	AAP	Stock	157.53	160.14	157.35	159.34	665800.0
2016-03-14	AAT	Stock	38.19	38.23	37.94	38.02	89400.0
2016-03-14	AAU-DELISTED	Stock	0.75	0.7642	0.725	0.7304	165178.0
2016-03-14	AAUAF-DELISTED	Stock	0.75	0.7642	0.725	0.7304	165802.0
2016-03-14	AAV-DELISTED	Stock	5.54	5.59	5.39	5.45	95232.0
2016-03-14	AAVL-DELISTED	Stock	5.18	5.35	5.13	5.29	171118.0
2016-03-14	AAWW-DELISTED	Stock	40.4	40.4	38.57	39.6	208453.0
2016-03-14	AAXJ	Stock	52.88	53.09	52.77	52.92	441752.0
2016-03-14	AAXN-DELISTED	Stock	19.45	19.5289	19.16	19.33	722010.0
2016-03-14	AB	Stock	22.02	22.65	22.0	22.17	214600.0
2016-03-14	ABAC-DELISTED	Stock	0.65	0.65	0.62	0.644	3025.0
2016-03-14	ABAX-DELISTED	Stock	42.79	43.15	42.18	42.66	112389.0
2016-03-14	ABB-DELISTED	Stock	18.47	18.55	18.41	18.5	1117363.0
2016-03-14	ABBNY-DELISTED	Stock	18.47	18.55	18.41	18.5	1151944.0
2016-03-14	ABBV	Stock	57.67	57.73	56.97	57.21	4650800.0
2016-03-14	ABC-DELISTED	Stock	89.06	89.77	87.88	87.97	1297918.0
2016-03-14	ABCB	Stock	28.42	29.28	28.37	29.01	610300.0
2016-03-14	ABCD-DELISTED	Stock	4.47	4.55	4.41	4.52	12291.0
2016-03-14	ABCO-DELISTED	Stock	28.72	29.35	27.765	29.02	587868.0
2016-03-14	ABCW-DELISTED	Stock	44.14	44.19	43.71	43.9	52950.0
2016-03-14	ABDC-DELISTED	Stock	10.58	10.9	10.56	10.78	63615.0
2016-03-14	ABE-DELISTED	Stock	11.23	11.2599	11.23	11.2599	1500.0
2016-03-14	ABEO	Stock	70.0	74.75	68.75	73.75	2476.0
2016-03-14	ABEV	Stock	4.93	4.99	4.88	4.91	15132800.0
2016-03-14	ABG	Stock	61.04	61.37	59.14	59.24	427300.0
2016-03-14	ABGB-DELISTED	Stock	1.62	1.75	1.58	1.72	32609.0
2016-03-14	ABIL-DELISTED	Stock	6.45	6.7	6.35	6.6999	7094.0

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

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