PREVIEW / stock_daily / 2017-10-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-17.parquet
  size:    214 KB
  rows:    6,440
  symbols: 2,914

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-10-17	AAPL	Stock	39.945	40.2175	39.8075	40.1175	75989200.0
2017-10-17	MSFT	Stock	77.47	77.62	77.25	77.59	16824000.0
2017-10-17	NVDA	Stock	4.9273	4.9725	4.9088	4.9438	478596000.0
2017-10-17	AMZN	Stock	50.2795	50.5735	50.219	50.4565	46394000.0
2017-10-17	GOOGL	Stock	50.372	50.728	50.3025	50.55	20259960.0
2017-10-17	META	Stock	174.71	176.13	174.36	176.11	15990100.0
2017-10-17	TSLA	Stock	23.394	23.748	23.338	23.7167	49399500.0
2017-10-17	TLT	Stock	125.39	126.09	125.39	125.92	4969626.0
2017-10-17	ES	Stock	61.25	61.76	61.1	61.74	1393900.0
2017-10-17	CL	Stock	75.5	75.53	74.62	74.96	3217600.0
2017-10-17	A	Stock	66.68	66.68	65.99	66.12	1711800.0
2017-10-17	AA	Stock	48.65	48.72	47.42	47.77	3960600.0
2017-10-17	AAAP-DELISTED	Stock	71.5	72.93	71.0	71.31	298427.0
2017-10-17	AABA-DELISTED	Stock	68.0	68.1	66.63	66.78	3892943.0
2017-10-17	AAC-DELISTED	Stock	7.97	8.08	7.83	7.94	93951.0
2017-10-17	AACG	Stock	4.74	4.74	4.64	4.64	500.0
2017-10-17	AAIC-DELISTED	Stock	12.71	12.75	12.66	12.7	294671.0
2017-10-17	AAL	Stock	52.72	52.82	51.87	52.07	3651200.0
2017-10-17	AAM.A-DELISTED	Stock	26.037	26.13	26.0124	26.1	19324.0
2017-10-17	AAMC-DELISTED	Stock	25.5882	25.5882	25.5882	25.5882	1142.0
2017-10-17	AAMI	Stock	15.32	15.37	15.07	15.1	164700.0
2017-10-17	AAOI	Stock	42.79	45.5	42.24	43.74	2840500.0
2017-10-17	AAON	Stock	22.8	22.9333	22.4333	22.5	113850.0
2017-10-17	AAP	Stock	86.38	88.97	86.2	88.09	2099400.0
2017-10-17	AAT	Stock	40.46	40.88	40.36	40.58	123500.0
2017-10-17	AAU-DELISTED	Stock	1.1	1.15	1.0832	1.14	227357.0
2017-10-17	AAUAF-DELISTED	Stock	1.1	1.15	1.0832	1.13	279631.0
2017-10-17	AAV-DELISTED	Stock	5.45	5.49	5.4	5.4	50201.0
2017-10-17	AAWW-DELISTED	Stock	64.55	64.85	61.9	61.95	182216.0
2017-10-17	AAXJ	Stock	75.12	75.22	74.94	75.0	1644228.0
2017-10-17	AAXN-DELISTED	Stock	24.19	24.47	24.11	24.45	349424.0
2017-10-17	AB	Stock	25.0	25.15	24.8	25.0	150700.0
2017-10-17	ABAC-DELISTED	Stock	3.4908	3.4908	3.4579	3.461	468.0
2017-10-17	ABAX-DELISTED	Stock	46.07	46.07	45.36	45.74	69773.0
2017-10-17	ABB-DELISTED	Stock	24.94	25.05	24.9	25.02	841462.0
2017-10-17	ABBNY-DELISTED	Stock	24.94	25.05	24.9	25.03	974743.0
2017-10-17	ABBV	Stock	91.09	92.78	90.95	92.17	5280500.0
2017-10-17	ABC-DELISTED	Stock	78.89	80.52	78.4	79.95	890180.0
2017-10-17	ABCB	Stock	49.65	50.25	48.6	49.15	116100.0
2017-10-17	ABCD-DELISTED	Stock	6.05	6.155	6.0	6.11	52849.0
2017-10-17	ABCO-DELISTED	Stock	53.8	53.95	53.65	53.7	923161.0
2017-10-17	ABDC-DELISTED	Stock	10.37	10.4022	10.19	10.38	73637.0
2017-10-17	ABE-DELISTED	Stock	14.64	14.6834	14.64	14.6568	5977.0
2017-10-17	ABEO	Stock	435.0	458.75	413.75	447.5	156384.0
2017-10-17	ABEOW-DELISTED	Stock	11.8	13.2	11.8	13.2	11100.0
2017-10-17	ABEV	Stock	6.82	6.84	6.76	6.83	10489600.0
2017-10-17	ABG	Stock	56.85	57.8	56.5	57.05	171300.0
2017-10-17	ABIL-DELISTED	Stock	0.7426	0.7541	0.66	0.73	149682.0
2017-10-17	ABM	Stock	42.81	42.86	42.36	42.48	167200.0
2017-10-17	ABMD-DELISTED	Stock	171.0	172.64	170.938	172.44	124559.0

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

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