PREVIEW / stock_daily / 2017-07-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-27.parquet
  size:    215 KB
  rows:    6,443
  symbols: 2,971

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-07-27	AAPL	Stock	38.4375	38.4975	36.825	37.64	129905200.0
2017-07-27	MSFT	Stock	73.76	74.42	72.32	73.16	36844200.0
2017-07-27	NVDA	Stock	4.2068	4.2185	3.939	4.0435	782856000.0
2017-07-27	AMZN	Stock	53.4775	54.1655	52.009	52.3	219834000.0
2017-07-27	GOOGL	Stock	48.459	48.476	46.853	47.6255	74358000.0
2017-07-27	META	Stock	174.7	175.49	167.5	170.44	68910700.0
2017-07-27	TSLA	Stock	23.0667	23.1667	21.7527	22.2973	124536000.0
2017-07-27	TLT	Stock	123.11	123.38	122.82	123.16	6390798.0
2017-07-27	ES	Stock	60.81	61.09	60.4	60.71	2204700.0
2017-07-27	CL	Stock	73.2	73.4	72.33	72.95	4326500.0
2017-07-27	A	Stock	59.82	60.24	59.6	59.91	1945000.0
2017-07-27	AA	Stock	36.84	37.07	36.085	36.36	2044100.0
2017-07-27	AAAP-DELISTED	Stock	42.69	42.69	40.955	41.96	74658.0
2017-07-27	AABA-DELISTED	Stock	59.61	60.215	57.56	58.42	7692033.0
2017-07-27	AAC-DELISTED	Stock	6.47	6.55	6.26	6.42	78668.0
2017-07-27	AACG	Stock	4.55	4.79	4.55	4.78	1100.0
2017-07-27	AAIC-DELISTED	Stock	12.75	13.0	12.75	12.99	519305.0
2017-07-27	AAL	Stock	50.34	50.34	48.75	50.0	10260300.0
2017-07-27	AAM.A-DELISTED	Stock	26.09	26.15	25.965	26.15	45798.0
2017-07-27	AAMC-DELISTED	Stock	26.6393	27.0588	25.892	27.0588	7157.0
2017-07-27	AAME	Stock	3.5	3.65	3.5	3.6	900.0
2017-07-27	AAMI	Stock	15.15	15.15	14.8	14.86	558800.0
2017-07-27	AAOI	Stock	99.59	103.41	92.93	97.82	5875500.0
2017-07-27	AAON	Stock	22.9667	23.0667	22.5	22.6	198000.0
2017-07-27	AAP	Stock	108.05	110.54	107.24	110.34	2247300.0
2017-07-27	AAT	Stock	40.05	40.78	39.85	40.39	166600.0
2017-07-27	AAU-DELISTED	Stock	1.26	1.26	1.19	1.2	116844.0
2017-07-27	AAUAF-DELISTED	Stock	1.26	1.26	1.19	1.2	122442.0
2017-07-27	AAV-DELISTED	Stock	7.05	7.15	7.025	7.15	79545.0
2017-07-27	AAWW-DELISTED	Stock	58.8	58.8	57.2	57.95	354797.0
2017-07-27	AAXJ	Stock	71.4	71.4854	70.4	70.75	4569849.0
2017-07-27	AAXN-DELISTED	Stock	25.23	25.37	24.8	24.98	261378.0
2017-07-27	AB	Stock	25.05	26.15	24.95	25.05	331600.0
2017-07-27	ABAC-DELISTED	Stock	2.27	2.59	2.19	2.28	28173.0
2017-07-27	ABAX-DELISTED	Stock	51.12	52.33	51.0	52.11	94511.0
2017-07-27	ABB-DELISTED	Stock	23.45	23.45	23.24	23.35	1851524.0
2017-07-27	ABBNY-DELISTED	Stock	23.45	23.45	23.24	23.35	1894019.0
2017-07-27	ABBV	Stock	72.78	72.8	70.88	71.73	7389300.0
2017-07-27	ABC-DELISTED	Stock	93.49	93.67	91.86	92.79	1234077.0
2017-07-27	ABCB	Stock	46.0	46.45	45.47	46.15	142300.0
2017-07-27	ABCD-DELISTED	Stock	4.85	4.9315	4.83	4.89	37999.0
2017-07-27	ABCO-DELISTED	Stock	56.25	56.8	55.605	56.2	366298.0
2017-07-27	ABDC-DELISTED	Stock	11.87	11.93	11.51	11.75	218887.0
2017-07-27	ABE-DELISTED	Stock	14.09	14.179	14.04	14.179	6627.0
2017-07-27	ABEO	Stock	215.0	218.75	203.75	210.0	23656.0
2017-07-27	ABEOW-DELISTED	Stock	4.5136	4.5136	4.0	4.13	1254.0
2017-07-27	ABEV	Stock	6.01	6.12	5.98	6.03	18887200.0
2017-07-27	ABG	Stock	53.9	54.25	52.93	53.95	429100.0
2017-07-27	ABIL-DELISTED	Stock	0.9	0.9	0.751	0.78	171834.0
2017-07-27	ABM	Stock	44.61	44.89	44.02	44.79	236600.0

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

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