PREVIEW / stock_daily / 2001-06-27

all stock daily files

  file:    by_date/stock_daily/2001/2001-06-27.parquet
  size:    100 KB
  rows:    2,927
  symbols: 1,819

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
2001-06-27	AAPL	Stock	0.4255	0.4286	0.4018	0.4168	374130400.0
2001-06-27	MSFT	Stock	34.93	35.765	34.68	35.57	69199800.0
2001-06-27	NVDA	Stock	0.3888	0.3896	0.3719	0.3785	895752000.0
2001-06-27	AMZN	Stock	0.6905	0.7125	0.6825	0.702	152488000.0
2001-06-27	CL	Stock	30.25	30.375	29.955	30.3	2879600.0
2001-06-27	A	Stock	20.3505	21.8169	20.3505	21.3519	3380364.0
2001-06-27	AABA-DELISTED	Stock	9.75	9.81999969482422	9.17000007629395	9.36499977111816	21202000.0
2001-06-27	AAI-DELISTED	Stock	8.49	9.4	8.41	9.25	458600.0
2001-06-27	AAIC-DELISTED	Stock	125.0	125.0	118.0	120.0	48300.0
2001-06-27	AAME	Stock	1.7	1.7	1.7	1.7	200.0
2001-06-27	AAON	Stock	1.6944	1.6944	1.5334	1.5539	714192.0
2001-06-27	AAXN-DELISTED	Stock	0.504166662693024	0.508333325386047	0.504166662693024	0.508333325386047	55200.0
2001-06-27	ABAX-DELISTED	Stock	5.35	5.35	5.25	5.31	9300.0
2001-06-27	ABB-DELISTED	Stock	14.15	14.25	14.15	14.2	34600.0
2001-06-27	ABC-DELISTED	Stock	14.2875003814697	14.3400001525879	14.0074996948242	14.25	3760000.0
2001-06-27	ABCB	Stock	9.0375	9.0375	8.9564	8.997	153726.0
2001-06-27	ABCW-DELISTED	Stock	15.0	15.05	14.91	15.05	24000.0
2001-06-27	ABE-DELISTED	Stock	8.07	8.07	7.95	8.0	15300.0
2001-06-27	ABFS-DELISTED	Stock	20.6	21.0	20.3	20.95	80300.0
2001-06-27	ABK-DELISTED	Stock	57.51	59.0	57.51	58.4	344500.0
2001-06-27	ABM	Stock	17.09	17.5	17.025	17.415	160600.0
2001-06-27	ABMD-DELISTED	Stock	24.2	24.2	22.3	22.6	126600.0
2001-06-27	ABP-DELISTED	Stock	3.62	3.62	3.2	3.3	70100.0
2001-06-27	ABT	Stock	23.1049	23.298	22.445	22.445	6347058.0
2001-06-27	ABTL-DELISTED	Stock	6.85	6.9	6.75	6.75	14600.0
2001-06-27	ABV-DELISTED	Stock	21.5	22.49	21.45	22.49	300900.0
2001-06-27	ABX-DELISTED	Stock	15.52	15.52	15.31	15.41	2535700.0
2001-06-27	ACAP-DELISTED	Stock	18.52	19.77	18.5	19.65	64300.0
2001-06-27	ACAS-DELISTED	Stock	26.35	26.9	25.95	26.5	416400.0
2001-06-27	ACAT-DELISTED	Stock	15.02	15.05	14.96	15.04	11400.0
2001-06-27	ACCL-DELISTED	Stock	14.2433004379272	14.3381996154785	14.2433004379272	14.3381996154785	188600.0
2001-06-27	ACE-DELISTED	Stock	37.6	38.95	37.32	38.44	1016200.0
2001-06-27	ACF-DELISTED	Stock	50.7	53.24	50.7	52.76	1796100.0
2001-06-27	ACG-DELISTED	Stock	8.8	8.85	8.76	8.76	292500.0
2001-06-27	ACGL	Stock	1.8556	1.8611	1.8556	1.8611	77400.0
2001-06-27	ACGN-DELISTED	Stock	1416.6712	1473.3288	1326.0	1382.6712	59500.0
2001-06-27	ACH	Stock	11.7667	12.3333	11.76	12.3333	234150.0
2001-06-27	ACLS	Stock	56.24	58.28	56.0	56.68	58600.0
2001-06-27	ACO-DELISTED	Stock	6.1	6.1	5.96	5.96	18500.0
2001-06-27	ACPW-DELISTED	Stock	87.75	90.25	77.0	78.8	373500.0
2001-06-27	ACS-DELISTED	Stock	37.45	37.45	37.075	37.125	240300.0
2001-06-27	ACTA-DELISTED	Stock	34.6	37.2	34.0	35.6	78800.0
2001-06-27	ACTT-DELISTED	Stock	6.28	6.35	6.23	6.34	12700.0
2001-06-27	ACTU-DELISTED	Stock	6.6	7.2	6.5	6.85	786700.0
2001-06-27	ACXM-DELISTED	Stock	10.8	12.17	10.7	11.3	1452500.0
2001-06-27	ACY-DELISTED	Stock	4.9	4.95	4.9	4.95	300.0
2001-06-27	AD	Stock	38.3333	39.2267	38.1667	38.6333	123300.0
2001-06-27	ADAT-DELISTED	Stock	63.9	72.72	63.72	70.74	3057.0
2001-06-27	ADBE	Stock	22.275	22.67	22.0	22.175	6150200.0
2001-06-27	ADC	Stock	19.48	19.53	19.4	19.48	4800.0

> showing 50 of 2,927 rows — these rows as CSV

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