PREVIEW / stock_daily / 2016-03-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-07.parquet
  size:    219 KB
  rows:    6,595
  symbols: 3,353

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-07	AAPL	Stock	25.5975	25.7075	25.24	25.4675	143315600.0
2016-03-07	MSFT	Stock	51.56	51.8	50.58	51.03	38407800.0
2016-03-07	NVDA	Stock	0.8092	0.8148	0.798	0.8085	239968000.0
2016-03-07	AMZN	Stock	28.677	28.6815	27.7775	28.14	98538000.0
2016-03-07	GOOGL	Stock	36.2575	36.3605	35.257	35.64	61765560.0
2016-03-07	META	Stock	108.07	108.07	104.72	105.73	31436400.0
2016-03-07	TSLA	Stock	13.1787	13.98	13.16	13.686	79941000.0
2016-03-07	TLT	Stock	128.45	128.67	128.05	128.56	5493336.0
2016-03-07	ES	Stock	55.32	56.27	55.32	56.11	2661600.0
2016-03-07	CL	Stock	67.8	67.94	67.37	67.57	2764100.0
2016-03-07	A	Stock	39.04	39.68	38.96	39.43	1221600.0
2016-03-07	AA.B-DELISTED	Stock	32.7	33.4	32.56	33.2	108205.0
2016-03-07	AAAP-DELISTED	Stock	33.48	35.0	32.69	34.0	23922.0
2016-03-07	AABA-DELISTED	Stock	33.67	34.38	33.59	33.95	19577039.0
2016-03-07	AAC-DELISTED	Stock	18.99	19.029	17.65	17.77	225911.0
2016-03-07	AACG	Stock	4.71	4.94	4.6	4.94	7300.0
2016-03-07	AAIC-DELISTED	Stock	12.95	13.36	12.95	13.15	207117.0
2016-03-07	AAL	Stock	41.31	42.23	40.9	42.13	6959700.0
2016-03-07	AAMC-DELISTED	Stock	4.6324	4.6324	4.1206	4.1794	103404.0
2016-03-07	AAME	Stock	4.02	4.19	4.02	4.16	1700.0
2016-03-07	AAMI	Stock	11.91	12.18	11.8	11.91	267300.0
2016-03-07	AAOI	Stock	18.15	18.48	17.89	18.12	196100.0
2016-03-07	AAON	Stock	16.8133	17.26	16.8	17.2267	325950.0
2016-03-07	AAP	Stock	151.37	152.87	150.38	151.52	481400.0
2016-03-07	AAT	Stock	37.84	38.12	37.76	38.09	151600.0
2016-03-07	AAU-DELISTED	Stock	0.7813	0.82	0.74	0.76	204519.0
2016-03-07	AAUAF-DELISTED	Stock	0.7813	0.82	0.74	0.76	205378.0
2016-03-07	AAV-DELISTED	Stock	5.14	5.25	4.99	5.02	123750.0
2016-03-07	AAVL-DELISTED	Stock	5.35	5.81	5.09	5.65	347981.0
2016-03-07	AAWW-DELISTED	Stock	37.75	40.47	37.75	40.22	278158.0
2016-03-07	AAXJ	Stock	52.14	52.73	52.11	52.52	718105.0
2016-03-07	AAXN-DELISTED	Stock	19.4	20.58	19.3365	19.85	1987617.0
2016-03-07	AB	Stock	21.43	22.02	21.43	21.72	382900.0
2016-03-07	ABAC-DELISTED	Stock	0.6295	0.6389	0.5999	0.5999	13989.0
2016-03-07	ABAX-DELISTED	Stock	41.5	42.26	41.3	42.18	107221.0
2016-03-07	ABB-DELISTED	Stock	18.24	18.49	18.23	18.46	1205256.0
2016-03-07	ABBNY-DELISTED	Stock	18.24	18.49	18.23	18.46	1246431.0
2016-03-07	ABBV	Stock	55.7	56.5	54.83	56.4	7741800.0
2016-03-07	ABC-DELISTED	Stock	87.36	88.25	87.19	88.11	1583659.0
2016-03-07	ABCB	Stock	28.08	28.34	27.88	28.27	82100.0
2016-03-07	ABCD-DELISTED	Stock	4.69	4.7689	4.55	4.59	25959.0
2016-03-07	ABCO-DELISTED	Stock	29.76	31.11	29.76	30.29	897707.0
2016-03-07	ABCW-DELISTED	Stock	43.42	43.74	43.36	43.49	36538.0
2016-03-07	ABDC-DELISTED	Stock	10.19	10.47	10.12	10.23	36004.0
2016-03-07	ABE-DELISTED	Stock	11.08	11.13	10.998	11.064	10841.0
2016-03-07	ABEO	Stock	64.5	72.5	64.5	70.5	4584.0
2016-03-07	ABEOW-DELISTED	Stock	1.0	1.0	0.9	0.95	1400.0
2016-03-07	ABEV	Stock	5.01	5.11	4.99	5.04	21879200.0
2016-03-07	ABG	Stock	60.23	61.3	59.98	61.0	512200.0
2016-03-07	ABGB-DELISTED	Stock	1.11	1.71	1.11	1.47	289085.0

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

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