PREVIEW / stock_daily / 2018-02-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-05.parquet
  size:    218 KB
  rows:    6,533
  symbols: 2,886

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
2018-02-05	AAPL	Stock	39.775	40.97	39.0	39.1225	290954000.0
2018-02-05	MSFT	Stock	90.56	93.24	88.0	88.0	51031500.0
2018-02-05	NVDA	Stock	5.675	5.8308	5.125	5.3425	1165204000.0
2018-02-05	AMZN	Stock	70.131	72.949	66.036	69.5	229900000.0
2018-02-05	GOOGL	Stock	55.0305	55.7495	52.837	53.1195	83549380.0
2018-02-05	META	Stock	186.93	190.61	180.61	181.26	33128200.0
2018-02-05	TSLA	Stock	22.5313	22.9647	22.2	22.2087	66961500.0
2018-02-05	TLT	Stock	119.17	121.82	118.64	120.71	28606241.0
2018-02-05	ES	Stock	59.06	59.59	58.33	58.33	4104100.0
2018-02-05	CL	Stock	72.34	72.98	69.78	69.81	6278000.0
2018-02-05	A	Stock	70.86	71.48	68.18	68.22	2860700.0
2018-02-05	AA	Stock	48.61	50.75	47.8	48.46	3865500.0
2018-02-05	AAAP-DELISTED	Stock	80.66	81.55	80.64	81.25	38923.0
2018-02-05	AABA-DELISTED	Stock	72.9	75.38	71.59	72.57	9234415.0
2018-02-05	AAC-DELISTED	Stock	8.01	8.14	7.81	7.99	123531.0
2018-02-05	AACG	Stock	4.8	4.99	4.66	4.66	11000.0
2018-02-05	AAIC-DELISTED	Stock	10.2	10.31	9.92	10.05	1265667.0
2018-02-05	AAL	Stock	51.23	52.39	49.75	49.76	6878300.0
2018-02-05	AAM.A-DELISTED	Stock	25.0	25.57	25.0	25.54	68081.0
2018-02-05	AAME	Stock	3.5	3.5	3.3	3.3	8500.0
2018-02-05	AAMI	Stock	17.3	17.4	16.15	16.4	1665100.0
2018-02-05	AAOI	Stock	32.5	33.7	32.37	32.48	661200.0
2018-02-05	AAON	Stock	23.6	23.8	22.7	22.7333	289500.0
2018-02-05	AAP	Stock	113.05	114.97	109.81	109.86	1281600.0
2018-02-05	AAT	Stock	34.18	34.72	33.09	33.15	221900.0
2018-02-05	AAU-DELISTED	Stock	0.94	0.94	0.9	0.918	346069.0
2018-02-05	AAUAF-DELISTED	Stock	0.94	0.94	0.9	0.918	357185.0
2018-02-05	AAV-DELISTED	Stock	3.3	3.45	3.225	3.325	319334.0
2018-02-05	AAWW-DELISTED	Stock	54.5	55.2	52.325	52.7	264967.0
2018-02-05	AAXJ	Stock	78.65	79.47	76.29	76.37	5891798.0
2018-02-05	AAXN-DELISTED	Stock	25.74	25.99	24.84	25.03	558958.0
2018-02-05	AB	Stock	26.2	26.55	24.7	25.15	619800.0
2018-02-05	ABAC-DELISTED	Stock	2.83	2.8537	2.65	2.65	4718.0
2018-02-05	ABAX-DELISTED	Stock	68.99	69.49	66.08	66.99	439739.0
2018-02-05	ABB-DELISTED	Stock	26.9	26.98	26.12	26.13	2853666.0
2018-02-05	ABBNY-DELISTED	Stock	26.9	26.98	26.12	26.13	2987220.0
2018-02-05	ABBV	Stock	113.0	115.54	109.4	109.51	9827800.0
2018-02-05	ABC-DELISTED	Stock	95.62	96.52	91.69	91.75	1886835.0
2018-02-05	ABCB	Stock	53.7	54.35	51.85	51.85	146200.0
2018-02-05	ABCD-DELISTED	Stock	6.89	7.0	6.58	6.63	60011.0
2018-02-05	ABDC-DELISTED	Stock	7.75	7.78	7.56	7.56	121707.0
2018-02-05	ABE-DELISTED	Stock	15.05	15.15	14.9	14.9	7421.0
2018-02-05	ABEO	Stock	375.0	396.25	367.5	372.5	26052.0
2018-02-05	ABEOW-DELISTED	Stock	10.0	10.6	9.84	10.09	2848.0
2018-02-05	ABEV	Stock	6.71	6.76	6.54	6.58	22245200.0
2018-02-05	ABG	Stock	67.8	68.6	65.45	65.6	276900.0
2018-02-05	ABIL-DELISTED	Stock	0.4444	0.4444	0.41	0.412	90718.0
2018-02-05	ABLX-DELISTED	Stock	54.41	54.43	53.82	54.105	621824.0
2018-02-05	ABM	Stock	36.82	36.97	34.93	34.96	563600.0
2018-02-05	ABMD-DELISTED	Stock	245.0	245.0	236.51	239.37	692946.0

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

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