PREVIEW / stock_daily / 2020-11-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-27.parquet
  size:    232 KB
  rows:    7,081
  symbols: 2,541

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-27	AAPL	Stock	116.57	117.49	116.22	116.59	46691300.0
2020-11-27	MSFT	Stock	214.85	216.27	214.04	215.23	14512200.0
2020-11-27	NVDA	Stock	13.375	13.4075	13.1705	13.2613	167276000.0
2020-11-27	AMZN	Stock	160.563	160.8095	159.5025	159.767	47858000.0
2020-11-27	GOOGL	Stock	88.227	89.8505	88.227	89.351	14790140.0
2020-11-27	META	Stock	277.39	279.13	274.82	277.81	7808400.0
2020-11-27	TSLA	Stock	193.72	199.5933	192.8167	195.2533	112683300.0
2020-11-27	TLT	Stock	159.61	160.27	159.58	160.22	4708153.0
2020-11-27	ES	Stock	88.5	88.68	86.94	87.93	633500.0
2020-11-27	CL	Stock	84.95	85.06	84.3	84.9	2188300.0
2020-11-27	A	Stock	113.77	114.98	112.94	114.09	983700.0
2020-11-27	AA	Stock	20.6	21.19	20.265	20.48	3739500.0
2020-11-27	AACG	Stock	1.3	1.3	1.21	1.24	34500.0
2020-11-27	AACQ-DELISTED	Stock	9.94	9.95	9.88	9.94	46339.0
2020-11-27	AACQU-DELISTED	Stock	10.37	10.38	10.34	10.37	14964.0
2020-11-27	AACQW-DELISTED	Stock	1.44	1.5	1.33	1.39	59718.0
2020-11-27	AAIC-DELISTED	Stock	3.31	3.34	3.23	3.34	129160.0
2020-11-27	AAIC.C-DELISTED	Stock	20.2	21.1	20.2	21.05	450.0
2020-11-27	AAL	Stock	15.12	15.56	14.95	14.98	66066400.0
2020-11-27	AAM.A-DELISTED	Stock	26.25	26.25	26.14	26.19	2365.0
2020-11-27	AAM.B-DELISTED	Stock	27.25	27.25	27.08	27.19	3133.0
2020-11-27	AAMC-DELISTED	Stock	6.8147	6.8147	6.6926	6.6941	2115.0
2020-11-27	AAME	Stock	2.12	2.15	2.02	2.06	4500.0
2020-11-27	AAMI	Stock	18.12	18.32	17.95	18.25	165000.0
2020-11-27	AAOI	Stock	8.52	8.6	8.1	8.14	527500.0
2020-11-27	AAON	Stock	43.74	44.0667	43.54	43.9467	87150.0
2020-11-27	AAP	Stock	150.24	150.65	148.31	149.93	460500.0
2020-11-27	AAT	Stock	30.36	30.5	29.71	30.18	97700.0
2020-11-27	AAU-DELISTED	Stock	1.0	1.06	1.0	1.06	131427.0
2020-11-27	AAUAF-DELISTED	Stock	1.0	1.0236	1.0	1.02	210706.0
2020-11-27	AAWW-DELISTED	Stock	55.97	56.89	55.63	55.63	103884.0
2020-11-27	AAXJ	Stock	87.16	87.43	86.99	87.28	538224.0
2020-11-27	AAXN-DELISTED	Stock	128.7	128.7	124.2	124.97	140501.0
2020-11-27	AB	Stock	31.95	32.41	31.95	32.36	105100.0
2020-11-27	ABB-DELISTED	Stock	26.57	26.67	26.51	26.6	876227.0
2020-11-27	ABBNY-DELISTED	Stock	26.57	26.67	26.51	26.6	1018390.0
2020-11-27	ABBV	Stock	104.98	105.8	104.3	104.89	4418800.0
2020-11-27	ABC-DELISTED	Stock	103.29	103.81	102.5401	103.2	214749.0
2020-11-27	ABCB	Stock	35.4	35.98	34.1	35.28	203100.0
2020-11-27	ABCM-DELISTED	Stock	18.58	19.08	18.58	18.8	26643.0
2020-11-27	ABEO	Stock	37.0	43.75	36.5	41.25	208100.0
2020-11-27	ABEV	Stock	2.71	2.76	2.7	2.73	7458800.0
2020-11-27	ABG	Stock	120.75	120.75	117.94	118.33	60000.0
2020-11-27	ABM	Stock	40.18	40.18	39.38	39.96	103100.0
2020-11-27	ABMD-DELISTED	Stock	264.78	272.0	261.0	271.9	85631.0
2020-11-27	ABR	Stock	13.75	13.84	13.55	13.69	352700.0
2020-11-27	ABR.A-DELISTED	Stock	25.499	25.57	25.47	25.57	1800.0
2020-11-27	ABR.C-DELISTED	Stock	25.84	25.8483	25.84	25.8483	200.0
2020-11-27	ABST-DELISTED	Stock	10.24	10.35	10.12	10.21	31743.0
2020-11-27	ABT	Stock	106.67	107.75	105.87	107.62	1979000.0

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

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