PREVIEW / stock_daily / 2018-10-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-23.parquet
  size:    222 KB
  rows:    6,565
  symbols: 2,744

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-10-23	AAPL	Stock	53.9575	55.8125	53.675	55.6825	155071200.0
2018-10-23	MSFT	Stock	107.77	108.97	105.11	108.1	43770400.0
2018-10-23	NVDA	Stock	5.5108	5.6048	5.4178	5.5265	626436000.0
2018-10-23	AMZN	Stock	87.112	88.817	85.7	88.435	134478000.0
2018-10-23	GOOGL	Stock	54.5645	55.9	53.9505	55.7455	37685100.0
2018-10-23	META	Stock	151.22	154.77	150.85	154.39	19095000.0
2018-10-23	TSLA	Stock	17.5913	19.862	17.4733	19.6093	285417000.0
2018-10-23	TLT	Stock	114.76	115.02	113.84	113.92	10330735.0
2018-10-23	ES	Stock	63.35	63.81	62.85	63.3	1542000.0
2018-10-23	CL	Stock	63.24	63.72	62.76	63.4	3766000.0
2018-10-23	A	Stock	62.82	63.13	61.38	62.73	4219800.0
2018-10-23	AA	Stock	38.87	38.97	37.07	37.32	3192900.0
2018-10-23	AABA-DELISTED	Stock	60.35	61.72	59.95	61.33	4437780.0
2018-10-23	AAC-DELISTED	Stock	6.98	7.0156	6.75	6.85	94605.0
2018-10-23	AACG	Stock	1.08	1.28	1.06	1.07	208100.0
2018-10-23	AAIC-DELISTED	Stock	8.33	8.38	8.19	8.33	372841.0
2018-10-23	AAL	Stock	31.53	32.44	30.6	32.38	12468300.0
2018-10-23	AAM.A-DELISTED	Stock	24.0514	24.39	24.0514	24.17	66562.0
2018-10-23	AAM.B-DELISTED	Stock	24.06	24.25	23.99	24.09	72651.0
2018-10-23	AAME	Stock	2.79	2.9	2.67	2.75	2900.0
2018-10-23	AAMI	Stock	11.59	11.75	11.44	11.67	455500.0
2018-10-23	AAOI	Stock	21.86	22.56	21.454	22.25	685500.0
2018-10-23	AAON	Stock	21.2667	21.7333	21.04	21.58	151650.0
2018-10-23	AAP	Stock	162.44	165.14	161.39	163.97	1037800.0
2018-10-23	AAT	Stock	36.08	36.77	35.92	36.48	75800.0
2018-10-23	AAU-DELISTED	Stock	0.565	0.5744	0.54	0.5647	162650.0
2018-10-23	AAUAF-DELISTED	Stock	0.565	0.5744	0.54	0.547	168355.0
2018-10-23	AAWW-DELISTED	Stock	51.55	51.83	50.42	51.27	204830.0
2018-10-23	AAXJ	Stock	62.92	64.17	62.72	63.81	913064.0
2018-10-23	AAXN-DELISTED	Stock	56.34	58.45	55.7301	58.01	475288.0
2018-10-23	AB	Stock	29.39	29.99	28.84	29.65	312600.0
2018-10-23	ABAC-DELISTED	Stock	1.78	1.81	1.66	1.8	15481.0
2018-10-23	ABB-DELISTED	Stock	20.57	20.85	20.5	20.78	1968507.0
2018-10-23	ABBNY-DELISTED	Stock	20.57	20.85	20.5	20.78	2138296.0
2018-10-23	ABBV	Stock	82.58	84.59	81.5	82.96	8096200.0
2018-10-23	ABC-DELISTED	Stock	88.95	90.74	87.49	90.27	767649.0
2018-10-23	ABCB	Stock	41.65	42.44	41.37	41.98	307900.0
2018-10-23	ABCD-DELISTED	Stock	14.38	14.4	14.38	14.39	412925.0
2018-10-23	ABDC-DELISTED	Stock	5.94	5.95	5.72	5.88	74953.0
2018-10-23	ABEO	Stock	232.75	239.25	221.5	235.0	25172.0
2018-10-23	ABEV	Stock	4.45	4.51	4.4	4.46	38786700.0
2018-10-23	ABG	Stock	67.29	70.0	64.72	66.23	883900.0
2018-10-23	ABIL-DELISTED	Stock	3.17	3.57	3.0331	3.2101	199097.0
2018-10-23	ABM	Stock	31.25	31.3	30.64	30.76	371100.0
2018-10-23	ABMD-DELISTED	Stock	358.89	373.85	350.25	370.28	333335.0
2018-10-23	ABR	Stock	11.79	11.94	11.68	11.76	724000.0
2018-10-23	ABR.A-DELISTED	Stock	25.25	25.6011	25.25	25.55	6135.0
2018-10-23	ABR.B-DELISTED	Stock	25.2514	25.32	25.2514	25.32	550.0
2018-10-23	ABR.C-DELISTED	Stock	25.8614	25.8732	25.7507	25.7507	2465.0
2018-10-23	ABT	Stock	67.58	69.04	66.99	68.57	7446400.0

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

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