PREVIEW / stock_daily / 2023-03-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-13.parquet
  size:    246 KB
  rows:    7,630
  symbols: 1,764

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-13	AAPL	Stock	147.81	153.14	147.7	150.47	84457100.0
2023-03-13	MSFT	Stock	247.4	257.91	245.73	253.92	33339700.0
2023-03-13	NVDA	Stock	22.752	23.298	22.297	22.966	421890000.0
2023-03-13	AMZN	Stock	89.97	94.02	88.12	92.43	72397100.0
2023-03-13	GOOGL	Stock	90.09	92.57	89.42	91.11	37335573.0
2023-03-13	META	Stock	177.96	183.78	174.82	180.9	24728000.0
2023-03-13	TSLA	Stock	167.46	177.35	163.91	174.48	167790300.0
2023-03-13	TLT	Stock	108.2	109.1	105.04	105.83	51502460.0
2023-03-13	ES	Stock	73.12	76.79	72.83	74.8	2998900.0
2023-03-13	CL	Stock	71.35	73.13	71.35	71.5	5949900.0
2023-03-13	A	Stock	135.55	138.28	134.76	136.69	1771400.0
2023-03-13	AA	Stock	43.51	46.05	42.245	44.71	5585500.0
2023-03-13	AAC-DELISTED	Stock	10.28	10.28	10.2529	10.27	17454.0
2023-03-13	AACG	Stock	2.06	2.22	1.96	1.99	26500.0
2023-03-13	AACIW-DELISTED	Stock	0.1099	0.1099	0.1099	0.1099	101.0
2023-03-13	AAIC-DELISTED	Stock	2.78	2.8	2.69	2.7	89043.0
2023-03-13	AAIC.C-DELISTED	Stock	20.78	21.5221	20.78	21.5	850.0
2023-03-13	AAL	Stock	15.02	15.26	14.69	14.85	32541700.0
2023-03-13	AAM.A-DELISTED	Stock	22.18	22.3	20.9223	21.0	58429.0
2023-03-13	AAM.B-DELISTED	Stock	21.73	22.33	20.41	20.8	32016.0
2023-03-13	AAMC-DELISTED	Stock	17.2912	17.8956	15.5588	15.7371	80033.0
2023-03-13	AAME	Stock	2.34	2.49	2.29	2.45	9100.0
2023-03-13	AAMI	Stock	22.55	22.63	21.69	22.32	163000.0
2023-03-13	AAN-DELISTED	Stock	10.85	10.88	10.3	10.46	331800.0
2023-03-13	AAOI	Stock	2.61	2.75	2.59	2.67	169500.0
2023-03-13	AAON	Stock	58.64	59.7533	58.14	58.62	520950.0
2023-03-13	AAP	Stock	126.26	127.57	124.1	124.36	2016900.0
2023-03-13	AAT	Stock	19.62	19.89	18.81	19.54	1628100.0
2023-03-13	AATC	Stock	4.16	4.16	4.14	4.16	1933.0
2023-03-13	AAU-DELISTED	Stock	0.19	0.1999	0.1807	0.194	562665.0
2023-03-13	AAUAF-DELISTED	Stock	0.19	0.1999	0.1807	0.1973	570490.0
2023-03-13	AAWW-DELISTED	Stock	99.54	100.27	99.12	99.52	307113.0
2023-03-13	AAXJ	Stock	64.57	65.37	64.54	65.02	997251.0
2023-03-13	AB	Stock	35.88	36.85	35.67	36.01	297800.0
2023-03-13	ABB-DELISTED	Stock	32.65	33.25	32.53	32.91	1466532.0
2023-03-13	ABBNY-DELISTED	Stock	32.65	33.25	32.53	32.92	1660260.0
2023-03-13	ABBV	Stock	149.0	153.32	149.0	151.95	7653800.0
2023-03-13	ABC-DELISTED	Stock	148.81	151.84	148.0552	148.32	711790.0
2023-03-13	ABCB	Stock	40.0	40.0	36.04	37.14	1998100.0
2023-03-13	ABCL	Stock	7.44	7.68	7.39	7.42	2130700.0
2023-03-13	ABCM-DELISTED	Stock	14.0	15.14	13.96	14.94	676575.0
2023-03-13	ABEO	Stock	2.57	2.66	2.46	2.51	205800.0
2023-03-13	ABEV	Stock	2.57	2.61	2.56	2.56	12873300.0
2023-03-13	ABG	Stock	218.81	219.98	207.19	207.47	544300.0
2023-03-13	ABLV	Stock	10.325	10.35	10.325	10.35	2700.0
2023-03-13	ABM	Stock	44.04	44.6	43.64	44.22	440300.0
2023-03-13	ABNB	Stock	115.722	117.9	113.66	115.96	5282000.0
2023-03-13	ABOS	Stock	4.51	4.635	4.3	4.34	191600.0
2023-03-13	ABR	Stock	12.85	13.23	12.31	12.99	5768300.0
2023-03-13	ABR.D	Stock	17.63	18.0	17.3	17.41	38260.0

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

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