PREVIEW / stock_daily / 2020-12-01

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-01.parquet
  size:    236 KB
  rows:    7,139
  symbols: 2,575

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-12-01	AAPL	Stock	121.01	123.47	120.01	122.72	127728200.0
2020-12-01	MSFT	Stock	214.51	217.32	213.35	216.21	30904500.0
2020-12-01	NVDA	Stock	13.4923	13.5288	13.2282	13.39	296948000.0
2020-12-01	AMZN	Stock	159.425	162.4475	157.859	161.004	90740000.0
2020-12-01	GOOGL	Stock	88.3328	91.086	88.1515	89.768	37362680.0
2020-12-01	META	Stock	279.16	289.3	278.96	286.55	20738900.0
2020-12-01	TSLA	Stock	199.1967	199.2833	190.6833	194.92	120310500.0
2020-12-01	TLT	Stock	158.55	158.74	156.68	157.5	13663889.0
2020-12-01	ES	Stock	87.92	89.16	87.55	88.22	1777000.0
2020-12-01	CL	Stock	85.76	86.34	85.38	86.26	3372300.0
2020-12-01	A	Stock	117.58	118.38	115.04	115.36	1753700.0
2020-12-01	AA	Stock	20.48	22.12	20.46	21.83	8330400.0
2020-12-01	AACG	Stock	1.19	1.22	1.15	1.15	30700.0
2020-12-01	AACQ-DELISTED	Stock	10.05	10.05	9.92	9.95	93256.0
2020-12-01	AACQU-DELISTED	Stock	10.6	10.6	10.45	10.4839	32322.0
2020-12-01	AACQW-DELISTED	Stock	1.43	1.5	1.33	1.4001	60034.0
2020-12-01	AAIC-DELISTED	Stock	3.21	3.33	3.21	3.32	330280.0
2020-12-01	AAIC.C-DELISTED	Stock	21.36	21.38	21.25	21.25	400.0
2020-12-01	AAL	Stock	14.42	14.78	14.24	14.27	76061200.0
2020-12-01	AAM.A-DELISTED	Stock	26.19	26.25	26.062	26.24	16120.0
2020-12-01	AAM.B-DELISTED	Stock	27.09	27.19	27.0	27.19	6558.0
2020-12-01	AAMC-DELISTED	Stock	6.7706	6.8765	6.7647	6.7647	6749.0
2020-12-01	AAME	Stock	2.21	2.21	2.16	2.16	1200.0
2020-12-01	AAMI	Stock	17.92	18.02	17.59	17.74	449600.0
2020-12-01	AAOI	Stock	8.33	8.38	8.02	8.15	694500.0
2020-12-01	AAON	Stock	43.8933	44.08	42.74	42.8267	317850.0
2020-12-01	AAP	Stock	149.07	153.18	147.57	152.61	1258300.0
2020-12-01	AAT	Stock	28.92	29.55	28.57	29.08	462400.0
2020-12-01	AAU-DELISTED	Stock	1.06	1.065	1.0	1.01	720055.0
2020-12-01	AAUAF-DELISTED	Stock	1.06	1.065	1.0	1.0	735821.0
2020-12-01	AAWW-DELISTED	Stock	56.63	57.38	54.42	54.5	312635.0
2020-12-01	AAXJ	Stock	86.32	86.54	85.83	86.2	1270091.0
2020-12-01	AAXN-DELISTED	Stock	127.03	127.4	124.29	125.44	326330.0
2020-12-01	AB	Stock	32.15	32.8	32.0	32.6	265400.0
2020-12-01	ABB-DELISTED	Stock	26.66	26.82	26.6	26.67	1780410.0
2020-12-01	ABBNY-DELISTED	Stock	26.66	26.82	26.6	26.67	1893366.0
2020-12-01	ABBV	Stock	105.05	106.38	104.04	104.04	7623500.0
2020-12-01	ABC-DELISTED	Stock	103.85	104.43	101.8875	102.2	630861.0
2020-12-01	ABCB	Stock	34.95	35.49	34.59	34.83	424500.0
2020-12-01	ABCM-DELISTED	Stock	19.1	19.31	18.875	19.25	56798.0
2020-12-01	ABEO	Stock	41.0	41.25	37.5	38.0	124376.0
2020-12-01	ABEV	Stock	2.72	2.86	2.69	2.86	26033300.0
2020-12-01	ABG	Stock	114.87	120.72	112.76	117.76	223000.0
2020-12-01	ABM	Stock	39.1	39.44	38.28	38.95	301700.0
2020-12-01	ABMD-DELISTED	Stock	272.73	274.98	264.0	268.58	153859.0
2020-12-01	ABR	Stock	13.47	13.76	13.4	13.59	1357900.0
2020-12-01	ABR.A-DELISTED	Stock	25.413	25.5	25.413	25.4737	1920.0
2020-12-01	ABR.B-DELISTED	Stock	25.59	25.61	25.15	25.21	8659.0
2020-12-01	ABR.C-DELISTED	Stock	25.97	25.99	25.91	25.95	833.0
2020-12-01	ABST-DELISTED	Stock	10.45	10.45	10.135	10.14	116418.0

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

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