PREVIEW / stock_daily / 2023-07-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-20.parquet
  size:    240 KB
  rows:    7,439
  symbols: 1,527

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-07-20	AAPL	Stock	195.09	196.47	192.5	193.13	59581200.0
2023-07-20	MSFT	Stock	353.57	357.97	345.37	346.87	33778400.0
2023-07-20	NVDA	Stock	46.507	47.087	45.062	45.52	537865000.0
2023-07-20	AMZN	Stock	134.07	134.79	129.33	129.96	59820600.0
2023-07-20	GOOGL	Stock	121.42	124.09	118.22	119.2	37906763.0
2023-07-20	META	Stock	313.5	315.54	302.22	302.52	23836900.0
2023-07-20	TSLA	Stock	279.56	280.93	261.2	262.9	175158300.0
2023-07-20	TLT	Stock	102.22	102.31	101.28	101.7	56951188.0
2023-07-20	ES	Stock	72.2	73.7	71.78	73.54	1581200.0
2023-07-20	CL	Stock	75.94	77.17	75.43	77.0	4345900.0
2023-07-20	A	Stock	123.51	124.9	123.13	124.55	2278800.0
2023-07-20	AA	Stock	35.33	35.76	32.67	32.68	11962100.0
2023-07-20	AAC-DELISTED	Stock	10.58	10.58	10.55	10.565	167753.0
2023-07-20	AACG	Stock	1.42	1.42	1.4	1.4	3000.0
2023-07-20	AACIW-DELISTED	Stock	0.064	0.064	0.064	0.064	276.0
2023-07-20	AACT	Stock	10.17	10.17	10.165	10.17	11000.0
2023-07-20	AAIC-DELISTED	Stock	4.72	4.81	4.72	4.81	124369.0
2023-07-20	AAL	Stock	18.15	18.17	17.28	17.44	54010900.0
2023-07-20	AAM.A-DELISTED	Stock	22.69	23.28	22.5852	23.25	14556.0
2023-07-20	AAM.B-DELISTED	Stock	23.05	23.39	22.7001	23.04	27784.0
2023-07-20	AAMC-DELISTED	Stock	30.3882	30.5294	28.5353	28.7641	44540.0
2023-07-20	AAME	Stock	1.8	1.87	1.8	1.82	1500.0
2023-07-20	AAMI	Stock	21.62	21.949	21.465	21.9	147800.0
2023-07-20	AAN-DELISTED	Stock	15.76	15.76	15.34	15.57	218600.0
2023-07-20	AAOI	Stock	8.34	8.48	7.9	8.12	2169000.0
2023-07-20	AAON	Stock	69.0867	69.2133	67.5333	68.2467	268050.0
2023-07-20	AAP	Stock	71.75	71.76	69.98	70.01	2467500.0
2023-07-20	AAT	Stock	22.31	22.31	21.85	22.12	569500.0
2023-07-20	AATC	Stock	4.485	4.5	4.45	4.47	2597.0
2023-07-20	AAU-DELISTED	Stock	0.158	0.1635	0.1533	0.1561	288273.0
2023-07-20	AAUAF-DELISTED	Stock	0.158	0.1635	0.1533	0.1561	292227.0
2023-07-20	AAXJ	Stock	67.8	67.94	67.5201	67.62	388499.0
2023-07-20	AB	Stock	34.0	34.12	33.72	33.87	117200.0
2023-07-20	ABBNY-DELISTED	Stock	39.95	40.06	39.64	39.72	457814.0
2023-07-20	ABBV	Stock	138.84	142.72	138.55	142.19	7009800.0
2023-07-20	ABC-DELISTED	Stock	193.08	193.83	191.76	193.41	518284.0
2023-07-20	ABCB	Stock	40.28	40.35	38.89	39.76	376800.0
2023-07-20	ABCL	Stock	7.91	8.02	7.7	7.72	2423000.0
2023-07-20	ABCM-DELISTED	Stock	23.45	23.695	23.15	23.44	1606609.0
2023-07-20	ABEO	Stock	3.75	3.83	3.7	3.74	86300.0
2023-07-20	ABEV	Stock	3.03	3.1	3.0	3.09	25911600.0
2023-07-20	ABG	Stock	250.58	251.85	241.17	243.08	189400.0
2023-07-20	ABLLW	Stock	0.245	0.28	0.2267	0.27	63609.0
2023-07-20	ABM	Stock	43.79	44.03	43.21	43.99	504900.0
2023-07-20	ABNB	Stock	143.59	146.27	143.5	145.28	4246300.0
2023-07-20	ABOS	Stock	7.49	7.74	6.98	7.31	1497900.0
2023-07-20	ABR	Stock	16.84	16.87	16.59	16.66	3624400.0
2023-07-20	ABR.D	Stock	18.67	18.85	18.594	18.78	20184.0
2023-07-20	ABR.E	Stock	18.35	18.39	18.3025	18.38	3867.0
2023-07-20	ABR.F	Stock	20.17	20.41	20.17	20.3	11641.0

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

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