PREVIEW / stock_daily / 2023-03-30

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-30.parquet
  size:    243 KB
  rows:    7,532
  symbols: 1,712

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-03-30	AAPL	Stock	161.53	162.47	161.27	162.36	49501700.0
2023-03-30	MSFT	Stock	284.23	284.46	281.48	284.05	25053400.0
2023-03-30	NVDA	Stock	27.229	27.499	27.102	27.383	364516000.0
2023-03-30	AMZN	Stock	101.55	103.04	101.01	102.0	53633400.0
2023-03-30	GOOGL	Stock	100.91	101.155	99.78	100.89	33086183.0
2023-03-30	META	Stock	203.38	208.09	202.82	207.84	22608300.0
2023-03-30	TSLA	Stock	195.58	197.33	194.42	195.28	110252200.0
2023-03-30	TLT	Stock	104.46	105.05	104.27	104.8	14315802.0
2023-03-30	ES	Stock	77.75	78.23	77.34	78.11	1092200.0
2023-03-30	CL	Stock	74.53	75.4	74.47	75.25	4181600.0
2023-03-30	A	Stock	135.27	135.54	133.32	134.49	1468200.0
2023-03-30	AA	Stock	41.6	42.89	41.38	41.76	4800400.0
2023-03-30	AAC-DELISTED	Stock	10.33	10.34	10.3108	10.32	63665.0
2023-03-30	AACG	Stock	1.82	1.87	1.82	1.87	6400.0
2023-03-30	AACIW-DELISTED	Stock	0.1	0.11	0.0795	0.1099	3850.0
2023-03-30	AAIC-DELISTED	Stock	2.69	2.74	2.69	2.73	34272.0
2023-03-30	AAIC.C-DELISTED	Stock	20.01	20.05	19.85	20.05	2156.0
2023-03-30	AAL	Stock	14.56	14.7	14.46	14.47	13673500.0
2023-03-30	AAM.A-DELISTED	Stock	21.25	22.2099	21.01	21.59	75072.0
2023-03-30	AAM.B-DELISTED	Stock	21.52	22.83	21.52	22.73	21526.0
2023-03-30	AAMC-DELISTED	Stock	21.3618	21.5533	19.9029	20.2941	111751.0
2023-03-30	AAME	Stock	2.5	2.5	2.39	2.49	1900.0
2023-03-30	AAMI	Stock	23.14	23.35	23.03	23.31	120200.0
2023-03-30	AAN-DELISTED	Stock	9.18	9.38	9.0	9.12	623900.0
2023-03-30	AAOI	Stock	1.86	1.98	1.791	1.93	288600.0
2023-03-30	AAON	Stock	63.28	63.7067	62.74	63.2667	367950.0
2023-03-30	AAP	Stock	119.04	119.59	118.12	118.61	1368700.0
2023-03-30	AAT	Stock	18.26	18.39	17.93	18.08	326300.0
2023-03-30	AATC	Stock	4.07	4.07	4.0	4.05	9222.0
2023-03-30	AAU-DELISTED	Stock	0.2	0.2	0.1945	0.197	182773.0
2023-03-30	AAUAF-DELISTED	Stock	0.2	0.2	0.1945	0.198	177346.0
2023-03-30	AAXJ	Stock	67.95	68.12	67.75	67.99	218852.0
2023-03-30	AB	Stock	35.6	36.57	35.6	35.95	131000.0
2023-03-30	ABB-DELISTED	Stock	33.56	33.76	33.51	33.64	989603.0
2023-03-30	ABBNY-DELISTED	Stock	33.56	33.76	33.51	33.65	1121939.0
2023-03-30	ABBV	Stock	158.01	158.53	157.42	157.92	3635800.0
2023-03-30	ABC-DELISTED	Stock	159.58	159.72	158.0	159.33	314139.0
2023-03-30	ABCB	Stock	37.32	37.43	35.92	36.11	411700.0
2023-03-30	ABCL	Stock	7.69	7.69	7.39	7.42	902300.0
2023-03-30	ABCM-DELISTED	Stock	13.4	13.59	13.21	13.31	321812.0
2023-03-30	ABEO	Stock	2.74	2.93	2.72	2.83	135500.0
2023-03-30	ABEV	Stock	2.9	2.91	2.85	2.87	13286300.0
2023-03-30	ABG	Stock	203.12	207.86	201.58	206.46	208200.0
2023-03-30	ABM	Stock	44.7	45.0	44.24	44.51	277700.0
2023-03-30	ABNB	Stock	120.8	122.65	120.11	122.28	5437900.0
2023-03-30	ABOS	Stock	4.07	4.13	3.86	4.08	44500.0
2023-03-30	ABR	Stock	11.16	11.23	10.9	11.07	3138100.0
2023-03-30	ABR.D	Stock	17.24	17.34	16.915	17.23	19442.0
2023-03-30	ABR.E	Stock	16.74	16.74	16.37	16.5	6747.0
2023-03-30	ABR.F	Stock	17.34	17.5961	17.09	17.16	16816.0

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

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