PREVIEW / stock_daily / 2020-06-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-08.parquet
  size:    222 KB
  rows:    6,681
  symbols: 2,372

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
2020-06-08	AAPL	Stock	82.5625	83.4	81.83	83.365	95654400.0
2020-06-08	MSFT	Stock	185.94	188.55	184.44	188.36	33211600.0
2020-06-08	NVDA	Stock	8.8772	8.8898	8.6858	8.805	387736000.0
2020-06-08	AMZN	Stock	125.01	126.5	124.367	126.203	79414000.0
2020-06-08	GOOGL	Stock	71.314	72.45	71.224	72.402	33877620.0
2020-06-08	META	Stock	229.03	231.55	227.41	231.4	15466500.0
2020-06-08	TSLA	Stock	61.2667	63.3333	60.6107	63.328	212620500.0
2020-06-08	TLT	Stock	155.07	156.85	155.05	156.71	10346680.0
2020-06-08	ES	Stock	86.41	87.98	85.53	87.76	1456200.0
2020-06-08	CL	Stock	71.94	73.54	71.76	73.51	5033300.0
2020-06-08	A	Stock	89.31	90.59	89.06	90.29	1804700.0
2020-06-08	AA	Stock	12.7	13.04	12.3	12.98	11247200.0
2020-06-08	AACG	Stock	0.9	0.93	0.82	0.89	32600.0
2020-06-08	AAIC-DELISTED	Stock	3.42	3.665	3.22	3.62	1459574.0
2020-06-08	AAIC.C-DELISTED	Stock	20.02	20.39	20.0	20.2	3118.0
2020-06-08	AAL	Stock	19.86	20.36	19.13	20.31	175418900.0
2020-06-08	AAM.A-DELISTED	Stock	26.04	26.17	25.98	26.01	21081.0
2020-06-08	AAM.B-DELISTED	Stock	26.394	26.394	26.11	26.2	15280.0
2020-06-08	AAMC-DELISTED	Stock	5.2647	5.7441	5.2647	5.3632	27904.0
2020-06-08	AAME	Stock	1.83	1.85	1.82	1.85	5000.0
2020-06-08	AAMI	Stock	9.92	10.031	9.69	9.89	388400.0
2020-06-08	AAOI	Stock	10.06	10.26	9.885	10.24	647500.0
2020-06-08	AAON	Stock	38.9733	39.5667	38.4667	38.5467	424350.0
2020-06-08	AAP	Stock	146.28	149.24	145.08	146.35	920500.0
2020-06-08	AAT	Stock	33.77	34.87	33.35	34.85	442800.0
2020-06-08	AAU-DELISTED	Stock	0.4999	0.5	0.4701	0.49	331925.0
2020-06-08	AAUAF-DELISTED	Stock	0.4999	0.5	0.4701	0.49	381417.0
2020-06-08	AAWW-DELISTED	Stock	44.4	44.77	40.31	40.55	1008237.0
2020-06-08	AAXJ	Stock	69.66	70.03	69.22	70.02	1180919.0
2020-06-08	AAXN-DELISTED	Stock	96.57	98.58	94.2	97.27	1000734.0
2020-06-08	AB	Stock	27.02	27.18	26.24	26.68	477700.0
2020-06-08	ABB-DELISTED	Stock	21.75	21.94	21.68	21.94	1401726.0
2020-06-08	ABBNY-DELISTED	Stock	21.74	21.94	21.68	21.94	1496454.0
2020-06-08	ABBV	Stock	92.91	95.01	92.81	94.59	6621400.0
2020-06-08	ABC-DELISTED	Stock	97.99	102.99	97.76	102.33	1088815.0
2020-06-08	ABCB	Stock	29.58	29.82	28.7	29.63	339100.0
2020-06-08	ABEO	Stock	74.25	77.25	72.75	75.25	33628.0
2020-06-08	ABEV	Stock	2.94	3.02	2.91	3.0	54865300.0
2020-06-08	ABG	Stock	83.08	86.12	81.96	82.61	554000.0
2020-06-08	ABM	Stock	36.72	37.22	36.4	36.75	392400.0
2020-06-08	ABMD-DELISTED	Stock	250.0	257.93	246.91	253.23	497486.0
2020-06-08	ABR	Stock	10.35	11.02	10.18	11.0	4197500.0
2020-06-08	ABR.A-DELISTED	Stock	24.8198	25.3	24.8198	25.3	25661.0
2020-06-08	ABR.B-DELISTED	Stock	24.5	24.76	24.5	24.7499	1776.0
2020-06-08	ABR.C-DELISTED	Stock	26.4733	26.4733	25.61	25.951	6583.0
2020-06-08	ABT	Stock	88.98	92.61	88.91	92.56	5426800.0
2020-06-08	ABTC	Stock	279600.0	344700.0	276450.0	325200.0	13.799999999999999
2020-06-08	ABTS	Stock	12.135	12.75	10.8	12.75	2987.0
2020-06-08	ABTX-DELISTED	Stock	29.88	30.25	29.24	29.39	62476.0
2020-06-08	ABUS	Stock	2.09	2.09	2.0	2.05	1194600.0

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

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