PREVIEW / stock_daily / 2016-09-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-16.parquet
  size:    219 KB
  rows:    6,547
  symbols: 3,214

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-09-16	AAPL	Stock	28.78	29.0325	28.51	28.73	319547600.0
2016-09-16	MSFT	Stock	57.63	57.63	56.75	57.25	44607000.0
2016-09-16	NVDA	Stock	1.5728	1.5812	1.553	1.571	902444000.0
2016-09-16	AMZN	Stock	38.664	39.023	38.583	38.926	109984000.0
2016-09-16	GOOGL	Stock	39.951	39.951	39.681	39.8985	42611420.0
2016-09-16	META	Stock	128.2	129.18	128.2	129.07	24119200.0
2016-09-16	TSLA	Stock	13.3613	13.7133	13.2667	13.6933	46617000.0
2016-09-16	TLT	Stock	134.58	134.81	134.22	134.75	7507901.0
2016-09-16	ES	Stock	53.62	54.26	53.33	54.18	2736500.0
2016-09-16	CL	Stock	71.83	72.08	71.38	71.96	3959700.0
2016-09-16	A	Stock	45.39	45.39	44.74	44.79	2592900.0
2016-09-16	AA.B-DELISTED	Stock	31.5072	31.5072	31.1377	31.45	15279.0
2016-09-16	AAAP-DELISTED	Stock	34.1	37.34	34.1	37.1	116050.0
2016-09-16	AABA-DELISTED	Stock	43.91	44.02	43.47	43.67	17845651.0
2016-09-16	AAC-DELISTED	Stock	17.85	18.1	17.49	17.5	149712.0
2016-09-16	AACG	Stock	4.72	4.88	4.72	4.78	1200.0
2016-09-16	AAIC-DELISTED	Stock	14.94	14.94	14.73	14.93	378764.0
2016-09-16	AAL	Stock	36.26	36.36	35.47	35.49	10724800.0
2016-09-16	AAMC-DELISTED	Stock	4.1	4.1853	3.9941	4.0882	20121.0
2016-09-16	AAME	Stock	3.4	3.48	3.24	3.24	9400.0
2016-09-16	AAMI	Stock	12.69	13.02	12.54	12.99	217900.0
2016-09-16	AAOI	Stock	21.41	21.75	20.91	21.7	449200.0
2016-09-16	AAON	Stock	18.4667	18.7733	18.1667	18.7733	381000.0
2016-09-16	AAP	Stock	148.26	148.99	147.73	148.11	961300.0
2016-09-16	AAT	Stock	42.06	42.42	41.89	42.31	150900.0
2016-09-16	AAU-DELISTED	Stock	1.37	1.384	1.34	1.35	173489.0
2016-09-16	AAUAF-DELISTED	Stock	1.37	1.384	1.34	1.35	175454.0
2016-09-16	AAV-DELISTED	Stock	6.67	6.69	6.55	6.55	40224.0
2016-09-16	AAWW-DELISTED	Stock	38.49	38.77	37.65	37.71	199169.0
2016-09-16	AAXJ	Stock	59.28	59.35	58.81	59.22	1003679.0
2016-09-16	AAXN-DELISTED	Stock	26.44	26.44	25.35	25.45	684541.0
2016-09-16	AB	Stock	22.7	22.81	22.51	22.71	262700.0
2016-09-16	ABAC-DELISTED	Stock	2.18	2.2295	2.12	2.175	21391.0
2016-09-16	ABAX-DELISTED	Stock	49.1	49.46	48.66	49.17	251826.0
2016-09-16	ABB-DELISTED	Stock	22.01	22.06	21.8658	21.93	2178578.0
2016-09-16	ABBNY-DELISTED	Stock	22.01	22.06	21.8658	21.95	2274353.0
2016-09-16	ABBV	Stock	63.53	63.79	63.17	63.27	11165300.0
2016-09-16	ABC-DELISTED	Stock	83.96	84.39	83.01	84.11	3072294.0
2016-09-16	ABCB	Stock	35.25	35.4	34.72	35.3	1145000.0
2016-09-16	ABCD-DELISTED	Stock	5.28	5.3	5.28	5.29	32082.0
2016-09-16	ABCO-DELISTED	Stock	43.39	43.76	42.8	42.88	247757.0
2016-09-16	ABDC-DELISTED	Stock	12.78	12.8	12.71	12.785	29824.0
2016-09-16	ABE-DELISTED	Stock	12.32	12.41	12.32	12.36	751.0
2016-09-16	ABEO	Stock	124.25	125.75	121.0	121.5	11804.0
2016-09-16	ABEV	Stock	5.9	5.93	5.84	5.9	14792700.0
2016-09-16	ABG	Stock	55.48	55.78	53.63	53.63	616900.0
2016-09-16	ABIL-DELISTED	Stock	3.8	3.8	3.62	3.73	25125.0
2016-09-16	ABM	Stock	39.45	39.45	38.92	39.11	377400.0
2016-09-16	ABMD-DELISTED	Stock	122.91	125.04	122.298	124.93	460258.0
2016-09-16	ABR	Stock	7.5	7.5	7.38	7.38	215200.0

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

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