PREVIEW / stock_daily / 2017-07-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-14.parquet
  size:    213 KB
  rows:    6,448
  symbols: 2,974

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
2017-07-14	AAPL	Stock	36.9925	37.3325	36.8325	37.26	80528400.0
2017-07-14	MSFT	Stock	72.24	73.27	71.96	72.78	25868100.0
2017-07-14	NVDA	Stock	4.0322	4.1252	4.0252	4.1238	941948000.0
2017-07-14	AMZN	Stock	50.12	50.2225	49.8445	50.0905	42050000.0
2017-07-14	GOOGL	Stock	48.7	48.877	48.5075	48.8455	21592160.0
2017-07-14	META	Stock	160.13	160.32	159.33	159.97	16371200.0
2017-07-14	TSLA	Stock	21.546	21.8947	21.4147	21.852	84378000.0
2017-07-14	TLT	Stock	124.1	124.16	123.12	123.33	6566826.0
2017-07-14	ES	Stock	60.37	60.47	60.07	60.22	932500.0
2017-07-14	CL	Stock	72.17	72.67	72.01	72.49	2484100.0
2017-07-14	A	Stock	61.28	61.66	60.92	61.52	1285500.0
2017-07-14	AA	Stock	36.2	36.44	35.98	36.32	4217600.0
2017-07-14	AAAP-DELISTED	Stock	39.93	40.51	39.57	39.99	95816.0
2017-07-14	AABA-DELISTED	Stock	56.54	57.41	56.53	57.2	4203328.0
2017-07-14	AAC-DELISTED	Stock	6.68	7.04	6.54	6.78	115016.0
2017-07-14	AACG	Stock	4.71	4.71	4.59	4.59	2000.0
2017-07-14	AAIC-DELISTED	Stock	13.77	13.95	13.77	13.9	178811.0
2017-07-14	AAL	Stock	53.8	54.28	53.34	54.22	4537900.0
2017-07-14	AAM.A-DELISTED	Stock	25.95	25.99	25.8414	25.99	27021.0
2017-07-14	AAMC-DELISTED	Stock	26.9118	27.3529	26.9118	27.3529	11580.0
2017-07-14	AAME	Stock	3.56	3.65	3.56	3.65	1000.0
2017-07-14	AAMI	Stock	15.25	15.41	15.15	15.4	500900.0
2017-07-14	AAOI	Stock	78.0	86.36	77.68	84.2	6861400.0
2017-07-14	AAON	Stock	24.9667	25.2	24.7333	25.0	126900.0
2017-07-14	AAP	Stock	103.66	103.68	101.63	102.04	1205400.0
2017-07-14	AAT	Stock	39.26	39.8	39.26	39.61	188400.0
2017-07-14	AAU-DELISTED	Stock	1.16	1.2	1.16	1.19	226768.0
2017-07-14	AAUAF-DELISTED	Stock	1.16	1.2	1.16	1.18	241888.0
2017-07-14	AAV-DELISTED	Stock	6.9	6.95	6.85	6.95	74384.0
2017-07-14	AAWW-DELISTED	Stock	57.15	58.55	56.05	58.15	458622.0
2017-07-14	AAXJ	Stock	69.93	70.305	69.84	70.27	744374.0
2017-07-14	AAXN-DELISTED	Stock	25.13	25.4	24.85	25.29	469626.0
2017-07-14	AB	Stock	24.45	24.65	24.45	24.5	202100.0
2017-07-14	ABAC-DELISTED	Stock	2.53	2.64	2.53	2.53	11637.0
2017-07-14	ABAX-DELISTED	Stock	51.46	52.53	51.46	51.71	98876.0
2017-07-14	ABB-DELISTED	Stock	24.94	25.185	24.895	25.16	1388132.0
2017-07-14	ABBNY-DELISTED	Stock	24.94	25.185	24.895	25.16	1466596.0
2017-07-14	ABBV	Stock	72.62	73.23	72.51	73.11	4335700.0
2017-07-14	ABC-DELISTED	Stock	93.06	93.42	92.53	92.98	741557.0
2017-07-14	ABCB	Stock	46.8	46.98	46.05	46.75	444100.0
2017-07-14	ABCD-DELISTED	Stock	4.88	4.9	4.8	4.89	7080.0
2017-07-14	ABCO-DELISTED	Stock	56.8	57.275	56.725	57.175	442624.0
2017-07-14	ABDC-DELISTED	Stock	13.34	13.49	13.3	13.42	22275.0
2017-07-14	ABE-DELISTED	Stock	14.07	14.19	14.07	14.19	1400.0
2017-07-14	ABEO	Stock	220.0	240.0	217.5	232.5	22256.0
2017-07-14	ABEOW-DELISTED	Stock	4.85	5.419	4.78	5.419	4709.0
2017-07-14	ABEV	Stock	5.83	5.87	5.82	5.85	8129900.0
2017-07-14	ABG	Stock	57.3	57.65	56.05	57.0	174000.0
2017-07-14	ABIL-DELISTED	Stock	1.04	1.0863	1.04	1.06	20873.0
2017-07-14	ABM	Stock	42.7	43.25	42.65	42.9	246600.0

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

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