PREVIEW / stock_daily / 2017-10-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-20.parquet
  size:    215 KB
  rows:    6,460
  symbols: 2,917

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-20	AAPL	Stock	39.1525	39.4375	38.99	39.0625	95896400.0
2017-10-20	MSFT	Stock	78.32	78.97	78.22	78.81	22866400.0
2017-10-20	NVDA	Stock	4.9623	4.9898	4.9135	4.9225	451620000.0
2017-10-20	AMZN	Stock	49.6765	49.731	49.1	49.1455	47302000.0
2017-10-20	GOOGL	Stock	50.3525	50.4325	50.1135	50.2535	32120620.0
2017-10-20	META	Stock	175.5	175.88	174.63	174.98	12602200.0
2017-10-20	TSLA	Stock	23.5127	23.6367	22.956	23.0067	73956000.0
2017-10-20	TLT	Stock	124.0	124.28	123.64	123.98	12326907.0
2017-10-20	ES	Stock	61.89	62.21	61.79	62.13	1017100.0
2017-10-20	CL	Stock	72.65	73.05	72.0	72.32	4317700.0
2017-10-20	A	Stock	67.19	67.53	67.07	67.25	1506100.0
2017-10-20	AA	Stock	47.13	48.13	47.06	47.93	4209100.0
2017-10-20	AAAP-DELISTED	Stock	73.0	74.94	73.0	73.46	234399.0
2017-10-20	AABA-DELISTED	Stock	67.65	68.36	67.45	67.5	6108431.0
2017-10-20	AAC-DELISTED	Stock	8.29	8.7	8.2323	8.64	98092.0
2017-10-20	AACG	Stock	4.65	4.7	4.65	4.7	1400.0
2017-10-20	AAIC-DELISTED	Stock	12.76	12.79	12.71	12.76	307830.0
2017-10-20	AAL	Stock	51.56	52.24	51.53	51.93	3643400.0
2017-10-20	AAM.A-DELISTED	Stock	26.1	26.33	26.07	26.33	69997.0
2017-10-20	AAMC-DELISTED	Stock	25.1471	25.1471	25.1471	25.1471	1425.0
2017-10-20	AAME	Stock	3.3	3.35	3.2	3.35	2700.0
2017-10-20	AAMI	Stock	15.47	15.625	15.39	15.58	692300.0
2017-10-20	AAOI	Stock	42.3	42.6	41.21	41.47	1303200.0
2017-10-20	AAON	Stock	23.0333	23.4	22.9333	23.0667	201150.0
2017-10-20	AAP	Stock	87.36	87.72	85.93	86.78	1156800.0
2017-10-20	AAT	Stock	39.95	39.95	38.89	39.07	324900.0
2017-10-20	AAU-DELISTED	Stock	1.12	1.1465	1.11	1.1301	121346.0
2017-10-20	AAUAF-DELISTED	Stock	1.12	1.1465	1.11	1.1301	132561.0
2017-10-20	AAV-DELISTED	Stock	5.5	5.5	5.4	5.45	65099.0
2017-10-20	AAWW-DELISTED	Stock	63.5	64.95	63.445	64.625	354208.0
2017-10-20	AAXJ	Stock	74.75	74.94	74.7	74.87	676860.0
2017-10-20	AAXN-DELISTED	Stock	23.5	24.03	22.86	23.01	3943006.0
2017-10-20	AB	Stock	25.2	25.45	25.1	25.35	283200.0
2017-10-20	ABAC-DELISTED	Stock	3.52	3.75	3.39	3.5672	8669.0
2017-10-20	ABAX-DELISTED	Stock	47.17	47.3	46.8101	47.08	71685.0
2017-10-20	ABB-DELISTED	Stock	25.43	25.54	25.36	25.465	1151463.0
2017-10-20	ABBNY-DELISTED	Stock	25.44	25.54	25.36	25.46	1224623.0
2017-10-20	ABBV	Stock	96.78	98.26	94.89	96.1	6882600.0
2017-10-20	ABC-DELISTED	Stock	82.57	83.77	82.35	83.19	1108284.0
2017-10-20	ABCB	Stock	48.8	48.8	48.14	48.25	203900.0
2017-10-20	ABCD-DELISTED	Stock	6.21	6.29	6.15	6.21	18426.0
2017-10-20	ABCO-DELISTED	Stock	53.9	53.95	53.85	53.9	163775.0
2017-10-20	ABDC-DELISTED	Stock	10.02	10.27	10.02	10.26	47930.0
2017-10-20	ABE-DELISTED	Stock	14.6453	14.65	14.619	14.62	1705.0
2017-10-20	ABEO	Stock	445.0	500.0	445.0	475.0	74644.0
2017-10-20	ABEOW-DELISTED	Stock	12.99	14.62	12.89	14.21	23100.0
2017-10-20	ABEV	Stock	6.82	6.82	6.67	6.71	27455400.0
2017-10-20	ABG	Stock	54.85	56.35	54.51	55.85	307100.0
2017-10-20	ABIL-DELISTED	Stock	0.71	0.7201	0.69	0.701	79497.0
2017-10-20	ABM	Stock	42.77	42.91	42.6	42.63	201500.0

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

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