PREVIEW / stock_daily / 2017-12-04

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-04.parquet
  size:    217 KB
  rows:    6,504
  symbols: 2,903

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-04	AAPL	Stock	43.12	43.155	42.4075	42.45	130169600.0
2017-12-04	MSFT	Stock	84.42	84.43	80.7	81.08	39094900.0
2017-12-04	NVDA	Stock	5.0013	5.0075	4.6125	4.6665	1240844000.0
2017-12-04	AMZN	Stock	58.6925	58.76	56.4	56.6975	118638000.0
2017-12-04	GOOGL	Stock	51.39	51.567	50.461	50.5935	38777220.0
2017-12-04	META	Stock	176.29	176.57	170.79	171.47	24459400.0
2017-12-04	TSLA	Stock	20.4333	20.5513	20.0407	20.3467	87526500.0
2017-12-04	TLT	Stock	125.92	126.67	125.81	126.61	9609316.0
2017-12-04	ES	Stock	65.53	66.11	65.32	65.48	2108900.0
2017-12-04	CL	Stock	73.09	74.63	72.95	74.52	3615800.0
2017-12-04	A	Stock	68.94	69.17	66.18	66.24	2899400.0
2017-12-04	AA	Stock	41.87	42.6	41.5	41.79	2709800.0
2017-12-04	AAAP-DELISTED	Stock	81.25	81.75	81.24	81.275	315976.0
2017-12-04	AABA-DELISTED	Stock	71.06	71.34	68.16	68.3	14183951.0
2017-12-04	AAC-DELISTED	Stock	9.08	9.11	8.8	8.83	130031.0
2017-12-04	AACG	Stock	5.0	5.16	5.0	5.07	24100.0
2017-12-04	AAIC-DELISTED	Stock	11.79	12.01	11.79	11.94	519855.0
2017-12-04	AAL	Stock	50.1	51.47	49.65	49.93	7113800.0
2017-12-04	AAM.A-DELISTED	Stock	25.99	26.22	25.9668	26.16	68269.0
2017-12-04	AAMC-DELISTED	Stock	21.6176	21.6176	20.6176	21.4559	8942.0
2017-12-04	AAME	Stock	3.5	3.6	3.3	3.6	1600.0
2017-12-04	AAMI	Stock	16.7	16.74	16.385	16.41	300500.0
2017-12-04	AAOI	Stock	43.47	44.05	41.53	44.05	1098800.0
2017-12-04	AAON	Stock	24.5	25.2333	24.4	24.9667	381150.0
2017-12-04	AAP	Stock	100.94	105.2	100.76	104.02	2225100.0
2017-12-04	AAT	Stock	39.38	39.99	39.37	39.54	331200.0
2017-12-04	AAU-DELISTED	Stock	0.869	0.89	0.8643	0.8644	161660.0
2017-12-04	AAUAF-DELISTED	Stock	0.869	0.89	0.861	0.861	178446.0
2017-12-04	AAV-DELISTED	Stock	4.7	4.81	4.7	4.75	95437.0
2017-12-04	AAWW-DELISTED	Stock	59.85	60.9	57.75	57.95	349226.0
2017-12-04	AAXJ	Stock	75.81	75.97	74.9507	75.0	1450060.0
2017-12-04	AAXN-DELISTED	Stock	24.64	24.879	24.06	24.08	693796.0
2017-12-04	AB	Stock	25.05	25.4	25.05	25.3	209300.0
2017-12-04	ABAC-DELISTED	Stock	2.81	2.8899	2.66	2.8	20016.0
2017-12-04	ABAX-DELISTED	Stock	48.43	48.89	47.48	47.48	130994.0
2017-12-04	ABB-DELISTED	Stock	25.93	25.97	25.72	25.725	2263627.0
2017-12-04	ABBNY-DELISTED	Stock	25.93	25.97	25.72	25.73	2311878.0
2017-12-04	ABBV	Stock	96.37	96.65	94.65	95.22	4934400.0
2017-12-04	ABC-DELISTED	Stock	85.73	88.2	85.44	87.43	1842267.0
2017-12-04	ABCB	Stock	50.6	51.15	49.85	50.1	255400.0
2017-12-04	ABCD-DELISTED	Stock	5.7	5.91	5.6	5.6	57590.0
2017-12-04	ABDC-DELISTED	Stock	8.44	8.45	8.249	8.33	84821.0
2017-12-04	ABE-DELISTED	Stock	14.15	14.1769	14.11	14.11	11597.0
2017-12-04	ABEO	Stock	417.5	421.25	381.25	382.5	29488.0
2017-12-04	ABEOW-DELISTED	Stock	11.11	11.11	10.75	11.0	900.0
2017-12-04	ABEV	Stock	6.25	6.34	6.23	6.28	10245200.0
2017-12-04	ABG	Stock	66.75	68.15	66.75	67.65	299800.0
2017-12-04	ABIL-DELISTED	Stock	0.46	0.505	0.46	0.505	106086.0
2017-12-04	ABLX-DELISTED	Stock	23.47	23.49	23.08	23.35	122634.0
2017-12-04	ABM	Stock	43.14	44.65	43.11	44.01	354200.0

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

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