PREVIEW / stock_daily / 2016-09-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-14.parquet
  size:    219 KB
  rows:    6,541
  symbols: 3,217

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-14	AAPL	Stock	27.1825	28.2575	27.15	27.9425	443554800.0
2016-09-14	MSFT	Stock	56.39	56.63	56.03	56.26	24062500.0
2016-09-14	NVDA	Stock	1.5002	1.515	1.4878	1.51	319048000.0
2016-09-14	AMZN	Stock	38.11	38.375	37.9425	38.0545	50460000.0
2016-09-14	GOOGL	Stock	39.3765	39.8165	39.3765	39.523	26278240.0
2016-09-14	META	Stock	126.89	128.8	126.89	127.77	15691100.0
2016-09-14	TSLA	Stock	13.05	13.1947	12.9907	13.094	33817500.0
2016-09-14	TLT	Stock	134.05	134.91	134.05	134.25	7037670.0
2016-09-14	ES	Stock	53.84	54.24	53.41	53.7	1651400.0
2016-09-14	CL	Stock	72.03	72.26	71.65	71.85	3188500.0
2016-09-14	A	Stock	45.01	45.1	44.6	44.86	1604800.0
2016-09-14	AA.B-DELISTED	Stock	31.99	31.99	31.08	31.2	24877.0
2016-09-14	AAAP-DELISTED	Stock	34.14	34.5912	33.83	34.3	33219.0
2016-09-14	AABA-DELISTED	Stock	42.91	43.62	42.86	43.46	10657700.0
2016-09-14	AAC-DELISTED	Stock	18.28	18.4	17.97	18.09	79860.0
2016-09-14	AACG	Stock	4.88	4.88	4.55	4.71	1500.0
2016-09-14	AAIC-DELISTED	Stock	14.66	14.82	14.6	14.71	135897.0
2016-09-14	AAL	Stock	37.0	37.2	36.25	36.39	8051800.0
2016-09-14	AAMC-DELISTED	Stock	4.0725	4.1853	3.9794	4.1118	16701.0
2016-09-14	AAME	Stock	3.28	3.5	3.28	3.47	7200.0
2016-09-14	AAMI	Stock	12.76	12.83	12.62	12.75	109900.0
2016-09-14	AAOI	Stock	20.23	21.72	20.05	21.6	893200.0
2016-09-14	AAON	Stock	18.2267	18.24	18.0733	18.2	139050.0
2016-09-14	AAP	Stock	151.54	152.49	150.14	150.72	701000.0
2016-09-14	AAT	Stock	42.26	42.5	42.06	42.06	104200.0
2016-09-14	AAU-DELISTED	Stock	1.38	1.4	1.33	1.36	241309.0
2016-09-14	AAUAF-DELISTED	Stock	1.38	1.4	1.33	1.36	245220.0
2016-09-14	AAV-DELISTED	Stock	6.65	6.82	6.56	6.63	69230.0
2016-09-14	AAWW-DELISTED	Stock	37.91	38.09	37.46	37.53	135276.0
2016-09-14	AAXJ	Stock	58.56	59.09	58.55	58.61	1051415.0
2016-09-14	AAXN-DELISTED	Stock	25.49	26.02	25.01	25.175	454488.0
2016-09-14	AB	Stock	22.0	22.08	21.85	22.0	175500.0
2016-09-14	ABAC-DELISTED	Stock	1.8	2.49	1.75	2.2378	120339.0
2016-09-14	ABAX-DELISTED	Stock	47.54	48.33	47.54	47.89	66665.0
2016-09-14	ABB-DELISTED	Stock	22.28	22.33	22.02	22.07	4285904.0
2016-09-14	ABBNY-DELISTED	Stock	22.28	22.33	22.02	22.07	4370762.0
2016-09-14	ABBV	Stock	63.41	63.96	63.06	63.34	5890000.0
2016-09-14	ABC-DELISTED	Stock	85.38	85.48	83.42	83.85	5372238.0
2016-09-14	ABCB	Stock	35.5	35.75	35.18	35.3	178400.0
2016-09-14	ABCD-DELISTED	Stock	5.2	5.3	5.09	5.15	16223.0
2016-09-14	ABCO-DELISTED	Stock	43.26	43.26	42.49	42.64	126795.0
2016-09-14	ABDC-DELISTED	Stock	12.89	12.89	12.65	12.69	33029.0
2016-09-14	ABE-DELISTED	Stock	12.3401	12.3401	12.3401	12.3401	151.0
2016-09-14	ABEO	Stock	123.25	125.75	121.5	124.75	5112.0
2016-09-14	ABEV	Stock	5.78	5.94	5.78	5.88	27224600.0
2016-09-14	ABG	Stock	54.96	55.56	54.46	55.14	246600.0
2016-09-14	ABIL-DELISTED	Stock	3.82	3.84	3.6499	3.7085	18177.0
2016-09-14	ABM	Stock	38.79	39.08	38.65	39.01	272800.0
2016-09-14	ABMD-DELISTED	Stock	117.37	119.26	117.37	118.53	176296.0
2016-09-14	ABR	Stock	7.38	7.63	7.38	7.58	122600.0

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

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