PREVIEW / stock_daily / 2018-06-22

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-22.parquet
  size:    220 KB
  rows:    6,502
  symbols: 2,784

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-22	AAPL	Stock	46.53	46.5375	46.175	46.23	108801600.0
2018-06-22	MSFT	Stock	100.41	100.77	99.63	100.41	38923100.0
2018-06-22	NVDA	Stock	6.4488	6.4623	6.2582	6.2738	434160000.0
2018-06-22	AMZN	Stock	87.131	87.15	85.595	85.7835	81502000.0
2018-06-22	GOOGL	Stock	58.5748	58.75	57.9825	58.4645	34220060.0
2018-06-22	META	Stock	201.16	202.24	199.31	201.74	17420200.0
2018-06-22	TSLA	Stock	23.436	23.4833	22.1333	22.242	153991500.0
2018-06-22	TLT	Stock	120.09	120.62	120.06	120.53	4082473.0
2018-06-22	ES	Stock	56.58	56.73	55.88	56.03	2449300.0
2018-06-22	CL	Stock	63.55	64.78	63.51	64.63	4871600.0
2018-06-22	A	Stock	63.58	63.69	62.73	62.79	2893800.0
2018-06-22	AA	Stock	45.45	45.78	45.26	45.56	3339700.0
2018-06-22	AABA-DELISTED	Stock	79.94	80.17	78.87	79.46	7209653.0
2018-06-22	AAC-DELISTED	Stock	10.27	10.28	9.86	10.08	309335.0
2018-06-22	AACG	Stock	4.83	5.19	4.7	5.19	3500.0
2018-06-22	AAIC-DELISTED	Stock	10.98	10.98	10.77	10.94	1173455.0
2018-06-22	AAL	Stock	41.46	42.41	41.02	41.35	9115100.0
2018-06-22	AAM.A-DELISTED	Stock	25.1845	25.31	25.18	25.31	6076.0
2018-06-22	AAM.B-DELISTED	Stock	24.62	24.77	24.601	24.72	86227.0
2018-06-22	AAMC-DELISTED	Stock	21.4706	21.4706	19.8824	20.5294	42789.0
2018-06-22	AAME	Stock	2.6	2.6	2.6	2.6	1100.0
2018-06-22	AAMI	Stock	15.23	15.4	15.085	15.17	1731000.0
2018-06-22	AAOI	Stock	43.19	44.28	41.809	43.75	1154100.0
2018-06-22	AAON	Stock	22.4333	22.6	21.9	22.0667	433200.0
2018-06-22	AAP	Stock	143.42	143.42	137.81	138.85	1377800.0
2018-06-22	AAT	Stock	38.04	38.53	38.03	38.38	442300.0
2018-06-22	AAU-DELISTED	Stock	0.722	0.7448	0.72	0.7423	129276.0
2018-06-22	AAUAF-DELISTED	Stock	0.722	0.7448	0.72	0.7423	133345.0
2018-06-22	AAV-DELISTED	Stock	3.1	3.15	3.05	3.1	109199.0
2018-06-22	AAWW-DELISTED	Stock	74.55	74.6	72.05	73.55	382118.0
2018-06-22	AAXJ	Stock	73.45	73.45	73.03	73.12	679207.0
2018-06-22	AAXN-DELISTED	Stock	67.13	68.15	66.29	67.65	724694.0
2018-06-22	AB	Stock	29.05	29.2	28.9	29.15	185500.0
2018-06-22	ABAC-DELISTED	Stock	2.25	2.37	2.18	2.21	8802.0
2018-06-22	ABAX-DELISTED	Stock	83.0	83.23	82.865	83.22	469178.0
2018-06-22	ABB-DELISTED	Stock	22.37	22.51	22.31	22.47	1030469.0
2018-06-22	ABBNY-DELISTED	Stock	22.39	22.51	22.31	22.47	1082853.0
2018-06-22	ABBV	Stock	96.06	96.11	93.43	93.49	9454800.0
2018-06-22	ABC-DELISTED	Stock	93.35	94.34	92.87	93.5	889079.0
2018-06-22	ABCB	Stock	57.45	57.5	56.35	56.7	789500.0
2018-06-22	ABCD-DELISTED	Stock	10.9	11.08	10.78	11.07	231889.0
2018-06-22	ABDC-DELISTED	Stock	6.85	6.85	6.6	6.6	86575.0
2018-06-22	ABEO	Stock	395.0	410.0	390.0	410.0	70864.0
2018-06-22	ABEV	Stock	4.89	4.93	4.79	4.81	21078300.0
2018-06-22	ABG	Stock	76.15	76.2	74.18	74.8	398800.0
2018-06-22	ABIL-DELISTED	Stock	5.99	6.68	3.96	4.99	7976858.0
2018-06-22	ABM	Stock	30.57	30.73	30.19	30.48	2040300.0
2018-06-22	ABMD-DELISTED	Stock	443.15	444.07	426.99	427.37	728803.0
2018-06-22	ABR	Stock	10.1	10.15	9.96	10.02	5613800.0
2018-06-22	ABR.A-DELISTED	Stock	25.944	25.944	25.7701	25.9202	2203.0

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

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