PREVIEW / stock_daily / 2017-10-03

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-03.parquet
  size:    216 KB
  rows:    6,481
  symbols: 2,945

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-03	AAPL	Stock	38.5025	38.7725	38.4775	38.62	64921200.0
2017-10-03	MSFT	Stock	74.67	74.88	74.19	74.26	12190400.0
2017-10-03	NVDA	Stock	4.4812	4.5145	4.4395	4.4842	390332000.0
2017-10-03	AMZN	Stock	47.9	48.1845	47.5185	47.855	53332000.0
2017-10-03	GOOGL	Stock	48.378	48.622	48.1353	48.604	21678960.0
2017-10-03	META	Stock	169.3	170.73	169.2	169.96	8190300.0
2017-10-03	TSLA	Stock	22.3933	23.2367	22.0853	23.2093	152304000.0
2017-10-03	TLT	Stock	123.92	124.51	123.915	124.4	6219818.0
2017-10-03	ES	Stock	60.31	60.39	59.59	60.21	1625000.0
2017-10-03	CL	Stock	72.78	72.99	72.36	72.44	2310000.0
2017-10-03	A	Stock	65.06	65.78	65.06	65.15	1216400.0
2017-10-03	AA	Stock	47.97	48.33	47.44	48.31	3313600.0
2017-10-03	AAAP-DELISTED	Stock	66.5	66.74	65.05	65.31	329586.0
2017-10-03	AABA-DELISTED	Stock	67.11	67.93	66.96	67.83	4793454.0
2017-10-03	AAC-DELISTED	Stock	10.0	10.2	9.84	10.0	91209.0
2017-10-03	AACG	Stock	4.75	4.77	4.75	4.77	8200.0
2017-10-03	AAIC-DELISTED	Stock	12.8	12.85	12.74	12.79	370916.0
2017-10-03	AAL	Stock	47.66	50.59	47.63	50.51	10261800.0
2017-10-03	AAM.A-DELISTED	Stock	26.134	26.23	26.0401	26.0401	15201.0
2017-10-03	AAMC-DELISTED	Stock	24.0882	25.8676	24.0882	24.7059	22518.0
2017-10-03	AAME	Stock	3.35	3.35	3.25	3.25	4400.0
2017-10-03	AAMI	Stock	14.83	15.04	14.73	15.04	588300.0
2017-10-03	AAOI	Stock	61.97	62.78	59.82	61.73	3393100.0
2017-10-03	AAON	Stock	23.4667	23.6667	23.1667	23.6333	227250.0
2017-10-03	AAP	Stock	99.46	100.1	98.24	98.98	935000.0
2017-10-03	AAT	Stock	40.35	40.61	40.02	40.59	204200.0
2017-10-03	AAU-DELISTED	Stock	1.12	1.1452	1.1	1.1177	101568.0
2017-10-03	AAUAF-DELISTED	Stock	1.12	1.1452	1.1	1.1177	102648.0
2017-10-03	AAV-DELISTED	Stock	6.2	6.225	6.05	6.1	83296.0
2017-10-03	AAWW-DELISTED	Stock	67.25	68.3	67.05	68.25	162263.0
2017-10-03	AAXJ	Stock	72.99	73.41	72.95	73.41	1687192.0
2017-10-03	AAXN-DELISTED	Stock	23.04	23.31	23.04	23.21	426950.0
2017-10-03	AB	Stock	24.1	24.6	24.05	24.5	250700.0
2017-10-03	ABAC-DELISTED	Stock	2.35	2.5	2.33	2.5	6650.0
2017-10-03	ABAX-DELISTED	Stock	45.97	46.09	44.92	45.58	74985.0
2017-10-03	ABB-DELISTED	Stock	24.98	25.1	24.97	25.09	1802005.0
2017-10-03	ABBNY-DELISTED	Stock	24.98	25.1	24.97	25.09	2259496.0
2017-10-03	ABBV	Stock	90.44	90.64	89.02	89.7	4286900.0
2017-10-03	ABC-DELISTED	Stock	83.33	83.7287	82.515	82.88	945079.0
2017-10-03	ABCB	Stock	49.05	49.05	48.0	48.5	215600.0
2017-10-03	ABCD-DELISTED	Stock	6.51	6.62	6.2335	6.31	85028.0
2017-10-03	ABCO-DELISTED	Stock	53.85	53.95	53.75	53.85	744159.0
2017-10-03	ABDC-DELISTED	Stock	10.54	10.689	10.34	10.4	113307.0
2017-10-03	ABE-DELISTED	Stock	13.88	14.26	13.88	14.24	18422.0
2017-10-03	ABEO	Stock	461.25	461.25	423.75	440.0	27448.0
2017-10-03	ABEOW-DELISTED	Stock	12.94	12.94	12.03	12.5	4200.0
2017-10-03	ABEV	Stock	6.53	6.78	6.53	6.76	23419100.0
2017-10-03	ABG	Stock	62.15	62.65	61.6	62.3	316000.0
2017-10-03	ABIL-DELISTED	Stock	0.799	0.799	0.7506	0.7692	113015.0
2017-10-03	ABM	Stock	42.37	42.9	42.27	42.83	377200.0

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

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