PREVIEW / stock_daily / 2021-12-06

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-06.parquet
  size:    261 KB
  rows:    8,030
  symbols: 2,676

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-06	AAPL	Stock	164.29	167.88	164.28	165.32	107497000.0
2021-12-06	MSFT	Stock	323.95	327.45	319.23	326.19	30032600.0
2021-12-06	NVDA	Stock	29.88	30.241	28.038	30.037	658938000.0
2021-12-06	AMZN	Stock	169.65	173.6955	166.9345	171.3685	68860000.0
2021-12-06	GOOGL	Stock	143.0405	143.8525	140.15	143.155	30618100.0
2021-12-06	META	Stock	308.13	320.1	306.34	317.87	21758300.0
2021-12-06	TSLA	Stock	333.8367	340.5467	316.8333	336.3367	81663000.0
2021-12-06	TLT	Stock	154.05	154.35	151.93	152.23	30924205.0
2021-12-06	ES	Stock	85.65	87.23	85.51	86.14	1672300.0
2021-12-06	CL	Stock	77.29	79.08	77.16	78.58	6525000.0
2021-12-06	A	Stock	149.34	152.04	147.78	151.47	1803400.0
2021-12-06	AA	Stock	44.92	46.738	44.13	45.56	7116500.0
2021-12-06	AAC-DELISTED	Stock	9.79	9.8	9.79	9.79	21085.0
2021-12-06	AACG	Stock	1.27	1.39	1.25	1.39	27600.0
2021-12-06	AACIU	Stock	10.02	10.02	10.01	10.01	5661.0
2021-12-06	AACIW-DELISTED	Stock	0.519	0.519	0.5098	0.5137	1646.0
2021-12-06	AAIC-DELISTED	Stock	3.64	3.74	3.59	3.66	275078.0
2021-12-06	AAIC.C-DELISTED	Stock	25.49	25.49	25.46	25.468	1839.0
2021-12-06	AAL	Stock	16.95	18.54	16.91	17.93	74005500.0
2021-12-06	AAM.A-DELISTED	Stock	25.31	25.3531	25.23	25.29	16379.0
2021-12-06	AAM.B-DELISTED	Stock	25.95	26.12	25.94	26.12	9084.0
2021-12-06	AAME	Stock	3.73	3.84	3.71	3.78	6400.0
2021-12-06	AAMI	Stock	27.36	28.58	27.05	28.14	1077700.0
2021-12-06	AAN-DELISTED	Stock	23.34	24.13	22.86	23.85	367700.0
2021-12-06	AAOI	Stock	5.38	5.52	5.2	5.46	536500.0
2021-12-06	AAON	Stock	53.4133	54.5333	53.0667	53.2533	327300.0
2021-12-06	AAP	Stock	229.99	233.34	229.0	230.02	657900.0
2021-12-06	AAQC-DELISTED	Stock	9.695	9.74	9.695	9.74	11940.0
2021-12-06	AAT	Stock	35.87	36.79	35.87	36.39	184700.0
2021-12-06	AATC	Stock	6.45	6.6907	6.3101	6.33	38364.0
2021-12-06	AAU-DELISTED	Stock	0.32	0.3249	0.3065	0.3198	405563.0
2021-12-06	AAUAF-DELISTED	Stock	0.32	0.3249	0.3065	0.3198	410052.0
2021-12-06	AAWW-DELISTED	Stock	87.65	88.86	86.6	87.2	379713.0
2021-12-06	AAXJ	Stock	82.89	83.81	82.58	83.81	1059944.0
2021-12-06	AB	Stock	51.27	53.0	50.66	52.44	272200.0
2021-12-06	ABB-DELISTED	Stock	35.78	36.195	35.65	36.12	1716292.0
2021-12-06	ABBNY-DELISTED	Stock	35.78	36.195	35.65	36.12	1891053.0
2021-12-06	ABBV	Stock	119.63	122.45	119.21	121.35	8939900.0
2021-12-06	ABC-DELISTED	Stock	118.45	120.5819	117.77	118.91	698325.0
2021-12-06	ABCB	Stock	49.73	51.03	49.32	50.16	273900.0
2021-12-06	ABCL	Stock	13.92	13.92	13.02	13.5	2533000.0
2021-12-06	ABCM-DELISTED	Stock	21.88	22.91	21.88	22.7	352094.0
2021-12-06	ABEO	Stock	14.75	14.75	14.0	14.75	30700.0
2021-12-06	ABEV	Stock	2.82	2.87	2.8	2.82	23329900.0
2021-12-06	ABG	Stock	167.91	176.99	166.71	174.24	332400.0
2021-12-06	ABGI-DELISTED	Stock	9.75	9.8	9.7	9.7	902313.0
2021-12-06	ABM	Stock	45.46	46.85	45.27	46.35	400400.0
2021-12-06	ABMD-DELISTED	Stock	302.07	310.25	297.22	308.55	169710.0
2021-12-06	ABNB	Stock	167.275	181.93	162.85	180.85	9813800.0
2021-12-06	ABOS	Stock	7.86	7.95	7.11	7.46	214500.0

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

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