PREVIEW / stock_daily / 2021-12-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-01.parquet
  size:    262 KB
  rows:    8,040
  symbols: 2,674

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-01	AAPL	Stock	167.48	170.3	164.53	164.77	152052500.0
2021-12-01	MSFT	Stock	335.13	339.28	329.39	330.08	33337600.0
2021-12-01	NVDA	Stock	33.219	33.289	31.38	31.435	484368000.0
2021-12-01	AMZN	Stock	177.25	177.994	172.08	172.186	74916000.0
2021-12-01	GOOGL	Stock	144.0	145.9502	140.912	141.0515	34055240.0
2021-12-01	META	Stock	330.29	330.5	310.29	310.6	30329600.0
2021-12-01	TSLA	Stock	386.9	390.9467	363.5867	365.0	68450400.0
2021-12-01	TLT	Stock	150.485	152.41	149.79	152.34	30838845.0
2021-12-01	ES	Stock	82.64	84.46	82.04	82.4	1254400.0
2021-12-01	CL	Stock	75.5	76.53	75.32	75.39	3716700.0
2021-12-01	A	Stock	151.12	152.85	148.09	148.21	1800900.0
2021-12-01	AA	Stock	47.89	48.05	43.75	43.78	15215300.0
2021-12-01	AAC-DELISTED	Stock	9.78	9.79	9.75	9.78	457053.0
2021-12-01	AACG	Stock	1.7	1.7	1.5	1.5	36000.0
2021-12-01	AACIU	Stock	10.03	10.03	10.03	10.03	204.0
2021-12-01	AACIW-DELISTED	Stock	0.5	0.52	0.495	0.52	20300.0
2021-12-01	AAIC-DELISTED	Stock	3.66	3.6799	3.59	3.6	157183.0
2021-12-01	AAIC.C-DELISTED	Stock	25.7	25.7	25.66	25.67	1057.0
2021-12-01	AAL	Stock	17.94	18.24	16.26	16.28	82030100.0
2021-12-01	AAM.A-DELISTED	Stock	25.27	25.52	25.15	25.2	24463.0
2021-12-01	AAM.B-DELISTED	Stock	26.13	26.41	26.02	26.07	11994.0
2021-12-01	AAME	Stock	3.9	3.94	3.81	3.82	8300.0
2021-12-01	AAMI	Stock	30.47	30.58	30.2	30.24	5922800.0
2021-12-01	AAN-DELISTED	Stock	22.82	23.2	21.85	21.89	308500.0
2021-12-01	AAOI	Stock	6.0	6.03	5.61	5.67	738200.0
2021-12-01	AAON	Stock	52.28	52.7467	51.54	51.5533	486300.0
2021-12-01	AAP	Stock	223.64	226.98	218.22	218.23	649600.0
2021-12-01	AAQC-DELISTED	Stock	9.72	9.74	9.72	9.73	22127.0
2021-12-01	AAT	Stock	35.33	35.77	33.82	33.84	345700.0
2021-12-01	AATC	Stock	6.8191	6.9	6.68	6.7	14442.0
2021-12-01	AAU-DELISTED	Stock	0.3408	0.345	0.325	0.327	494614.0
2021-12-01	AAUAF-DELISTED	Stock	0.3408	0.345	0.325	0.3274	498871.0
2021-12-01	AAWW-DELISTED	Stock	89.15	89.15	85.26	85.5	324692.0
2021-12-01	AAXJ	Stock	84.44	84.92	83.36	83.36	901592.0
2021-12-01	AB	Stock	51.0	51.52	49.57	49.95	372600.0
2021-12-01	ABB-DELISTED	Stock	34.87	35.15	34.14	34.145	1832924.0
2021-12-01	ABBNY-DELISTED	Stock	34.87	35.15	34.14	34.15	2020123.0
2021-12-01	ABBV	Stock	115.78	118.98	115.61	115.91	6287500.0
2021-12-01	ABC-DELISTED	Stock	116.42	117.14	114.03	114.04	865387.0
2021-12-01	ABCB	Stock	50.06	50.49	48.0	48.08	459300.0
2021-12-01	ABCL	Stock	14.79	15.17	14.5	14.58	1508100.0
2021-12-01	ABCM-DELISTED	Stock	22.6	22.85	22.49	22.55	55694.0
2021-12-01	ABEO	Stock	17.25	17.5	15.0	15.0	45588.0
2021-12-01	ABEV	Stock	2.82	2.86	2.74	2.75	33211500.0
2021-12-01	ABG	Stock	166.91	169.05	160.7	160.82	256200.0
2021-12-01	ABGI-DELISTED	Stock	9.83	9.83	9.83	9.83	15122.0
2021-12-01	ABM	Stock	46.15	46.49	43.83	43.83	337900.0
2021-12-01	ABMD-DELISTED	Stock	317.17	325.23	305.71	305.73	106651.0
2021-12-01	ABNB	Stock	174.01	180.13	162.03	163.08	7645700.0
2021-12-01	ABOS	Stock	8.08	8.16	7.435	7.58	80900.0

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

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