PREVIEW / stock_daily / 2020-11-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-09.parquet
  size:    231 KB
  rows:    7,053
  symbols: 2,516

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-11-09	AAPL	Stock	120.5	121.99	116.05	116.32	154515300.0
2020-11-09	MSFT	Stock	224.44	228.12	217.88	218.39	44395000.0
2020-11-09	NVDA	Stock	14.5525	14.6915	13.6108	13.6308	582976000.0
2020-11-09	AMZN	Stock	161.5515	164.45	155.6055	157.187	143808000.0
2020-11-09	GOOGL	Stock	89.799	90.8445	87.8772	88.071	53440480.0
2020-11-09	META	Stock	289.87	292.58	278.53	278.77	25117700.0
2020-11-09	TSLA	Stock	146.5	150.8333	140.3333	140.42	104499000.0
2020-11-09	TLT	Stock	155.97	156.15	154.625	156.06	23245038.0
2020-11-09	ES	Stock	95.0	96.66	93.41	93.53	1757800.0
2020-11-09	CL	Stock	83.8	84.57	81.54	81.78	6633800.0
2020-11-09	A	Stock	116.16	117.5	112.39	112.5	2177900.0
2020-11-09	AA	Stock	15.5	16.185	15.11	15.73	8373200.0
2020-11-09	AACG	Stock	1.13	1.19	1.13	1.15	24400.0
2020-11-09	AACQ-DELISTED	Stock	9.74	9.7599	9.72	9.74	140998.0
2020-11-09	AACQU-DELISTED	Stock	10.1	10.1	10.05	10.07	72028.0
2020-11-09	AACQW-DELISTED	Stock	1.1461	1.2	1.05	1.14	76813.0
2020-11-09	AAIC-DELISTED	Stock	2.64	2.83	2.64	2.79	376386.0
2020-11-09	AAIC.C-DELISTED	Stock	19.14	19.24	18.6	19.21	7708.0
2020-11-09	AAL	Stock	14.33	14.41	12.75	13.2	231326200.0
2020-11-09	AAM.A-DELISTED	Stock	26.29	26.48	26.29	26.34	28822.0
2020-11-09	AAM.B-DELISTED	Stock	27.17	27.3454	26.9203	27.34	21979.0
2020-11-09	AAMC-DELISTED	Stock	6.5294	6.7647	6.4676	6.4735	23691.0
2020-11-09	AAMI	Stock	15.93	16.44	15.91	16.06	699800.0
2020-11-09	AAOI	Stock	7.91	8.13	7.7	7.715	883800.0
2020-11-09	AAON	Stock	44.38	46.2733	42.1333	42.2133	643200.0
2020-11-09	AAP	Stock	161.59	164.08	156.33	156.63	1877600.0
2020-11-09	AAT	Stock	23.02	25.75	23.02	25.13	1211700.0
2020-11-09	AAU-DELISTED	Stock	1.19	1.22	1.1	1.16	1098945.0
2020-11-09	AAUAF-DELISTED	Stock	1.19	1.22	1.1	1.16	1170587.0
2020-11-09	AAWW-DELISTED	Stock	59.52	59.79	52.01	52.02	1095540.0
2020-11-09	AAXJ	Stock	86.4	86.4	84.155	84.21	1971393.0
2020-11-09	AAXN-DELISTED	Stock	126.65	128.385	121.27	124.36	731428.0
2020-11-09	AB	Stock	31.02	31.67	30.59	30.85	756600.0
2020-11-09	ABB-DELISTED	Stock	27.73	27.77	26.73	26.74	2390298.0
2020-11-09	ABBNY-DELISTED	Stock	27.72	27.77	26.73	26.73	2635500.0
2020-11-09	ABBV	Stock	95.74	96.95	94.67	95.12	11028900.0
2020-11-09	ABC-DELISTED	Stock	108.42	109.65	104.1	106.37	752032.0
2020-11-09	ABCB	Stock	31.89	35.83	31.62	33.97	839800.0
2020-11-09	ABCM-DELISTED	Stock	18.12	19.34	17.88	19.25	547915.0
2020-11-09	ABEO	Stock	27.0	27.5	26.25	26.75	58316.0
2020-11-09	ABEV	Stock	2.63	2.67	2.58	2.66	57773600.0
2020-11-09	ABG	Stock	121.59	126.46	120.57	122.49	431300.0
2020-11-09	ABM	Stock	38.39	40.6	38.39	39.82	507400.0
2020-11-09	ABMD-DELISTED	Stock	281.24	292.225	277.22	279.72	245121.0
2020-11-09	ABR	Stock	13.9	14.04	13.29	13.29	2302800.0
2020-11-09	ABR.A-DELISTED	Stock	25.99	25.99	25.78	25.94	4303.0
2020-11-09	ABR.B-DELISTED	Stock	25.63	25.63	25.5977	25.63	2957.0
2020-11-09	ABR.C-DELISTED	Stock	26.25	26.25	25.87	26.1664	3882.0
2020-11-09	ABST-DELISTED	Stock	12.15	12.15	11.18	11.37	64046.0
2020-11-09	ABT	Stock	111.8	113.21	106.19	109.39	13990700.0

> showing 50 of 7,053 rows — these rows as CSV

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