PREVIEW / stock_daily / 2023-06-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-21.parquet
  size:    242 KB
  rows:    7,513
  symbols: 1,600

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-21	AAPL	Stock	184.9	185.41	182.59	183.96	49515700.0
2023-06-21	MSFT	Stock	336.37	337.73	332.07	333.56	25117800.0
2023-06-21	NVDA	Stock	43.501	43.615	42.08	43.045	551603000.0
2023-06-21	AMZN	Stock	125.64	126.73	123.85	124.83	52137700.0
2023-06-21	GOOGL	Stock	122.4	122.66	120.1	120.55	30306336.0
2023-06-21	META	Stock	283.53	284.0	278.36	281.64	20556200.0
2023-06-21	TSLA	Stock	275.13	276.99	257.78	259.46	211797100.0
2023-06-21	TLT	Stock	102.81	103.65	102.34	103.56	19720142.0
2023-06-21	ES	Stock	70.31	71.34	69.43	71.23	1649000.0
2023-06-21	CL	Stock	77.63	77.94	77.22	77.62	3618100.0
2023-06-21	A	Stock	117.79	119.11	117.27	118.33	1393400.0
2023-06-21	AA	Stock	33.7	35.13	33.577	34.91	4907500.0
2023-06-21	AAC-DELISTED	Stock	10.51	10.5299	10.5	10.51	50026.0
2023-06-21	AACG	Stock	1.44	1.45	1.4	1.4	9500.0
2023-06-21	AACIU	Stock	10.33	10.35	10.3	10.3	995.0
2023-06-21	AACIW-DELISTED	Stock	0.06139	0.15	0.06139	0.1429	28366.0
2023-06-21	AACT	Stock	10.13	10.13	10.12	10.12	8195.0
2023-06-21	AAIC-DELISTED	Stock	4.26	4.43	4.26	4.41	280438.0
2023-06-21	AAIC.C-DELISTED	Stock	22.65	22.8525	22.65	22.696	3864.0
2023-06-21	AAL	Stock	16.25	16.35	16.0	16.3	18543400.0
2023-06-21	AAM.A-DELISTED	Stock	22.71	23.34	22.44	23.2	13100.0
2023-06-21	AAM.B-DELISTED	Stock	22.41	22.96	22.4	22.9	9914.0
2023-06-21	AAMC-DELISTED	Stock	16.6029	16.9118	15.7824	16.6147	41589.0
2023-06-21	AAME	Stock	2.1	2.1	2.1	2.1	100.0
2023-06-21	AAMI	Stock	21.64	21.83	21.28	21.29	156500.0
2023-06-21	AAN-DELISTED	Stock	13.34	13.53	13.19	13.3	154400.0
2023-06-21	AAOI	Stock	4.95	5.15	4.05	4.165	6117700.0
2023-06-21	AAON	Stock	64.6667	66.9733	64.3533	66.7	599850.0
2023-06-21	AAP	Stock	67.78	69.84	67.45	68.72	2956300.0
2023-06-21	AAT	Stock	19.16	19.25	18.85	19.1	245000.0
2023-06-21	AATC	Stock	4.33	4.42	4.27	4.28	8346.0
2023-06-21	AAU-DELISTED	Stock	0.128	0.1298	0.126	0.128	148831.0
2023-06-21	AAUAF-DELISTED	Stock	0.128	0.1298	0.126	0.128	154216.0
2023-06-21	AAXJ	Stock	67.0	67.19	66.78	66.96	280388.0
2023-06-21	AB	Stock	32.65	32.76	32.14	32.47	397300.0
2023-06-21	ABBNY-DELISTED	Stock	38.61	38.79	38.5	38.5	580571.0
2023-06-21	ABBV	Stock	136.75	137.43	134.68	136.86	5828400.0
2023-06-21	ABC-DELISTED	Stock	185.47	186.79	185.0	185.81	960328.0
2023-06-21	ABCB	Stock	34.51	34.64	33.97	34.09	598100.0
2023-06-21	ABCL	Stock	7.45	7.5	7.111	7.26	3459300.0
2023-06-21	ABCM-DELISTED	Stock	20.15	20.68	20.07	20.08	2353650.0
2023-06-21	ABEO	Stock	4.49	5.03	4.31	4.83	181900.0
2023-06-21	ABEV	Stock	3.13	3.19	3.11	3.19	15233700.0
2023-06-21	ABG	Stock	225.09	229.2	222.87	226.48	143500.0
2023-06-21	ABM	Stock	41.32	42.15	41.23	41.66	529800.0
2023-06-21	ABNB	Stock	125.09	129.26	125.09	127.46	4711900.0
2023-06-21	ABOS	Stock	5.99	5.99	5.55	5.71	122600.0
2023-06-21	ABR	Stock	14.24	14.6	14.04	14.43	16966500.0
2023-06-21	ABR.D	Stock	18.14	18.25	18.0974	18.21	9052.0
2023-06-21	ABR.E	Stock	18.03	18.31	18.03	18.21	11356.0

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

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