PREVIEW / stock_daily / 2023-07-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-17.parquet
  size:    240 KB
  rows:    7,454
  symbols: 1,535

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-07-17	AAPL	Stock	191.9	194.32	191.81	193.99	50520200.0
2023-07-17	MSFT	Stock	345.68	346.99	342.2	345.73	20363900.0
2023-07-17	NVDA	Stock	46.289	46.496	45.262	46.461	510488000.0
2023-07-17	AMZN	Stock	134.56	135.62	133.21	133.56	48450200.0
2023-07-17	GOOGL	Stock	125.94	127.0999	124.195	124.65	25716215.0
2023-07-17	META	Stock	307.54	311.71	304.71	310.62	25323100.0
2023-07-17	TSLA	Stock	286.63	292.23	283.57	290.38	131569600.0
2023-07-17	TLT	Stock	101.23	101.485	100.92	101.34	18828245.0
2023-07-17	ES	Stock	72.4	72.62	71.54	72.18	2068500.0
2023-07-17	CL	Stock	76.29	76.38	75.42	75.58	5938900.0
2023-07-17	A	Stock	119.95	119.98	117.66	118.25	1123000.0
2023-07-17	AA	Stock	34.35	36.05	34.25	35.57	6405900.0
2023-07-17	AAC-DELISTED	Stock	10.59	10.59	10.57	10.59	35906.0
2023-07-17	AACG	Stock	1.44	1.46	1.44	1.44	2100.0
2023-07-17	AACT	Stock	10.165	10.17	10.16	10.16	13500.0
2023-07-17	AAIC-DELISTED	Stock	4.69	4.69	4.63	4.68	228915.0
2023-07-17	AAIC.C-DELISTED	Stock	23.34	23.34	23.2	23.2	928.0
2023-07-17	AAL	Stock	18.04	18.38	18.0	18.18	14825400.0
2023-07-17	AAM.A-DELISTED	Stock	23.13	23.1399	22.55	22.55	17358.0
2023-07-17	AAM.B-DELISTED	Stock	22.81	23.2	22.46	22.55	32906.0
2023-07-17	AAMC-DELISTED	Stock	33.4882	33.4882	30.6	30.9471	78540.0
2023-07-17	AAME	Stock	1.89	1.89	1.8	1.8	3600.0
2023-07-17	AAMI	Stock	21.31	21.48	21.24	21.25	156200.0
2023-07-17	AAN-DELISTED	Stock	14.69	15.17	14.643	15.09	226900.0
2023-07-17	AAOI	Stock	9.01	9.83	8.54	8.89	3893600.0
2023-07-17	AAON	Stock	66.3733	69.84	66.3733	69.2133	507000.0
2023-07-17	AAP	Stock	70.67	70.71	68.86	69.48	2062000.0
2023-07-17	AAT	Stock	20.75	20.95	20.64	20.85	350100.0
2023-07-17	AATC	Stock	4.41	4.46	4.4	4.46	9968.0
2023-07-17	AAU-DELISTED	Stock	0.15	0.15	0.141	0.1436	140163.0
2023-07-17	AAUAF-DELISTED	Stock	0.15	0.15	0.141	0.1436	136058.0
2023-07-17	AAXJ	Stock	68.51	68.89	68.3	68.88	374176.0
2023-07-17	AB	Stock	33.44	33.9	33.07	33.79	222700.0
2023-07-17	ABBNY-DELISTED	Stock	39.07	39.44	39.07	39.32	153852.0
2023-07-17	ABBV	Stock	135.82	136.23	134.56	134.83	4033000.0
2023-07-17	ABC-DELISTED	Stock	191.61	192.42	191.09	192.13	407004.0
2023-07-17	ABCB	Stock	36.32	37.79	36.24	37.45	507100.0
2023-07-17	ABCL	Stock	7.16	7.62	7.021	7.55	1744400.0
2023-07-17	ABCM-DELISTED	Stock	23.85	24.01	23.79	23.875	654006.0
2023-07-17	ABEO	Stock	3.88	4.08	3.85	4.0	156400.0
2023-07-17	ABEV	Stock	3.03	3.05	2.99	3.04	16989000.0
2023-07-17	ABG	Stock	242.66	246.92	240.88	244.23	140400.0
2023-07-17	ABLLW	Stock	0.3762	0.3799	0.3003	0.33	61317.0
2023-07-17	ABLV	Stock	10.6	10.6	10.59	10.59	3103.0
2023-07-17	ABM	Stock	42.46	42.78	42.3	42.36	391300.0
2023-07-17	ABNB	Stock	142.29	147.4	142.29	145.36	5755800.0
2023-07-17	ABOS	Stock	11.01	11.31	9.26	9.72	29215900.0
2023-07-17	ABR	Stock	15.78	16.1	15.7	16.08	2030600.0
2023-07-17	ABR.D	Stock	18.63	18.63	17.61	18.3	28116.0
2023-07-17	ABR.E	Stock	18.1601	18.3	18.1425	18.3	6812.0

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

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