PREVIEW / stock_daily / 2018-07-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-13.parquet
  size:    217 KB
  rows:    6,483
  symbols: 2,759

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-13	AAPL	Stock	47.77	47.96	47.725	47.8325	50055600.0
2018-07-13	MSFT	Stock	104.37	105.6	104.09	105.43	24635200.0
2018-07-13	NVDA	Stock	6.2995	6.2995	6.1905	6.233	246988000.0
2018-07-13	AMZN	Stock	90.1965	90.765	89.7615	90.6515	87664000.0
2018-07-13	GOOGL	Stock	60.14	60.522	59.7645	60.221	32637140.0
2018-07-13	META	Stock	207.81	208.43	206.45	207.32	11486800.0
2018-07-13	TSLA	Stock	21.0387	21.3053	20.6167	21.258	88047000.0
2018-07-13	TLT	Stock	122.61	122.87	122.47	122.72	4078970.0
2018-07-13	ES	Stock	59.14	59.48	58.81	59.14	1793600.0
2018-07-13	CL	Stock	65.24	65.81	65.19	65.75	2684800.0
2018-07-13	A	Stock	63.52	63.83	63.21	63.38	963700.0
2018-07-13	AA	Stock	47.68	47.85	47.02	47.26	1350400.0
2018-07-13	AABA-DELISTED	Stock	75.18	75.25	74.14	74.46	5266742.0
2018-07-13	AAC-DELISTED	Stock	10.45	10.495	10.0	10.01	88689.0
2018-07-13	AACG	Stock	4.5	4.5	4.5	4.5	300.0
2018-07-13	AAIC-DELISTED	Stock	10.24	10.3	10.205	10.21	243458.0
2018-07-13	AAL	Stock	36.31	37.26	36.14	37.12	10829800.0
2018-07-13	AAM.A-DELISTED	Stock	25.7	25.78	25.7	25.78	11892.0
2018-07-13	AAM.B-DELISTED	Stock	25.04	25.1	25.01	25.05	90673.0
2018-07-13	AAMC-DELISTED	Stock	18.9559	19.6176	18.7941	19.4118	6630.0
2018-07-13	AAME	Stock	2.4	2.4	2.35	2.39	1100.0
2018-07-13	AAMI	Stock	13.63	13.915	13.59	13.61	608100.0
2018-07-13	AAOI	Stock	48.84	50.3	46.65	47.78	1857000.0
2018-07-13	AAON	Stock	23.5667	24.0667	23.5667	23.8333	147600.0
2018-07-13	AAP	Stock	139.3	141.7	138.92	139.34	835000.0
2018-07-13	AAT	Stock	38.52	38.68	38.14	38.17	192400.0
2018-07-13	AAU-DELISTED	Stock	0.711	0.7228	0.71	0.7133	88685.0
2018-07-13	AAUAF-DELISTED	Stock	0.711	0.7228	0.71	0.7133	92348.0
2018-07-13	AAV-DELISTED	Stock	3.2	3.275	3.155	3.225	30828.0
2018-07-13	AAWW-DELISTED	Stock	69.3	71.45	68.655	70.525	172397.0
2018-07-13	AAXJ	Stock	71.93	72.08	71.67	71.97	374124.0
2018-07-13	AAXN-DELISTED	Stock	69.08	70.425	67.43	67.77	548676.0
2018-07-13	AB	Stock	28.8	29.3	28.8	29.05	145300.0
2018-07-13	ABAC-DELISTED	Stock	2.39	2.39	2.3	2.35	2000.0
2018-07-13	ABAX-DELISTED	Stock	83.27	83.36	83.23	83.26	100824.0
2018-07-13	ABB-DELISTED	Stock	21.55	21.69	21.54	21.63	1992597.0
2018-07-13	ABBNY-DELISTED	Stock	21.55	21.69	21.54	21.63	2055341.0
2018-07-13	ABBV	Stock	94.96	96.86	94.94	96.63	3712400.0
2018-07-13	ABC-DELISTED	Stock	86.97	88.67	86.46	87.91	1028353.0
2018-07-13	ABCB	Stock	51.95	52.1	51.0	51.25	462100.0
2018-07-13	ABCD-DELISTED	Stock	11.84	12.05	11.6501	11.68	83951.0
2018-07-13	ABDC-DELISTED	Stock	6.07	6.18	6.03	6.11	49797.0
2018-07-13	ABEO	Stock	382.5	388.75	363.75	368.75	22916.0
2018-07-13	ABEV	Stock	4.72	4.81	4.68	4.81	24141700.0
2018-07-13	ABG	Stock	67.7	68.55	67.15	67.35	353400.0
2018-07-13	ABIL-DELISTED	Stock	7.35	7.77	7.04	7.1	174971.0
2018-07-13	ABM	Stock	31.0	31.68	31.0	31.38	657700.0
2018-07-13	ABMD-DELISTED	Stock	416.23	421.11	413.8735	418.65	354997.0
2018-07-13	ABR	Stock	10.95	10.96	10.86	10.89	884300.0
2018-07-13	ABR.A-DELISTED	Stock	26.08	26.08	26.08	26.08	200.0

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

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