PREVIEW / stock_daily / 2016-06-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-27.parquet
  size:    219 KB
  rows:    6,576
  symbols: 3,270

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-06-27	AAPL	Stock	23.25	23.2625	22.875	23.01	181958400.0
2016-06-27	MSFT	Stock	49.1	49.15	48.04	48.43	50216300.0
2016-06-27	NVDA	Stock	1.1338	1.1425	1.1142	1.131	449088000.0
2016-06-27	AMZN	Stock	34.6005	34.841	34.106	34.568	111360000.0
2016-06-27	GOOGL	Stock	34.1245	34.1663	33.633	34.057	58389720.0
2016-06-27	META	Stock	111.57	111.57	108.23	108.97	36130400.0
2016-06-27	TSLA	Stock	12.724	13.254	12.5247	13.2367	108081000.0
2016-06-27	TLT	Stock	138.44	139.59	138.4	139.17	17573865.0
2016-06-27	ES	Stock	57.12	58.82	57.12	58.59	2988100.0
2016-06-27	CL	Stock	70.14	70.23	69.71	69.99	3421800.0
2016-06-27	A	Stock	43.63	43.71	41.98	42.26	4328100.0
2016-06-27	AA.B-DELISTED	Stock	32.98	32.98	31.6885	32.0699	29102.0
2016-06-27	AAAP-DELISTED	Stock	28.67	28.69	27.65	28.17	87272.0
2016-06-27	AABA-DELISTED	Stock	35.92	36.01	35.05	35.22	13088211.0
2016-06-27	AAC-DELISTED	Stock	20.46	20.46	19.495	20.04	214017.0
2016-06-27	AACG	Stock	4.83	5.19	4.83	4.84	5000.0
2016-06-27	AAIC-DELISTED	Stock	13.42	13.43	13.1	13.3	723557.0
2016-06-27	AAL	Stock	26.85	26.85	24.85	25.27	23170100.0
2016-06-27	AAMC-DELISTED	Stock	4.3676	4.4088	3.9	3.9706	140060.0
2016-06-27	AAME	Stock	4.0	4.18	3.95	4.18	5600.0
2016-06-27	AAMI	Stock	13.47	13.5	12.86	12.88	396600.0
2016-06-27	AAOI	Stock	9.77	9.77	9.07	9.2	452000.0
2016-06-27	AAON	Stock	17.36	17.6933	17.2	17.46	566400.0
2016-06-27	AAP	Stock	153.74	155.7	152.2	153.78	2242500.0
2016-06-27	AAT	Stock	40.59	40.9	40.21	40.71	157600.0
2016-06-27	AAU-DELISTED	Stock	1.33	1.37	1.27	1.29	435910.0
2016-06-27	AAUAF-DELISTED	Stock	1.33	1.37	1.27	1.29	438824.0
2016-06-27	AAV-DELISTED	Stock	5.31	5.4301	5.25	5.34	67005.0
2016-06-27	AAWW-DELISTED	Stock	39.77	39.77	37.88	38.45	320944.0
2016-06-27	AAXJ	Stock	52.18	52.18	51.21	51.74	1162373.0
2016-06-27	AAXN-DELISTED	Stock	22.74	23.29	22.53	22.77	835424.0
2016-06-27	AB	Stock	22.25	22.34	21.49	21.56	365500.0
2016-06-27	ABAC-DELISTED	Stock	0.78	0.85	0.73	0.79	20892.0
2016-06-27	ABAX-DELISTED	Stock	44.13	44.51	43.57	43.97	110195.0
2016-06-27	ABB-DELISTED	Stock	19.52	19.53	19.08	19.29	2807293.0
2016-06-27	ABBNY-DELISTED	Stock	19.53	19.53	19.08	19.29	3279061.0
2016-06-27	ABBV	Stock	59.38	59.68	58.33	58.68	7945500.0
2016-06-27	ABC-DELISTED	Stock	75.14	75.18	73.44	73.85	1969669.0
2016-06-27	ABCB	Stock	28.59	28.62	27.92	27.95	279800.0
2016-06-27	ABCD-DELISTED	Stock	4.53	4.6	4.39	4.47	37372.0
2016-06-27	ABCO-DELISTED	Stock	34.52	35.17	32.23	33.74	705138.0
2016-06-27	ABDC-DELISTED	Stock	12.16	12.3199	12.1	12.16	76849.0
2016-06-27	ABE-DELISTED	Stock	12.29	12.29	11.55	11.55	1500.0
2016-06-27	ABEO	Stock	61.75	66.25	58.5	61.0	2492.0
2016-06-27	ABEV	Stock	5.43	5.53	5.39	5.47	27150300.0
2016-06-27	ABG	Stock	52.83	52.97	51.29	51.97	479300.0
2016-06-27	ABIL-DELISTED	Stock	4.09	4.1	3.66	3.86	58931.0
2016-06-27	ABM	Stock	35.56	35.61	35.03	35.23	346000.0
2016-06-27	ABMD-DELISTED	Stock	99.57	101.45	99.4	101.24	936422.0
2016-06-27	ABR	Stock	6.83	6.9	6.7	6.71	144000.0

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

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