PREVIEW / stock_daily / 2020-10-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-06.parquet
  size:    229 KB
  rows:    6,957
  symbols: 2,487

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-06	AAPL	Stock	115.7	116.12	112.25	113.16	161498200.0
2020-10-06	MSFT	Stock	208.82	210.18	204.82	205.91	28554300.0
2020-10-06	NVDA	Stock	13.83	14.142	13.665	13.7365	784420000.0
2020-10-06	AMZN	Stock	158.25	159.1	154.5	154.998	101738000.0
2020-10-06	GOOGL	Stock	73.775	74.226	72.2505	72.551	26095040.0
2020-10-06	META	Stock	261.78	265.69	258.24	258.66	18696900.0
2020-10-06	TSLA	Stock	141.2633	142.9267	135.35	137.9933	147438900.0
2020-10-06	TLT	Stock	159.33	161.405	158.68	160.43	22419358.0
2020-10-06	ES	Stock	89.49	91.37	88.74	90.78	1687000.0
2020-10-06	CL	Stock	78.55	78.63	77.2	77.54	2640900.0
2020-10-06	A	Stock	103.12	103.33	101.48	101.63	1078000.0
2020-10-06	AA	Stock	12.11	12.47	11.66	11.67	7031300.0
2020-10-06	AACG	Stock	1.13	1.13	1.11	1.11	1800.0
2020-10-06	AACQ-DELISTED	Stock	9.84	9.9	9.76	9.78	873015.0
2020-10-06	AACQU-DELISTED	Stock	10.32	10.38	10.25	10.25	143056.0
2020-10-06	AACQW-DELISTED	Stock	1.56	1.59	1.44	1.44	117791.0
2020-10-06	AAIC-DELISTED	Stock	2.82	2.92	2.81	2.81	184882.0
2020-10-06	AAIC.C-DELISTED	Stock	19.04	19.04	18.75	18.925	9023.0
2020-10-06	AAL	Stock	13.28	13.44	12.46	12.53	85252400.0
2020-10-06	AAM.A-DELISTED	Stock	26.26	26.3618	26.2	26.29	21028.0
2020-10-06	AAM.B-DELISTED	Stock	27.34	27.39	27.22	27.33	10473.0
2020-10-06	AAMC-DELISTED	Stock	5.7315	6.1118	5.7176	6.0294	10819.0
2020-10-06	AAME	Stock	1.97	1.97	1.97	1.97	200.0
2020-10-06	AAMI	Stock	13.65	14.1	13.545	13.62	521900.0
2020-10-06	AAOI	Stock	11.49	11.85	11.01	11.2	482800.0
2020-10-06	AAON	Stock	41.5067	42.4933	41.0733	41.92	350850.0
2020-10-06	AAP	Stock	160.26	160.78	155.06	155.16	837200.0
2020-10-06	AAT	Stock	25.94	26.26	25.37	25.41	425700.0
2020-10-06	AAU-DELISTED	Stock	0.81	0.8182	0.771	0.771	346596.0
2020-10-06	AAUAF-DELISTED	Stock	0.81	0.8182	0.771	0.7835	355398.0
2020-10-06	AAWW-DELISTED	Stock	65.8	66.73	63.56	63.965	421177.0
2020-10-06	AAXJ	Stock	78.23	78.81	78.07	78.18	1587024.0
2020-10-06	AAXN-DELISTED	Stock	92.2	94.47	91.46	93.21	326624.0
2020-10-06	AB	Stock	27.4	28.4	27.27	27.62	516600.0
2020-10-06	ABB-DELISTED	Stock	26.3	26.36	25.9	25.91	1450433.0
2020-10-06	ABBNY-DELISTED	Stock	26.3	26.36	25.9	25.91	1659215.0
2020-10-06	ABBV	Stock	87.97	88.06	85.71	85.89	8743800.0
2020-10-06	ABC-DELISTED	Stock	97.17	97.72	95.46	95.63	555126.0
2020-10-06	ABCB	Stock	25.38	26.44	24.82	25.38	827200.0
2020-10-06	ABEO	Stock	28.0	31.75	27.75	30.5	240756.0
2020-10-06	ABEV	Stock	2.39	2.51	2.38	2.42	31067300.0
2020-10-06	ABG	Stock	112.62	121.16	111.91	112.56	313700.0
2020-10-06	ABM	Stock	36.97	37.78	36.62	36.92	740800.0
2020-10-06	ABMD-DELISTED	Stock	268.69	271.17	263.565	265.15	224867.0
2020-10-06	ABR	Stock	11.9	11.99	11.53	11.55	1070500.0
2020-10-06	ABR.A-DELISTED	Stock	25.24	25.24	25.24	25.24	188.0
2020-10-06	ABR.B-DELISTED	Stock	25.17	25.23	25.07	25.07	1951.0
2020-10-06	ABR.C-DELISTED	Stock	25.68	25.96	25.55	25.56	5943.0
2020-10-06	ABT	Stock	108.56	108.77	106.05	106.25	3992600.0
2020-10-06	ABTC	Stock	121800.0	123840.0	117600.0	118200.0	3.6266666666666665

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

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