PREVIEW / stock_daily / 2017-07-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-19.parquet
  size:    215 KB
  rows:    6,439
  symbols: 2,966

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-19	AAPL	Stock	37.62	37.855	37.4875	37.755	83692000.0
2017-07-19	MSFT	Stock	73.5	74.04	73.45	73.86	22416200.0
2017-07-19	NVDA	Stock	4.1583	4.185	4.1153	4.1275	687044000.0
2017-07-19	AMZN	Stock	51.25	51.5795	51.125	51.3435	59280000.0
2017-07-19	GOOGL	Stock	49.5005	49.78	49.3505	49.6385	28242960.0
2017-07-19	META	Stock	163.59	165.7	163.17	164.14	26273600.0
2017-07-19	TSLA	Stock	21.882	22.11	21.548	21.684	95355000.0
2017-07-19	TLT	Stock	124.78	125.01	124.59	124.8	5140862.0
2017-07-19	ES	Stock	60.56	60.73	60.37	60.67	862800.0
2017-07-19	CL	Stock	72.42	72.68	72.29	72.49	2877400.0
2017-07-19	A	Stock	61.32	61.64	61.17	61.38	1512200.0
2017-07-19	AA	Stock	36.61	36.62	36.07	36.5	4516100.0
2017-07-19	AAAP-DELISTED	Stock	39.83	40.82	39.78	40.57	31123.0
2017-07-19	AABA-DELISTED	Stock	59.27	59.33	58.19	58.35	6997877.0
2017-07-19	AAC-DELISTED	Stock	6.89	6.9999	6.7	6.74	46777.0
2017-07-19	AACG	Stock	4.6	4.7	4.58	4.69	6400.0
2017-07-19	AAIC-DELISTED	Stock	13.62	13.6826	13.53	13.64	232508.0
2017-07-19	AAL	Stock	52.26	53.19	51.78	52.61	5774700.0
2017-07-19	AAM.A-DELISTED	Stock	26.01	26.04	25.9	26.0	78563.0
2017-07-19	AAMC-DELISTED	Stock	27.5	28.0882	27.5	27.75	14307.0
2017-07-19	AAME	Stock	3.5	3.65	3.5	3.65	400.0
2017-07-19	AAMI	Stock	15.35	15.36	15.26	15.31	340100.0
2017-07-19	AAOI	Stock	91.8	95.43	91.0	92.54	5879600.0
2017-07-19	AAON	Stock	24.7667	25.0667	24.7667	25.0333	84300.0
2017-07-19	AAP	Stock	100.47	101.91	99.95	100.87	1413700.0
2017-07-19	AAT	Stock	40.03	40.52	40.0	40.47	167900.0
2017-07-19	AAU-DELISTED	Stock	1.27	1.29	1.22	1.24	174016.0
2017-07-19	AAUAF-DELISTED	Stock	1.27	1.29	1.22	1.22	174874.0
2017-07-19	AAV-DELISTED	Stock	7.1	7.35	7.06	7.3	104536.0
2017-07-19	AAWW-DELISTED	Stock	58.75	59.25	58.3	58.425	233348.0
2017-07-19	AAXJ	Stock	70.67	70.71	70.53	70.62	496550.0
2017-07-19	AAXN-DELISTED	Stock	25.2	25.56	25.15	25.38	301899.0
2017-07-19	AB	Stock	24.65	24.9	24.5	24.7	176600.0
2017-07-19	ABAC-DELISTED	Stock	2.42	2.42	2.2	2.24	14228.0
2017-07-19	ABAX-DELISTED	Stock	51.21	51.56	50.67	50.755	67305.0
2017-07-19	ABB-DELISTED	Stock	25.14	25.21	25.04	25.08	1374557.0
2017-07-19	ABBNY-DELISTED	Stock	25.14	25.21	25.04	25.09	1413271.0
2017-07-19	ABBV	Stock	72.48	72.77	72.02	72.77	3904100.0
2017-07-19	ABC-DELISTED	Stock	91.56	91.67	90.3	91.16	1162036.0
2017-07-19	ABCB	Stock	46.8	47.35	46.65	47.1	81900.0
2017-07-19	ABCD-DELISTED	Stock	4.84	4.93	4.84	4.92	17331.0
2017-07-19	ABCO-DELISTED	Stock	56.8	57.15	56.3	56.8	152523.0
2017-07-19	ABDC-DELISTED	Stock	12.45	12.625	12.39	12.58	45514.0
2017-07-19	ABE-DELISTED	Stock	14.22	14.3	14.19	14.21	22310.0
2017-07-19	ABEO	Stock	226.25	256.25	220.0	246.25	49320.0
2017-07-19	ABEOW-DELISTED	Stock	4.7	5.78	4.7	5.58	6482.0
2017-07-19	ABEV	Stock	5.91	5.94	5.87	5.94	9794500.0
2017-07-19	ABG	Stock	56.6	57.7	56.5	57.3	112100.0
2017-07-19	ABIL-DELISTED	Stock	0.99	1.07	0.85	0.96	164521.0
2017-07-19	ABM	Stock	43.12	43.63	43.07	43.51	234500.0

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

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