PREVIEW / stock_daily / 2017-07-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-05.parquet
  size:    214 KB
  rows:    6,458
  symbols: 2,983

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-05	AAPL	Stock	35.9225	36.1975	35.68	36.0225	86278400.0
2017-07-05	MSFT	Stock	68.26	69.44	68.22	69.08	21176300.0
2017-07-05	NVDA	Stock	3.5475	3.6055	3.5282	3.5763	820188000.0
2017-07-05	AMZN	Stock	48.0765	48.75	47.7625	48.57	73060000.0
2017-07-05	GOOGL	Stock	46.21	46.8145	45.9315	46.613	41881100.0
2017-07-05	META	Stock	149.0	150.85	148.13	150.34	14334300.0
2017-07-05	TSLA	Stock	23.1467	23.1493	21.7553	21.806	255700500.0
2017-07-05	TLT	Stock	124.2	124.65	124.115	124.49	11394539.0
2017-07-05	ES	Stock	60.53	60.53	59.9	60.07	1414900.0
2017-07-05	CL	Stock	74.0	74.19	73.71	73.76	2197400.0
2017-07-05	A	Stock	59.19	60.05	59.19	59.77	1639000.0
2017-07-05	AA	Stock	34.17	34.255	33.57	33.77	4007000.0
2017-07-05	AAAP-DELISTED	Stock	39.1	39.13	38.365	38.95	105878.0
2017-07-05	AABA-DELISTED	Stock	54.5	55.84	54.23	55.64	7859673.0
2017-07-05	AAC-DELISTED	Stock	7.0	7.0	6.7	6.82	35653.0
2017-07-05	AACG	Stock	4.61	4.72	4.37	4.72	4600.0
2017-07-05	AAIC-DELISTED	Stock	13.69	13.85	13.69	13.82	484085.0
2017-07-05	AAL	Stock	50.44	51.55	50.18	51.26	5157500.0
2017-07-05	AAM.A-DELISTED	Stock	25.76	25.77	25.679	25.76	40875.0
2017-07-05	AAMC-DELISTED	Stock	26.1765	26.1765	26.1691	26.1691	1765.0
2017-07-05	AAME	Stock	3.6	3.73	3.6	3.73	1200.0
2017-07-05	AAMI	Stock	14.85	15.04	14.67	14.96	653000.0
2017-07-05	AAOI	Stock	61.65	62.6	60.2	60.62	1480200.0
2017-07-05	AAON	Stock	24.6333	24.8667	24.5333	24.7	127500.0
2017-07-05	AAP	Stock	110.13	111.7	99.13	105.21	7348700.0
2017-07-05	AAT	Stock	40.21	40.21	39.21	39.48	243800.0
2017-07-05	AAU-DELISTED	Stock	1.15	1.2	1.15	1.19	238026.0
2017-07-05	AAUAF-DELISTED	Stock	1.15	1.2	1.15	1.19	241130.0
2017-07-05	AAV-DELISTED	Stock	6.8	6.8	6.5685	6.7	35185.0
2017-07-05	AAWW-DELISTED	Stock	54.85	54.95	53.1	54.65	322936.0
2017-07-05	AAXJ	Stock	67.29	67.64	67.1273	67.59	997707.0
2017-07-05	AAXN-DELISTED	Stock	25.09	25.5	25.03	25.26	271917.0
2017-07-05	AB	Stock	23.75	23.95	23.6	23.65	175700.0
2017-07-05	ABAC-DELISTED	Stock	2.29	2.3162	2.225	2.26	28011.0
2017-07-05	ABAX-DELISTED	Stock	53.56	53.59	52.87	53.32	62136.0
2017-07-05	ABB-DELISTED	Stock	24.63	24.85	24.61	24.825	1463740.0
2017-07-05	ABBNY-DELISTED	Stock	24.63	24.85	24.61	24.83	1503675.0
2017-07-05	ABBV	Stock	72.48	72.74	71.99	72.48	4751900.0
2017-07-05	ABC-DELISTED	Stock	94.91	95.68	94.25	95.22	744563.0
2017-07-05	ABCB	Stock	49.3	49.3	48.3	49.05	84200.0
2017-07-05	ABCD-DELISTED	Stock	5.15	5.15	4.93	5.05	12891.0
2017-07-05	ABCO-DELISTED	Stock	51.25	52.5	51.15	52.25	384596.0
2017-07-05	ABDC-DELISTED	Stock	13.41	13.6	13.19	13.57	50142.0
2017-07-05	ABE-DELISTED	Stock	13.06	13.84	12.7	13.84	45194.0
2017-07-05	ABEO	Stock	166.25	183.75	162.75	182.5	28088.0
2017-07-05	ABEOW-DELISTED	Stock	3.79	3.8	3.79	3.8	499.0
2017-07-05	ABEV	Stock	5.45	5.52	5.45	5.49	36699300.0
2017-07-05	ABG	Stock	57.6	57.6	55.5	56.1	131900.0
2017-07-05	ABIL-DELISTED	Stock	1.26	1.36	1.17	1.2	899901.0
2017-07-05	ABM	Stock	41.57	41.57	41.16	41.17	188500.0

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

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