PREVIEW / stock_daily / 2023-08-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-28.parquet
  size:    236 KB
  rows:    7,369
  symbols: 1,442

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-08-28	AAPL	Stock	180.09	180.59	178.55	180.19	43820700.0
2023-08-28	MSFT	Stock	325.66	326.15	321.72	323.7	14808500.0
2023-08-28	NVDA	Stock	46.482	46.98	44.888	46.835	685192000.0
2023-08-28	AMZN	Stock	133.78	133.95	131.85	133.14	34108400.0
2023-08-28	GOOGL	Stock	131.31	132.54	130.14	131.01	20543266.0
2023-08-28	META	Stock	288.0	291.45	285.8	290.26	14239300.0
2023-08-28	TSLA	Stock	242.58	244.38	235.35	238.82	107673700.0
2023-08-28	TLT	Stock	95.65	95.66	94.8897	95.32	16037346.0
2023-08-28	ES	Stock	65.36	65.77	65.09	65.17	1351300.0
2023-08-28	CL	Stock	73.94	74.01	73.18	73.64	2871100.0
2023-08-28	A	Stock	119.95	120.94	119.34	119.92	1052400.0
2023-08-28	AA	Stock	28.6	29.02	28.38	28.48	4457500.0
2023-08-28	AAC-DELISTED	Stock	10.68	10.69	10.6736	10.685	41374.0
2023-08-28	AACG	Stock	1.19	1.23	1.19	1.21	2000.0
2023-08-28	AACT	Stock	10.21	10.22	10.21	10.21	875000.0
2023-08-28	AAIC-DELISTED	Stock	4.47	4.58	4.47	4.58	54502.0
2023-08-28	AAIC.C-DELISTED	Stock	23.9271	23.96	23.9271	23.93	783.0
2023-08-28	AAL	Stock	14.66	14.83	14.57	14.73	19455200.0
2023-08-28	AAM.A-DELISTED	Stock	25.32	25.33	25.32	25.33	43629.0
2023-08-28	AAM.B-DELISTED	Stock	25.32	25.3404	25.32	25.34	11544.0
2023-08-28	AAMC-DELISTED	Stock	5.0765	5.4706	5.0765	5.3412	55420.0
2023-08-28	AAME	Stock	2.0	2.16	2.0	2.1	11300.0
2023-08-28	AAMI	Stock	21.18	21.4	21.1	21.1	111900.0
2023-08-28	AAN-DELISTED	Stock	11.92	12.23	11.74	11.74	222300.0
2023-08-28	AAOI	Stock	13.0	14.08	12.76	12.97	2677300.0
2023-08-28	AAON	Stock	61.1	61.44	60.62	60.78	216400.0
2023-08-28	AAP	Stock	64.05	65.99	64.01	65.63	2408500.0
2023-08-28	AAT	Stock	20.9	21.48	20.88	21.3	232300.0
2023-08-28	AATC	Stock	6.0	6.06	5.75	6.01	25299.0
2023-08-28	AAU-DELISTED	Stock	0.12	0.1286	0.12	0.1247	164481.0
2023-08-28	AAUAF-DELISTED	Stock	0.12	0.1286	0.12	0.1247	168295.0
2023-08-28	AAXJ	Stock	65.11	65.56	65.07	65.47	600473.0
2023-08-28	AB	Stock	30.4	31.42	30.4	31.03	277200.0
2023-08-28	ABBNY-DELISTED	Stock	37.65	37.78	37.6	37.78	160897.0
2023-08-28	ABBV	Stock	147.09	148.07	146.77	147.43	2806900.0
2023-08-28	ABC-DELISTED	Stock	179.75	180.66	179.67	180.39	622459.0
2023-08-28	ABCB	Stock	39.75	40.45	39.75	39.97	226700.0
2023-08-28	ABCL	Stock	5.53	5.68	5.475	5.5	1063900.0
2023-08-28	ABCM-DELISTED	Stock	22.36	22.68	22.24	22.32	69944255.0
2023-08-28	ABEO	Stock	3.9	4.09	3.81	4.06	78800.0
2023-08-28	ABEV	Stock	2.83	2.9	2.8	2.88	11871800.0
2023-08-28	ABG	Stock	220.2	223.82	219.84	221.72	101700.0
2023-08-28	ABLLW	Stock	0.38375	0.4831	0.35	0.47	384876.0
2023-08-28	ABLV	Stock	4.62	5.15	4.58	4.69	67600.0
2023-08-28	ABM	Stock	45.59	46.1	45.44	45.49	217200.0
2023-08-28	ABNB	Stock	127.0	127.0	124.95	126.155	2348500.0
2023-08-28	ABOS	Stock	6.34	6.36	6.17	6.24	172900.0
2023-08-28	ABR	Stock	15.6	15.94	15.59	15.8	2780200.0
2023-08-28	ABR.D	Stock	18.88	18.9082	18.655	18.6799	5471.0
2023-08-28	ABR.E	Stock	18.515	18.52	18.5	18.5	3298.0

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

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