PREVIEW / stock_daily / 2017-10-31

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-31.parquet
  size:    215 KB
  rows:    6,465
  symbols: 2,915

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-31	AAPL	Stock	41.975	42.4125	41.735	42.26	144187200.0
2017-10-31	MSFT	Stock	84.36	84.36	83.11	83.18	27086600.0
2017-10-31	NVDA	Stock	5.1283	5.1973	5.1225	5.1702	411908000.0
2017-10-31	AMZN	Stock	55.45	55.527	55.056	55.264	69540000.0
2017-10-31	GOOGL	Stock	51.65	52.05	51.3148	51.652	30325560.0
2017-10-31	META	Stock	180.57	180.8	178.94	180.06	20174200.0
2017-10-31	TSLA	Stock	21.3487	22.13	21.3453	22.102	85084500.0
2017-10-31	TLT	Stock	124.53	124.6589	124.4	124.46	4424322.0
2017-10-31	ES	Stock	62.45	62.83	62.31	62.64	1965400.0
2017-10-31	CL	Stock	69.35	70.52	69.1	70.45	4734000.0
2017-10-31	A	Stock	67.74	68.17	67.54	68.03	1614400.0
2017-10-31	AA	Stock	47.15	48.07	46.38	47.78	2721500.0
2017-10-31	AAAP-DELISTED	Stock	80.5	81.17	80.1	81.15	6433769.0
2017-10-31	AABA-DELISTED	Stock	69.5	70.27	68.96	70.2	10080558.0
2017-10-31	AAC-DELISTED	Stock	8.18	8.36	7.92	7.92	134298.0
2017-10-31	AAIC-DELISTED	Stock	11.65	11.65	11.435	11.47	439711.0
2017-10-31	AAL	Stock	47.22	47.6	46.79	46.82	4596600.0
2017-10-31	AAM.A-DELISTED	Stock	26.13	26.24	26.13	26.23	30263.0
2017-10-31	AAMC-DELISTED	Stock	24.8162	24.8162	24.8162	24.8162	1948.0
2017-10-31	AAMI	Stock	15.42	15.48	15.26	15.28	420300.0
2017-10-31	AAOI	Stock	42.44	42.99	40.57	40.74	1612100.0
2017-10-31	AAON	Stock	23.0	23.6	23.0	23.3333	274950.0
2017-10-31	AAP	Stock	82.17	83.15	81.68	81.74	1081500.0
2017-10-31	AAT	Stock	39.05	39.05	38.6	38.79	301000.0
2017-10-31	AAU-DELISTED	Stock	1.0	1.045	1.0	1.03	209148.0
2017-10-31	AAUAF-DELISTED	Stock	1.0	1.045	1.0	1.03	230244.0
2017-10-31	AAV-DELISTED	Stock	5.4	5.4	5.3	5.3	143226.0
2017-10-31	AAWW-DELISTED	Stock	61.7	62.15	61.15	61.45	149127.0
2017-10-31	AAXJ	Stock	75.14	75.35	74.98	75.31	872846.0
2017-10-31	AAXN-DELISTED	Stock	22.96	23.15	22.89	22.97	446328.0
2017-10-31	AB	Stock	26.05	26.1	25.75	25.85	267300.0
2017-10-31	ABAC-DELISTED	Stock	3.25	3.3724	3.25	3.32	1095.0
2017-10-31	ABAX-DELISTED	Stock	47.87	48.74	47.48	48.38	80653.0
2017-10-31	ABB-DELISTED	Stock	25.92	26.29	25.9	26.12	3000660.0
2017-10-31	ABBNY-DELISTED	Stock	25.92	26.29	25.9	26.13	3095088.0
2017-10-31	ABBV	Stock	90.88	91.82	90.04	90.25	7065600.0
2017-10-31	ABC-DELISTED	Stock	76.85	78.99	75.46	76.95	2836123.0
2017-10-31	ABCB	Stock	47.9	48.5	47.5	47.9	133100.0
2017-10-31	ABCD-DELISTED	Stock	5.92	6.18	5.88	6.11	65738.0
2017-10-31	ABCO-DELISTED	Stock	53.9	54.05	53.75	53.9	569396.0
2017-10-31	ABDC-DELISTED	Stock	9.5	9.6	9.24	9.28	104671.0
2017-10-31	ABE-DELISTED	Stock	14.4201	14.44	14.42	14.43	8062.0
2017-10-31	ABEO	Stock	438.75	451.25	432.5	448.75	21704.0
2017-10-31	ABEOW-DELISTED	Stock	11.98	12.93	11.98	12.87	9700.0
2017-10-31	ABEV	Stock	6.33	6.43	6.29	6.33	22224600.0
2017-10-31	ABG	Stock	60.95	62.05	60.5	61.4	245500.0
2017-10-31	ABIL-DELISTED	Stock	0.68	0.68	0.6253	0.6599	22685.0
2017-10-31	ABLX-DELISTED	Stock	20.21	20.99	20.16	20.84	675827.0
2017-10-31	ABM	Stock	42.15	42.15	41.73	41.97	515600.0
2017-10-31	ABMD-DELISTED	Stock	180.12	193.95	180.12	192.86	656405.0

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

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