PREVIEW / stock_daily / 2023-11-29

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-29.parquet
  size:    235 KB
  rows:    7,363
  symbols: 1,288

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-11-29	AAPL	Stock	190.9	192.09	188.97	189.37	43014200.0
2023-11-29	MSFT	Stock	383.76	384.3	377.44	378.85	28963400.0
2023-11-29	NVDA	Stock	48.379	48.762	47.86	48.14	382005000.0
2023-11-29	AMZN	Stock	147.85	148.54	145.97	146.32	40610900.0
2023-11-29	GOOGL	Stock	137.57	138.288	134.84	134.99	23967222.0
2023-11-29	META	Stock	339.69	339.9	330.78	332.2	16024500.0
2023-11-29	TSLA	Stock	249.21	252.75	242.76	244.14	135401300.0
2023-11-29	TLT	Stock	92.11	92.695	91.775	92.63	61647846.0
2023-11-29	ES	Stock	60.17	60.83	59.45	59.71	2562000.0
2023-11-29	CL	Stock	77.84	78.06	77.47	77.88	4010200.0
2023-11-29	A	Stock	125.59	127.73	125.59	127.59	2266200.0
2023-11-29	AA	Stock	26.42	27.04	26.22	26.44	6103800.0
2023-11-29	AACG	Stock	0.88	0.93	0.82	0.88	4300.0
2023-11-29	AACIW-DELISTED	Stock	0.056	0.056	0.0211	0.0211	5305.0
2023-11-29	AACT	Stock	10.37	10.37	10.37	10.37	22900.0
2023-11-29	AAIC-DELISTED	Stock	4.62	4.75	4.62	4.7	238254.0
2023-11-29	AAIC.C-DELISTED	Stock	24.1601	24.4	24.13	24.13	3232.0
2023-11-29	AAL	Stock	12.27	12.56	12.23	12.23	31763200.0
2023-11-29	AAMC-DELISTED	Stock	3.196	3.203	3.112	3.16	5500.0
2023-11-29	AAME	Stock	2.01	2.03	1.89	1.9	3400.0
2023-11-29	AAMI	Stock	17.87	17.95	17.575	17.58	108700.0
2023-11-29	AAN-DELISTED	Stock	9.11	9.33	9.03	9.06	278700.0
2023-11-29	AAOI	Stock	14.81	16.2	14.78	14.9	3232200.0
2023-11-29	AAON	Stock	62.72	63.13	61.92	62.04	212500.0
2023-11-29	AAP	Stock	51.9	53.13	50.81	51.58	1471100.0
2023-11-29	AAT	Stock	19.8	20.27	19.77	19.8	364900.0
2023-11-29	AATC	Stock	6.366	6.39	6.3	6.3	19749.0
2023-11-29	AAU-DELISTED	Stock	0.1411	0.148	0.1403	0.147	296376.0
2023-11-29	AAUAF-DELISTED	Stock	0.1411	0.148	0.1403	0.147	287341.0
2023-11-29	AAXJ	Stock	65.55	65.8	65.36	65.43	447646.0
2023-11-29	AB	Stock	28.26	28.75	28.1	28.58	315400.0
2023-11-29	ABAT	Stock	4.31	4.33	4.15	4.29	274286.0
2023-11-29	ABBNY-DELISTED	Stock	38.98	39.13	38.8501	38.95	127669.0
2023-11-29	ABBV	Stock	138.02	139.09	137.65	138.5	3996500.0
2023-11-29	ABCB	Stock	42.37	43.36	42.28	42.64	393000.0
2023-11-29	ABCL	Stock	4.75	5.025	4.69	4.78	2508600.0
2023-11-29	ABCM-DELISTED	Stock	23.96	23.975	23.95	23.96	8303913.0
2023-11-29	ABEO	Stock	5.05	5.14	4.81	4.9	313800.0
2023-11-29	ABEV	Stock	2.76	2.77	2.71	2.72	9262600.0
2023-11-29	ABG	Stock	212.31	215.29	208.9	209.29	114000.0
2023-11-29	ABLLW	Stock	0.374	0.39	0.374	0.39	18450.0
2023-11-29	ABLV	Stock	2.871	2.89	2.74	2.89	8000.0
2023-11-29	ABM	Stock	41.2	41.36	40.64	40.95	793800.0
2023-11-29	ABNB	Stock	127.0	129.583	126.06	126.48	4615400.0
2023-11-29	ABOS	Stock	2.26	2.34	2.22	2.25	308200.0
2023-11-29	ABR	Stock	12.13	12.47	12.03	12.09	5281700.0
2023-11-29	ABR.D	Stock	16.89	16.935	16.7496	16.8	12734.0
2023-11-29	ABR.E	Stock	16.69	17.16	16.59	16.59	5816.0
2023-11-29	ABR.F	Stock	18.61	18.79	18.5	18.5	10137.0
2023-11-29	ABSI	Stock	1.56	1.705	1.54	1.63	534800.0

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

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