PREVIEW / stock_daily / 2023-06-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-05.parquet
  size:    241 KB
  rows:    7,517
  symbols: 1,612

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-05	AAPL	Stock	182.63	184.95	178.04	179.58	121946500.0
2023-06-05	MSFT	Stock	335.22	338.56	334.66	335.94	21307100.0
2023-06-05	NVDA	Stock	38.909	39.565	38.707	39.171	396094000.0
2023-06-05	AMZN	Stock	123.36	125.8	123.03	125.3	47950100.0
2023-06-05	GOOGL	Stock	124.01	127.43	123.84	126.01	32305531.0
2023-06-05	META	Stock	270.3	275.57	269.56	271.39	20742900.0
2023-06-05	TSLA	Stock	217.8	221.29	214.52	217.61	151143100.0
2023-06-05	TLT	Stock	101.35	102.4399	101.21	101.8	14433172.0
2023-06-05	ES	Stock	70.01	71.49	70.01	70.51	2142500.0
2023-06-05	CL	Stock	75.82	77.01	75.82	76.25	4681300.0
2023-06-05	A	Stock	118.58	119.76	117.09	118.35	2129300.0
2023-06-05	AA	Stock	34.83	34.83	33.4	33.78	4118500.0
2023-06-05	AAC-DELISTED	Stock	10.49	10.4999	10.48	10.49	26331.0
2023-06-05	AACG	Stock	1.52	1.52	1.45	1.45	11400.0
2023-06-05	AACIW-DELISTED	Stock	0.06	0.06	0.06	0.06	15850.0
2023-06-05	AAIC-DELISTED	Stock	4.16	4.18	4.13	4.14	465905.0
2023-06-05	AAIC.C-DELISTED	Stock	22.69	22.6901	22.5598	22.5598	2488.0
2023-06-05	AAL	Stock	14.87	14.91	14.68	14.81	15399300.0
2023-06-05	AAM.A-DELISTED	Stock	24.73	24.75	24.05	24.55	21522.0
2023-06-05	AAM.B-DELISTED	Stock	24.9	24.9	24.0325	24.6	3730.0
2023-06-05	AAMC-DELISTED	Stock	27.6059	27.9412	25.7191	25.8529	57440.0
2023-06-05	AAME	Stock	2.12	2.12	2.1	2.1	1900.0
2023-06-05	AAMI	Stock	22.3	22.46	21.63	22.04	112200.0
2023-06-05	AAN-DELISTED	Stock	12.71	13.07	12.52	13.04	204100.0
2023-06-05	AAOI	Stock	2.3	2.43	2.26	2.33	196900.0
2023-06-05	AAON	Stock	60.6533	60.78	59.5267	60.7733	480450.0
2023-06-05	AAP	Stock	67.5	68.4	65.56	65.59	4578800.0
2023-06-05	AAT	Stock	19.49	19.63	19.04	19.33	259400.0
2023-06-05	AATC	Stock	4.14	4.33	4.14	4.2625	2396.0
2023-06-05	AAU-DELISTED	Stock	0.12	0.1247	0.12	0.1215	165560.0
2023-06-05	AAUAF-DELISTED	Stock	0.12	0.1247	0.12	0.12	168233.0
2023-06-05	AAXJ	Stock	66.77	66.92	66.61	66.86	239480.0
2023-06-05	AB	Stock	35.37	35.56	34.62	34.75	279400.0
2023-06-05	ABBNY-DELISTED	Stock	37.35	37.45	37.21	37.337	505146.0
2023-06-05	ABBV	Stock	137.0	138.31	136.29	136.86	4276200.0
2023-06-05	ABC-DELISTED	Stock	174.9	175.65	173.69	174.68	692427.0
2023-06-05	ABCB	Stock	34.55	34.56	32.73	33.54	463700.0
2023-06-05	ABCL	Stock	6.81	6.94	6.66	6.83	1908200.0
2023-06-05	ABCM-DELISTED	Stock	16.94	17.14	16.81	16.94	1487923.0
2023-06-05	ABEO	Stock	3.31	4.28	3.31	4.03	793600.0
2023-06-05	ABEV	Stock	2.9	2.92	2.88	2.88	8344000.0
2023-06-05	ABG	Stock	215.62	216.78	208.44	210.96	146100.0
2023-06-05	ABM	Stock	45.94	45.94	45.1	45.3	358200.0
2023-06-05	ABNB	Stock	115.12	116.595	112.315	115.69	8324400.0
2023-06-05	ABOS	Stock	5.19	5.36	4.91	4.95	75700.0
2023-06-05	ABR	Stock	13.5	13.69	13.14	13.57	2424200.0
2023-06-05	ABR.D	Stock	18.29	18.49	18.2	18.28	23769.0
2023-06-05	ABR.E	Stock	17.79	17.81	17.69	17.69	3894.0
2023-06-05	ABR.F	Stock	18.84	19.08	18.72	18.72	29796.0
2023-06-05	ABSI	Stock	1.88	1.91	1.8	1.8	813400.0

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

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