PREVIEW / stock_daily / 2023-07-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-21.parquet
  size:    240 KB
  rows:    7,473
  symbols: 1,546

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-21	AAPL	Stock	194.1	194.97	191.23	191.94	71917800.0
2023-07-21	MSFT	Stock	349.15	350.3	339.83	343.77	69368900.0
2023-07-21	NVDA	Stock	45.788	45.866	44.1	44.309	963769000.0
2023-07-21	AMZN	Stock	131.34	131.37	128.42	130.0	133265000.0
2023-07-21	GOOGL	Stock	120.62	120.99	118.73	120.02	71606474.0
2023-07-21	META	Stock	304.57	305.46	291.2	294.26	42089700.0
2023-07-21	TSLA	Stock	268.0	268.0	255.8	260.02	161050100.0
2023-07-21	TLT	Stock	102.16	102.345	101.63	101.73	20657453.0
2023-07-21	ES	Stock	73.81	74.81	73.63	74.31	1848200.0
2023-07-21	CL	Stock	77.25	77.57	76.71	77.19	11117900.0
2023-07-21	A	Stock	124.55	128.3	123.14	127.62	3918200.0
2023-07-21	AA	Stock	32.79	33.495	32.76	33.38	5565800.0
2023-07-21	AAC-DELISTED	Stock	10.57	10.58	10.5401	10.55	439007.0
2023-07-21	AACG	Stock	1.44	1.44	1.39	1.39	6300.0
2023-07-21	AACIW-DELISTED	Stock	0.064	0.075	0.064	0.0701	3960.0
2023-07-21	AACT	Stock	10.177	10.18	10.169	10.17	1800.0
2023-07-21	AAIC-DELISTED	Stock	4.72	4.82	4.72	4.78	60277.0
2023-07-21	AAIC.C-DELISTED	Stock	23.18	23.18	23.18	23.18	418.0
2023-07-21	AAL	Stock	17.5	17.67	17.1	17.42	28594500.0
2023-07-21	AAM.A-DELISTED	Stock	23.1	23.54	22.73	23.175	9014.0
2023-07-21	AAM.B-DELISTED	Stock	22.98	23.825	22.91	23.4934	15790.0
2023-07-21	AAMC-DELISTED	Stock	29.1176	29.4118	28.5735	28.7529	41310.0
2023-07-21	AAME	Stock	1.85	1.88	1.85	1.85	3500.0
2023-07-21	AAMI	Stock	22.12	22.13	21.68	21.75	116100.0
2023-07-21	AAN-DELISTED	Stock	15.77	15.77	15.47	15.66	213200.0
2023-07-21	AAOI	Stock	8.45	8.88	7.745	7.91	2449900.0
2023-07-21	AAON	Stock	68.6667	69.0467	67.1933	67.36	308850.0
2023-07-21	AAP	Stock	70.25	70.92	69.2	70.73	1555000.0
2023-07-21	AAT	Stock	22.25	22.25	21.83	21.99	533300.0
2023-07-21	AATC	Stock	4.49	4.49	4.4686	4.4686	2169.0
2023-07-21	AAU-DELISTED	Stock	0.1627	0.1638	0.151	0.16	190523.0
2023-07-21	AAUAF-DELISTED	Stock	0.1627	0.1638	0.151	0.16	187504.0
2023-07-21	AAXJ	Stock	67.62	67.85	67.395	67.45	343608.0
2023-07-21	AB	Stock	33.9	34.01	33.5	33.6	158100.0
2023-07-21	ABBNY-DELISTED	Stock	40.4	40.44	40.1405	40.17	311141.0
2023-07-21	ABBV	Stock	142.2	144.18	141.94	143.74	5654300.0
2023-07-21	ABC-DELISTED	Stock	193.5	194.79	192.38	192.61	924608.0
2023-07-21	ABCB	Stock	40.19	40.2	39.18	39.76	469300.0
2023-07-21	ABCL	Stock	7.76	7.86	7.53	7.85	1531100.0
2023-07-21	ABCM-DELISTED	Stock	23.5	24.04	23.3238	23.89	3895380.0
2023-07-21	ABEO	Stock	3.75	3.79	3.65	3.73	78100.0
2023-07-21	ABEV	Stock	3.13	3.21	3.12	3.16	22742900.0
2023-07-21	ABG	Stock	245.14	245.14	231.23	232.37	286100.0
2023-07-21	ABLLW	Stock	0.2775	0.2778	0.2358	0.26	31929.0
2023-07-21	ABLV	Stock	10.79	10.79	10.66	10.66	96441.0
2023-07-21	ABM	Stock	44.16	44.39	43.56	43.81	462200.0
2023-07-21	ABNB	Stock	147.0	149.99	146.91	148.77	11794500.0
2023-07-21	ABOS	Stock	7.35	7.58	7.15	7.4	779500.0
2023-07-21	ABR	Stock	16.73	16.83	16.35	16.54	3489300.0
2023-07-21	ABR.D	Stock	18.84	18.85	18.52	18.56	9088.0

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

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