PREVIEW / stock_daily / 2023-01-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-11.parquet
  size:    250 KB
  rows:    7,762
  symbols: 1,947

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-01-11	AAPL	Stock	131.25	133.51	130.46	133.49	69458900.0
2023-01-11	MSFT	Stock	231.29	235.95	231.11	235.77	28669300.0
2023-01-11	NVDA	Stock	15.84	16.028	15.563	16.001	353285000.0
2023-01-11	AMZN	Stock	90.93	95.26	90.93	95.09	103126200.0
2023-01-11	GOOGL	Stock	89.18	91.6	89.01	91.52	26861969.0
2023-01-11	META	Stock	130.96	133.85	130.34	132.89	25423000.0
2023-01-11	TSLA	Stock	122.09	125.95	120.51	123.22	183810800.0
2023-01-11	TLT	Stock	104.97	105.72	104.7	105.68	18794029.0
2023-01-11	ES	Stock	86.05	86.44	84.99	85.81	1381200.0
2023-01-11	CL	Stock	78.44	78.72	76.69	77.13	9122200.0
2023-01-11	A	Stock	155.23	158.58	155.23	158.17	1241900.0
2023-01-11	AA	Stock	53.21	53.55	51.68	51.95	5176000.0
2023-01-11	AAC-DELISTED	Stock	10.12	10.14	10.12	10.13	348584.0
2023-01-11	AACG	Stock	1.39	1.41	1.28	1.38	6600.0
2023-01-11	AACIW-DELISTED	Stock	0.1	0.12	0.0502	0.12	62172.0
2023-01-11	AAIC-DELISTED	Stock	2.94	3.0	2.94	2.98	128375.0
2023-01-11	AAL	Stock	15.09	15.5	15.05	15.34	28664300.0
2023-01-11	AAM.A-DELISTED	Stock	24.05	24.21	23.85	24.0	11038.0
2023-01-11	AAM.B-DELISTED	Stock	23.56	24.28	23.56	24.25	8778.0
2023-01-11	AAMC-DELISTED	Stock	7.3979	7.4059	7.1412	7.2353	34238.0
2023-01-11	AAME	Stock	2.5	2.55	2.5	2.5	4600.0
2023-01-11	AAMI	Stock	21.19	21.47	20.975	21.2	710200.0
2023-01-11	AAN-DELISTED	Stock	13.52	14.17	13.52	14.16	245500.0
2023-01-11	AAOI	Stock	2.15	2.23	2.12	2.15	111800.0
2023-01-11	AAON	Stock	50.6667	51.0267	50.2333	50.6467	155400.0
2023-01-11	AAP	Stock	152.68	154.87	152.66	153.28	590300.0
2023-01-11	AAT	Stock	26.71	27.24	26.71	27.14	411300.0
2023-01-11	AATC	Stock	3.75	3.78	3.7	3.75	25742.0
2023-01-11	AAU-DELISTED	Stock	0.2671	0.2671	0.2426	0.2484	241117.0
2023-01-11	AAUAF-DELISTED	Stock	0.2671	0.2671	0.2426	0.2484	243887.0
2023-01-11	AAWW-DELISTED	Stock	101.5	101.711	101.45	101.5	231561.0
2023-01-11	AAXJ	Stock	69.57	70.025	69.45	69.9	2644759.0
2023-01-11	AB	Stock	38.22	38.75	37.96	38.63	184700.0
2023-01-11	ABB-DELISTED	Stock	33.15	33.41	33.045	33.41	777104.0
2023-01-11	ABBNY-DELISTED	Stock	33.18	33.41	33.045	33.4	888790.0
2023-01-11	ABBV	Stock	159.22	159.34	155.06	157.17	7492000.0
2023-01-11	ABC-DELISTED	Stock	167.7	168.84	164.76	165.4	819424.0
2023-01-11	ABCB	Stock	47.99	48.58	47.59	48.3	240800.0
2023-01-11	ABCL	Stock	9.42	9.61	9.16	9.6	1613700.0
2023-01-11	ABCM-DELISTED	Stock	16.53	16.75	15.93	16.44	734222.0
2023-01-11	ABEO	Stock	3.05	3.15	2.58	2.73	1603600.0
2023-01-11	ABEV	Stock	2.7	2.74	2.67	2.72	32105600.0
2023-01-11	ABG	Stock	189.42	195.5	189.42	191.97	132700.0
2023-01-11	ABGI-DELISTED	Stock	10.12	10.12	10.12	10.12	100.0
2023-01-11	ABM	Stock	45.92	46.88	45.35	45.91	311700.0
2023-01-11	ABNB	Stock	89.0	94.83	88.864	94.44	7718900.0
2023-01-11	ABOS	Stock	5.61	5.72	5.33	5.69	22900.0
2023-01-11	ABR	Stock	14.0	14.24	14.0	14.09	1220100.0
2023-01-11	ABR.D	Stock	19.52	19.95	19.5	19.95	22254.0
2023-01-11	ABR.E	Stock	18.65	18.9499	18.5	18.8	24988.0

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

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