PREVIEW / stock_daily / 2021-12-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-20.parquet
  size:    261 KB
  rows:    8,028
  symbols: 2,630

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
2021-12-20	AAPL	Stock	168.28	170.58	167.46	169.75	107499100.0
2021-12-20	MSFT	Stock	320.05	322.8	317.57	319.91	28326500.0
2021-12-20	NVDA	Stock	27.305	28.144	27.145	27.719	461847000.0
2021-12-20	AMZN	Stock	166.85	167.8745	165.6	167.079	57372000.0
2021-12-20	GOOGL	Stock	140.0	141.7745	139.321	141.607	27192360.0
2021-12-20	META	Stock	329.78	329.9	322.53	325.45	17901800.0
2021-12-20	TSLA	Stock	303.5667	307.23	297.7967	299.98	56480100.0
2021-12-20	TLT	Stock	150.75	151.02	149.595	149.7	17147276.0
2021-12-20	ES	Stock	88.81	89.76	88.03	89.67	1011500.0
2021-12-20	CL	Stock	82.09	82.85	81.82	82.52	5162300.0
2021-12-20	A	Stock	150.76	152.18	148.54	150.42	2027200.0
2021-12-20	AA	Stock	51.89	53.355	51.36	53.11	8394500.0
2021-12-20	AAC-DELISTED	Stock	9.75	9.77	9.75	9.76	213954.0
2021-12-20	AACG	Stock	1.26	1.26	1.12	1.15	53200.0
2021-12-20	AACIU	Stock	10.02	10.04	10.0	10.02	17632.0
2021-12-20	AACIW-DELISTED	Stock	0.54	0.54	0.4503	0.4503	44349.0
2021-12-20	AAIC-DELISTED	Stock	3.47	3.48	3.38	3.41	224257.0
2021-12-20	AAIC.C-DELISTED	Stock	25.3501	25.74	25.3501	25.7163	455.0
2021-12-20	AAL	Stock	16.5	17.78	16.45	17.3	44479100.0
2021-12-20	AAM.A-DELISTED	Stock	25.31	25.41	25.31	25.32	11924.0
2021-12-20	AAM.B-DELISTED	Stock	26.21	26.33	26.2	26.2	4488.0
2021-12-20	AAME	Stock	3.64	3.64	2.84	3.12	21800.0
2021-12-20	AAMI	Stock	25.85	25.935	24.55	24.85	2119900.0
2021-12-20	AAN-DELISTED	Stock	23.65	23.68	22.95	23.45	228200.0
2021-12-20	AAOI	Stock	5.55	5.55	5.28	5.38	357400.0
2021-12-20	AAON	Stock	51.5333	52.6333	50.2533	51.3467	307950.0
2021-12-20	AAP	Stock	230.28	230.28	224.22	228.39	643000.0
2021-12-20	AAQC-DELISTED	Stock	9.69	9.71	9.69	9.7	33855.0
2021-12-20	AAT	Stock	35.28	35.28	34.3	34.85	240700.0
2021-12-20	AATC	Stock	6.38	6.57	6.33	6.54	12621.0
2021-12-20	AAU-DELISTED	Stock	0.32	0.32	0.2844	0.292	1080067.0
2021-12-20	AAUAF-DELISTED	Stock	0.32	0.32	0.2844	0.2938	1086466.0
2021-12-20	AAWW-DELISTED	Stock	88.905	88.905	85.06	87.97	311731.0
2021-12-20	AAXJ	Stock	80.12	80.39	79.8	80.18	957386.0
2021-12-20	AB	Stock	46.25	46.4	44.25	45.54	551000.0
2021-12-20	ABB-DELISTED	Stock	36.59	36.615	36.23	36.57	1552156.0
2021-12-20	ABBNY-DELISTED	Stock	36.59	36.615	36.23	36.56	1725505.0
2021-12-20	ABBV	Stock	128.51	131.39	128.23	130.86	7119200.0
2021-12-20	ABC-DELISTED	Stock	124.71	126.29	123.205	126.05	532696.0
2021-12-20	ABCB	Stock	48.02	48.61	46.2	46.65	481400.0
2021-12-20	ABCL	Stock	14.58	15.28	14.36	14.6	1409900.0
2021-12-20	ABCM-DELISTED	Stock	22.05	22.39	21.86	22.22	77752.0
2021-12-20	ABEO	Stock	7.5	7.75	7.0	7.75	661636.0
2021-12-20	ABEV	Stock	2.67	2.68	2.62	2.66	15144600.0
2021-12-20	ABG	Stock	161.69	162.0	153.79	159.35	348200.0
2021-12-20	ABM	Stock	39.8	40.12	38.44	38.94	647400.0
2021-12-20	ABMD-DELISTED	Stock	311.8	317.295	309.44	316.02	136704.0
2021-12-20	ABNB	Stock	151.16	158.48	151.0	157.23	4639300.0
2021-12-20	ABOS	Stock	6.88	7.11	6.56	6.96	244900.0
2021-12-20	ABR	Stock	16.82	16.84	16.19	16.7	3167600.0

> showing 50 of 8,028 rows — these rows as CSV

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