PREVIEW / stock_daily / 2020-06-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-30.parquet
  size:    222 KB
  rows:    6,743
  symbols: 2,416

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-30	AAPL	Stock	90.02	91.495	90.0	91.2	140223200.0
2020-06-30	MSFT	Stock	197.88	204.4	197.74	203.51	34310300.0
2020-06-30	NVDA	Stock	9.314	9.5263	9.2665	9.4978	367892000.0
2020-06-30	AMZN	Stock	134.2535	138.4815	133.7515	137.941	75394000.0
2020-06-30	GOOGL	Stock	69.844	71.2	69.3465	70.9025	40286400.0
2020-06-30	META	Stock	220.59	227.5	218.47	227.07	33927100.0
2020-06-30	TSLA	Stock	67.1	72.5127	66.9153	71.9873	253777500.0
2020-06-30	TLT	Stock	165.23	165.29	163.48	163.93	14841678.0
2020-06-30	ES	Stock	82.88	83.75	82.11	83.27	1902300.0
2020-06-30	CL	Stock	72.59	73.51	72.27	73.26	3556100.0
2020-06-30	A	Stock	87.33	88.88	87.24	88.37	1920200.0
2020-06-30	AA	Stock	10.84	11.36	10.745	11.24	5798100.0
2020-06-30	AACG	Stock	1.16	1.27	1.16	1.26	40200.0
2020-06-30	AAIC-DELISTED	Stock	2.95	2.99	2.885	2.97	249630.0
2020-06-30	AAIC.C-DELISTED	Stock	19.61	19.65	19.61	19.6306	1548.0
2020-06-30	AAL	Stock	13.1	13.48	12.88	13.07	69607700.0
2020-06-30	AAM.A-DELISTED	Stock	26.0	26.05	25.6	25.68	72837.0
2020-06-30	AAM.B-DELISTED	Stock	25.78	26.015	25.74	25.74	83483.0
2020-06-30	AAMC-DELISTED	Stock	4.9533	4.9533	4.8221	4.8221	867.0
2020-06-30	AAME	Stock	1.7	1.7	1.63	1.66	3900.0
2020-06-30	AAMI	Stock	12.6	12.62	12.305	12.46	1366500.0
2020-06-30	AAOI	Stock	9.35	11.17	9.35	10.87	1792800.0
2020-06-30	AAON	Stock	35.5733	36.4267	35.5133	36.1933	271950.0
2020-06-30	AAP	Stock	142.43	143.36	140.43	142.45	746100.0
2020-06-30	AAT	Stock	28.05	28.64	27.52	27.84	448900.0
2020-06-30	AAU-DELISTED	Stock	0.48	0.4922	0.4697	0.485	361944.0
2020-06-30	AAUAF-DELISTED	Stock	0.48	0.4922	0.4697	0.4891	378849.0
2020-06-30	AAWW-DELISTED	Stock	40.61	43.32	40.61	43.0	436279.0
2020-06-30	AAXJ	Stock	69.31	69.45	68.85	69.17	934888.0
2020-06-30	AAXN-DELISTED	Stock	95.2	100.65	95.2	98.11	819950.0
2020-06-30	AB	Stock	26.25	27.31	26.25	27.24	290300.0
2020-06-30	ABB-DELISTED	Stock	22.29	22.64	22.245	22.56	2062771.0
2020-06-30	ABBNY-DELISTED	Stock	22.29	22.64	22.245	22.56	2186779.0
2020-06-30	ABBV	Stock	95.97	98.88	95.83	98.18	8112500.0
2020-06-30	ABC-DELISTED	Stock	98.7	101.2	98.57	100.69	781191.0
2020-06-30	ABCB	Stock	23.26	23.95	23.01	23.59	375100.0
2020-06-30	ABEO	Stock	71.75	73.25	70.25	73.0	17928.0
2020-06-30	ABEV	Stock	2.67	2.74	2.61	2.64	33405100.0
2020-06-30	ABG	Stock	77.99	78.82	76.9	77.33	106000.0
2020-06-30	ABM	Stock	36.36	36.8	36.02	36.3	415500.0
2020-06-30	ABMD-DELISTED	Stock	240.08	242.56	237.18	241.46	238435.0
2020-06-30	ABR	Stock	9.09	9.3	8.96	9.24	1239100.0
2020-06-30	ABR.A-DELISTED	Stock	24.71	24.94	24.6007	24.94	4379.0
2020-06-30	ABR.B-DELISTED	Stock	23.69	23.98	23.3942	23.69	9524.0
2020-06-30	ABR.C-DELISTED	Stock	24.85	24.9	24.66	24.8999	2400.0
2020-06-30	ABT	Stock	88.75	91.9	88.44	91.43	5220900.0
2020-06-30	ABTC	Stock	265800.0	267300.0	258600.0	264000.0	2.3466666666666667
2020-06-30	ABTS	Stock	12.75	12.9	12.015	12.3	7073.0
2020-06-30	ABTX-DELISTED	Stock	24.46	25.5	24.46	25.39	44494.0
2020-06-30	ABUS	Stock	1.91	1.92	1.8	1.82	814300.0

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

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