PREVIEW / stock_daily / 2023-03-31

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-31.parquet
  size:    244 KB
  rows:    7,556
  symbols: 1,710

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-31	AAPL	Stock	162.44	165.0	161.91	164.9	68749800.0
2023-03-31	MSFT	Stock	283.73	289.27	283.0	288.3	32766000.0
2023-03-31	NVDA	Stock	27.14	27.834	27.105	27.777	433933000.0
2023-03-31	AMZN	Stock	102.16	103.49	101.95	103.29	56750300.0
2023-03-31	GOOGL	Stock	101.3	103.89	101.04	103.73	36863369.0
2023-03-31	META	Stock	207.24	212.17	206.77	211.94	25440300.0
2023-03-31	TSLA	Stock	197.53	207.79	197.2	207.46	170222100.0
2023-03-31	TLT	Stock	105.35	106.56	105.075	106.37	25396684.0
2023-03-31	ES	Stock	78.38	78.48	77.47	78.26	1734900.0
2023-03-31	CL	Stock	75.61	75.86	75.06	75.15	5153600.0
2023-03-31	A	Stock	135.4	138.73	134.86	138.34	2579800.0
2023-03-31	AA	Stock	41.97	42.75	41.6	42.56	3079300.0
2023-03-31	AAC-DELISTED	Stock	10.34	10.34	10.31	10.31	16556.0
2023-03-31	AACG	Stock	1.99	2.05	1.84	1.93	16900.0
2023-03-31	AAIC-DELISTED	Stock	2.76	2.87	2.73	2.86	291694.0
2023-03-31	AAIC.C-DELISTED	Stock	20.18	20.86	20.18	20.8598	3136.0
2023-03-31	AAL	Stock	14.61	14.76	14.56	14.75	12348700.0
2023-03-31	AAM.A-DELISTED	Stock	21.94	22.4299	21.46	21.46	251671.0
2023-03-31	AAM.B-DELISTED	Stock	21.9676	23.94	21.9676	22.15	91792.0
2023-03-31	AAMC-DELISTED	Stock	20.2912	20.5294	17.9412	19.1324	185382.0
2023-03-31	AAME	Stock	2.44	2.5	2.39	2.45	1800.0
2023-03-31	AAMI	Stock	23.44	23.66	23.28	23.58	230800.0
2023-03-31	AAN-DELISTED	Stock	9.21	9.705	9.195	9.66	496900.0
2023-03-31	AAOI	Stock	1.92	2.23	1.92	2.21	358000.0
2023-03-31	AAON	Stock	63.7333	64.6333	63.3867	64.46	505950.0
2023-03-31	AAP	Stock	119.9	121.74	119.65	121.61	1029200.0
2023-03-31	AAT	Stock	18.26	18.59	18.1	18.59	563600.0
2023-03-31	AATC	Stock	4.04	4.04	3.9	3.95	7247.0
2023-03-31	AAU-DELISTED	Stock	0.1999	0.2	0.185	0.19	256286.0
2023-03-31	AAUAF-DELISTED	Stock	0.1999	0.2	0.185	0.19	258904.0
2023-03-31	AAXJ	Stock	67.82	68.16	67.72	67.87	303605.0
2023-03-31	AB	Stock	36.27	36.6	35.95	36.56	139800.0
2023-03-31	ABB-DELISTED	Stock	34.22	34.355	34.125	34.31	1266068.0
2023-03-31	ABBNY-DELISTED	Stock	34.22	34.355	34.125	34.3	1420348.0
2023-03-31	ABBV	Stock	158.43	159.57	157.73	159.37	4957300.0
2023-03-31	ABC-DELISTED	Stock	160.32	161.0	158.91	160.04	968972.0
2023-03-31	ABCB	Stock	36.6	36.8	35.92	36.58	529300.0
2023-03-31	ABCL	Stock	7.48	7.585	7.45	7.54	1394500.0
2023-03-31	ABCM-DELISTED	Stock	13.21	13.58	13.13	13.465	519673.0
2023-03-31	ABEO	Stock	2.85	2.96	2.77	2.82	132400.0
2023-03-31	ABEV	Stock	2.85	2.87	2.77	2.82	27607700.0
2023-03-31	ABG	Stock	208.54	210.78	208.43	210.0	182900.0
2023-03-31	ABLV	Stock	10.34	10.34	10.34	10.34	2930.0
2023-03-31	ABM	Stock	44.75	45.05	44.62	44.94	335700.0
2023-03-31	ABNB	Stock	123.3	125.94	122.8	124.4	5533800.0
2023-03-31	ABOS	Stock	4.07	4.24	3.96	4.06	91500.0
2023-03-31	ABR	Stock	11.15	11.49	11.06	11.49	3408200.0
2023-03-31	ABR.D	Stock	17.29	17.45	16.61	17.45	20101.0
2023-03-31	ABR.E	Stock	16.5	17.26	16.5	17.0	24483.0
2023-03-31	ABR.F	Stock	17.2	17.76	17.0	17.0	172999.0

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

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