PREVIEW / stock_daily / 2017-12-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-08.parquet
  size:    217 KB
  rows:    6,498
  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-12-08	AAPL	Stock	42.6225	42.75	42.205	42.3425	93420800.0
2017-12-08	MSFT	Stock	83.63	84.58	83.33	84.16	24489100.0
2017-12-08	NVDA	Stock	4.8502	4.8695	4.7788	4.7872	466876000.0
2017-12-08	AMZN	Stock	58.52	58.6395	57.855	58.1	61002000.0
2017-12-08	GOOGL	Stock	52.5905	52.821	52.293	52.469	31169440.0
2017-12-08	META	Stock	181.53	182.28	178.74	179.0	19883800.0
2017-12-08	TSLA	Stock	20.9733	21.132	20.7507	21.0087	52027500.0
2017-12-08	TLT	Stock	126.59	126.74	126.235	126.69	4786306.0
2017-12-08	ES	Stock	64.84	65.23	64.57	65.22	1741400.0
2017-12-08	CL	Stock	73.16	73.35	72.7	73.32	3048000.0
2017-12-08	A	Stock	66.94	67.55	66.65	67.38	2195600.0
2017-12-08	AA	Stock	41.0	41.77	40.9	41.4	3696900.0
2017-12-08	AAAP-DELISTED	Stock	81.65	81.7	81.58	81.6	422558.0
2017-12-08	AABA-DELISTED	Stock	71.0	71.63	70.82	71.26	5911657.0
2017-12-08	AAC-DELISTED	Stock	8.9	8.9	8.69	8.845	105284.0
2017-12-08	AACG	Stock	5.18	5.2	5.08	5.19	19100.0
2017-12-08	AAIC-DELISTED	Stock	12.09	12.1	11.9944	12.07	260030.0
2017-12-08	AAL	Stock	51.23	51.79	50.93	51.02	3817900.0
2017-12-08	AAM.A-DELISTED	Stock	26.3552	26.37	26.12	26.17	21814.0
2017-12-08	AAMC-DELISTED	Stock	20.0	22.0441	20.0	21.4853	6290.0
2017-12-08	AAME	Stock	3.5	3.5	3.35	3.45	2100.0
2017-12-08	AAMI	Stock	16.07	16.07	15.84	15.96	403300.0
2017-12-08	AAOI	Stock	39.1	39.71	38.1	38.69	1335800.0
2017-12-08	AAON	Stock	24.3667	24.3667	23.8	23.8	153900.0
2017-12-08	AAP	Stock	98.21	100.62	97.38	100.31	925600.0
2017-12-08	AAT	Stock	38.55	38.7	38.35	38.49	110900.0
2017-12-08	AAU-DELISTED	Stock	0.757	0.8	0.713	0.7676	1558596.0
2017-12-08	AAUAF-DELISTED	Stock	0.757	0.8	0.713	0.764	1678265.0
2017-12-08	AAV-DELISTED	Stock	4.05	4.05	3.95	3.9763	192059.0
2017-12-08	AAWW-DELISTED	Stock	57.75	57.95	56.8	57.25	87663.0
2017-12-08	AAXJ	Stock	75.29	75.38	75.03	75.32	1132464.0
2017-12-08	AAXN-DELISTED	Stock	24.36	24.78	24.32	24.5	433009.0
2017-12-08	AB	Stock	26.0	26.0	25.53	25.85	110800.0
2017-12-08	ABAC-DELISTED	Stock	2.95	3.01	2.8101	2.8101	6464.0
2017-12-08	ABAX-DELISTED	Stock	47.17	47.8	46.456	47.64	111079.0
2017-12-08	ABB-DELISTED	Stock	26.02	26.21	25.96	26.2	2045842.0
2017-12-08	ABBNY-DELISTED	Stock	26.02	26.21	25.96	26.2	4293390.0
2017-12-08	ABBV	Stock	95.68	96.54	94.62	95.95	5297000.0
2017-12-08	ABC-DELISTED	Stock	86.06	86.83	85.01	86.69	1503613.0
2017-12-08	ABCB	Stock	47.9	47.9	47.05	47.05	146600.0
2017-12-08	ABCD-DELISTED	Stock	5.64	5.66	5.44	5.46	55705.0
2017-12-08	ABDC-DELISTED	Stock	8.35	8.36	8.28	8.34	34330.0
2017-12-08	ABE-DELISTED	Stock	14.1	14.2285	14.1	14.1864	2643.0
2017-12-08	ABEO	Stock	398.75	408.75	388.75	405.0	23024.0
2017-12-08	ABEOW-DELISTED	Stock	10.7	11.1	10.7	11.1	1400.0
2017-12-08	ABEV	Stock	6.3	6.35	6.27	6.35	16883600.0
2017-12-08	ABG	Stock	66.1	68.1	65.35	67.75	216500.0
2017-12-08	ABIL-DELISTED	Stock	0.44	0.4461	0.352	0.3999	336192.0
2017-12-08	ABLX-DELISTED	Stock	23.64	24.16	23.59	23.92	210831.0
2017-12-08	ABM	Stock	43.4	43.64	42.94	43.33	177500.0

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

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