PREVIEW / stock_daily / 2023-07-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-26.parquet
  size:    239 KB
  rows:    7,440
  symbols: 1,512

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-26	AAPL	Stock	193.67	195.64	193.32	194.5	47471900.0
2023-07-26	MSFT	Stock	341.44	344.67	333.11	337.77	58383700.0
2023-07-26	NVDA	Stock	46.021	46.053	44.63	45.452	364237000.0
2023-07-26	AMZN	Stock	126.51	129.08	126.11	128.15	53910100.0
2023-07-26	GOOGL	Stock	130.07	130.98	128.32	129.27	61682093.0
2023-07-26	META	Stock	301.19	301.77	291.9	298.57	47256900.0
2023-07-26	TSLA	Stock	263.25	268.04	261.75	264.35	95856200.0
2023-07-26	TLT	Stock	101.68	101.69	100.9256	101.27	19310659.0
2023-07-26	ES	Stock	73.89	74.75	73.37	73.62	1617500.0
2023-07-26	CL	Stock	77.75	78.36	77.2	77.96	4116700.0
2023-07-26	A	Stock	125.0	128.53	123.4	128.47	2507500.0
2023-07-26	AA	Stock	35.02	35.447	34.545	34.84	7282100.0
2023-07-26	AAC-DELISTED	Stock	10.6	10.61	10.59	10.59	458968.0
2023-07-26	AACG	Stock	1.33	1.39	1.32	1.34	7000.0
2023-07-26	AACIW-DELISTED	Stock	0.06909	0.06909	0.06909	0.06909	695.0
2023-07-26	AACT	Stock	10.19	10.19	10.17	10.19	60000.0
2023-07-26	AAIC-DELISTED	Stock	4.72	4.78	4.71	4.765	39672.0
2023-07-26	AAIC.C-DELISTED	Stock	23.9511	23.9511	23.5	23.5	230.0
2023-07-26	AAL	Stock	16.72	16.9	16.51	16.76	21833000.0
2023-07-26	AAM.A-DELISTED	Stock	23.88	23.99	23.505	23.76	54908.0
2023-07-26	AAM.B-DELISTED	Stock	23.82	24.5122	23.7	23.975	28441.0
2023-07-26	AAMC-DELISTED	Stock	25.0353	25.0847	22.8176	23.6471	71910.0
2023-07-26	AAME	Stock	1.89	1.94	1.89	1.94	3400.0
2023-07-26	AAMI	Stock	22.12	22.25	21.6	21.64	178100.0
2023-07-26	AAN-DELISTED	Stock	15.58	16.16	15.55	15.69	213600.0
2023-07-26	AAOI	Stock	8.52	8.78	7.89	7.95	1700600.0
2023-07-26	AAON	Stock	67.34	69.4467	66.6133	67.3933	489150.0
2023-07-26	AAP	Stock	71.5	73.43	71.42	73.09	1842300.0
2023-07-26	AAT	Stock	22.05	23.17	22.05	22.5	469700.0
2023-07-26	AATC	Stock	4.45	4.45	4.45	4.45	263.0
2023-07-26	AAU-DELISTED	Stock	0.1488	0.157	0.1458	0.1475	141899.0
2023-07-26	AAUAF-DELISTED	Stock	0.1488	0.157	0.1458	0.1475	137793.0
2023-07-26	AAXJ	Stock	68.54	69.54	68.54	69.34	503282.0
2023-07-26	AB	Stock	34.2	34.42	33.8	33.81	276800.0
2023-07-26	ABBNY-DELISTED	Stock	39.97	40.365	39.89	40.16	341233.0
2023-07-26	ABBV	Stock	141.43	142.28	140.52	141.9	5006800.0
2023-07-26	ABC-DELISTED	Stock	190.91	191.5295	186.87	187.72	1075582.0
2023-07-26	ABCB	Stock	41.41	42.11	41.25	41.94	535300.0
2023-07-26	ABCL	Stock	7.79	7.805	7.56	7.76	1377400.0
2023-07-26	ABCM-DELISTED	Stock	23.33	23.88	23.12	23.46	1170565.0
2023-07-26	ABEO	Stock	3.48	3.57	3.41	3.46	99000.0
2023-07-26	ABEV	Stock	3.14	3.16	3.11	3.14	10852600.0
2023-07-26	ABG	Stock	219.25	225.07	218.13	221.91	285100.0
2023-07-26	ABLLW	Stock	0.239	0.3075	0.238	0.263	19518.0
2023-07-26	ABLV	Stock	10.6499	10.67	10.61	10.65	45596.0
2023-07-26	ABM	Stock	44.7	45.76	44.7	44.99	718200.0
2023-07-26	ABNB	Stock	147.83	150.27	147.09	150.17	4055500.0
2023-07-26	ABOS	Stock	7.2	7.3	6.71	7.1	1284900.0
2023-07-26	ABR	Stock	16.04	16.58	16.04	16.54	3385000.0
2023-07-26	ABR.D	Stock	18.89	19.45	18.71	18.79	36460.0

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

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