PREVIEW / stock_daily / 2023-03-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-07.parquet
  size:    247 KB
  rows:    7,622
  symbols: 1,793

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-07	AAPL	Stock	153.7	154.03	151.13	151.6	56182000.0
2023-03-07	MSFT	Stock	256.3	257.69	253.39	254.15	21473200.0
2023-03-07	NVDA	Stock	23.6	24.125	23.241	23.288	515154000.0
2023-03-07	AMZN	Stock	94.06	95.09	92.78	93.55	49100700.0
2023-03-07	GOOGL	Stock	94.98	95.67	93.53	93.86	27835476.0
2023-03-07	META	Stock	189.0	190.36	184.01	184.51	36701500.0
2023-03-07	TSLA	Stock	191.38	194.2	186.1	187.71	148125800.0
2023-03-07	TLT	Stock	101.46	102.365	100.88	101.72	23096462.0
2023-03-07	ES	Stock	75.74	76.01	73.79	74.06	1987800.0
2023-03-07	CL	Stock	73.25	73.37	71.05	71.5	6423000.0
2023-03-07	A	Stock	143.56	143.66	140.23	140.33	1088400.0
2023-03-07	AA	Stock	52.78	53.04	49.92	50.17	6298100.0
2023-03-07	AAC-DELISTED	Stock	10.26	10.27	10.25	10.26	25689.0
2023-03-07	AACG	Stock	2.09	2.43	2.06	2.32	385900.0
2023-03-07	AACIW-DELISTED	Stock	0.1	0.1149	0.1	0.1148	604.0
2023-03-07	AAIC-DELISTED	Stock	3.02	3.07	3.02	3.04	59596.0
2023-03-07	AAIC.C-DELISTED	Stock	21.8967	22.5941	21.8967	22.25	3870.0
2023-03-07	AAL	Stock	16.24	16.66	16.14	16.36	17951300.0
2023-03-07	AAM.A-DELISTED	Stock	23.59	23.71	22.86	22.86	27916.0
2023-03-07	AAM.B-DELISTED	Stock	23.74	23.9104	23.7	23.82	10980.0
2023-03-07	AAMC-DELISTED	Stock	17.1147	17.1147	16.4759	16.7676	19030.0
2023-03-07	AAME	Stock	2.34	2.4	2.34	2.39	3500.0
2023-03-07	AAMI	Stock	24.93	24.98	24.48	24.74	115800.0
2023-03-07	AAN-DELISTED	Stock	11.99	12.31	11.77	12.26	274200.0
2023-03-07	AAOI	Stock	2.76	2.83	2.72	2.75	42600.0
2023-03-07	AAON	Stock	62.0267	62.44	60.7467	61.5533	598650.0
2023-03-07	AAP	Stock	135.31	135.43	133.5	133.69	1085600.0
2023-03-07	AAT	Stock	24.51	24.66	23.23	23.6	802300.0
2023-03-07	AATC	Stock	4.216	4.223	4.18	4.18	4134.0
2023-03-07	AAU-DELISTED	Stock	0.199	0.2002	0.1916	0.196	231546.0
2023-03-07	AAUAF-DELISTED	Stock	0.199	0.2002	0.1916	0.196	235538.0
2023-03-07	AAWW-DELISTED	Stock	98.89	100.1763	98.8075	100.05	495557.0
2023-03-07	AAXJ	Stock	67.35	67.35	66.41	66.42	387920.0
2023-03-07	AB	Stock	38.48	38.65	37.65	37.66	173400.0
2023-03-07	ABB-DELISTED	Stock	34.11	34.16	33.5073	33.6	981217.0
2023-03-07	ABBNY-DELISTED	Stock	34.11	34.16	33.5073	33.59	1114138.0
2023-03-07	ABBV	Stock	155.57	155.67	152.05	152.93	4606900.0
2023-03-07	ABC-DELISTED	Stock	156.81	157.14	153.12	153.26	1030561.0
2023-03-07	ABCB	Stock	46.41	46.85	44.54	44.71	332400.0
2023-03-07	ABCL	Stock	8.08	8.155	7.961	8.0	1436700.0
2023-03-07	ABCM-DELISTED	Stock	15.22	15.22	14.7601	14.935	565221.0
2023-03-07	ABEO	Stock	2.68	3.07	2.68	2.8	515100.0
2023-03-07	ABEV	Stock	2.59	2.61	2.54	2.57	11776100.0
2023-03-07	ABG	Stock	235.25	240.95	234.8	235.48	169500.0
2023-03-07	ABM	Stock	48.38	48.59	47.54	47.86	360000.0
2023-03-07	ABNB	Stock	125.74	130.85	125.5	126.94	5590800.0
2023-03-07	ABOS	Stock	5.38	5.65	5.33	5.46	42600.0
2023-03-07	ABR	Stock	15.25	15.33	14.94	15.04	2342600.0
2023-03-07	ABR.D	Stock	19.0999	19.2	19.03	19.05	25657.0
2023-03-07	ABR.E	Stock	19.1507	19.73	19.1	19.2	105691.0

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

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