PREVIEW / stock_daily / 2017-10-24

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-24.parquet
  size:    215 KB
  rows:    6,452
  symbols: 2,906

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-24	AAPL	Stock	39.0725	39.355	39.05	39.275	71028800.0
2017-10-24	MSFT	Stock	78.9	79.2	78.46	78.86	17517200.0
2017-10-24	NVDA	Stock	4.9248	4.9688	4.8985	4.967	407244000.0
2017-10-24	AMZN	Stock	48.45	48.9925	48.25	48.795	54478000.0
2017-10-24	GOOGL	Stock	49.325	49.463	48.854	49.4245	28902580.0
2017-10-24	META	Stock	172.3	173.24	171.5	171.8	12267900.0
2017-10-24	TSLA	Stock	22.5867	22.8533	22.4107	22.4893	67375500.0
2017-10-24	TLT	Stock	123.37	123.69	123.15	123.43	6842843.0
2017-10-24	ES	Stock	62.07	62.5	61.83	62.42	1710000.0
2017-10-24	CL	Stock	72.15	72.19	71.62	71.84	4000100.0
2017-10-24	A	Stock	67.31	67.55	66.88	67.32	1975700.0
2017-10-24	AA	Stock	48.13	50.31	48.06	50.08	6702500.0
2017-10-24	AAAP-DELISTED	Stock	70.92	76.73	70.34	74.5	565596.0
2017-10-24	AABA-DELISTED	Stock	66.69	67.203	66.4	66.59	3172081.0
2017-10-24	AAC-DELISTED	Stock	8.45	8.6	8.41	8.42	30517.0
2017-10-24	AACG	Stock	4.69	4.7	4.68	4.68	600.0
2017-10-24	AAIC-DELISTED	Stock	12.67	12.76	12.655	12.67	349555.0
2017-10-24	AAL	Stock	51.02	52.1	50.55	51.95	3654900.0
2017-10-24	AAM.A-DELISTED	Stock	26.3	26.3	26.125	26.2	34477.0
2017-10-24	AAMC-DELISTED	Stock	25.1324	25.1471	25.1176	25.1471	2931.0
2017-10-24	AAME	Stock	3.4	3.4	3.34	3.4	1800.0
2017-10-24	AAMI	Stock	15.6	15.69	15.56	15.61	292500.0
2017-10-24	AAOI	Stock	42.04	42.835	41.55	41.66	1076400.0
2017-10-24	AAON	Stock	23.0667	23.6867	23.0667	23.4	243450.0
2017-10-24	AAP	Stock	85.73	85.93	83.5	84.25	1789500.0
2017-10-24	AAT	Stock	39.27	39.54	39.16	39.48	379700.0
2017-10-24	AAU-DELISTED	Stock	1.13	1.15	1.1	1.12	134814.0
2017-10-24	AAUAF-DELISTED	Stock	1.13	1.15	1.1	1.12	137350.0
2017-10-24	AAV-DELISTED	Stock	5.5	5.575	5.4	5.4	83740.0
2017-10-24	AAWW-DELISTED	Stock	64.7	65.6	63.65	63.65	126955.0
2017-10-24	AAXJ	Stock	74.69	74.8	74.4	74.49	640203.0
2017-10-24	AAXN-DELISTED	Stock	22.48	22.54	22.115	22.3	968580.0
2017-10-24	AB	Stock	25.35	25.7	25.2	25.6	281200.0
2017-10-24	ABAC-DELISTED	Stock	3.53	3.6	3.3277	3.42	13555.0
2017-10-24	ABAX-DELISTED	Stock	46.83	47.01	45.7	46.4	169122.0
2017-10-24	ABB-DELISTED	Stock	25.1	25.16	25.04	25.1	1204110.0
2017-10-24	ABBNY-DELISTED	Stock	25.1	25.16	25.04	25.11	1947931.0
2017-10-24	ABBV	Stock	94.0	94.14	90.77	91.69	10301100.0
2017-10-24	ABC-DELISTED	Stock	82.69	82.98	80.64	81.85	991391.0
2017-10-24	ABCB	Stock	47.9	49.1	47.9	48.45	166400.0
2017-10-24	ABCD-DELISTED	Stock	6.14	6.35	6.12	6.19	47008.0
2017-10-24	ABCO-DELISTED	Stock	53.9	53.95	53.75	53.8	252136.0
2017-10-24	ABDC-DELISTED	Stock	10.22	10.25	10.01	10.03	65305.0
2017-10-24	ABE-DELISTED	Stock	14.5434	14.5784	14.5	14.5577	2291.0
2017-10-24	ABEO	Stock	461.25	474.75	446.25	446.25	39940.0
2017-10-24	ABEOW-DELISTED	Stock	13.02	13.87	12.9	12.9	7300.0
2017-10-24	ABEV	Stock	6.54	6.55	6.49	6.53	17329100.0
2017-10-24	ABG	Stock	56.85	58.15	55.4	57.05	395700.0
2017-10-24	ABIL-DELISTED	Stock	0.69	0.7	0.6282	0.659	169302.0
2017-10-24	ABM	Stock	42.42	42.65	42.23	42.36	286200.0

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

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