PREVIEW / stock_daily / 2023-06-30

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-30.parquet
  size:    240 KB
  rows:    7,462
  symbols: 1,554

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-06-30	AAPL	Stock	191.63	194.48	191.26	193.97	85069600.0
2023-06-30	MSFT	Stock	337.75	342.73	337.2	340.54	26823800.0
2023-06-30	NVDA	Stock	41.68	42.55	41.501	42.302	501148000.0
2023-06-30	AMZN	Stock	129.47	131.25	128.95	130.36	54310500.0
2023-06-30	GOOGL	Stock	120.17	121.08	119.69	119.7	29532241.0
2023-06-30	META	Stock	284.76	289.05	284.42	286.98	19676000.0
2023-06-30	TSLA	Stock	260.6	264.45	259.89	261.77	112267600.0
2023-06-30	TLT	Stock	102.06	103.06	101.87	102.94	32024910.0
2023-06-30	ES	Stock	69.76	70.97	69.72	70.92	2550700.0
2023-06-30	CL	Stock	76.72	77.41	76.57	77.04	4781800.0
2023-06-30	A	Stock	118.73	120.69	118.3	120.25	2487900.0
2023-06-30	AA	Stock	33.99	34.1	33.315	33.93	4966300.0
2023-06-30	AAC-DELISTED	Stock	10.55	10.58	10.54	10.56	9129394.0
2023-06-30	AACG	Stock	1.46	1.49	1.43	1.43	17400.0
2023-06-30	AACIW-DELISTED	Stock	0.1021	0.1108	0.0983	0.1108	1002.0
2023-06-30	AACT	Stock	10.17	10.17	10.155	10.155	5184.0
2023-06-30	AAIC-DELISTED	Stock	4.6	4.645	4.58	4.625	895810.0
2023-06-30	AAIC.C-DELISTED	Stock	22.72	22.78	22.7	22.7	1754.0
2023-06-30	AAL	Stock	17.72	17.99	17.67	17.94	18597900.0
2023-06-30	AAM.A-DELISTED	Stock	23.52	23.85	23.15	23.15	231185.0
2023-06-30	AAM.B-DELISTED	Stock	22.88	23.12	22.5	22.65	62385.0
2023-06-30	AAMC-DELISTED	Stock	16.1294	16.6559	15.6882	16.5265	37533.0
2023-06-30	AAME	Stock	1.91	1.98	1.91	1.93	2800.0
2023-06-30	AAMI	Stock	21.3	21.41	20.7	20.95	488000.0
2023-06-30	AAN-DELISTED	Stock	14.5	14.5	13.985	14.14	211000.0
2023-06-30	AAOI	Stock	5.69	6.94	5.69	5.96	7148500.0
2023-06-30	AAON	Stock	63.9933	63.9933	62.8667	63.2067	425700.0
2023-06-30	AAP	Stock	68.41	70.97	67.84	70.3	3979600.0
2023-06-30	AAT	Stock	19.37	19.48	18.92	19.2	527600.0
2023-06-30	AATC	Stock	4.44	4.44	4.4	4.44	3182.0
2023-06-30	AAU-DELISTED	Stock	0.128	0.1289	0.127	0.1289	205978.0
2023-06-30	AAUAF-DELISTED	Stock	0.128	0.1289	0.127	0.1289	209106.0
2023-06-30	AAXJ	Stock	66.4	66.74	66.33	66.44	607750.0
2023-06-30	AB	Stock	31.7	32.21	31.4	32.16	539300.0
2023-06-30	ABBNY-DELISTED	Stock	39.146	39.34	39.1	39.25	140103.0
2023-06-30	ABBV	Stock	133.47	135.93	132.8	134.73	8710500.0
2023-06-30	ABC-DELISTED	Stock	191.21	193.435	190.01	192.43	984279.0
2023-06-30	ABCB	Stock	34.8	34.8	34.07	34.21	808400.0
2023-06-30	ABCL	Stock	6.64	6.645	6.41	6.46	1989700.0
2023-06-30	ABCM-DELISTED	Stock	23.64	25.32	23.2502	24.45	3839445.0
2023-06-30	ABEO	Stock	4.07	4.19	4.0	4.03	74700.0
2023-06-30	ABEV	Stock	3.12	3.19	3.12	3.18	10169500.0
2023-06-30	ABG	Stock	241.59	244.29	236.95	240.42	166300.0
2023-06-30	ABM	Stock	42.74	42.85	42.28	42.65	385000.0
2023-06-30	ABNB	Stock	127.25	131.14	127.02	128.16	4600100.0
2023-06-30	ABOS	Stock	4.87	4.95	4.68	4.81	61500.0
2023-06-30	ABR	Stock	14.7	14.9	14.61	14.82	3646600.0
2023-06-30	ABR.D	Stock	18.26	18.4443	18.26	18.3	20581.0
2023-06-30	ABR.E	Stock	18.25	18.43	17.9817	18.02	38423.0
2023-06-30	ABR.F	Stock	19.84	21.0	19.8	20.95	172620.0

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

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