PREVIEW / stock_daily / 2020-10-01

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-01.parquet
  size:    227 KB
  rows:    6,910
  symbols: 2,461

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-10-01	AAPL	Stock	117.64	117.72	115.83	116.79	116120400.0
2020-10-01	MSFT	Stock	213.49	213.99	211.32	212.46	27158400.0
2020-10-01	NVDA	Stock	13.758	13.7628	13.4608	13.6145	525004000.0
2020-10-01	AMZN	Stock	160.4	161.2	158.6	161.063	99438000.0
2020-10-01	GOOGL	Stock	74.183	74.7535	73.84	74.395	32884420.0
2020-10-01	META	Stock	265.35	268.33	264.8	266.63	20009800.0
2020-10-01	TSLA	Stock	146.92	149.6267	144.8067	149.3867	152224500.0
2020-10-01	TLT	Stock	162.51	163.7401	162.1	163.36	11523874.0
2020-10-01	ES	Stock	83.84	85.48	83.6	85.45	1644900.0
2020-10-01	CL	Stock	77.53	77.73	76.74	77.06	4048600.0
2020-10-01	A	Stock	101.77	102.41	100.54	101.22	723600.0
2020-10-01	AA	Stock	11.69	11.88	11.29	11.39	6112000.0
2020-10-01	AACG	Stock	1.11	1.13	1.11	1.13	4700.0
2020-10-01	AACQ-DELISTED	Stock	9.95	9.98	9.9	9.94	2370936.0
2020-10-01	AACQU-DELISTED	Stock	10.43	10.49	10.35	10.4	123390.0
2020-10-01	AACQW-DELISTED	Stock	1.59	1.67	1.46	1.4999	87952.0
2020-10-01	AAIC-DELISTED	Stock	2.81	2.85	2.8	2.85	170315.0
2020-10-01	AAIC.C-DELISTED	Stock	19.1343	19.1343	18.94	19.0581	701.0
2020-10-01	AAL	Stock	12.45	12.77	12.35	12.58	48842000.0
2020-10-01	AAM.A-DELISTED	Stock	26.04	26.13	25.97	26.09	27226.0
2020-10-01	AAM.B-DELISTED	Stock	26.8	27.12	26.8	27.03	15521.0
2020-10-01	AAMC-DELISTED	Stock	6.1	6.1912	5.9206	6.1765	11499.0
2020-10-01	AAME	Stock	2.0	2.17	1.9	2.04	1000.0
2020-10-01	AAMI	Stock	12.91	13.12	12.69	12.8	373400.0
2020-10-01	AAOI	Stock	11.4	11.407	11.037	11.22	275200.0
2020-10-01	AAON	Stock	40.3533	40.78	39.58	40.36	309000.0
2020-10-01	AAP	Stock	153.56	156.26	153.2	154.85	649700.0
2020-10-01	AAT	Stock	24.06	24.81	24.06	24.8	198300.0
2020-10-01	AAU-DELISTED	Stock	0.83	0.843	0.7717	0.8022	618462.0
2020-10-01	AAUAF-DELISTED	Stock	0.83	0.843	0.7717	0.8067	627212.0
2020-10-01	AAWW-DELISTED	Stock	61.15	63.0	61.15	62.81	316777.0
2020-10-01	AAXJ	Stock	77.94	78.16	77.49	78.05	1319956.0
2020-10-01	AAXN-DELISTED	Stock	91.84	96.09	91.305	95.64	692070.0
2020-10-01	AB	Stock	27.04	27.16	26.52	26.82	469800.0
2020-10-01	ABB-DELISTED	Stock	25.75	25.82	25.52	25.64	2307021.0
2020-10-01	ABBNY-DELISTED	Stock	25.75	25.82	25.52	25.64	2544890.0
2020-10-01	ABBV	Stock	88.17	88.17	86.73	87.14	8777300.0
2020-10-01	ABC-DELISTED	Stock	97.32	97.6265	94.73	95.36	534827.0
2020-10-01	ABCB	Stock	22.8	23.18	22.37	23.03	355300.0
2020-10-01	ABEO	Stock	26.25	26.5	25.0	26.25	190676.0
2020-10-01	ABEV	Stock	2.23	2.28	2.22	2.26	18290500.0
2020-10-01	ABG	Stock	97.53	101.01	95.99	100.3	179400.0
2020-10-01	ABM	Stock	36.72	37.05	36.35	36.74	280600.0
2020-10-01	ABMD-DELISTED	Stock	277.14	280.73	258.29	260.15	657232.0
2020-10-01	ABR	Stock	11.48	11.74	11.31	11.72	698000.0
2020-10-01	ABR.A-DELISTED	Stock	25.315	25.315	25.12	25.17	1700.0
2020-10-01	ABR.C-DELISTED	Stock	25.81	25.825	25.62	25.7883	2300.0
2020-10-01	ABT	Stock	109.18	110.33	108.38	108.64	7242100.0
2020-10-01	ABTC	Stock	114000.0	137400.0	110400.0	118800.0	25.466666666666665
2020-10-01	ABTS	Stock	19.95	21.3	19.665	20.4	7000.0

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

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