PREVIEW / stock_daily / 2023-05-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-01.parquet
  size:    241 KB
  rows:    7,506
  symbols: 1,642

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-05-01	AAPL	Stock	169.28	170.45	168.64	169.59	52472900.0
2023-05-01	MSFT	Stock	306.97	308.6	305.15	305.56	21294100.0
2023-05-01	NVDA	Stock	27.84	29.058	27.78	28.91	570329000.0
2023-05-01	AMZN	Stock	104.95	105.23	101.82	102.05	74728100.0
2023-05-01	GOOGL	Stock	106.84	107.99	106.82	107.2	26681680.0
2023-05-01	META	Stock	238.62	244.0	236.46	243.18	29143900.0
2023-05-01	TSLA	Stock	163.17	163.28	158.83	161.83	109015000.0
2023-05-01	TLT	Stock	105.27	105.42	102.84	103.13	32487293.0
2023-05-01	ES	Stock	77.49	78.64	77.42	77.72	1808000.0
2023-05-01	CL	Stock	79.84	81.03	79.38	80.69	6111100.0
2023-05-01	A	Stock	136.02	137.14	135.76	136.08	1012900.0
2023-05-01	AA	Stock	37.66	37.7	36.77	37.27	2730300.0
2023-05-01	AAC-DELISTED	Stock	10.35	10.38	10.35	10.38	76766.0
2023-05-01	AACG	Stock	1.8	1.96	1.8	1.94	21400.0
2023-05-01	AAIC-DELISTED	Stock	2.59	2.64	2.59	2.6	30925.0
2023-05-01	AAIC.C-DELISTED	Stock	21.0001	21.0001	21.0001	21.0001	660.0
2023-05-01	AAL	Stock	13.6	14.03	13.52	13.89	29101800.0
2023-05-01	AAM.A-DELISTED	Stock	24.8561	24.8599	24.53	24.67	13308.0
2023-05-01	AAM.B-DELISTED	Stock	25.1	25.21	25.021	25.165	7013.0
2023-05-01	AAMC-DELISTED	Stock	24.4118	25.9559	24.1176	25.5912	75840.0
2023-05-01	AAME	Stock	2.22	2.22	2.2	2.2	800.0
2023-05-01	AAMI	Stock	22.58	22.98	22.15	22.21	132200.0
2023-05-01	AAN-DELISTED	Stock	13.36	13.49	13.07	13.21	348600.0
2023-05-01	AAOI	Stock	1.91	2.02	1.82	1.82	188300.0
2023-05-01	AAON	Stock	65.3933	65.9933	65.02	65.26	493350.0
2023-05-01	AAP	Stock	125.59	126.51	125.19	125.47	652500.0
2023-05-01	AAT	Stock	18.12	18.24	17.8	17.97	411700.0
2023-05-01	AATC	Stock	3.9	3.95	3.86	3.91	7508.0
2023-05-01	AAU-DELISTED	Stock	0.12	0.1257	0.12	0.1214	197795.0
2023-05-01	AAUAF-DELISTED	Stock	0.12	0.13	0.12	0.13	182823.0
2023-05-01	AAXJ	Stock	66.49	66.98	66.46	66.47	211738.0
2023-05-01	AB	Stock	35.0	35.33	34.48	34.55	178900.0
2023-05-01	ABB-DELISTED	Stock	36.2	36.325	35.91	35.91	954660.0
2023-05-01	ABBNY-DELISTED	Stock	36.2	36.325	35.91	35.92	1052175.0
2023-05-01	ABBV	Stock	150.84	154.71	150.82	153.71	5601000.0
2023-05-01	ABC-DELISTED	Stock	167.18	167.41	164.78	166.77	1026390.0
2023-05-01	ABCB	Stock	33.6	33.75	32.65	32.71	385800.0
2023-05-01	ABCL	Stock	6.81	6.843	6.66	6.77	1518800.0
2023-05-01	ABCM-DELISTED	Stock	16.3	17.29	16.3	17.27	443621.0
2023-05-01	ABEO	Stock	3.06	3.34	3.06	3.24	94800.0
2023-05-01	ABEV	Stock	2.79	2.83	2.79	2.79	4765300.0
2023-05-01	ABG	Stock	194.77	200.62	194.6	198.33	254000.0
2023-05-01	ABM	Stock	42.49	43.05	42.23	42.55	188900.0
2023-05-01	ABNB	Stock	119.26	122.65	118.98	121.42	4830600.0
2023-05-01	ABOS	Stock	3.86	4.025	3.79	3.94	40300.0
2023-05-01	ABR	Stock	11.33	11.38	11.05	11.21	4593700.0
2023-05-01	ABR.D	Stock	17.92	18.0837	17.4704	17.4704	8639.0
2023-05-01	ABR.E	Stock	18.0	18.0	17.55	17.815	14780.0
2023-05-01	ABR.F	Stock	18.33	18.33	18.1	18.19	21224.0
2023-05-01	ABSI	Stock	1.315	1.38	1.165	1.25	421500.0

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

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