PREVIEW / stock_daily / 2021-11-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-11.parquet
  size:    260 KB
  rows:    7,956
  symbols: 2,651

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-11-11	AAPL	Stock	148.96	149.43	147.68	147.87	41000000.0
2021-11-11	MSFT	Stock	331.25	333.77	330.51	332.43	16849800.0
2021-11-11	NVDA	Stock	30.468	30.59	29.777	30.39	332172000.0
2021-11-11	AMZN	Stock	175.65	177.162	173.3735	173.625	45288000.0
2021-11-11	GOOGL	Stock	146.4895	147.5355	145.6005	145.7665	16517480.0
2021-11-11	META	Stock	329.82	332.46	327.0	327.74	12376600.0
2021-11-11	TSLA	Stock	367.59	368.3233	351.56	354.5033	67189800.0
2021-11-11	TLT	Stock	148.508	148.655	147.89	147.98	5552818.0
2021-11-11	ES	Stock	83.3	83.54	82.15	82.51	816400.0
2021-11-11	CL	Stock	78.39	78.43	77.84	77.99	2788500.0
2021-11-11	A	Stock	160.28	161.04	157.93	158.79	935500.0
2021-11-11	AA	Stock	48.52	51.71	48.4	51.21	14257300.0
2021-11-11	AAC-DELISTED	Stock	9.85	9.85	9.82	9.83	609560.0
2021-11-11	AACG	Stock	2.2	2.22	2.18	2.21	18700.0
2021-11-11	AACIU	Stock	9.99	10.02	9.95	9.99	441067.0
2021-11-11	AACIW-DELISTED	Stock	0.5	0.6	0.5	0.5	441200.0
2021-11-11	AAIC-DELISTED	Stock	3.8	3.85	3.8	3.85	168220.0
2021-11-11	AAIC.C-DELISTED	Stock	25.6	25.6141	25.6	25.6141	467.0
2021-11-11	AAL	Stock	21.6	21.79	21.3	21.33	18499300.0
2021-11-11	AAM.A-DELISTED	Stock	26.09	26.09	25.62	25.81	17935.0
2021-11-11	AAM.B-DELISTED	Stock	26.96	26.96	26.71	26.71	1847.0
2021-11-11	AAMC-DELISTED	Stock	6.8938	7.0574	6.8938	7.0559	7830.0
2021-11-11	AAME	Stock	4.15	4.24	4.08	4.13	7300.0
2021-11-11	AAMI	Stock	30.46	30.77	30.28	30.63	1529900.0
2021-11-11	AAN-DELISTED	Stock	26.16	26.64	26.16	26.54	131500.0
2021-11-11	AAOI	Stock	5.77	6.14	5.77	6.04	969700.0
2021-11-11	AAON	Stock	51.3333	51.38	50.84	51.12	140550.0
2021-11-11	AAP	Stock	234.33	240.96	234.33	238.45	771200.0
2021-11-11	AAT	Stock	39.29	39.71	38.82	39.22	121300.0
2021-11-11	AATC	Stock	6.9	6.95	6.8	6.82	14552.0
2021-11-11	AAU-DELISTED	Stock	0.41	0.4371	0.4033	0.4264	977332.0
2021-11-11	AAUAF-DELISTED	Stock	0.41	0.4371	0.4033	0.4264	1162734.0
2021-11-11	AAWW-DELISTED	Stock	84.15	85.92	83.79	85.43	223002.0
2021-11-11	AAXJ	Stock	87.1	87.61	87.05	87.44	1093672.0
2021-11-11	AB	Stock	55.28	55.68	54.9	55.53	136100.0
2021-11-11	ABB-DELISTED	Stock	34.87	34.93	34.725	34.76	801580.0
2021-11-11	ABBNY-DELISTED	Stock	34.87	34.93	34.725	34.76	894984.0
2021-11-11	ABBV	Stock	116.94	117.49	116.29	116.63	3120900.0
2021-11-11	ABC-DELISTED	Stock	125.1	125.885	123.87	125.74	365959.0
2021-11-11	ABCB	Stock	55.13	55.42	54.52	54.82	281300.0
2021-11-11	ABCL	Stock	14.22	15.11	14.21	15.05	1724800.0
2021-11-11	ABCM-DELISTED	Stock	22.73	22.91	22.65	22.88	27288.0
2021-11-11	ABEO	Stock	23.0	25.0	23.0	23.5	31840.0
2021-11-11	ABEV	Stock	3.22	3.27	3.19	3.19	22001300.0
2021-11-11	ABG	Stock	183.07	185.25	179.55	182.38	196200.0
2021-11-11	ABGI-DELISTED	Stock	9.75	9.82	9.75	9.8	451000.0
2021-11-11	ABM	Stock	48.22	48.78	48.0	48.57	279900.0
2021-11-11	ABMD-DELISTED	Stock	357.32	362.56	351.21	356.61	140470.0
2021-11-11	ABNB	Stock	195.2	197.93	190.77	191.61	5899000.0
2021-11-11	ABOS	Stock	14.33	14.33	13.33	13.41	18500.0

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

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