PREVIEW / stock_daily / 2023-06-29

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-29.parquet
  size:    241 KB
  rows:    7,489
  symbols: 1,571

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-29	AAPL	Stock	189.08	190.07	188.94	189.59	46347300.0
2023-06-29	MSFT	Stock	334.71	336.11	332.62	335.05	16997000.0
2023-06-29	NVDA	Stock	41.558	41.6	40.6	40.822	380514000.0
2023-06-29	AMZN	Stock	128.77	129.26	127.26	127.9	40761000.0
2023-06-29	GOOGL	Stock	119.24	120.06	118.295	119.1	24090902.0
2023-06-29	META	Stock	284.5	286.57	280.69	281.53	15395700.0
2023-06-29	TSLA	Stock	258.03	260.74	253.61	257.5	131283400.0
2023-06-29	TLT	Stock	102.17	102.34	101.45	101.74	41091617.0
2023-06-29	ES	Stock	68.97	70.05	68.75	69.72	1733900.0
2023-06-29	CL	Stock	75.45	76.74	75.14	76.56	4419100.0
2023-06-29	A	Stock	116.16	118.25	116.07	118.05	1885800.0
2023-06-29	AA	Stock	33.5	33.96	33.08	33.76	5419200.0
2023-06-29	AAC-DELISTED	Stock	10.54	10.55	10.53	10.54	1201446.0
2023-06-29	AACG	Stock	1.46	1.46	1.43	1.44	2200.0
2023-06-29	AACIW-DELISTED	Stock	0.0972	0.1108	0.0972	0.1108	651.0
2023-06-29	AACT	Stock	10.19	10.19	10.15	10.16	155297.0
2023-06-29	AAIC-DELISTED	Stock	4.52	4.6	4.43	4.6	193616.0
2023-06-29	AAIC.C-DELISTED	Stock	22.7	22.7799	22.6601	22.72	1625.0
2023-06-29	AAL	Stock	17.64	17.98	17.53	17.6	20315700.0
2023-06-29	AAM.A-DELISTED	Stock	23.23	23.66	23.17	23.55	53262.0
2023-06-29	AAM.B-DELISTED	Stock	22.45	23.148	22.45	22.79	22491.0
2023-06-29	AAMC-DELISTED	Stock	14.7059	16.8397	14.7059	16.0735	60292.0
2023-06-29	AAME	Stock	1.95	2.0	1.85	1.89	10500.0
2023-06-29	AAMI	Stock	20.6	21.18	20.6	21.03	345600.0
2023-06-29	AAN-DELISTED	Stock	14.12	14.44	14.03	14.33	192300.0
2023-06-29	AAOI	Stock	5.13	5.82	5.08	5.43	2344500.0
2023-06-29	AAON	Stock	63.5267	64.2867	63.5267	63.6933	279900.0
2023-06-29	AAP	Stock	68.42	69.08	67.88	68.23	1407400.0
2023-06-29	AAT	Stock	18.64	19.21	18.41	19.16	338100.0
2023-06-29	AATC	Stock	4.39	4.47	4.32	4.44	11901.0
2023-06-29	AAU-DELISTED	Stock	0.1287	0.1299	0.128	0.128	130341.0
2023-06-29	AAUAF-DELISTED	Stock	0.1287	0.1299	0.128	0.128	135204.0
2023-06-29	AAXJ	Stock	65.83	65.99	65.8	65.91	317488.0
2023-06-29	AB	Stock	31.5	31.9	31.19	31.49	311000.0
2023-06-29	ABBNY-DELISTED	Stock	38.34	38.51	38.2	38.25	107298.0
2023-06-29	ABBV	Stock	132.37	133.91	132.13	133.23	4947600.0
2023-06-29	ABC-DELISTED	Stock	189.48	191.76	189.16	190.52	548906.0
2023-06-29	ABCB	Stock	34.15	34.79	34.15	34.4	417800.0
2023-06-29	ABCL	Stock	6.63	6.715	6.45	6.58	1872100.0
2023-06-29	ABCM-DELISTED	Stock	23.4	24.0	22.86	23.65	1427842.0
2023-06-29	ABEO	Stock	4.36	4.49	4.05	4.05	150900.0
2023-06-29	ABEV	Stock	3.1	3.13	3.09	3.1	11113300.0
2023-06-29	ABG	Stock	240.76	246.69	239.93	240.68	192900.0
2023-06-29	ABM	Stock	42.04	42.83	42.04	42.63	326300.0
2023-06-29	ABNB	Stock	127.64	128.0	123.42	125.1	4242000.0
2023-06-29	ABOS	Stock	4.92	5.15	4.74	4.81	145300.0
2023-06-29	ABR	Stock	14.39	14.7	14.37	14.59	5152200.0
2023-06-29	ABR.D	Stock	18.15	18.27	18.14	18.25	12040.0
2023-06-29	ABR.E	Stock	18.16	18.2	17.9623	18.2	6002.0
2023-06-29	ABR.F	Stock	19.6	19.75	19.4601	19.75	10397.0

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

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