PREVIEW / stock_daily / 2023-09-29

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-29.parquet
  size:    236 KB
  rows:    7,375
  symbols: 1,382

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-09-29	AAPL	Stock	172.02	173.07	170.34	171.21	51814200.0
2023-09-29	MSFT	Stock	317.75	319.47	314.98	315.75	24140300.0
2023-09-29	NVDA	Stock	43.827	44.144	43.307	43.499	397830000.0
2023-09-29	AMZN	Stock	128.2	129.15	126.32	127.12	62377600.0
2023-09-29	GOOGL	Stock	133.28	134.05	130.36	130.86	30859790.0
2023-09-29	META	Stock	307.38	310.64	299.36	300.21	25356600.0
2023-09-29	TSLA	Stock	250.0	254.77	246.35	250.22	128346200.0
2023-09-29	TLT	Stock	89.27	89.49	88.13	88.69	49010145.0
2023-09-29	ES	Stock	58.01	58.83	57.61	58.15	3915000.0
2023-09-29	CL	Stock	71.79	71.79	70.72	71.11	3226300.0
2023-09-29	A	Stock	113.12	113.17	111.45	111.82	1830100.0
2023-09-29	AA	Stock	29.07	29.83	28.97	29.06	7721900.0
2023-09-29	AAC-DELISTED	Stock	10.73	10.76	10.73	10.75	30516.0
2023-09-29	AACG	Stock	1.12	1.16	1.12	1.12	1500.0
2023-09-29	AACT	Stock	10.26	10.27	10.26	10.27	604300.0
2023-09-29	AAIC-DELISTED	Stock	4.23	4.32	4.23	4.28	102610.0
2023-09-29	AAIC.C-DELISTED	Stock	23.9001	24.2699	23.81	23.84	3586.0
2023-09-29	AAL	Stock	13.02	13.07	12.65	12.81	33956200.0
2023-09-29	AAMC-DELISTED	Stock	4.0882	4.1235	4.0588	4.0588	13090.0
2023-09-29	AAME	Stock	1.94	1.94	1.93	1.93	1300.0
2023-09-29	AAMI	Stock	19.65	19.65	19.17	19.39	342500.0
2023-09-29	AAN-DELISTED	Stock	10.72	10.78	10.44	10.47	306900.0
2023-09-29	AAOI	Stock	11.28	11.38	10.71	10.97	1897500.0
2023-09-29	AAON	Stock	57.86	58.01	56.69	56.87	252500.0
2023-09-29	AAP	Stock	55.94	57.25	55.56	55.93	1911000.0
2023-09-29	AAT	Stock	19.8	19.88	19.25	19.45	355600.0
2023-09-29	AATC	Stock	6.0	6.0	5.95	5.95	15048.0
2023-09-29	AAU-DELISTED	Stock	0.14	0.1491	0.1363	0.146	293840.0
2023-09-29	AAUAF-DELISTED	Stock	0.14	0.1491	0.1363	0.1465	312658.0
2023-09-29	AAXJ	Stock	64.07	64.13	63.42	63.5	865150.0
2023-09-29	AB	Stock	30.74	31.1	30.32	30.35	305100.0
2023-09-29	ABAT	Stock	8.43	8.69	8.43	8.62	98471.0
2023-09-29	ABBNY-DELISTED	Stock	36.13	36.1699	35.59	35.59	109783.0
2023-09-29	ABBV	Stock	152.46	152.53	148.83	149.06	5581600.0
2023-09-29	ABCB	Stock	37.99	38.78	37.93	38.39	470900.0
2023-09-29	ABCL	Stock	4.74	4.75	4.57	4.6	1510400.0
2023-09-29	ABCM-DELISTED	Stock	22.67	22.76	22.615	22.635	4571239.0
2023-09-29	ABEO	Stock	4.03	4.55	3.83	4.21	369400.0
2023-09-29	ABEV	Stock	2.61	2.61	2.57	2.58	15264400.0
2023-09-29	ABG	Stock	231.57	232.3	228.71	230.07	224800.0
2023-09-29	ABLLW	Stock	0.34	0.38	0.34	0.38	24127.0
2023-09-29	ABLV	Stock	3.4	3.415	3.27	3.395	17300.0
2023-09-29	ABM	Stock	40.06	40.46	39.96	40.01	469500.0
2023-09-29	ABNB	Stock	138.05	141.075	136.36	137.21	4781100.0
2023-09-29	ABOS	Stock	4.22	4.23	4.11	4.15	230000.0
2023-09-29	ABR	Stock	15.34	15.44	15.15	15.18	2820000.0
2023-09-29	ABR.D	Stock	17.94	18.5	17.79	17.79	17644.0
2023-09-29	ABR.E	Stock	18.12	18.12	17.2	17.24	4194.0
2023-09-29	ABR.F	Stock	19.225	19.3	18.05	18.45	79163.0
2023-09-29	ABSI	Stock	1.38	1.4	1.32	1.32	215500.0

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

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