PREVIEW / stock_daily / 2016-09-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-19.parquet
  size:    217 KB
  rows:    6,522
  symbols: 3,206

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-19	AAPL	Stock	28.7975	29.045	28.3125	28.395	188092000.0
2016-09-19	MSFT	Stock	57.27	57.75	56.85	56.93	20937100.0
2016-09-19	NVDA	Stock	1.5875	1.6315	1.5803	1.5918	417128000.0
2016-09-19	AMZN	Stock	38.9985	39.097	38.55	38.755	45944000.0
2016-09-19	GOOGL	Stock	40.0555	40.1995	39.678	39.7695	22990440.0
2016-09-19	META	Stock	129.91	129.94	128.26	128.65	14958800.0
2016-09-19	TSLA	Stock	13.8	13.962	13.6667	13.756	34492500.0
2016-09-19	TLT	Stock	134.52	134.87	134.25	134.31	7105887.0
2016-09-19	ES	Stock	54.39	54.63	54.18	54.59	1426100.0
2016-09-19	CL	Stock	72.02	72.5	71.93	72.19	2272000.0
2016-09-19	A	Stock	44.9	45.48	44.86	44.95	1927900.0
2016-09-19	AA.B-DELISTED	Stock	31.5	31.5	31.07	31.1634	25185.0
2016-09-19	AAAP-DELISTED	Stock	36.76	36.8	35.71	36.17	90609.0
2016-09-19	AABA-DELISTED	Stock	43.92	43.95	43.0	43.19	7354008.0
2016-09-19	AAC-DELISTED	Stock	17.67	18.015	17.47	17.77	96007.0
2016-09-19	AACG	Stock	4.88	4.88	4.63	4.65	2000.0
2016-09-19	AAIC-DELISTED	Stock	14.94	15.13	14.83	15.0	268190.0
2016-09-19	AAL	Stock	35.66	36.11	35.35	35.44	5422300.0
2016-09-19	AAMC-DELISTED	Stock	4.1206	4.5588	4.1206	4.2529	54482.0
2016-09-19	AAME	Stock	3.26	3.44	3.25	3.25	17200.0
2016-09-19	AAMI	Stock	13.09	13.25	13.03	13.24	152600.0
2016-09-19	AAOI	Stock	21.81	22.3	21.66	22.03	421300.0
2016-09-19	AAON	Stock	18.92	19.1	18.7667	18.9	150750.0
2016-09-19	AAP	Stock	148.11	148.97	147.44	148.44	972000.0
2016-09-19	AAT	Stock	42.32	42.66	42.0	42.61	89200.0
2016-09-19	AAU-DELISTED	Stock	1.38	1.39	1.34	1.3704	151660.0
2016-09-19	AAUAF-DELISTED	Stock	1.38	1.39	1.34	1.36	153635.0
2016-09-19	AAV-DELISTED	Stock	6.64	6.64	6.505	6.53	42582.0
2016-09-19	AAWW-DELISTED	Stock	37.87	38.48	37.68	38.39	219959.0
2016-09-19	AAXJ	Stock	59.9	60.09	59.61	59.69	803578.0
2016-09-19	AAXN-DELISTED	Stock	25.53	26.21	25.5	26.03	638324.0
2016-09-19	AB	Stock	22.8	23.22	22.5	22.76	300500.0
2016-09-19	ABAC-DELISTED	Stock	2.18	2.39	2.18	2.25	32720.0
2016-09-19	ABAX-DELISTED	Stock	49.16	50.93	49.16	50.85	147761.0
2016-09-19	ABB-DELISTED	Stock	21.97	22.12	21.95	21.97	1424292.0
2016-09-19	ABBNY-DELISTED	Stock	21.99	22.12	21.95	21.98	1473921.0
2016-09-19	ABBV	Stock	63.62	63.71	62.83	62.91	7903500.0
2016-09-19	ABC-DELISTED	Stock	83.91	84.96	83.07	83.26	2064950.0
2016-09-19	ABCB	Stock	35.24	35.57	34.95	35.36	210100.0
2016-09-19	ABCD-DELISTED	Stock	5.33	5.33	5.277	5.33	5187.0
2016-09-19	ABCO-DELISTED	Stock	43.23	43.53	42.7383	42.91	92473.0
2016-09-19	ABDC-DELISTED	Stock	12.91	13.07	12.8	12.83	31248.0
2016-09-19	ABE-DELISTED	Stock	12.43	12.57	12.4	12.5499	8589.0
2016-09-19	ABEO	Stock	121.5	128.5	121.0	127.75	9808.0
2016-09-19	ABEOW-DELISTED	Stock	2.5	2.5	2.5	2.5	1097.0
2016-09-19	ABEV	Stock	5.96	5.97	5.88	5.91	11225500.0
2016-09-19	ABG	Stock	53.64	54.54	53.1	53.52	169900.0
2016-09-19	ABIL-DELISTED	Stock	3.75	3.85	3.75	3.85	8389.0
2016-09-19	ABM	Stock	39.08	39.25	38.85	38.95	252100.0
2016-09-19	ABMD-DELISTED	Stock	125.14	127.1	123.65	125.09	462101.0

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

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