PREVIEW / stock_daily / 2016-03-17

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-17.parquet
  size:    219 KB
  rows:    6,578
  symbols: 3,330

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-17	AAPL	Stock	26.38	26.6175	26.24	26.45	137682800.0
2016-03-17	MSFT	Stock	54.21	55.0	54.0	54.66	28223900.0
2016-03-17	NVDA	Stock	0.8245	0.8285	0.8092	0.8205	353680000.0
2016-03-17	AMZN	Stock	28.4755	28.57	27.7505	27.972	118562000.0
2016-03-17	GOOGL	Stock	37.8825	38.267	37.868	37.924	44564880.0
2016-03-17	META	Stock	112.15	112.69	110.73	111.02	24241200.0
2016-03-17	TSLA	Stock	14.7647	15.2333	14.6667	15.092	56743500.0
2016-03-17	TLT	Stock	128.51	129.34	128.49	128.79	7805464.0
2016-03-17	ES	Stock	57.54	58.09	57.32	57.84	2626700.0
2016-03-17	CL	Stock	68.76	69.99	68.58	69.86	4243300.0
2016-03-17	A	Stock	39.06	39.44	38.59	39.29	1895700.0
2016-03-17	AA.B-DELISTED	Stock	32.56	33.1002	32.3101	32.84	74237.0
2016-03-17	AAAP-DELISTED	Stock	34.46	34.9899	33.9	34.69	30870.0
2016-03-17	AABA-DELISTED	Stock	33.88	34.55	33.87	34.28	8667276.0
2016-03-17	AAC-DELISTED	Stock	17.04	18.22	16.725	17.9	200787.0
2016-03-17	AACG	Stock	5.16	5.37	5.16	5.2	5800.0
2016-03-17	AAIC-DELISTED	Stock	13.2	13.6	13.11	13.53	374575.0
2016-03-17	AAL	Stock	42.31	42.31	41.82	42.1	5960600.0
2016-03-17	AAMC-DELISTED	Stock	3.9441	4.2029	3.9441	4.0441	47838.0
2016-03-17	AAME	Stock	4.15	4.17	4.03	4.16	4100.0
2016-03-17	AAMI	Stock	12.16	12.7	12.03	12.55	249800.0
2016-03-17	AAOI	Stock	17.29	17.94	17.19	17.65	159400.0
2016-03-17	AAON	Stock	17.3133	17.9333	17.3133	17.7533	231150.0
2016-03-17	AAP	Stock	157.78	158.84	156.3	157.94	580300.0
2016-03-17	AAT	Stock	38.19	38.85	37.96	38.72	183500.0
2016-03-17	AAU-DELISTED	Stock	0.77	0.77	0.73	0.73	125041.0
2016-03-17	AAUAF-DELISTED	Stock	0.77	0.77	0.73	0.735	126961.0
2016-03-17	AAV-DELISTED	Stock	5.55	5.68	5.55	5.64	102351.0
2016-03-17	AAVL-DELISTED	Stock	4.9	5.0449	4.66	4.98	240056.0
2016-03-17	AAWW-DELISTED	Stock	39.81	41.9	39.76	41.65	247230.0
2016-03-17	AAXJ	Stock	53.45	54.08	53.24	54.04	1123477.0
2016-03-17	AAXN-DELISTED	Stock	18.5	19.1	18.44	18.88	1194299.0
2016-03-17	AB	Stock	22.45	23.3	22.41	23.1	380500.0
2016-03-17	ABAC-DELISTED	Stock	0.66	0.7455	0.55	0.699	34828.0
2016-03-17	ABAX-DELISTED	Stock	41.98	42.13	40.97	41.88	117770.0
2016-03-17	ABB-DELISTED	Stock	19.12	19.48	19.06	19.415	1860529.0
2016-03-17	ABBNY-DELISTED	Stock	19.12	19.48	19.06	19.42	1923830.0
2016-03-17	ABBV	Stock	56.46	56.46	54.41	55.32	8308800.0
2016-03-17	ABC-DELISTED	Stock	87.07	87.47	85.73	85.91	2739015.0
2016-03-17	ABCB	Stock	28.49	29.21	28.29	29.1	248700.0
2016-03-17	ABCD-DELISTED	Stock	4.4	4.42	4.31	4.42	7384.0
2016-03-17	ABCO-DELISTED	Stock	27.69	29.28	27.53	29.17	465374.0
2016-03-17	ABCW-DELISTED	Stock	43.16	44.21	42.79	44.02	51450.0
2016-03-17	ABDC-DELISTED	Stock	10.65	10.8971	10.63	10.75	23615.0
2016-03-17	ABE-DELISTED	Stock	11.29	11.47	11.29	11.4499	6266.0
2016-03-17	ABEO	Stock	68.5	71.75	67.5	70.0	764.0
2016-03-17	ABEV	Stock	5.05	5.08	4.94	5.05	28963000.0
2016-03-17	ABG	Stock	58.0	59.36	57.54	58.99	386500.0
2016-03-17	ABGB-DELISTED	Stock	1.49	1.52	1.45	1.51	34954.0
2016-03-17	ABIL-DELISTED	Stock	6.37	6.4	6.19	6.3	8500.0

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

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