PREVIEW / stock_daily / 2023-10-02

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-02.parquet
  size:    234 KB
  rows:    7,333
  symbols: 1,357

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-10-02	AAPL	Stock	171.22	174.3	170.93	173.75	52164500.0
2023-10-02	MSFT	Stock	316.28	321.89	315.18	321.8	20570000.0
2023-10-02	NVDA	Stock	44.03	45.175	43.861	44.782	433298000.0
2023-10-02	AMZN	Stock	127.28	130.47	126.54	129.46	48029700.0
2023-10-02	GOOGL	Stock	131.21	134.42	131.17	134.17	22288038.0
2023-10-02	META	Stock	302.74	307.18	301.63	306.82	16265600.0
2023-10-02	TSLA	Stock	244.81	254.28	242.62	251.6	123810400.0
2023-10-02	TLT	Stock	87.82	87.93	86.71	86.93	44704259.0
2023-10-02	ES	Stock	57.81	57.85	55.15	55.73	3621700.0
2023-10-02	CL	Stock	70.91	70.98	70.25	70.76	2634400.0
2023-10-02	A	Stock	110.9	111.8	109.77	110.9	1569000.0
2023-10-02	AA	Stock	28.69	29.33	28.33	28.84	4496000.0
2023-10-02	AAC-DELISTED	Stock	10.76	10.76	10.74	10.74	419666.0
2023-10-02	AACG	Stock	1.13	1.13	1.12	1.12	2600.0
2023-10-02	AACT	Stock	10.28	10.28	10.265	10.27	17000.0
2023-10-02	AAIC-DELISTED	Stock	4.26	4.3	4.16	4.22	67286.0
2023-10-02	AAIC.C-DELISTED	Stock	23.87	23.87	23.8	23.8	1927.0
2023-10-02	AAL	Stock	12.84	13.1	12.68	12.75	38342700.0
2023-10-02	AAMC-DELISTED	Stock	4.0529	4.25	3.9059	3.9059	18700.0
2023-10-02	AAME	Stock	1.85	1.93	1.76	1.91	9600.0
2023-10-02	AAMI	Stock	19.35	19.35	19.02	19.1	177000.0
2023-10-02	AAN-DELISTED	Stock	10.49	10.57	9.935	9.97	330200.0
2023-10-02	AAOI	Stock	11.0	11.68	10.88	11.27	2937000.0
2023-10-02	AAON	Stock	56.56	57.32	56.18	57.03	372400.0
2023-10-02	AAP	Stock	56.11	56.15	53.88	53.94	1732700.0
2023-10-02	AAT	Stock	19.41	19.41	18.85	19.04	272400.0
2023-10-02	AATC	Stock	5.87	5.87	5.67	5.678	10008.0
2023-10-02	AAU-DELISTED	Stock	0.1432	0.1478	0.135	0.137	170052.0
2023-10-02	AAUAF-DELISTED	Stock	0.1432	0.1478	0.135	0.137	178275.0
2023-10-02	AAXJ	Stock	63.5	63.52	63.1	63.26	329257.0
2023-10-02	AB	Stock	30.35	30.79	30.31	30.38	213100.0
2023-10-02	ABAT	Stock	8.82	8.84	7.75	7.86	249977.0
2023-10-02	ABBNY-DELISTED	Stock	36.0	36.074	35.67	35.73	150054.0
2023-10-02	ABBV	Stock	148.47	148.86	146.72	148.25	3827800.0
2023-10-02	ABCB	Stock	38.39	38.57	37.51	37.77	394100.0
2023-10-02	ABCL	Stock	4.6	4.6	4.43	4.46	2387300.0
2023-10-02	ABCM-DELISTED	Stock	22.64	22.69	22.61	22.645	2474301.0
2023-10-02	ABEO	Stock	4.27	4.44	4.02	4.05	147700.0
2023-10-02	ABEV	Stock	2.57	2.58	2.53	2.55	11026800.0
2023-10-02	ABG	Stock	230.41	232.9	216.88	218.85	175300.0
2023-10-02	ABLLW	Stock	0.396	0.4	0.31	0.34	275696.0
2023-10-02	ABLV	Stock	3.29	3.474	3.26	3.27	3400.0
2023-10-02	ABM	Stock	39.87	40.06	39.56	39.86	590000.0
2023-10-02	ABNB	Stock	136.55	138.0	135.36	136.56	3489100.0
2023-10-02	ABOS	Stock	4.15	4.225	4.04	4.17	360100.0
2023-10-02	ABR	Stock	15.13	15.15	14.36	14.41	3557700.0
2023-10-02	ABR.D	Stock	17.815	17.985	17.5	17.6167	14528.0
2023-10-02	ABR.E	Stock	17.75	17.75	17.4	17.4	5242.0
2023-10-02	ABR.F	Stock	18.59	18.84	18.13	18.2	22370.0
2023-10-02	ABSI	Stock	1.32	1.36	1.251	1.29	371600.0

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

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