PREVIEW / stock_daily / 2018-07-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-19.parquet
  size:    218 KB
  rows:    6,498
  symbols: 2,773

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-07-19	AAPL	Stock	47.4225	48.1375	47.4225	47.97	81147200.0
2018-07-19	MSFT	Stock	104.93	105.31	103.89	104.4	40171600.0
2018-07-19	NVDA	Stock	6.2735	6.3348	6.2582	6.3008	235752000.0
2018-07-19	AMZN	Stock	91.473	92.05	90.5635	90.6485	93538000.0
2018-07-19	GOOGL	Stock	60.3325	60.824	59.8867	59.955	38337840.0
2018-07-19	META	Stock	208.77	209.99	207.76	208.09	11350400.0
2018-07-19	TSLA	Stock	21.0887	21.5693	20.934	21.3487	88729500.0
2018-07-19	TLT	Stock	121.8	122.45	121.77	122.26	6166739.0
2018-07-19	ES	Stock	58.79	59.39	58.66	59.16	1674600.0
2018-07-19	CL	Stock	65.35	66.05	64.8	65.75	4346100.0
2018-07-19	A	Stock	63.61	64.65	63.4	64.15	1726700.0
2018-07-19	AA	Stock	45.75	46.3	41.025	41.56	19926800.0
2018-07-19	AABA-DELISTED	Stock	74.14	74.29	73.14	73.36	4807084.0
2018-07-19	AAC-DELISTED	Stock	9.57	9.67	9.46	9.61	105976.0
2018-07-19	AACG	Stock	4.6	4.6	4.45	4.45	3800.0
2018-07-19	AAIC-DELISTED	Stock	10.23	10.369	10.23	10.3	307619.0
2018-07-19	AAL	Stock	38.32	38.38	37.55	38.13	4985200.0
2018-07-19	AAM.A-DELISTED	Stock	25.521	25.64	25.46	25.5	38426.0
2018-07-19	AAM.B-DELISTED	Stock	24.921	25.02	24.9	25.0	51026.0
2018-07-19	AAMC-DELISTED	Stock	19.2647	20.0015	18.1441	19.0206	24198.0
2018-07-19	AAME	Stock	2.55	2.55	2.55	2.55	200.0
2018-07-19	AAMI	Stock	13.98	14.06	13.905	13.94	402600.0
2018-07-19	AAOI	Stock	42.5	43.93	42.13	42.5	1171500.0
2018-07-19	AAON	Stock	23.9667	24.6867	23.8333	24.4333	293550.0
2018-07-19	AAP	Stock	139.85	143.7	139.44	143.37	1123700.0
2018-07-19	AAT	Stock	37.36	38.32	37.34	38.21	211500.0
2018-07-19	AAU-DELISTED	Stock	0.685	0.689	0.67	0.6734	105299.0
2018-07-19	AAUAF-DELISTED	Stock	0.685	0.689	0.67	0.6734	109270.0
2018-07-19	AAV-DELISTED	Stock	3.2	3.2	3.11	3.175	70483.0
2018-07-19	AAWW-DELISTED	Stock	70.45	70.45	69.05	69.25	289413.0
2018-07-19	AAXJ	Stock	71.02	71.37	70.76	71.0	1297506.0
2018-07-19	AAXN-DELISTED	Stock	71.46	73.3399	71.45	73.09	739431.0
2018-07-19	AB	Stock	29.8	30.08	29.8	30.0	195300.0
2018-07-19	ABAC-DELISTED	Stock	2.27	2.5507	2.27	2.5507	51608.0
2018-07-19	ABAX-DELISTED	Stock	83.28	83.3	83.25	83.28	132589.0
2018-07-19	ABB-DELISTED	Stock	22.78	22.81	22.48	22.6	3024796.0
2018-07-19	ABBNY-DELISTED	Stock	22.78	22.81	22.48	22.6	3132645.0
2018-07-19	ABBV	Stock	93.22	93.28	87.76	89.95	19747200.0
2018-07-19	ABC-DELISTED	Stock	86.26	86.38	83.51	85.56	1919041.0
2018-07-19	ABCB	Stock	51.55	51.75	51.1	51.7	247600.0
2018-07-19	ABCD-DELISTED	Stock	11.9	12.17	11.8444	12.09	108939.0
2018-07-19	ABDC-DELISTED	Stock	6.31	6.345	6.2	6.31	26812.0
2018-07-19	ABEO	Stock	348.75	358.75	346.25	355.0	22388.0
2018-07-19	ABEV	Stock	4.76	4.88	4.75	4.86	33230600.0
2018-07-19	ABG	Stock	69.6	70.3	68.95	69.4	135800.0
2018-07-19	ABIL-DELISTED	Stock	5.28	5.65	5.1	5.27	111633.0
2018-07-19	ABM	Stock	29.54	30.12	29.31	30.02	456200.0
2018-07-19	ABMD-DELISTED	Stock	431.94	433.56	425.3334	425.81	383062.0
2018-07-19	ABR	Stock	11.21	11.26	11.14	11.21	1391500.0
2018-07-19	ABR.A-DELISTED	Stock	26.11	26.11	26.11	26.11	1100.0

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

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