PREVIEW / stock_daily / 2023-04-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-18.parquet
  size:    244 KB
  rows:    7,568
  symbols: 1,703

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-04-18	AAPL	Stock	166.1	167.41	165.65	166.47	49923000.0
2023-04-18	MSFT	Stock	291.57	291.76	287.01	288.37	20161800.0
2023-04-18	NVDA	Stock	27.533	28.11	27.357	27.667	604812000.0
2023-04-18	AMZN	Stock	103.95	104.2	101.52	102.3	39790500.0
2023-04-18	GOOGL	Stock	106.49	106.54	104.07	104.5	26596445.0
2023-04-18	META	Stock	219.91	220.44	216.21	217.89	12281000.0
2023-04-18	TSLA	Stock	187.15	187.69	183.58	184.31	92067000.0
2023-04-18	TLT	Stock	103.81	104.585	103.8	104.2	15922623.0
2023-04-18	ES	Stock	78.94	79.15	78.04	78.38	1629100.0
2023-04-18	CL	Stock	75.72	75.99	75.17	75.54	3499300.0
2023-04-18	A	Stock	140.73	140.99	138.21	139.0	1218900.0
2023-04-18	AA	Stock	41.37	42.19	41.0	42.15	3753200.0
2023-04-18	AAC-DELISTED	Stock	10.37	10.37	10.35	10.355	260464.0
2023-04-18	AACG	Stock	1.93	1.94	1.86	1.89	10100.0
2023-04-18	AACIW-DELISTED	Stock	0.1	0.1	0.1	0.1	210.0
2023-04-18	AAIC-DELISTED	Stock	2.6	2.67	2.575	2.58	58003.0
2023-04-18	AAIC.C-DELISTED	Stock	21.0	21.1	20.8801	21.1	4144.0
2023-04-18	AAL	Stock	13.2	13.3	12.97	13.29	24684700.0
2023-04-18	AAM.A-DELISTED	Stock	23.76	24.21	23.505	24.19	42358.0
2023-04-18	AAM.B-DELISTED	Stock	23.38	24.92	23.38	24.85	34583.0
2023-04-18	AAMC-DELISTED	Stock	22.3176	23.4471	22.3176	22.7353	36132.0
2023-04-18	AAME	Stock	2.37	2.47	2.33	2.37	11600.0
2023-04-18	AAMI	Stock	23.72	23.95	23.59	23.92	68000.0
2023-04-18	AAN-DELISTED	Stock	10.65	10.695	10.3	10.43	270600.0
2023-04-18	AAOI	Stock	2.18	2.325	2.17	2.2	256600.0
2023-04-18	AAON	Stock	64.1467	64.9267	63.84	64.8333	598050.0
2023-04-18	AAP	Stock	127.49	128.69	126.61	126.65	1135500.0
2023-04-18	AAT	Stock	18.17	18.17	17.65	17.75	360600.0
2023-04-18	AATC	Stock	3.85	4.11	3.85	4.09	24935.0
2023-04-18	AAU-DELISTED	Stock	0.17	0.1778	0.1601	0.1609	424599.0
2023-04-18	AAUAF-DELISTED	Stock	0.17	0.1778	0.1601	0.1616	421236.0
2023-04-18	AAXJ	Stock	68.45	68.47	68.04	68.16	452138.0
2023-04-18	AB	Stock	36.72	36.88	35.91	36.18	242300.0
2023-04-18	ABB-DELISTED	Stock	35.42	35.5	35.31	35.4	1191542.0
2023-04-18	ABBNY-DELISTED	Stock	35.42	35.5	35.31	35.4	1353755.0
2023-04-18	ABBV	Stock	161.0	161.23	158.41	159.59	4996200.0
2023-04-18	ABC-DELISTED	Stock	167.49	168.0	166.1975	167.39	495997.0
2023-04-18	ABCB	Stock	34.56	34.7	33.29	33.71	323200.0
2023-04-18	ABCL	Stock	7.39	7.39	7.13	7.19	1435200.0
2023-04-18	ABCM-DELISTED	Stock	15.96	15.96	15.57	15.75	918789.0
2023-04-18	ABEO	Stock	2.88	3.04	2.87	2.93	147900.0
2023-04-18	ABEV	Stock	2.92	2.96	2.89	2.92	9485400.0
2023-04-18	ABG	Stock	206.21	210.76	204.0	208.08	212000.0
2023-04-18	ABM	Stock	43.86	44.05	42.92	43.1	201200.0
2023-04-18	ABNB	Stock	119.83	121.32	118.1	119.19	7162200.0
2023-04-18	ABOS	Stock	3.7	3.769	3.52	3.59	256400.0
2023-04-18	ABR	Stock	10.46	10.65	10.31	10.45	3940600.0
2023-04-18	ABR.D	Stock	17.46	18.0692	17.32	17.62	12552.0
2023-04-18	ABR.E	Stock	16.66	16.9999	16.5887	16.83	8398.0
2023-04-18	ABR.F	Stock	17.5	17.55	17.39	17.3999	30385.0

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

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