PREVIEW / stock_daily / 2018-06-15

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-15.parquet
  size:    219 KB
  rows:    6,499
  symbols: 2,779

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-06-15	AAPL	Stock	47.5075	47.54	47.065	47.21	246876800.0
2018-06-15	MSFT	Stock	101.51	101.53	100.07	100.13	65738600.0
2018-06-15	NVDA	Stock	6.615	6.687	6.5838	6.6315	432260000.0
2018-06-15	AMZN	Stock	85.7	86.0435	85.426	85.7985	95552000.0
2018-06-15	GOOGL	Stock	57.996	58.1954	57.6845	57.9635	44437820.0
2018-06-15	META	Stock	195.79	197.07	194.64	195.85	21860900.0
2018-06-15	TSLA	Stock	23.5893	24.3113	23.4167	23.878	162724500.0
2018-06-15	TLT	Stock	120.83	121.09	120.3	120.38	7992758.0
2018-06-15	ES	Stock	54.03	54.7	53.69	54.63	3192900.0
2018-06-15	CL	Stock	63.28	64.77	63.25	64.73	9744900.0
2018-06-15	A	Stock	66.11	66.24	65.19	66.13	4113200.0
2018-06-15	AA	Stock	47.4	47.4	45.03	45.34	4962400.0
2018-06-15	AABA-DELISTED	Stock	81.05	82.14	80.63	81.38	8047922.0
2018-06-15	AAC-DELISTED	Stock	9.81	10.02	9.475	9.99	255191.0
2018-06-15	AACG	Stock	5.11	5.11	5.11	5.11	200.0
2018-06-15	AAIC-DELISTED	Stock	10.94	11.16	10.76	10.9	2345941.0
2018-06-15	AAL	Stock	43.06	43.11	42.32	42.77	7032000.0
2018-06-15	AAM.A-DELISTED	Stock	25.55	25.55	25.449	25.45	45372.0
2018-06-15	AAM.B-DELISTED	Stock	24.87	24.87	24.77	24.82	74969.0
2018-06-15	AAMC-DELISTED	Stock	19.9706	21.2353	19.022	20.6471	25571.0
2018-06-15	AAME	Stock	2.7	2.75	2.5	2.5	9300.0
2018-06-15	AAMI	Stock	16.05	16.31	15.98	16.27	858800.0
2018-06-15	AAOI	Stock	43.56	44.22	43.0	43.38	873000.0
2018-06-15	AAON	Stock	22.0333	22.2333	21.7667	22.2	429600.0
2018-06-15	AAP	Stock	133.49	137.33	133.02	137.16	1652900.0
2018-06-15	AAT	Stock	37.32	37.77	37.32	37.44	375000.0
2018-06-15	AAU-DELISTED	Stock	0.75	0.75	0.7401	0.7448	95777.0
2018-06-15	AAUAF-DELISTED	Stock	0.75	0.75	0.7401	0.7448	98461.0
2018-06-15	AAV-DELISTED	Stock	3.05	3.1	3.0	3.05	127266.0
2018-06-15	AAWW-DELISTED	Stock	72.6	72.9	71.705	72.8	196511.0
2018-06-15	AAXJ	Stock	75.58	75.72	75.18	75.68	632026.0
2018-06-15	AAXN-DELISTED	Stock	63.26	64.53	61.57	64.39	1663167.0
2018-06-15	AB	Stock	29.15	29.4	29.0	29.1	289700.0
2018-06-15	ABAC-DELISTED	Stock	2.2817	2.2817	2.22	2.27	3404.0
2018-06-15	ABAX-DELISTED	Stock	83.06	83.35	83.05	83.27	174470.0
2018-06-15	ABB-DELISTED	Stock	23.08	23.09	22.95	23.03	1614984.0
2018-06-15	ABBNY-DELISTED	Stock	23.08	23.09	22.95	23.03	1676768.0
2018-06-15	ABBV	Stock	98.77	99.87	98.0	99.57	20806200.0
2018-06-15	ABC-DELISTED	Stock	92.9	94.88	92.0	94.85	1721621.0
2018-06-15	ABCB	Stock	56.4	56.85	55.5	56.35	1329900.0
2018-06-15	ABCD-DELISTED	Stock	10.66	10.9	10.5509	10.86	90188.0
2018-06-15	ABDC-DELISTED	Stock	6.79	6.901	6.68	6.81	31300.0
2018-06-15	ABEO	Stock	397.5	415.0	391.25	413.75	80452.0
2018-06-15	ABEV	Stock	5.0	5.02	4.91	4.98	43547900.0
2018-06-15	ABG	Stock	72.85	74.55	72.5	73.55	211500.0
2018-06-15	ABIL-DELISTED	Stock	2.36	2.43	2.33	2.33	2189.0
2018-06-15	ABM	Stock	30.97	31.3	30.72	31.25	990300.0
2018-06-15	ABMD-DELISTED	Stock	441.0	445.4497	435.48	443.58	599468.0
2018-06-15	ABR	Stock	10.01	10.02	9.91	9.94	3794100.0
2018-06-15	ABR.A-DELISTED	Stock	26.2323	26.2323	26.0	26.12	1500.0

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

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