PREVIEW / stock_daily / 2023-02-23

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-23.parquet
  size:    247 KB
  rows:    7,632
  symbols: 1,815

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
2023-02-23	AAPL	Stock	150.09	150.34	147.24	149.4	48394200.0
2023-02-23	MSFT	Stock	255.56	256.84	250.48	254.77	29219100.0
2023-02-23	NVDA	Stock	23.44	23.888	23.025	23.664	1117995000.0
2023-02-23	AMZN	Stock	96.12	96.43	93.67	95.82	48467000.0
2023-02-23	GOOGL	Stock	91.92	91.94	89.76	90.89	41206380.0
2023-02-23	META	Stock	172.0	173.69	169.38	172.04	20017800.0
2023-02-23	TSLA	Stock	203.91	205.14	196.33	202.07	146360000.0
2023-02-23	TLT	Stock	101.54	102.59	101.47	102.3	15829077.0
2023-02-23	ES	Stock	78.92	79.24	77.75	78.04	1659600.0
2023-02-23	CL	Stock	74.41	74.77	72.92	73.66	3008600.0
2023-02-23	A	Stock	142.09	143.58	141.31	143.2	1511500.0
2023-02-23	AA	Stock	48.5	49.03	46.55	47.96	4654300.0
2023-02-23	AAC-DELISTED	Stock	10.23	10.23	10.21	10.23	247047.0
2023-02-23	AACG	Stock	1.88	1.95	1.85	1.95	22200.0
2023-02-23	AACIW-DELISTED	Stock	0.1195	0.1195	0.0832	0.1001	10300.0
2023-02-23	AAIC-DELISTED	Stock	3.05	3.05	3.02	3.035	61248.0
2023-02-23	AAIC.C-DELISTED	Stock	23.0	23.0	23.0	23.0	555.0
2023-02-23	AAL	Stock	15.66	16.17	15.5	15.87	25607100.0
2023-02-23	AAM.A-DELISTED	Stock	24.43	24.6717	24.29	24.6717	5977.0
2023-02-23	AAM.B-DELISTED	Stock	24.76	24.76	24.21	24.7	5205.0
2023-02-23	AAMC-DELISTED	Stock	11.5176	12.6176	11.4706	12.1853	58667.0
2023-02-23	AAME	Stock	2.32	2.49	2.31	2.38	11900.0
2023-02-23	AAMI	Stock	25.33	25.42	24.94	25.14	76100.0
2023-02-23	AAN-DELISTED	Stock	13.97	14.34	13.96	14.15	186800.0
2023-02-23	AAOI	Stock	3.04	3.04	2.9	3.04	456300.0
2023-02-23	AAON	Stock	52.3	53.7867	51.9133	53.58	410100.0
2023-02-23	AAP	Stock	143.4	143.98	140.14	142.01	1597600.0
2023-02-23	AAT	Stock	25.9	26.05	25.49	25.81	172200.0
2023-02-23	AATC	Stock	4.28	4.3	4.26	4.3	4193.0
2023-02-23	AAU-DELISTED	Stock	0.22	0.2227	0.2066	0.2146	474203.0
2023-02-23	AAUAF-DELISTED	Stock	0.22	0.2227	0.2066	0.22	477817.0
2023-02-23	AAWW-DELISTED	Stock	101.75	101.975	101.425	101.76	608678.0
2023-02-23	AAXJ	Stock	67.51	67.54	66.6	67.02	549907.0
2023-02-23	AB	Stock	38.86	39.63	38.76	39.53	285000.0
2023-02-23	ABB-DELISTED	Stock	33.68	33.8	33.45	33.79	950939.0
2023-02-23	ABBNY-DELISTED	Stock	33.68	33.8	33.45	33.79	1079136.0
2023-02-23	ABBV	Stock	150.9	153.57	149.17	152.07	5993300.0
2023-02-23	ABC-DELISTED	Stock	159.85	161.31	158.49	159.48	584768.0
2023-02-23	ABCB	Stock	47.41	48.33	47.21	48.29	323700.0
2023-02-23	ABCL	Stock	8.83	8.83	8.34	8.51	2095700.0
2023-02-23	ABCM-DELISTED	Stock	14.11	14.39	14.11	14.29	207480.0
2023-02-23	ABEO	Stock	2.34	2.35	2.23	2.3	193800.0
2023-02-23	ABEV	Stock	2.58	2.59	2.53	2.58	18087400.0
2023-02-23	ABG	Stock	229.81	230.95	225.8	229.39	176700.0
2023-02-23	ABGI-DELISTED	Stock	10.22	10.22	10.195	10.195	4029.0
2023-02-23	ABLV	Stock	10.295	10.295	10.2898	10.29	21960.0
2023-02-23	ABM	Stock	48.48	49.0	47.96	48.79	290100.0
2023-02-23	ABNB	Stock	128.21	128.85	121.92	125.52	7013500.0
2023-02-23	ABOS	Stock	5.28	5.42	5.26	5.28	34300.0
2023-02-23	ABR	Stock	15.43	15.45	15.16	15.36	1968300.0

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

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