PREVIEW / stock_daily / 2023-03-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-06.parquet
  size:    247 KB
  rows:    7,643
  symbols: 1,802

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-03-06	AAPL	Stock	153.79	156.3	153.46	153.83	87558000.0
2023-03-06	MSFT	Stock	256.43	260.12	255.98	256.87	24109800.0
2023-03-06	NVDA	Stock	23.891	24.248	23.487	23.554	437429000.0
2023-03-06	AMZN	Stock	95.19	96.55	93.74	93.75	52112400.0
2023-03-06	GOOGL	Stock	94.015	95.97	94.0	95.13	32639313.0
2023-03-06	META	Stock	188.0	189.66	184.64	184.9	33209400.0
2023-03-06	TSLA	Stock	198.54	198.6	192.3	193.81	128100100.0
2023-03-06	TLT	Stock	102.22	102.34	100.99	101.1	16631871.0
2023-03-06	ES	Stock	75.56	75.91	74.96	75.69	1768500.0
2023-03-06	CL	Stock	73.7	74.04	73.22	73.29	3001600.0
2023-03-06	A	Stock	143.35	145.44	142.68	143.23	1153600.0
2023-03-06	AA	Stock	54.01	54.9	53.38	53.69	5129900.0
2023-03-06	AAC-DELISTED	Stock	10.24	10.27	10.24	10.26	89805.0
2023-03-06	AACG	Stock	1.98	1.98	1.91	1.95	647600.0
2023-03-06	AACIW-DELISTED	Stock	0.11	0.11	0.108	0.108	2850.0
2023-03-06	AAIC-DELISTED	Stock	3.01	3.05	3.01	3.03	66736.0
2023-03-06	AAIC.C-DELISTED	Stock	22.11	22.59	22.0	22.59	1385.0
2023-03-06	AAL	Stock	16.47	16.55	16.1	16.12	13504800.0
2023-03-06	AAM.A-DELISTED	Stock	23.72	23.8099	23.445	23.7087	12004.0
2023-03-06	AAM.B-DELISTED	Stock	23.61	24.1	23.6	23.8737	11990.0
2023-03-06	AAMC-DELISTED	Stock	15.8529	17.1941	15.7412	16.9088	93180.0
2023-03-06	AAME	Stock	2.32	2.41	2.32	2.39	4000.0
2023-03-06	AAMI	Stock	25.41	25.65	24.72	24.85	156800.0
2023-03-06	AAN-DELISTED	Stock	12.79	12.85	11.96	12.0	575400.0
2023-03-06	AAOI	Stock	2.73	2.86	2.71	2.78	120700.0
2023-03-06	AAON	Stock	62.6667	62.9667	61.6933	62.0333	635700.0
2023-03-06	AAP	Stock	139.04	139.23	135.11	135.13	1607300.0
2023-03-06	AAT	Stock	24.91	24.94	24.39	24.46	335400.0
2023-03-06	AATC	Stock	4.35	4.35	4.16	4.176	11877.0
2023-03-06	AAU-DELISTED	Stock	0.2	0.206	0.1991	0.1998	398960.0
2023-03-06	AAUAF-DELISTED	Stock	0.2	0.206	0.1991	0.2002	403417.0
2023-03-06	AAWW-DELISTED	Stock	99.75	99.92	97.75	99.095	1271910.0
2023-03-06	AAXJ	Stock	67.84	68.005	67.47	67.47	948267.0
2023-03-06	AB	Stock	39.17	39.25	38.33	38.61	244500.0
2023-03-06	ABB-DELISTED	Stock	34.03	34.356	34.01	34.22	1469583.0
2023-03-06	ABBNY-DELISTED	Stock	34.03	34.356	34.01	34.23	1908684.0
2023-03-06	ABBV	Stock	155.79	156.46	154.54	155.28	4051900.0
2023-03-06	ABC-DELISTED	Stock	155.51	156.88	154.64	156.45	872104.0
2023-03-06	ABCB	Stock	47.23	47.5	46.4	46.65	426400.0
2023-03-06	ABCL	Stock	8.38	8.41	8.075	8.1	1594600.0
2023-03-06	ABCM-DELISTED	Stock	15.4	15.4	15.14	15.27	441232.0
2023-03-06	ABEO	Stock	2.59	2.74	2.46	2.69	165400.0
2023-03-06	ABEV	Stock	2.52	2.62	2.52	2.61	24846200.0
2023-03-06	ABG	Stock	236.31	240.5	233.1	235.44	281800.0
2023-03-06	ABLV	Stock	10.32	10.32	10.32	10.32	102.0
2023-03-06	ABM	Stock	48.69	48.94	48.0	48.35	371200.0
2023-03-06	ABNB	Stock	126.355	129.44	125.28	126.33	5292500.0
2023-03-06	ABOS	Stock	5.18	5.735	5.145	5.4	56100.0
2023-03-06	ABR	Stock	15.18	15.3	15.11	15.24	3569400.0
2023-03-06	ABR.D	Stock	19.29	19.29	18.9904	19.1	17544.0

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

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