PREVIEW / stock_daily / 2023-06-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-15.parquet
  size:    243 KB
  rows:    7,512
  symbols: 1,589

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-15	AAPL	Stock	183.96	186.52	183.78	186.01	65433200.0
2023-06-15	MSFT	Stock	337.48	349.84	337.2	348.1	38899100.0
2023-06-15	NVDA	Stock	42.602	43.289	42.147	42.653	568622000.0
2023-06-15	AMZN	Stock	125.21	127.69	124.32	127.11	60458500.0
2023-06-15	GOOGL	Stock	123.14	125.46	122.4	125.09	35246268.0
2023-06-15	META	Stock	272.3	283.99	271.42	281.83	25973500.0
2023-06-15	TSLA	Stock	248.4	258.95	247.29	255.9	160171200.0
2023-06-15	TLT	Stock	103.03	103.63	102.6	103.0	25731994.0
2023-06-15	ES	Stock	70.95	71.34	70.26	71.01	2275200.0
2023-06-15	CL	Stock	75.85	76.82	75.5	76.8	3947600.0
2023-06-15	A	Stock	118.88	121.74	118.73	121.23	1791100.0
2023-06-15	AA	Stock	35.67	36.24	35.35	35.97	4217500.0
2023-06-15	AAC-DELISTED	Stock	10.48	10.52	10.48	10.49	24485.0
2023-06-15	AACG	Stock	1.31	1.4	1.31	1.38	13300.0
2023-06-15	AACIW-DELISTED	Stock	0.07999	0.07999	0.07999	0.07999	521.0
2023-06-15	AACT	Stock	10.11	10.11	10.1	10.11	2061100.0
2023-06-15	AAIC-DELISTED	Stock	4.34	4.46	4.34	4.44	288334.0
2023-06-15	AAIC.C-DELISTED	Stock	22.7982	22.7982	22.5	22.51	1150.0
2023-06-15	AAL	Stock	16.45	16.65	16.4	16.65	17235100.0
2023-06-15	AAM.A-DELISTED	Stock	23.36	23.792	22.72	22.77	38562.0
2023-06-15	AAM.B-DELISTED	Stock	22.93	23.2971	22.0	22.41	39671.0
2023-06-15	AAMC-DELISTED	Stock	16.7647	19.2382	16.4471	19.0588	126307.0
2023-06-15	AAMI	Stock	22.68	22.92	22.44	22.79	161600.0
2023-06-15	AAN-DELISTED	Stock	12.99	13.67	12.99	13.61	256300.0
2023-06-15	AAOI	Stock	3.62	4.35	3.61	4.33	2347700.0
2023-06-15	AAON	Stock	62.8333	63.2	62.1067	62.5667	349800.0
2023-06-15	AAP	Stock	69.88	70.52	69.11	69.91	3276900.0
2023-06-15	AAT	Stock	19.5	19.79	19.3	19.78	293100.0
2023-06-15	AATC	Stock	4.22	4.29	4.22	4.29	315.0
2023-06-15	AAU-DELISTED	Stock	0.128	0.1282	0.125	0.1282	83036.0
2023-06-15	AAUAF-DELISTED	Stock	0.128	0.1282	0.125	0.1282	84181.0
2023-06-15	AAXJ	Stock	68.9	69.17	68.73	69.13	460585.0
2023-06-15	AB	Stock	33.78	34.41	33.76	34.35	271200.0
2023-06-15	ABBNY-DELISTED	Stock	39.12	39.82	39.12	39.7	305919.0
2023-06-15	ABBV	Stock	136.75	136.84	135.46	135.89	6614900.0
2023-06-15	ABC-DELISTED	Stock	179.58	182.2	178.55	181.89	787454.0
2023-06-15	ABCB	Stock	34.49	35.72	34.43	35.45	393600.0
2023-06-15	ABCL	Stock	7.35	7.49	7.29	7.48	1975100.0
2023-06-15	ABCM-DELISTED	Stock	18.88	19.25	18.35	19.06	712930.0
2023-06-15	ABEO	Stock	4.59	4.62	4.37	4.49	125900.0
2023-06-15	ABEV	Stock	3.14	3.16	3.09	3.13	15677100.0
2023-06-15	ABG	Stock	220.28	228.93	220.19	228.76	183000.0
2023-06-15	ABM	Stock	42.7	43.01	41.98	42.83	507200.0
2023-06-15	ABNB	Stock	122.96	128.38	122.75	127.85	5599400.0
2023-06-15	ABOS	Stock	5.9	6.15	5.59	5.61	198500.0
2023-06-15	ABR	Stock	13.99	14.28	13.98	14.19	2666100.0
2023-06-15	ABR.D	Stock	18.3802	18.3802	17.9	17.9	12666.0
2023-06-15	ABR.E	Stock	17.83	18.0064	17.7	17.795	2767.0
2023-06-15	ABR.F	Stock	19.0	19.07	18.8701	19.04	13877.0
2023-06-15	ABSI	Stock	1.73	1.78	1.63	1.71	593700.0

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

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