PREVIEW / stock_daily / 2022-09-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-27.parquet
  size:    253 KB
  rows:    7,957
  symbols: 2,263

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
2022-09-27	AAPL	Stock	152.74	154.72	149.95	151.76	84442700.0
2022-09-27	MSFT	Stock	239.98	241.8	234.5	236.41	27018700.0
2022-09-27	NVDA	Stock	12.507	12.736	12.258	12.413	553854000.0
2022-09-27	AMZN	Stock	117.2	118.32	113.05	114.41	60094700.0
2022-09-27	GOOGL	Stock	99.43	100.0	96.872	97.5	30072781.0
2022-09-27	META	Stock	137.92	139.42	134.12	134.4	30826500.0
2022-09-27	TSLA	Stock	283.84	288.67	277.51	282.94	61925200.0
2022-09-27	TLT	Stock	102.71	102.98	100.9	100.95	34609453.0
2022-09-27	ES	Stock	84.86	85.17	82.35	82.49	2225900.0
2022-09-27	CL	Stock	75.36	75.64	72.53	72.58	5260600.0
2022-09-27	A	Stock	123.87	124.07	120.6	121.61	1040500.0
2022-09-27	AA	Stock	35.04	35.84	34.4	34.7	8346300.0
2022-09-27	AAC-DELISTED	Stock	9.94	9.94	9.92	9.925	112626.0
2022-09-27	AACG	Stock	1.83	1.83	1.66	1.66	8000.0
2022-09-27	AACIU	Stock	9.97	9.995	9.97	9.995	905.0
2022-09-27	AAIC-DELISTED	Stock	2.69	2.75	2.68	2.71	66069.0
2022-09-27	AAIC.C-DELISTED	Stock	19.6088	19.6088	19.0	19.0823	8451.0
2022-09-27	AAL	Stock	12.19	12.51	11.91	12.27	44010500.0
2022-09-27	AAM.A-DELISTED	Stock	23.41	23.87	23.4009	23.81	18905.0
2022-09-27	AAM.B-DELISTED	Stock	23.56	23.86	23.4667	23.83	13833.0
2022-09-27	AAMC-DELISTED	Stock	4.4294	5.0235	4.4235	5.0	15898.0
2022-09-27	AAME	Stock	2.85	3.04	2.85	2.95	4100.0
2022-09-27	AAMI	Stock	15.66	15.97	15.32	15.4	266100.0
2022-09-27	AAN-DELISTED	Stock	10.7	10.84	10.35	10.51	447300.0
2022-09-27	AAOI	Stock	2.81	2.89	2.76	2.83	260000.0
2022-09-27	AAON	Stock	36.7467	36.7867	35.86	36.44	246000.0
2022-09-27	AAP	Stock	159.19	162.17	157.83	159.31	750600.0
2022-09-27	AAQC-DELISTED	Stock	9.81	9.815	9.81	9.81	34452.0
2022-09-27	AAT	Stock	24.8	24.83	24.08	24.2	289100.0
2022-09-27	AATC	Stock	4.6	5.04	4.44	4.5484	21555.0
2022-09-27	AAU-DELISTED	Stock	0.2	0.21	0.199	0.2008	95643.0
2022-09-27	AAUAF-DELISTED	Stock	0.2	0.21	0.199	0.2	97308.0
2022-09-27	AAWW-DELISTED	Stock	97.3	97.46	93.385	95.86	2164355.0
2022-09-27	AAXJ	Stock	60.51	60.95	59.8	60.02	1128420.0
2022-09-27	AB	Stock	37.75	38.05	36.82	37.24	417200.0
2022-09-27	ABB-DELISTED	Stock	25.7	25.9091	25.28	25.47	2434811.0
2022-09-27	ABBNY-DELISTED	Stock	25.7	25.9091	25.28	25.47	2609886.0
2022-09-27	ABBV	Stock	142.59	145.54	141.29	141.72	5598000.0
2022-09-27	ABC-DELISTED	Stock	137.02	138.005	135.17	135.43	684251.0
2022-09-27	ABCB	Stock	46.13	46.68	45.0	45.4	294900.0
2022-09-27	ABCL	Stock	9.36	9.515	9.24	9.43	1693400.0
2022-09-27	ABCM-DELISTED	Stock	14.65	14.75	14.44	14.48	215865.0
2022-09-27	ABEO	Stock	2.79	3.39	2.79	3.0	78300.0
2022-09-27	ABEV	Stock	2.85	2.88	2.81	2.83	33028200.0
2022-09-27	ABG	Stock	152.44	153.09	150.03	151.71	197400.0
2022-09-27	ABGI-DELISTED	Stock	9.9	9.9	9.9	9.9	101443.0
2022-09-27	ABM	Stock	38.53	38.85	37.68	37.85	297600.0
2022-09-27	ABMD-DELISTED	Stock	245.95	248.78	240.555	244.57	119431.0
2022-09-27	ABNB	Stock	106.04	108.17	104.14	106.37	5081000.0
2022-09-27	ABOS	Stock	4.44	4.71	4.44	4.7	65000.0

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

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