PREVIEW / stock_daily / 2020-10-26

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-26.parquet
  size:    229 KB
  rows:    6,975
  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-26	AAPL	Stock	114.01	116.55	112.88	115.05	111850700.0
2020-10-26	MSFT	Stock	213.85	216.34	208.1	210.08	37111600.0
2020-10-26	NVDA	Stock	13.427	13.6928	13.0385	13.1412	336896000.0
2020-10-26	AMZN	Stock	159.937	164.149	157.665	160.352	118024000.0
2020-10-26	GOOGL	Stock	80.75	81.479	78.389	79.2145	35826340.0
2020-10-26	META	Stock	283.16	285.23	274.26	277.11	21322900.0
2020-10-26	TSLA	Stock	137.21	141.92	136.6667	140.0933	84717600.0
2020-10-26	TLT	Stock	159.21	160.02	159.01	159.48	7227337.0
2020-10-26	ES	Stock	91.36	91.97	90.45	91.73	1677300.0
2020-10-26	CL	Stock	78.86	79.22	78.12	78.69	3886700.0
2020-10-26	A	Stock	105.39	105.82	103.75	104.63	1102000.0
2020-10-26	AA	Stock	13.26	13.37	12.865	13.0	3640600.0
2020-10-26	AACG	Stock	1.23	1.23	1.09	1.1	95800.0
2020-10-26	AACQ-DELISTED	Stock	9.76	9.76	9.67	9.69	146225.0
2020-10-26	AACQU-DELISTED	Stock	10.09	10.21	10.07	10.07	20227.0
2020-10-26	AACQW-DELISTED	Stock	1.39	1.39	1.15	1.25	59479.0
2020-10-26	AAIC-DELISTED	Stock	2.71	2.82	2.61	2.62	86591.0
2020-10-26	AAIC.C-DELISTED	Stock	18.8073	18.9	18.8073	18.9	4702.0
2020-10-26	AAL	Stock	12.39	12.45	11.67	11.8	85349600.0
2020-10-26	AAM.A-DELISTED	Stock	26.16	26.32	26.13	26.3143	13151.0
2020-10-26	AAM.B-DELISTED	Stock	26.9874	27.185	26.93	27.1	13501.0
2020-10-26	AAMC-DELISTED	Stock	6.9118	6.9118	6.9118	6.9118	17000.0
2020-10-26	AAME	Stock	2.25	2.25	2.06	2.14	1800.0
2020-10-26	AAMI	Stock	14.95	15.185	14.44	14.49	392600.0
2020-10-26	AAOI	Stock	10.41	10.439	9.9	10.02	359200.0
2020-10-26	AAON	Stock	40.7533	40.8733	40.0667	40.52	156750.0
2020-10-26	AAP	Stock	152.71	152.96	149.35	151.21	619000.0
2020-10-26	AAT	Stock	24.08	24.08	23.31	23.68	196200.0
2020-10-26	AAU-DELISTED	Stock	0.96	0.96	0.86	0.9	561874.0
2020-10-26	AAUAF-DELISTED	Stock	0.96	0.96	0.86	0.9	587718.0
2020-10-26	AAWW-DELISTED	Stock	61.85	62.96	61.28	62.34	275992.0
2020-10-26	AAXJ	Stock	79.85	80.38	79.25	79.89	725904.0
2020-10-26	AAXN-DELISTED	Stock	102.0	103.32	100.51	101.94	247873.0
2020-10-26	AB	Stock	31.1	31.25	30.23	30.77	867700.0
2020-10-26	ABB-DELISTED	Stock	25.89	26.02	25.71	26.005	2296635.0
2020-10-26	ABBNY-DELISTED	Stock	25.89	26.02	25.71	26.01	2711994.0
2020-10-26	ABBV	Stock	84.09	84.32	82.81	83.92	7986300.0
2020-10-26	ABC-DELISTED	Stock	98.57	98.75	97.07	98.37	462153.0
2020-10-26	ABCB	Stock	29.47	29.47	28.34	28.99	489800.0
2020-10-26	ABCM-DELISTED	Stock	18.9	19.45	18.63	19.4	203032.0
2020-10-26	ABEO	Stock	33.25	33.75	30.75	31.5	38664.0
2020-10-26	ABEV	Stock	2.51	2.58	2.5	2.56	36584300.0
2020-10-26	ABG	Stock	117.0	117.06	113.09	116.59	136400.0
2020-10-26	ABM	Stock	35.26	35.93	35.01	35.9	484000.0
2020-10-26	ABMD-DELISTED	Stock	279.22	288.58	277.945	288.43	178352.0
2020-10-26	ABR	Stock	11.85	11.85	11.41	11.44	1299600.0
2020-10-26	ABR.A-DELISTED	Stock	25.2	25.2829	25.2	25.2829	232.0
2020-10-26	ABR.B-DELISTED	Stock	24.975	25.14	24.955	25.14	1868.0
2020-10-26	ABR.C-DELISTED	Stock	25.62	25.656	25.62	25.656	400.0
2020-10-26	ABT	Stock	107.57	109.16	107.05	109.0	7298000.0

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

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