PREVIEW / stock_daily / 2023-03-08

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-08.parquet
  size:    246 KB
  rows:    7,635
  symbols: 1,812

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-08	AAPL	Stock	152.81	153.47	151.83	152.87	47204800.0
2023-03-08	MSFT	Stock	254.04	254.54	250.81	253.7	17340200.0
2023-03-08	NVDA	Stock	23.487	24.2	23.424	24.181	513573000.0
2023-03-08	AMZN	Stock	93.6	94.17	92.18	93.92	44899100.0
2023-03-08	GOOGL	Stock	94.12	95.955	94.0	94.25	34103265.0
2023-03-08	META	Stock	182.87	185.26	181.34	184.97	19432400.0
2023-03-08	TSLA	Stock	185.04	186.5	180.0	182.0	151897800.0
2023-03-08	TLT	Stock	102.4	102.97	101.42	101.82	20252359.0
2023-03-08	ES	Stock	74.12	75.02	73.52	74.92	1896000.0
2023-03-08	CL	Stock	71.43	72.04	71.24	71.96	2942800.0
2023-03-08	A	Stock	140.15	141.58	139.38	140.9	1135900.0
2023-03-08	AA	Stock	50.41	51.24	49.75	51.02	3467000.0
2023-03-08	AAC-DELISTED	Stock	10.25	10.2728	10.25	10.26	24952.0
2023-03-08	AACG	Stock	2.32	2.48	2.32	2.42	64600.0
2023-03-08	AACIW-DELISTED	Stock	0.1035	0.1099	0.1025	0.1099	3125.0
2023-03-08	AAIC-DELISTED	Stock	3.03	3.04	3.0	3.03	78648.0
2023-03-08	AAIC.C-DELISTED	Stock	22.01	22.3	21.8	22.0	6228.0
2023-03-08	AAL	Stock	16.41	16.6	16.27	16.59	11399600.0
2023-03-08	AAM.A-DELISTED	Stock	22.98	23.276	22.87	22.87	24275.0
2023-03-08	AAM.B-DELISTED	Stock	23.75	24.59	23.54	23.83	38623.0
2023-03-08	AAMC-DELISTED	Stock	16.5794	17.0588	16.5794	17.0588	10282.0
2023-03-08	AAME	Stock	2.46	2.46	2.37	2.37	900.0
2023-03-08	AAMI	Stock	24.73	24.87	24.52	24.84	68300.0
2023-03-08	AAN-DELISTED	Stock	12.28	12.28	11.87	12.16	259500.0
2023-03-08	AAOI	Stock	2.75	2.84	2.75	2.82	50800.0
2023-03-08	AAON	Stock	61.82	61.8733	60.5067	61.4	360300.0
2023-03-08	AAP	Stock	133.37	133.54	130.94	132.21	1446600.0
2023-03-08	AAT	Stock	23.27	23.39	22.02	22.5	2915500.0
2023-03-08	AATC	Stock	4.185	4.19	4.18	4.1885	1542.0
2023-03-08	AAU-DELISTED	Stock	0.19	0.203	0.19	0.192	255909.0
2023-03-08	AAUAF-DELISTED	Stock	0.19	0.203	0.19	0.192	258681.0
2023-03-08	AAWW-DELISTED	Stock	100.04	100.95	99.6	100.5	287731.0
2023-03-08	AAXJ	Stock	66.4	66.6	66.26	66.49	552736.0
2023-03-08	AB	Stock	37.7	37.94	37.25	37.55	163700.0
2023-03-08	ABB-DELISTED	Stock	33.74	33.99	33.7217	33.9	1020331.0
2023-03-08	ABBNY-DELISTED	Stock	33.74	33.99	33.7217	33.9	1137724.0
2023-03-08	ABBV	Stock	152.79	153.74	148.54	149.6	5860100.0
2023-03-08	ABC-DELISTED	Stock	153.47	153.665	150.6	151.89	1089837.0
2023-03-08	ABCB	Stock	44.92	45.12	44.31	44.92	266800.0
2023-03-08	ABCL	Stock	8.0	8.175	7.93	8.16	1235000.0
2023-03-08	ABCM-DELISTED	Stock	14.9	15.07	14.6	14.935	632110.0
2023-03-08	ABEO	Stock	2.87	3.29	2.83	3.27	929900.0
2023-03-08	ABEV	Stock	2.6	2.64	2.59	2.63	21866600.0
2023-03-08	ABG	Stock	236.21	239.92	234.34	234.7	174500.0
2023-03-08	ABM	Stock	48.29	48.95	45.99	47.5	683200.0
2023-03-08	ABNB	Stock	126.9	127.66	124.74	125.0	3290800.0
2023-03-08	ABOS	Stock	5.45	5.67	5.31	5.52	58300.0
2023-03-08	ABR	Stock	15.1	15.12	14.52	14.8	2911000.0
2023-03-08	ABR.D	Stock	19.2299	19.23	18.72	18.8998	17201.0
2023-03-08	ABR.E	Stock	19.2	19.5737	18.9	19.16	5626.0

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

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