PREVIEW / stock_daily / 2023-07-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-11.parquet
  size:    241 KB
  rows:    7,503
  symbols: 1,561

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-11	AAPL	Stock	189.16	189.3	186.6	188.08	46638100.0
2023-07-11	MSFT	Stock	331.06	332.86	327.0	332.47	26698200.0
2023-07-11	NVDA	Stock	42.481	42.758	42.067	42.405	298244000.0
2023-07-11	AMZN	Stock	127.75	129.77	127.35	128.78	49951500.0
2023-07-11	GOOGL	Stock	116.29	117.71	115.35	117.14	23078782.0
2023-07-11	META	Stock	293.9	300.18	291.9	298.29	27585900.0
2023-07-11	TSLA	Stock	268.65	270.9	266.37	269.79	91972400.0
2023-07-11	TLT	Stock	99.57	99.97	99.29	99.72	20491147.0
2023-07-11	ES	Stock	70.35	71.38	70.25	71.36	1373600.0
2023-07-11	CL	Stock	75.97	75.97	74.65	75.39	5200200.0
2023-07-11	A	Stock	118.3	118.98	117.64	118.48	1096700.0
2023-07-11	AA	Stock	33.6	34.87	33.33	34.69	5218400.0
2023-07-11	AAC-DELISTED	Stock	10.56	10.59	10.55	10.57	136305.0
2023-07-11	AACG	Stock	1.39	1.42	1.39	1.4	4400.0
2023-07-11	AACT	Stock	10.15	10.17	10.15	10.16	54100.0
2023-07-11	AAIC-DELISTED	Stock	4.59	4.65	4.57	4.63	371161.0
2023-07-11	AAIC.C-DELISTED	Stock	22.95	23.0537	22.95	23.04	1346.0
2023-07-11	AAL	Stock	18.64	18.87	18.44	18.8	23613200.0
2023-07-11	AAM.A-DELISTED	Stock	22.82	22.9999	22.6931	22.92	12964.0
2023-07-11	AAM.B-DELISTED	Stock	22.83	23.0	22.75	23.0	12705.0
2023-07-11	AAMC-DELISTED	Stock	33.1941	34.4118	31.1765	32.1765	35020.0
2023-07-11	AAME	Stock	1.91	1.93	1.9	1.93	10000.0
2023-07-11	AAMI	Stock	20.27	20.58	20.01	20.29	248000.0
2023-07-11	AAN-DELISTED	Stock	13.99	14.41	13.89	14.32	309400.0
2023-07-11	AAOI	Stock	8.615	10.0	8.55	9.75	7547200.0
2023-07-11	AAON	Stock	63.4067	64.0533	63.1133	63.4133	304200.0
2023-07-11	AAP	Stock	69.16	70.84	69.16	70.12	1925500.0
2023-07-11	AAT	Stock	20.11	20.6	19.96	20.54	295600.0
2023-07-11	AATC	Stock	4.36	4.36	4.36	4.36	501.0
2023-07-11	AAU-DELISTED	Stock	0.134	0.1489	0.134	0.1486	343477.0
2023-07-11	AAUAF-DELISTED	Stock	0.134	0.1489	0.134	0.1486	343097.0
2023-07-11	AAXJ	Stock	66.7	66.92	66.38	66.85	275215.0
2023-07-11	AB	Stock	31.79	32.1	31.43	31.78	400000.0
2023-07-11	ABBNY-DELISTED	Stock	38.18	38.26	38.04	38.18	279577.0
2023-07-11	ABBV	Stock	134.0	135.76	133.68	135.57	5144800.0
2023-07-11	ABC-DELISTED	Stock	192.87	193.83	192.1	193.22	400131.0
2023-07-11	ABCB	Stock	34.65	35.24	34.37	35.0	371100.0
2023-07-11	ABCL	Stock	6.82	7.035	6.66	6.75	1923800.0
2023-07-11	ABCM-DELISTED	Stock	24.28	24.46	23.98	24.08	1736360.0
2023-07-11	ABEO	Stock	4.07	4.17	4.04	4.1	38000.0
2023-07-11	ABEV	Stock	2.97	3.0	2.94	3.0	15806100.0
2023-07-11	ABG	Stock	245.87	256.39	245.27	250.85	239800.0
2023-07-11	ABLLW	Stock	0.3	0.32	0.3	0.3031	115410.0
2023-07-11	ABM	Stock	41.96	42.62	41.64	42.54	504000.0
2023-07-11	ABNB	Stock	129.45	138.09	128.77	137.54	10045600.0
2023-07-11	ABOS	Stock	5.748	6.39	5.32	6.0	4936700.0
2023-07-11	ABR	Stock	15.35	15.69	15.32	15.69	3306300.0
2023-07-11	ABR.D	Stock	18.65	18.74	18.56	18.74	35073.0
2023-07-11	ABR.E	Stock	18.34	18.36	18.2999	18.36	8325.0
2023-07-11	ABR.F	Stock	20.105	20.3	19.9	20.18	20815.0

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

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