PREVIEW / stock_daily / 2023-07-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-06.parquet
  size:    236 KB
  rows:    7,340
  symbols: 1,441

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-06	AAPL	Stock	189.84	192.02	189.2	191.81	45094300.0
2023-07-06	MSFT	Stock	337.3	342.99	335.5	341.27	28161200.0
2023-07-06	NVDA	Stock	41.844	42.179	41.346	42.103	303582000.0
2023-07-06	AMZN	Stock	128.25	128.73	127.37	128.36	40639900.0
2023-07-06	GOOGL	Stock	119.795	120.3	118.4	120.11	24778801.0
2023-07-06	META	Stock	295.89	298.12	291.31	291.99	47600500.0
2023-07-06	TSLA	Stock	278.09	279.97	272.88	276.54	120332100.0
2023-07-06	TLT	Stock	100.2	100.38	99.47	99.68	41375735.0
2023-07-06	ES	Stock	71.04	71.54	70.23	71.38	2001200.0
2023-07-06	CL	Stock	76.48	77.09	76.28	76.91	3287700.0
2023-07-06	A	Stock	116.36	118.89	115.66	118.43	1626600.0
2023-07-06	AA	Stock	33.03	33.223	31.83	32.54	6066300.0
2023-07-06	AAC-DELISTED	Stock	10.57	10.57	10.56	10.57	477524.0
2023-07-06	AACG	Stock	1.4	1.42	1.36	1.37	3700.0
2023-07-06	AACIW-DELISTED	Stock	0.0878	0.088	0.07	0.07	4922.0
2023-07-06	AACT	Stock	10.16	10.18	10.16	10.18	5200.0
2023-07-06	AAIC-DELISTED	Stock	4.42	4.42	4.32	4.4	97800.0
2023-07-06	AAIC.C-DELISTED	Stock	23.025	23.15	22.6	22.61	1733.0
2023-07-06	AAL	Stock	18.02	18.14	17.67	17.88	25768000.0
2023-07-06	AAM.A-DELISTED	Stock	23.15	23.15	22.56	22.6	15381.0
2023-07-06	AAM.B-DELISTED	Stock	22.94	22.94	22.46	22.53	23863.0
2023-07-06	AAMC-DELISTED	Stock	34.1765	37.5706	33.1235	34.1176	36040.0
2023-07-06	AAME	Stock	2.05	2.05	1.97	2.04	600.0
2023-07-06	AAMI	Stock	20.48	20.62	19.99	20.35	212100.0
2023-07-06	AAN-DELISTED	Stock	13.94	14.62	13.86	14.46	682600.0
2023-07-06	AAOI	Stock	6.89	7.19	6.35	6.51	3035900.0
2023-07-06	AAON	Stock	61.9133	61.9133	60.6533	61.5267	255300.0
2023-07-06	AAP	Stock	70.34	70.63	68.88	69.96	2315000.0
2023-07-06	AAT	Stock	19.2	19.35	18.83	19.29	249800.0
2023-07-06	AATC	Stock	4.435	4.44	4.41	4.44	24940.0
2023-07-06	AAU-DELISTED	Stock	0.13	0.13	0.1276	0.1285	209276.0
2023-07-06	AAUAF-DELISTED	Stock	0.13	0.13	0.1276	0.1285	211309.0
2023-07-06	AAXJ	Stock	65.47	65.81	65.14	65.45	434867.0
2023-07-06	AB	Stock	31.66	31.95	31.24	31.57	232700.0
2023-07-06	ABBNY-DELISTED	Stock	37.7	37.73	37.302	37.58	292219.0
2023-07-06	ABBV	Stock	137.48	138.28	136.44	137.25	6091000.0
2023-07-06	ABC-DELISTED	Stock	190.44	192.28	190.13	192.19	774677.0
2023-07-06	ABCB	Stock	33.7	33.8	33.21	33.68	320800.0
2023-07-06	ABCL	Stock	6.53	6.53	6.28	6.37	1547500.0
2023-07-06	ABCM-DELISTED	Stock	24.56	24.56	23.76	23.97	1418524.0
2023-07-06	ABEO	Stock	4.3	4.3	4.05	4.07	116000.0
2023-07-06	ABEV	Stock	3.07	3.08	2.98	3.0	17367600.0
2023-07-06	ABG	Stock	238.36	241.94	235.5	236.63	117300.0
2023-07-06	ABLLW	Stock	0.2788	0.3262	0.2511	0.3247	115480.0
2023-07-06	ABM	Stock	41.79	42.46	41.73	42.19	372800.0
2023-07-06	ABNB	Stock	129.17	129.323	126.06	128.16	3733600.0
2023-07-06	ABOS	Stock	5.35	5.35	4.851	5.05	118600.0
2023-07-06	ABR	Stock	14.86	14.88	14.44	14.62	3271500.0
2023-07-06	ABR.D	Stock	18.28	18.5106	18.1	18.38	18315.0
2023-07-06	ABR.E	Stock	18.02	18.18	17.85	18.18	12219.0

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

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