PREVIEW / stock_daily / 2018-02-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-26.parquet
  size:    217 KB
  rows:    6,492
  symbols: 2,863

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-02-26	AAPL	Stock	44.0875	44.8475	44.0525	44.7425	152648800.0
2018-02-26	MSFT	Stock	94.4	95.45	94.25	95.42	30199800.0
2018-02-26	NVDA	Stock	6.195	6.1995	6.1015	6.1645	469312000.0
2018-02-26	AMZN	Stock	75.46	76.142	75.35	76.0975	99100000.0
2018-02-26	GOOGL	Stock	56.593	57.21	56.467	57.185	30912380.0
2018-02-26	META	Stock	184.58	185.66	183.22	184.93	17599700.0
2018-02-26	TSLA	Stock	23.5667	23.9333	23.4907	23.828	65100000.0
2018-02-26	TLT	Stock	118.68	118.91	118.04	118.17	8771646.0
2018-02-26	ES	Stock	59.39	59.39	58.5	58.82	1699400.0
2018-02-26	CL	Stock	70.77	71.13	70.49	71.07	2844700.0
2018-02-26	A	Stock	71.0	71.21	70.01	70.58	5947400.0
2018-02-26	AA	Stock	47.42	47.58	46.14	46.68	3562000.0
2018-02-26	AABA-DELISTED	Stock	78.43	78.68	76.715	78.15	15414905.0
2018-02-26	AAC-DELISTED	Stock	9.5	10.43	9.39	9.57	496972.0
2018-02-26	AACG	Stock	5.37	5.4	5.33	5.33	4100.0
2018-02-26	AAIC-DELISTED	Stock	11.35	11.41	11.315	11.38	294557.0
2018-02-26	AAL	Stock	53.99	55.13	53.92	55.0	4962100.0
2018-02-26	AAM.A-DELISTED	Stock	25.57	25.65	25.5101	25.5765	89328.0
2018-02-26	AAME	Stock	3.6	3.6	3.6	3.6	300.0
2018-02-26	AAMI	Stock	15.7	15.84	15.56	15.77	546800.0
2018-02-26	AAOI	Stock	28.06	28.75	27.8	28.0	1360200.0
2018-02-26	AAON	Stock	23.6	23.9333	23.4333	23.8333	112950.0
2018-02-26	AAP	Stock	116.5	117.74	112.08	114.85	1409600.0
2018-02-26	AAT	Stock	33.0	33.03	32.65	32.94	350300.0
2018-02-26	AAU-DELISTED	Stock	0.91	0.91	0.89	0.8955	90277.0
2018-02-26	AAUAF-DELISTED	Stock	0.91	0.91	0.89	0.8971	94443.0
2018-02-26	AAV-DELISTED	Stock	3.0	3.05	2.95	2.975	230335.0
2018-02-26	AAWW-DELISTED	Stock	64.5	64.5	62.7	62.95	264960.0
2018-02-26	AAXJ	Stock	79.38	79.88	78.95	79.86	1130132.0
2018-02-26	AAXN-DELISTED	Stock	28.66	28.78	28.11	28.15	548747.0
2018-02-26	AB	Stock	27.25	27.3	26.65	27.0	364700.0
2018-02-26	ABAC-DELISTED	Stock	2.4332	2.5	2.4332	2.5	700.0
2018-02-26	ABAX-DELISTED	Stock	68.67	69.77	67.67	69.36	140568.0
2018-02-26	ABB-DELISTED	Stock	24.85	25.07	24.76	25.03	2019895.0
2018-02-26	ABBNY-DELISTED	Stock	24.85	25.07	24.76	25.02	2176229.0
2018-02-26	ABBV	Stock	119.27	121.72	119.04	121.54	4473500.0
2018-02-26	ABC-DELISTED	Stock	98.59	100.9586	74.81	100.59	1407836.0
2018-02-26	ABCB	Stock	54.85	55.15	54.25	55.1	176200.0
2018-02-26	ABCD-DELISTED	Stock	7.18	7.53	7.18	7.47	63922.0
2018-02-26	ABDC-DELISTED	Stock	7.5	7.57	7.485	7.5	41173.0
2018-02-26	ABE-DELISTED	Stock	15.29	15.31	15.12	15.17	27903.0
2018-02-26	ABEO	Stock	335.0	361.25	331.25	351.25	40100.0
2018-02-26	ABEOW-DELISTED	Stock	8.4	9.25	8.4	9.25	5100.0
2018-02-26	ABEV	Stock	6.69	6.83	6.67	6.82	12706700.0
2018-02-26	ABG	Stock	69.25	69.55	68.35	69.3	222100.0
2018-02-26	ABIL-DELISTED	Stock	0.402	0.5	0.3982	0.4502	1201781.0
2018-02-26	ABLX-DELISTED	Stock	54.06	54.06	53.75	53.91	175989.0
2018-02-26	ABM	Stock	36.77	37.13	36.46	37.11	431300.0
2018-02-26	ABMD-DELISTED	Stock	270.52	274.0	269.15	273.02	245284.0
2018-02-26	ABR	Stock	8.59	8.7	8.55	8.64	1497900.0

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

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