PREVIEW / stock_daily / 2020-06-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-24.parquet
  size:    223 KB
  rows:    6,722
  symbols: 2,404

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-24	AAPL	Stock	91.25	92.1975	89.63	90.015	192623200.0
2020-06-24	MSFT	Stock	201.6	203.25	196.56	197.84	36740600.0
2020-06-24	NVDA	Stock	9.4762	9.5565	9.1445	9.2355	449372000.0
2020-06-24	AMZN	Stock	139.0	139.8	136.05	136.72	90532000.0
2020-06-24	GOOGL	Stock	73.164	73.7895	71.5	71.635	31591580.0
2020-06-24	META	Stock	241.2	243.22	232.68	234.02	20834900.0
2020-06-24	TSLA	Stock	66.274	66.7253	63.5427	64.0567	164394000.0
2020-06-24	TLT	Stock	161.53	163.09	161.52	163.03	11436501.0
2020-06-24	ES	Stock	82.73	82.88	81.66	82.42	1664500.0
2020-06-24	CL	Stock	72.59	72.68	71.76	72.03	3243000.0
2020-06-24	A	Stock	89.08	89.08	86.32	86.56	1806600.0
2020-06-24	AA	Stock	11.96	12.04	10.9	11.14	7562700.0
2020-06-24	AACG	Stock	1.14	1.3	1.14	1.25	80400.0
2020-06-24	AAIC-DELISTED	Stock	2.85	2.855	2.69	2.82	411265.0
2020-06-24	AAIC.C-DELISTED	Stock	19.86	19.884	19.61	19.68	5117.0
2020-06-24	AAL	Stock	13.59	13.9	12.83	13.04	140975500.0
2020-06-24	AAM.A-DELISTED	Stock	26.07	26.17	25.89	26.06	10422.0
2020-06-24	AAM.B-DELISTED	Stock	26.05	26.05	25.71	25.95	12306.0
2020-06-24	AAMC-DELISTED	Stock	5.2941	5.3206	5.0559	5.3206	17656.0
2020-06-24	AAME	Stock	1.76	1.79	1.63	1.68	8600.0
2020-06-24	AAMI	Stock	10.06	10.15	9.72	9.79	2049500.0
2020-06-24	AAOI	Stock	9.69	9.79	9.31	9.34	480700.0
2020-06-24	AAON	Stock	35.7733	35.9667	34.88	35.18	251400.0
2020-06-24	AAP	Stock	148.56	148.81	142.76	143.0	1073200.0
2020-06-24	AAT	Stock	27.88	28.12	26.38	27.3	297400.0
2020-06-24	AAU-DELISTED	Stock	0.515	0.52	0.493	0.4998	132186.0
2020-06-24	AAUAF-DELISTED	Stock	0.515	0.52	0.493	0.5016	139007.0
2020-06-24	AAWW-DELISTED	Stock	41.07	41.085	39.73	40.6	395989.0
2020-06-24	AAXJ	Stock	70.08	70.33	69.17	69.62	953283.0
2020-06-24	AAXN-DELISTED	Stock	94.4	97.1599	91.86	93.42	1105647.0
2020-06-24	AB	Stock	25.88	25.95	24.98	25.05	776500.0
2020-06-24	ABB-DELISTED	Stock	22.11	22.11	21.74	21.77	3633485.0
2020-06-24	ABBNY-DELISTED	Stock	22.07	22.1	21.74	21.75	3780910.0
2020-06-24	ABBV	Stock	96.46	97.16	94.35	95.14	9025100.0
2020-06-24	ABC-DELISTED	Stock	100.74	101.46	98.0	98.87	983228.0
2020-06-24	ABCB	Stock	23.31	23.53	22.53	22.73	579000.0
2020-06-24	ABEO	Stock	76.0	78.75	71.5	72.0	33968.0
2020-06-24	ABEV	Stock	2.67	2.69	2.55	2.59	29196300.0
2020-06-24	ABG	Stock	75.26	75.5	72.28	73.04	163300.0
2020-06-24	ABM	Stock	37.67	38.0	35.51	35.57	748200.0
2020-06-24	ABMD-DELISTED	Stock	252.15	253.42	239.48	241.65	306261.0
2020-06-24	ABR	Stock	9.8	9.91	9.13	9.51	3360600.0
2020-06-24	ABR.A-DELISTED	Stock	24.67	24.75	23.59	24.75	5406.0
2020-06-24	ABR.B-DELISTED	Stock	23.27	23.36	23.26	23.325	733.0
2020-06-24	ABR.C-DELISTED	Stock	25.2559	25.27	25.09	25.151	3900.0
2020-06-24	ABT	Stock	90.63	90.73	86.82	87.3	6141900.0
2020-06-24	ABTC	Stock	243000.0	247500.0	231600.0	244200.0	5.48
2020-06-24	ABTS	Stock	14.955	15.6	13.95	15.0	3947.0
2020-06-24	ABTX-DELISTED	Stock	24.69	24.79	23.86	23.99	68550.0
2020-06-24	ABUS	Stock	2.06	2.14	1.97	2.07	1149900.0

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

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