PREVIEW / stock_daily / 2017-11-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-14.parquet
  size:    216 KB
  rows:    6,493
  symbols: 2,921

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-11-14	AAPL	Stock	43.26	43.37	42.795	42.835	99130000.0
2017-11-14	MSFT	Stock	83.5	84.1	82.98	84.05	18801300.0
2017-11-14	NVDA	Stock	5.325	5.37	5.2808	5.3545	529292000.0
2017-11-14	AMZN	Stock	56.5055	56.9	56.1945	56.842	62768000.0
2017-11-14	GOOGL	Stock	51.886	52.115	51.4665	52.082	21011320.0
2017-11-14	META	Stock	178.13	178.97	177.18	178.07	9585900.0
2017-11-14	TSLA	Stock	21.0	21.09	20.46	20.58	85141500.0
2017-11-14	TLT	Stock	124.77	125.24	124.77	125.2	6195891.0
2017-11-14	ES	Stock	64.61	65.85	64.46	65.81	1761200.0
2017-11-14	CL	Stock	73.46	73.66	73.12	73.46	2970100.0
2017-11-14	A	Stock	66.98	67.8	66.89	67.46	2426200.0
2017-11-14	AA	Stock	42.9	42.9	40.62	41.87	8096800.0
2017-11-14	AAAP-DELISTED	Stock	81.02	81.06	80.96	81.025	709756.0
2017-11-14	AABA-DELISTED	Stock	70.0	70.15	69.098	69.52	4779613.0
2017-11-14	AAC-DELISTED	Stock	10.23	10.39	10.09	10.16	89668.0
2017-11-14	AACG	Stock	4.27	4.5	4.27	4.46	8600.0
2017-11-14	AAIC-DELISTED	Stock	11.19	11.38	11.19	11.32	212963.0
2017-11-14	AAL	Stock	45.3	45.97	45.27	45.81	1827100.0
2017-11-14	AAM.A-DELISTED	Stock	26.47	26.59	26.36	26.55	21025.0
2017-11-14	AAMC-DELISTED	Stock	23.5294	23.5294	22.3529	22.3529	8537.0
2017-11-14	AAME	Stock	3.65	3.8	3.55	3.6	2300.0
2017-11-14	AAMI	Stock	16.0	16.02	15.77	15.96	391600.0
2017-11-14	AAOI	Stock	43.89	44.269	42.79	43.9	1331500.0
2017-11-14	AAON	Stock	22.4333	22.9667	22.3	22.8667	183750.0
2017-11-14	AAP	Stock	94.88	102.89	94.75	95.72	10153800.0
2017-11-14	AAT	Stock	39.57	39.65	39.32	39.6	299300.0
2017-11-14	AAU-DELISTED	Stock	0.9151	0.92	0.8884	0.915	311593.0
2017-11-14	AAUAF-DELISTED	Stock	0.9151	0.92	0.8884	0.91	331441.0
2017-11-14	AAV-DELISTED	Stock	5.6	5.625	5.35	5.375	95522.0
2017-11-14	AAWW-DELISTED	Stock	53.55	54.5	52.65	52.8	362079.0
2017-11-14	AAXJ	Stock	75.89	75.93	75.57	75.67	483372.0
2017-11-14	AAXN-DELISTED	Stock	21.01	21.44	20.8099	21.41	846753.0
2017-11-14	AB	Stock	24.75	24.95	24.75	24.8	186300.0
2017-11-14	ABAC-DELISTED	Stock	2.88	3.25	2.88	3.08	5917.0
2017-11-14	ABAX-DELISTED	Stock	45.68	46.34	45.64	46.16	91566.0
2017-11-14	ABB-DELISTED	Stock	25.19	25.36	25.16	25.31	1302051.0
2017-11-14	ABBNY-DELISTED	Stock	25.19	25.36	25.16	25.31	1361993.0
2017-11-14	ABBV	Stock	94.64	94.91	93.12	94.75	4717300.0
2017-11-14	ABC-DELISTED	Stock	75.15	75.48	74.499	75.45	1621119.0
2017-11-14	ABCB	Stock	46.45	47.15	46.15	46.8	79700.0
2017-11-14	ABCD-DELISTED	Stock	6.8	7.02	5.46	5.86	387016.0
2017-11-14	ABCO-DELISTED	Stock	53.5	53.6	53.45	53.6	2696359.0
2017-11-14	ABDC-DELISTED	Stock	7.24	7.38	7.13	7.17	195484.0
2017-11-14	ABE-DELISTED	Stock	14.12	14.12	13.89	13.89	8479.0
2017-11-14	ABEO	Stock	365.0	378.75	358.75	377.5	21552.0
2017-11-14	ABEOW-DELISTED	Stock	9.89	9.9	9.89	9.9	200.0
2017-11-14	ABEV	Stock	6.13	6.15	6.05	6.06	13492100.0
2017-11-14	ABG	Stock	61.45	62.28	61.33	61.95	114000.0
2017-11-14	ABIL-DELISTED	Stock	0.6519	0.7	0.5899	0.6099	581512.0
2017-11-14	ABLX-DELISTED	Stock	20.96	21.15	20.88	21.06	118397.0

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

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