PREVIEW / stock_daily / 2016-03-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-16.parquet
  size:    217 KB
  rows:    6,523
  symbols: 3,301

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-16	AAPL	Stock	26.1525	26.5775	26.1475	26.4925	153214000.0
2016-03-16	MSFT	Stock	53.45	54.6	53.4	54.35	31691700.0
2016-03-16	NVDA	Stock	0.7975	0.8302	0.7938	0.8275	363644000.0
2016-03-16	AMZN	Stock	28.832	29.066	28.557	28.7135	70754000.0
2016-03-16	GOOGL	Stock	37.4525	37.95	37.325	37.868	29305700.0
2016-03-16	META	Stock	110.49	112.5	110.1	112.18	24744800.0
2016-03-16	TSLA	Stock	14.5333	14.8387	14.468	14.7953	52750500.0
2016-03-16	TLT	Stock	127.75	128.52	127.37	128.26	9728881.0
2016-03-16	ES	Stock	56.5	57.58	56.05	57.39	1406500.0
2016-03-16	CL	Stock	68.41	68.82	67.86	68.68	2603300.0
2016-03-16	A	Stock	38.09	39.1	38.02	38.98	1956100.0
2016-03-16	AA.B-DELISTED	Stock	30.88	32.42	30.43	32.42	22464.0
2016-03-16	AAAP-DELISTED	Stock	34.59	35.18	33.81	34.11	85553.0
2016-03-16	AABA-DELISTED	Stock	33.03	34.08	33.0	34.01	10446823.0
2016-03-16	AAC-DELISTED	Stock	17.02	17.5	16.82	17.01	73840.0
2016-03-16	AACG	Stock	4.98	5.19	4.9	5.01	10300.0
2016-03-16	AAIC-DELISTED	Stock	12.98	13.2097	12.81	13.17	359563.0
2016-03-16	AAL	Stock	41.81	42.43	41.59	42.31	4792900.0
2016-03-16	AAMC-DELISTED	Stock	3.8236	3.9529	3.8236	3.9324	57171.0
2016-03-16	AAMI	Stock	11.84	12.32	11.64	12.21	123800.0
2016-03-16	AAOI	Stock	16.83	17.5	16.5	17.4	175100.0
2016-03-16	AAON	Stock	16.9	17.4867	16.9	17.36	141000.0
2016-03-16	AAP	Stock	158.46	160.16	157.02	158.96	486800.0
2016-03-16	AAT	Stock	37.63	38.4	37.2	38.19	75900.0
2016-03-16	AAU-DELISTED	Stock	0.6772	0.75	0.6772	0.7301	126278.0
2016-03-16	AAUAF-DELISTED	Stock	0.6772	0.75	0.6772	0.7301	126811.0
2016-03-16	AAV-DELISTED	Stock	5.32	5.4901	5.29	5.47	128572.0
2016-03-16	AAVL-DELISTED	Stock	4.86	4.98	4.81	4.905	207596.0
2016-03-16	AAWW-DELISTED	Stock	38.53	39.72	38.53	39.7	236084.0
2016-03-16	AAXJ	Stock	52.19	53.435	52.09	53.34	2481952.0
2016-03-16	AAXN-DELISTED	Stock	18.22	18.83	18.2	18.5	1002822.0
2016-03-16	AB	Stock	21.58	22.68	21.52	22.53	214600.0
2016-03-16	ABAC-DELISTED	Stock	0.66	0.66	0.6186	0.6186	600.0
2016-03-16	ABAX-DELISTED	Stock	41.88	42.13	41.17	41.9	113391.0
2016-03-16	ABB-DELISTED	Stock	18.5	18.95	18.5	18.92	1731342.0
2016-03-16	ABBNY-DELISTED	Stock	18.5	18.95	18.5	18.91	1800504.0
2016-03-16	ABBV	Stock	55.58	56.54	55.25	56.31	6245400.0
2016-03-16	ABC-DELISTED	Stock	86.29	87.34	85.94	87.1	1193980.0
2016-03-16	ABCB	Stock	28.3	28.57	28.07	28.5	232100.0
2016-03-16	ABCD-DELISTED	Stock	4.35	4.45	4.31	4.41	11749.0
2016-03-16	ABCO-DELISTED	Stock	27.92	28.18	27.53	27.79	337430.0
2016-03-16	ABCW-DELISTED	Stock	43.34	43.7	43.07	43.25	25342.0
2016-03-16	ABDC-DELISTED	Stock	10.75	10.97	10.72	10.73	24519.0
2016-03-16	ABE-DELISTED	Stock	11.05	11.25	11.05	11.25	4746.0
2016-03-16	ABEO	Stock	71.0	74.75	67.0	68.75	1412.0
2016-03-16	ABEV	Stock	4.74	4.83	4.63	4.81	16855000.0
2016-03-16	ABG	Stock	57.86	58.98	57.66	58.32	333600.0
2016-03-16	ABGB-DELISTED	Stock	1.57	1.69	1.47	1.55	43549.0
2016-03-16	ABIL-DELISTED	Stock	6.51	6.51	6.1	6.1301	9930.0
2016-03-16	ABM	Stock	30.97	31.46	30.79	31.27	230000.0

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

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