PREVIEW / stock_daily / 2017-01-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-12.parquet
  size:    214 KB
  rows:    6,470
  symbols: 3,088

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-01-12	AAPL	Stock	29.725	29.825	29.5525	29.8125	108344800.0
2017-01-12	MSFT	Stock	63.06	63.4	61.95	62.61	20968200.0
2017-01-12	NVDA	Stock	2.6058	2.6175	2.5405	2.586	625616000.0
2017-01-12	AMZN	Stock	40.0155	40.7065	39.975	40.682	97478000.0
2017-01-12	GOOGL	Stock	41.419	41.519	41.0505	41.4765	27006160.0
2017-01-12	META	Stock	125.61	126.73	124.8	126.62	18653900.0
2017-01-12	TSLA	Stock	15.2707	15.38	15.0387	15.306	56853000.0
2017-01-12	TLT	Stock	122.8	123.14	121.83	121.89	9977612.0
2017-01-12	ES	Stock	54.91	55.41	54.84	55.31	1353600.0
2017-01-12	CL	Stock	65.37	65.94	65.26	65.85	2992400.0
2017-01-12	A	Stock	48.9	48.9	47.98	48.52	3276900.0
2017-01-12	AA	Stock	33.0	33.5	32.51	33.04	4521700.0
2017-01-12	AAAP-DELISTED	Stock	29.19	29.5	28.28	29.01	142888.0
2017-01-12	AABA-DELISTED	Stock	42.34	42.4604	41.7	42.11	5492746.0
2017-01-12	AAC-DELISTED	Stock	8.25	8.25	7.9	7.99	153036.0
2017-01-12	AACG	Stock	3.58	3.7	3.4	3.4	12100.0
2017-01-12	AAIC-DELISTED	Stock	15.28	15.28	14.9375	15.11	195410.0
2017-01-12	AAL	Stock	48.67	49.0	46.84	48.1	5447300.0
2017-01-12	AAMC-DELISTED	Stock	18.8382	18.8824	18.1324	18.7647	18003.0
2017-01-12	AAME	Stock	3.9	3.9	3.85	3.85	1800.0
2017-01-12	AAMI	Stock	14.57	14.63	14.2	14.42	353600.0
2017-01-12	AAOI	Stock	27.1	30.5	26.11	29.86	4415900.0
2017-01-12	AAON	Stock	22.2333	22.3333	21.3667	21.7333	178050.0
2017-01-12	AAP	Stock	172.42	174.61	172.0	174.47	747400.0
2017-01-12	AAT	Stock	43.04	43.17	42.56	43.12	62100.0
2017-01-12	AAU-DELISTED	Stock	1.07	1.08	1.0	1.01	276728.0
2017-01-12	AAUAF-DELISTED	Stock	1.07	1.08	1.0	1.01	278206.0
2017-01-12	AAV-DELISTED	Stock	6.55	6.65	6.45	6.5	80210.0
2017-01-12	AAWW-DELISTED	Stock	53.0	53.0	51.4	51.85	133186.0
2017-01-12	AAXJ	Stock	57.72	57.765	57.49	57.74	1652476.0
2017-01-12	AAXN-DELISTED	Stock	24.5	24.685	23.48	24.28	1056018.0
2017-01-12	AB	Stock	23.0	23.5	22.7	23.45	190300.0
2017-01-12	ABAC-DELISTED	Stock	3.4599	3.75	3.38	3.75	34934.0
2017-01-12	ABAX-DELISTED	Stock	49.82	49.82	47.9	49.47	146982.0
2017-01-12	ABB-DELISTED	Stock	22.29	22.325	22.1528	22.26	2716317.0
2017-01-12	ABBNY-DELISTED	Stock	22.29	22.325	22.1528	22.26	3055113.0
2017-01-12	ABBV	Stock	60.77	61.43	60.42	61.28	8194400.0
2017-01-12	ABC-DELISTED	Stock	82.34	84.94	81.95	83.82	2354090.0
2017-01-12	ABCB	Stock	44.3	44.3	42.7	43.25	96100.0
2017-01-12	ABCD-DELISTED	Stock	5.23	5.25	4.965	5.24	59388.0
2017-01-12	ABCO-DELISTED	Stock	39.75	42.35	39.45	42.0	2546929.0
2017-01-12	ABDC-DELISTED	Stock	12.45	12.45	12.15	12.37	21074.0
2017-01-12	ABE-DELISTED	Stock	11.55	11.55	11.47	11.5	10986.0
2017-01-12	ABEO	Stock	133.75	135.0	126.25	133.75	9144.0
2017-01-12	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	200.0
2017-01-12	ABEV	Stock	5.24	5.32	5.21	5.25	22514300.0
2017-01-12	ABG	Stock	63.2	63.75	62.2	63.65	156500.0
2017-01-12	ABIL-DELISTED	Stock	3.34	3.35	3.3099	3.33	5000.0
2017-01-12	ABM	Stock	39.98	40.17	39.4	39.77	217600.0
2017-01-12	ABMD-DELISTED	Stock	110.99	112.5	110.205	112.41	229525.0

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

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