PREVIEW / stock_daily / 2017-08-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-01.parquet
  size:    215 KB
  rows:    6,457
  symbols: 2,967

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-08-01	AAPL	Stock	37.275	37.555	37.1025	37.5125	141474400.0
2017-08-01	MSFT	Stock	73.1	73.42	72.49	72.58	22132300.0
2017-08-01	NVDA	Stock	4.0532	4.114	4.025	4.1123	431384000.0
2017-08-01	AMZN	Stock	49.8055	50.32	49.579	49.8095	91452000.0
2017-08-01	GOOGL	Stock	47.3905	47.7245	47.248	47.328	26649120.0
2017-08-01	META	Stock	169.82	170.47	169.05	169.86	14385000.0
2017-08-01	TSLA	Stock	21.5333	21.63	21.0753	21.3047	124546500.0
2017-08-01	TLT	Stock	123.18	124.71	123.16	124.64	9676842.0
2017-08-01	ES	Stock	60.93	61.06	60.54	60.89	1807300.0
2017-08-01	CL	Stock	72.11	72.29	71.62	71.7	3052900.0
2017-08-01	A	Stock	60.04	60.29	59.81	59.94	1323600.0
2017-08-01	AA	Stock	36.46	36.74	35.91	36.38	1939200.0
2017-08-01	AAAP-DELISTED	Stock	47.99	51.02	47.99	50.76	150819.0
2017-08-01	AABA-DELISTED	Stock	58.6	58.8	58.11	58.5	3396355.0
2017-08-01	AAC-DELISTED	Stock	6.34	6.58	6.09	6.48	82372.0
2017-08-01	AACG	Stock	4.7	4.8	4.7	4.79	2400.0
2017-08-01	AAIC-DELISTED	Stock	13.0	13.13	12.9074	13.13	321288.0
2017-08-01	AAL	Stock	51.13	52.0	50.32	51.06	5045300.0
2017-08-01	AAM.A-DELISTED	Stock	26.08	26.1	26.05	26.1	36338.0
2017-08-01	AAMC-DELISTED	Stock	26.4811	27.2059	26.4811	27.1765	9561.0
2017-08-01	AAME	Stock	3.65	3.65	3.5	3.5	500.0
2017-08-01	AAMI	Stock	15.14	15.16	14.9	14.96	297100.0
2017-08-01	AAOI	Stock	97.66	100.5	97.15	99.61	3135900.0
2017-08-01	AAON	Stock	22.6667	22.8333	22.3667	22.6333	209700.0
2017-08-01	AAP	Stock	112.0	114.1	110.82	114.05	1513100.0
2017-08-01	AAT	Stock	40.68	41.09	40.55	40.95	198100.0
2017-08-01	AAU-DELISTED	Stock	1.19	1.205	1.18	1.19	209733.0
2017-08-01	AAUAF-DELISTED	Stock	1.19	1.205	1.18	1.19	212858.0
2017-08-01	AAV-DELISTED	Stock	6.85	6.9	6.7	6.75	85802.0
2017-08-01	AAWW-DELISTED	Stock	59.6	60.35	59.1	59.8	499350.0
2017-08-01	AAXJ	Stock	71.43	71.43	71.16	71.25	1613463.0
2017-08-01	AAXN-DELISTED	Stock	24.6	24.88	24.27	24.87	402226.0
2017-08-01	AB	Stock	24.75	25.0	24.6	24.95	265100.0
2017-08-01	ABAC-DELISTED	Stock	2.44	2.44	2.25	2.3401	9440.0
2017-08-01	ABAX-DELISTED	Stock	48.565	48.565	45.93	46.06	204686.0
2017-08-01	ABB-DELISTED	Stock	23.77	23.8	23.56	23.64	1292032.0
2017-08-01	ABBNY-DELISTED	Stock	23.77	23.8	23.56	23.64	1328835.0
2017-08-01	ABBV	Stock	70.03	70.84	69.85	70.38	6681700.0
2017-08-01	ABC-DELISTED	Stock	94.08	94.17	92.63	92.94	1016301.0
2017-08-01	ABCB	Stock	46.1	47.05	45.85	46.55	117200.0
2017-08-01	ABCD-DELISTED	Stock	4.9	4.94	4.86	4.905	41563.0
2017-08-01	ABCO-DELISTED	Stock	56.4	56.4	55.0	55.3	450179.0
2017-08-01	ABDC-DELISTED	Stock	11.95	12.009	11.5	11.63	107757.0
2017-08-01	ABE-DELISTED	Stock	14.28	14.3	14.21	14.21	3405.0
2017-08-01	ABEO	Stock	210.0	215.75	193.75	201.25	34220.0
2017-08-01	ABEOW-DELISTED	Stock	4.54	4.54	4.0	4.0	1400.0
2017-08-01	ABEV	Stock	6.08	6.16	6.08	6.11	11548500.0
2017-08-01	ABG	Stock	54.1	54.8	53.1	54.55	240400.0
2017-08-01	ABIL-DELISTED	Stock	0.8	0.8	0.7211	0.7597	52169.0
2017-08-01	ABM	Stock	44.99	44.99	44.34	44.75	152500.0

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

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