PREVIEW / stock_daily / 2023-07-12

all stock daily files

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

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-12	AAPL	Stock	189.68	191.7	188.47	189.77	60750200.0
2023-07-12	MSFT	Stock	336.6	341.65	335.67	337.2	29995300.0
2023-07-12	NVDA	Stock	43.033	43.935	42.777	43.902	481277000.0
2023-07-12	AMZN	Stock	130.31	131.26	128.83	130.8	54022800.0
2023-07-12	GOOGL	Stock	118.8	120.33	118.4145	118.93	30404409.0
2023-07-12	META	Stock	301.75	309.45	300.1	309.34	36677100.0
2023-07-12	TSLA	Stock	276.33	276.52	271.46	271.99	95672100.0
2023-07-12	TLT	Stock	100.1	101.12	99.765	100.83	31927964.0
2023-07-12	ES	Stock	71.97	72.65	71.58	72.42	1644900.0
2023-07-12	CL	Stock	75.46	75.73	75.01	75.16	5291500.0
2023-07-12	A	Stock	120.0	120.49	119.15	120.0	1595400.0
2023-07-12	AA	Stock	35.81	35.95	35.0	35.05	4288700.0
2023-07-12	AAC-DELISTED	Stock	10.56	10.59	10.56	10.57	39090.0
2023-07-12	AACG	Stock	1.38	1.54	1.38	1.52	18000.0
2023-07-12	AACIW-DELISTED	Stock	0.0822	0.0822	0.07	0.07	3256.0
2023-07-12	AAIC-DELISTED	Stock	4.65	4.69	4.625	4.63	309810.0
2023-07-12	AAIC.C-DELISTED	Stock	23.1	23.2	23.09	23.1	2600.0
2023-07-12	AAL	Stock	18.93	19.07	18.49	18.57	23388600.0
2023-07-12	AAM.A-DELISTED	Stock	22.81	23.33	22.72	22.88	15520.0
2023-07-12	AAM.B-DELISTED	Stock	22.96	23.17	22.86	23.013	4498.0
2023-07-12	AAMC-DELISTED	Stock	33.2118	36.4706	32.7147	35.7353	57630.0
2023-07-12	AAME	Stock	1.96	2.04	1.9	1.93	30300.0
2023-07-12	AAMI	Stock	20.74	21.64	20.73	21.61	701900.0
2023-07-12	AAN-DELISTED	Stock	14.55	14.83	14.37	14.55	313100.0
2023-07-12	AAOI	Stock	10.32	10.379	8.88	9.54	6554000.0
2023-07-12	AAON	Stock	64.2	65.5133	63.5667	64.66	393150.0
2023-07-12	AAP	Stock	71.26	71.55	70.48	70.75	2701200.0
2023-07-12	AAT	Stock	20.93	21.14	20.56	20.59	350500.0
2023-07-12	AATC	Stock	4.395	4.4	4.37	4.39	1360.0
2023-07-12	AAU-DELISTED	Stock	0.14	0.1474	0.1379	0.1427	394167.0
2023-07-12	AAUAF-DELISTED	Stock	0.14	0.1474	0.1379	0.1426	387504.0
2023-07-12	AAXJ	Stock	67.6	68.39	67.6	68.27	535149.0
2023-07-12	AB	Stock	31.99	32.89	31.96	32.46	295900.0
2023-07-12	ABBNY-DELISTED	Stock	39.12	39.39	38.97	39.28	557206.0
2023-07-12	ABBV	Stock	135.82	136.6	134.79	134.98	4944100.0
2023-07-12	ABC-DELISTED	Stock	192.04	193.3	190.46	190.81	918639.0
2023-07-12	ABCB	Stock	35.86	36.34	35.43	36.22	509300.0
2023-07-12	ABCL	Stock	6.96	7.785	6.95	7.55	5411600.0
2023-07-12	ABCM-DELISTED	Stock	24.25	24.49	23.84	23.96	1733053.0
2023-07-12	ABEO	Stock	4.1	4.15	3.93	3.95	185300.0
2023-07-12	ABEV	Stock	3.02	3.05	3.02	3.02	8131500.0
2023-07-12	ABG	Stock	255.05	255.05	249.02	251.19	225800.0
2023-07-12	ABLLW	Stock	0.33	0.35	0.3031	0.3086	83594.0
2023-07-12	ABLV	Stock	10.59	10.6	10.59	10.6	3370.0
2023-07-12	ABM	Stock	43.15	43.26	42.33	42.54	430800.0
2023-07-12	ABNB	Stock	139.35	140.32	135.52	137.02	5583600.0
2023-07-12	ABOS	Stock	6.08	6.95	5.9	6.15	1187200.0
2023-07-12	ABR	Stock	15.96	16.07	15.76	15.78	2868800.0
2023-07-12	ABR.D	Stock	18.83	18.9	18.6	18.79	38041.0
2023-07-12	ABR.E	Stock	18.42	18.505	18.37	18.45	33927.0

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

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