PREVIEW / stock_daily / 2017-07-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-13.parquet
  size:    213 KB
  rows:    6,429
  symbols: 2,965

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-13	AAPL	Stock	36.375	37.1225	36.36	36.9425	100797600.0
2017-07-13	MSFT	Stock	71.5	72.04	71.31	71.77	20269800.0
2017-07-13	NVDA	Stock	4.075	4.1575	3.9688	4.0158	1369132000.0
2017-07-13	AMZN	Stock	50.231	50.344	49.795	50.0315	57616000.0
2017-07-13	GOOGL	Stock	48.54	48.935	48.24	48.4425	30491420.0
2017-07-13	META	Stock	158.74	159.78	158.42	159.26	13929200.0
2017-07-13	TSLA	Stock	22.0073	22.1067	21.3313	21.5607	128917500.0
2017-07-13	TLT	Stock	123.6	123.65	122.81	123.18	7449253.0
2017-07-13	ES	Stock	60.01	60.21	59.76	59.9	1325300.0
2017-07-13	CL	Stock	72.21	72.59	71.79	72.23	3913500.0
2017-07-13	A	Stock	61.25	61.31	60.67	61.19	2059600.0
2017-07-13	AA	Stock	35.45	36.38	35.43	36.01	5302100.0
2017-07-13	AAAP-DELISTED	Stock	40.43	40.82	39.0	40.24	299871.0
2017-07-13	AABA-DELISTED	Stock	56.44	56.68	56.06	56.41	3379601.0
2017-07-13	AAC-DELISTED	Stock	6.39	6.75	6.34	6.67	61815.0
2017-07-13	AACG	Stock	4.54	4.54	4.51	4.53	3400.0
2017-07-13	AAIC-DELISTED	Stock	13.81	13.85	13.7	13.8	174920.0
2017-07-13	AAL	Stock	53.4	54.48	53.15	53.81	5346700.0
2017-07-13	AAM.A-DELISTED	Stock	25.93	25.9499	25.9	25.919	20449.0
2017-07-13	AAMC-DELISTED	Stock	26.9485	27.9412	26.7647	27.2059	13777.0
2017-07-13	AAME	Stock	3.35	3.65	3.35	3.65	2900.0
2017-07-13	AAMI	Stock	15.44	15.59	15.3	15.32	266800.0
2017-07-13	AAOI	Stock	77.05	79.98	74.01	78.04	8239800.0
2017-07-13	AAON	Stock	25.0333	25.0333	24.5667	25.0333	127950.0
2017-07-13	AAP	Stock	100.69	103.79	100.69	103.22	2222300.0
2017-07-13	AAT	Stock	39.03	39.33	38.89	39.05	175100.0
2017-07-13	AAU-DELISTED	Stock	1.14	1.17	1.11	1.14	161500.0
2017-07-13	AAUAF-DELISTED	Stock	1.14	1.17	1.11	1.14	163517.0
2017-07-13	AAV-DELISTED	Stock	6.85	6.9	6.8	6.875	167977.0
2017-07-13	AAWW-DELISTED	Stock	57.7	57.7	56.5	57.05	435770.0
2017-07-13	AAXJ	Stock	69.37	69.56	69.3	69.53	2400738.0
2017-07-13	AAXN-DELISTED	Stock	25.43	25.5	25.07	25.22	380589.0
2017-07-13	AB	Stock	24.25	24.6	24.23	24.55	212800.0
2017-07-13	ABAC-DELISTED	Stock	2.66	2.66	2.53	2.54	17773.0
2017-07-13	ABAX-DELISTED	Stock	52.73	52.73	51.145	51.56	60027.0
2017-07-13	ABB-DELISTED	Stock	25.16	25.21	24.94	24.99	2202077.0
2017-07-13	ABBNY-DELISTED	Stock	25.16	25.21	24.94	24.98	2253119.0
2017-07-13	ABBV	Stock	71.94	72.9	71.67	72.63	5189800.0
2017-07-13	ABC-DELISTED	Stock	93.55	93.79	92.32	92.87	656399.0
2017-07-13	ABCB	Stock	47.4	47.75	46.9	47.25	131100.0
2017-07-13	ABCD-DELISTED	Stock	4.95	4.99	4.8501	4.94	13498.0
2017-07-13	ABCO-DELISTED	Stock	56.8	57.1	56.4	56.9	305892.0
2017-07-13	ABDC-DELISTED	Stock	13.5	13.5	13.3	13.33	25256.0
2017-07-13	ABE-DELISTED	Stock	13.99	14.085	13.99	14.06	910.0
2017-07-13	ABEO	Stock	222.5	226.25	218.75	220.0	14200.0
2017-07-13	ABEOW-DELISTED	Stock	4.98	5.61	4.98	5.61	1695.0
2017-07-13	ABEV	Stock	5.79	5.8	5.74	5.76	10639900.0
2017-07-13	ABG	Stock	56.65	57.55	56.65	57.35	381100.0
2017-07-13	ABIL-DELISTED	Stock	1.09	1.1	1.02	1.05	99308.0
2017-07-13	ABM	Stock	42.91	42.94	42.11	42.73	283900.0

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

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