PREVIEW / stock_daily / 2017-09-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-12.parquet
  size:    215 KB
  rows:    6,463
  symbols: 2,943

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-09-12	AAPL	Stock	40.6525	40.99	39.6925	40.215	286856000.0
2017-09-12	MSFT	Stock	74.76	75.24	74.37	74.68	14394900.0
2017-09-12	NVDA	Stock	4.25	4.25	4.1742	4.2403	411488000.0
2017-09-12	AMZN	Stock	49.1635	49.2335	48.776	49.129	49622000.0
2017-09-12	GOOGL	Stock	47.346	47.4043	46.875	47.3325	25695740.0
2017-09-12	META	Stock	173.76	174.0	171.75	172.96	11186300.0
2017-09-12	TSLA	Stock	24.2993	24.584	24.0267	24.1833	89593500.0
2017-09-12	TLT	Stock	127.045	127.089	126.53	126.79	7557437.0
2017-09-12	ES	Stock	64.15	64.15	62.36	62.64	1288600.0
2017-09-12	CL	Stock	72.0	72.47	71.86	71.95	1413700.0
2017-09-12	A	Stock	66.27	66.42	65.89	66.14	1081900.0
2017-09-12	AA	Stock	44.59	45.2	44.33	45.0	4826300.0
2017-09-12	AAAP-DELISTED	Stock	53.0	53.28	51.5	52.07	223321.0
2017-09-12	AABA-DELISTED	Stock	65.3	65.63	65.06	65.35	6212965.0
2017-09-12	AAC-DELISTED	Stock	10.75	13.0551	10.75	12.57	441454.0
2017-09-12	AACG	Stock	4.63	4.63	4.63	4.63	500.0
2017-09-12	AAIC-DELISTED	Stock	13.04	13.21	13.03	13.14	344410.0
2017-09-12	AAL	Stock	45.9	46.48	45.63	46.29	6325100.0
2017-09-12	AAM.A-DELISTED	Stock	26.17	26.3	26.17	26.2501	30362.0
2017-09-12	AAMC-DELISTED	Stock	30.0	33.1029	29.5853	30.2316	34037.0
2017-09-12	AAME	Stock	3.35	3.4	3.3	3.4	1400.0
2017-09-12	AAMI	Stock	13.69	13.96	13.69	13.89	479500.0
2017-09-12	AAOI	Stock	58.65	59.29	57.5	57.99	1391300.0
2017-09-12	AAON	Stock	21.3	21.6333	21.2333	21.3	222300.0
2017-09-12	AAP	Stock	92.31	97.95	91.46	97.26	2286800.0
2017-09-12	AAT	Stock	40.74	41.04	40.15	40.3	169300.0
2017-09-12	AAU-DELISTED	Stock	1.18	1.25	1.17	1.2	197362.0
2017-09-12	AAUAF-DELISTED	Stock	1.18	1.25	1.17	1.19	204050.0
2017-09-12	AAV-DELISTED	Stock	6.2	6.375	6.2	6.275	73730.0
2017-09-12	AAWW-DELISTED	Stock	65.75	67.15	65.7	67.15	137398.0
2017-09-12	AAXJ	Stock	72.93	72.93	72.7401	72.88	891917.0
2017-09-12	AAXN-DELISTED	Stock	21.87	22.35	21.86	22.35	642437.0
2017-09-12	AB	Stock	23.65	23.85	23.55	23.7	182200.0
2017-09-12	ABAC-DELISTED	Stock	2.13	2.17	2.12	2.15	1987.0
2017-09-12	ABAX-DELISTED	Stock	45.43	45.55	45.11	45.39	150634.0
2017-09-12	ABB-DELISTED	Stock	24.25	24.39	24.25	24.32	779876.0
2017-09-12	ABBNY-DELISTED	Stock	24.25	24.39	24.25	24.32	813004.0
2017-09-12	ABBV	Stock	86.97	87.97	86.5	87.75	11155600.0
2017-09-12	ABC-DELISTED	Stock	84.19	84.805	83.11	83.9	1563613.0
2017-09-12	ABCB	Stock	43.1	43.4	41.05	43.25	233700.0
2017-09-12	ABCD-DELISTED	Stock	6.29	6.3	6.16	6.21	39884.0
2017-09-12	ABCO-DELISTED	Stock	53.45	53.55	53.4	53.45	650395.0
2017-09-12	ABDC-DELISTED	Stock	10.82	10.82	10.64	10.7	75712.0
2017-09-12	ABE-DELISTED	Stock	14.38	14.52	14.2634	14.48	3364.0
2017-09-12	ABEO	Stock	355.0	355.75	341.5	345.0	21124.0
2017-09-12	ABEOW-DELISTED	Stock	8.68	9.0	8.63	9.0	2002.0
2017-09-12	ABEV	Stock	6.58	6.75	6.56	6.68	32747000.0
2017-09-12	ABG	Stock	57.2	58.0	56.95	57.6	119200.0
2017-09-12	ABIL-DELISTED	Stock	0.7602	0.77	0.71	0.7303	72663.0
2017-09-12	ABM	Stock	41.03	41.18	40.34	40.53	448500.0

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

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