PREVIEW / stock_daily / 2023-06-23

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-23.parquet
  size:    242 KB
  rows:    7,475
  symbols: 1,592

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-06-23	AAPL	Stock	185.55	187.56	185.01	186.68	53079300.0
2023-06-23	MSFT	Stock	334.36	337.96	333.45	335.02	23084700.0
2023-06-23	NVDA	Stock	42.464	42.809	42.015	42.209	358140000.0
2023-06-23	AMZN	Stock	129.11	130.84	128.28	129.33	71855200.0
2023-06-23	GOOGL	Stock	121.38	122.7879	121.06	122.34	34913637.0
2023-06-23	META	Stock	281.51	289.67	278.95	288.73	50988400.0
2023-06-23	TSLA	Stock	259.29	262.45	252.8	256.6	176584100.0
2023-06-23	TLT	Stock	103.83	103.95	102.98	103.33	22901918.0
2023-06-23	ES	Stock	71.06	71.35	69.62	69.73	2878900.0
2023-06-23	CL	Stock	78.33	78.33	77.04	77.11	10964300.0
2023-06-23	A	Stock	117.76	119.71	117.58	119.42	2632600.0
2023-06-23	AA	Stock	32.73	33.3	32.55	32.84	5471400.0
2023-06-23	AAC-DELISTED	Stock	10.51	10.515	10.51	10.515	1055322.0
2023-06-23	AACG	Stock	1.37	1.41	1.35	1.36	6700.0
2023-06-23	AACIW-DELISTED	Stock	0.1358	0.1358	0.1266	0.1283	3055.0
2023-06-23	AACT	Stock	10.13	10.14	10.13	10.14	395083.0
2023-06-23	AAIC-DELISTED	Stock	4.38	4.4	4.28	4.29	93197.0
2023-06-23	AAL	Stock	15.94	16.33	15.92	16.26	24406900.0
2023-06-23	AAM.A-DELISTED	Stock	23.2	23.22	22.63	22.63	9201.0
2023-06-23	AAM.B-DELISTED	Stock	22.4	23.19	22.205	22.43	15252.0
2023-06-23	AAMC-DELISTED	Stock	16.6147	17.5294	16.0294	16.7059	48916.0
2023-06-23	AAME	Stock	2.03	2.17	2.03	2.11	9300.0
2023-06-23	AAMI	Stock	20.64	20.82	20.17	20.33	880500.0
2023-06-23	AAN-DELISTED	Stock	12.78	12.94	12.57	12.61	330800.0
2023-06-23	AAOI	Stock	3.77	4.38	3.73	4.34	2503300.0
2023-06-23	AAON	Stock	63.8067	64.9	63.18	63.56	724350.0
2023-06-23	AAP	Stock	67.67	67.67	65.65	65.67	3297300.0
2023-06-23	AAT	Stock	18.22	18.46	17.83	18.08	1115000.0
2023-06-23	AATC	Stock	4.39	4.39	4.35	4.38	4682.0
2023-06-23	AAU-DELISTED	Stock	0.1287	0.129	0.1275	0.128	322906.0
2023-06-23	AAUAF-DELISTED	Stock	0.1287	0.129	0.1275	0.128	323918.0
2023-06-23	AAXJ	Stock	66.13	66.13	65.58	65.8	435561.0
2023-06-23	AB	Stock	31.99	32.25	31.55	31.77	378500.0
2023-06-23	ABBNY-DELISTED	Stock	38.05	38.29	38.02	38.04	1492646.0
2023-06-23	ABBV	Stock	137.3	138.69	135.67	135.92	7394900.0
2023-06-23	ABC-DELISTED	Stock	188.19	188.745	186.85	187.73	1459244.0
2023-06-23	ABCB	Stock	32.74	33.48	32.74	33.3	775100.0
2023-06-23	ABCL	Stock	7.11	7.415	7.03	7.31	29466700.0
2023-06-23	ABCM-DELISTED	Stock	22.26	23.25	21.73	22.98	6792031.0
2023-06-23	ABEO	Stock	5.27	5.29	4.6	4.97	308700.0
2023-06-23	ABEV	Stock	3.22	3.23	3.2	3.2	10130500.0
2023-06-23	ABG	Stock	227.58	232.0	226.38	228.36	362800.0
2023-06-23	ABM	Stock	40.69	41.17	40.4	40.53	925800.0
2023-06-23	ABNB	Stock	125.99	126.8	124.0	124.73	5794100.0
2023-06-23	ABOS	Stock	5.61	5.68	5.4	5.42	62900.0
2023-06-23	ABR	Stock	13.9	13.96	13.58	13.65	7507400.0
2023-06-23	ABR.D	Stock	18.22	18.25	18.18	18.22	4524.0
2023-06-23	ABR.E	Stock	18.16	18.2199	18.16	18.2199	800.0
2023-06-23	ABR.F	Stock	19.28	19.3	19.15	19.24	7710.0
2023-06-23	ABSI	Stock	1.78	1.84	1.72	1.77	7012800.0

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

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