PREVIEW / stock_daily / 2020-12-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-07.parquet
  size:    237 KB
  rows:    7,197
  symbols: 2,609

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-07	AAPL	Stock	122.31	124.57	122.25	123.75	86712000.0
2020-12-07	MSFT	Stock	214.37	215.54	212.99	214.29	24620000.0
2020-12-07	NVDA	Stock	13.6012	13.7312	13.5	13.6068	223244000.0
2020-12-07	AMZN	Stock	157.824	159.038	157.0845	157.9	55026000.0
2020-12-07	GOOGL	Stock	90.7775	91.4645	90.152	90.8515	22287820.0
2020-12-07	META	Stock	279.19	288.49	278.2	285.58	13007700.0
2020-12-07	TSLA	Stock	201.64	216.2633	201.0167	213.92	168929100.0
2020-12-07	TLT	Stock	156.35	156.88	156.18	156.6	9316138.0
2020-12-07	ES	Stock	85.19	87.13	85.01	86.74	1464600.0
2020-12-07	CL	Stock	84.8	85.86	84.75	85.39	2966800.0
2020-12-07	A	Stock	115.2	116.44	114.12	114.4	2076700.0
2020-12-07	AA	Stock	23.51	23.54	23.03	23.39	6582500.0
2020-12-07	AACG	Stock	1.19	1.25	1.18	1.19	19300.0
2020-12-07	AACQ-DELISTED	Stock	10.0	10.263	9.94	10.11	2195453.0
2020-12-07	AACQU-DELISTED	Stock	10.52	10.79	10.52	10.71	63405.0
2020-12-07	AACQW-DELISTED	Stock	1.65	1.88	1.58	1.8	258614.0
2020-12-07	AAIC-DELISTED	Stock	3.6	3.77	3.565	3.71	357228.0
2020-12-07	AAIC.C-DELISTED	Stock	21.52	21.955	21.396	21.72	4466.0
2020-12-07	AAL	Stock	16.54	18.07	16.47	17.21	157231900.0
2020-12-07	AAM.A-DELISTED	Stock	26.45	26.5	26.2755	26.38	4750.0
2020-12-07	AAM.B-DELISTED	Stock	27.14	27.19	27.01	27.04	8314.0
2020-12-07	AAMC-DELISTED	Stock	6.9265	6.9265	6.9176	6.9176	1367.0
2020-12-07	AAME	Stock	2.11	2.15	2.11	2.15	3400.0
2020-12-07	AAMI	Stock	19.36	19.7	19.07	19.35	367900.0
2020-12-07	AAN-DELISTED	Stock	18.99	19.21	17.75	18.0	1481500.0
2020-12-07	AAOI	Stock	8.44	8.47	8.25	8.39	500300.0
2020-12-07	AAON	Stock	41.5867	42.0133	41.1933	41.4333	220500.0
2020-12-07	AAP	Stock	151.61	153.72	151.0	153.68	985900.0
2020-12-07	AAT	Stock	30.91	30.91	30.02	30.06	169900.0
2020-12-07	AAU-DELISTED	Stock	0.784	0.7916	0.7103	0.715	1767915.0
2020-12-07	AAUAF-DELISTED	Stock	0.784	0.7916	0.7103	0.732	1835891.0
2020-12-07	AAWW-DELISTED	Stock	56.36	56.75	54.645	55.53	405484.0
2020-12-07	AAXJ	Stock	87.78	88.132	87.69	87.88	1190097.0
2020-12-07	AAXN-DELISTED	Stock	124.99	126.0	122.45	122.93	224774.0
2020-12-07	AB	Stock	33.18	33.25	32.62	32.78	420000.0
2020-12-07	ABB-DELISTED	Stock	27.11	27.145	26.86	26.9	690760.0
2020-12-07	ABBNY-DELISTED	Stock	27.11	27.145	26.86	26.91	760344.0
2020-12-07	ABBV	Stock	107.04	107.21	104.96	105.84	6532500.0
2020-12-07	ABC-DELISTED	Stock	103.0	103.3	99.14	99.5	885582.0
2020-12-07	ABCB	Stock	36.28	37.03	35.66	36.83	281400.0
2020-12-07	ABCM-DELISTED	Stock	18.8	19.0	18.67	18.98	27254.0
2020-12-07	ABEO	Stock	37.5	39.5	37.0	37.5	69956.0
2020-12-07	ABEV	Stock	2.97	3.04	2.93	2.95	26377100.0
2020-12-07	ABG	Stock	144.88	150.0	142.16	143.39	439100.0
2020-12-07	ABM	Stock	39.59	39.92	39.24	39.47	304800.0
2020-12-07	ABMD-DELISTED	Stock	271.71	273.4	268.53	272.42	101465.0
2020-12-07	ABR	Stock	13.71	13.9	13.5	13.74	1147200.0
2020-12-07	ABR.A-DELISTED	Stock	25.5	25.5	25.38	25.38	4202.0
2020-12-07	ABR.B-DELISTED	Stock	25.29	25.37	25.25	25.3311	1195.0
2020-12-07	ABR.C-DELISTED	Stock	25.61	25.9	25.51	25.75	9180.0

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

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