PREVIEW / stock_daily / 2018-01-22

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-22.parquet
  size:    217 KB
  rows:    6,488
  symbols: 2,856

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-01-22	AAPL	Stock	44.325	44.445	44.15	44.25	108434400.0
2018-01-22	MSFT	Stock	90.0	91.62	89.74	91.61	23601600.0
2018-01-22	NVDA	Stock	5.7608	5.844	5.7025	5.8422	550944000.0
2018-01-22	AMZN	Stock	64.8585	66.3725	64.833	66.3655	82802000.0
2018-01-22	GOOGL	Stock	57.191	58.344	57.091	58.208	29550400.0
2018-01-22	META	Stock	180.8	185.39	180.41	185.37	21059500.0
2018-01-22	TSLA	Stock	23.2933	23.8553	23.28	23.4373	93156000.0
2018-01-22	TLT	Stock	123.45	123.71	122.99	123.18	8985125.0
2018-01-22	ES	Stock	61.12	61.34	60.61	60.76	2493400.0
2018-01-22	CL	Stock	76.87	77.55	76.64	77.38	2824700.0
2018-01-22	A	Stock	73.17	73.55	72.6	73.48	1963700.0
2018-01-22	AA	Stock	52.8	53.9	52.261	52.94	4220800.0
2018-01-22	AAAP-DELISTED	Stock	81.99	82.74	81.99	82.32	9709.0
2018-01-22	AABA-DELISTED	Stock	74.6	74.6	73.58	74.14	4400622.0
2018-01-22	AAC-DELISTED	Stock	9.2	9.2	8.94	9.08	126411.0
2018-01-22	AACG	Stock	5.63	5.63	5.48	5.58	1000.0
2018-01-22	AAIC-DELISTED	Stock	11.75	11.7801	11.69	11.73	348959.0
2018-01-22	AAL	Stock	57.99	58.34	57.53	58.1	3553900.0
2018-01-22	AAM.A-DELISTED	Stock	25.5804	25.71	25.48	25.661	17321.0
2018-01-22	AAMC-DELISTED	Stock	20.4118	20.4559	19.4648	19.4648	3733.0
2018-01-22	AAME	Stock	3.49	3.5	3.49	3.5	3100.0
2018-01-22	AAMI	Stock	18.44	18.62	18.33	18.46	369400.0
2018-01-22	AAOI	Stock	34.98	35.44	34.1	34.5	785900.0
2018-01-22	AAON	Stock	24.8	24.8	24.1	24.2333	180150.0
2018-01-22	AAP	Stock	116.88	118.19	115.9	118.03	1612100.0
2018-01-22	AAT	Stock	36.22	36.45	35.71	36.3	151000.0
2018-01-22	AAU-DELISTED	Stock	0.92	0.9277	0.9	0.9089	181319.0
2018-01-22	AAUAF-DELISTED	Stock	0.92	0.9277	0.9	0.9038	191347.0
2018-01-22	AAV-DELISTED	Stock	3.45	3.55	3.4	3.475	274512.0
2018-01-22	AAWW-DELISTED	Stock	62.0	62.9	61.3	62.65	88928.0
2018-01-22	AAXJ	Stock	81.2	81.71	81.07	81.71	1042129.0
2018-01-22	AAXN-DELISTED	Stock	27.48	27.48	27.07	27.47	376644.0
2018-01-22	AB	Stock	27.4	27.55	27.05	27.45	163200.0
2018-01-22	ABAC-DELISTED	Stock	2.99	2.99	2.81	2.9	9151.0
2018-01-22	ABAX-DELISTED	Stock	61.56	62.94	61.38	62.78	134675.0
2018-01-22	ABB-DELISTED	Stock	28.07	28.07	27.9	28.05	1266884.0
2018-01-22	ABBNY-DELISTED	Stock	28.07	28.07	27.9	28.04	1825707.0
2018-01-22	ABBV	Stock	104.7	106.54	104.46	106.49	4538100.0
2018-01-22	ABC-DELISTED	Stock	100.28	102.73	99.66	102.67	1001633.0
2018-01-22	ABCB	Stock	53.95	53.95	53.4	53.8	92000.0
2018-01-22	ABCD-DELISTED	Stock	6.91	7.16	6.77	6.92	224591.0
2018-01-22	ABDC-DELISTED	Stock	8.32	8.35	8.15	8.27	66815.0
2018-01-22	ABE-DELISTED	Stock	15.15	15.51	15.15	15.41	22949.0
2018-01-22	ABEO	Stock	367.5	372.5	355.0	371.25	38624.0
2018-01-22	ABEOW-DELISTED	Stock	9.4	9.4	9.3721	9.3721	200.0
2018-01-22	ABEV	Stock	6.81	6.82	6.76	6.8	12528900.0
2018-01-22	ABG	Stock	73.8	75.1	73.6	75.05	168300.0
2018-01-22	ABIL-DELISTED	Stock	0.4875	0.5497	0.4859	0.5293	469795.0
2018-01-22	ABLX-DELISTED	Stock	42.9	44.895	42.72	43.9865	538738.0
2018-01-22	ABM	Stock	39.8	39.89	39.27	39.5	369300.0

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

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