PREVIEW / stock_daily / 2001-08-27

all stock daily files

  file:    by_date/stock_daily/2001/2001-08-27.parquet
  size:    102 KB
  rows:    2,979
  symbols: 1,849

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-08-27	AAPL	Stock	0.3321	0.3446	0.3243	0.3379	175644000.0
2001-08-27	MSFT	Stock	30.95	31.68	30.785	31.155	44562800.0
2001-08-27	NVDA	Stock	0.3474	0.3723	0.346	0.3676	1279608000.0
2001-08-27	AMZN	Stock	0.5045	0.5135	0.4955	0.5065	52360000.0
2001-08-27	CL	Stock	27.93	27.93	27.575	27.68	3464600.0
2001-08-27	A	Stock	20.0501	20.0572	19.3491	19.4278	1373815.0
2001-08-27	AABA-DELISTED	Stock	7.03499984741211	7.03499984741211	6.50500011444092	6.71000003814697	15045400.0
2001-08-27	AAI-DELISTED	Stock	6.14	6.14	5.96	6.01	814700.0
2001-08-27	AAIC-DELISTED	Stock	130.0	130.0	125.0	125.0	16300.0
2001-08-27	AAME	Stock	1.5	1.54	1.2	1.26	58500.0
2001-08-27	AAON	Stock	1.8144	1.8144	1.7851	1.8085	879926.0
2001-08-27	AAXN-DELISTED	Stock	0.716666638851166	0.741666674613953	0.683333337306976	0.735000014305115	1335600.0
2001-08-27	ABAX-DELISTED	Stock	5.04	5.15	5.0	5.15	4700.0
2001-08-27	ABB-DELISTED	Stock	11.38	11.38	11.1	11.23	9800.0
2001-08-27	ABC-DELISTED	Stock	16.25	16.3500003814697	16.2000007629395	16.25	14416000.0
2001-08-27	ABCB	Stock	10.7396	10.7396	10.699	10.699	864.0
2001-08-27	ABCW-DELISTED	Stock	17.85	18.3	17.3	17.61	34400.0
2001-08-27	ABE-DELISTED	Stock	7.33	7.37	7.33	7.34	4700.0
2001-08-27	ABFS-DELISTED	Stock	27.69	27.69	26.6	27.03	113300.0
2001-08-27	ABK-DELISTED	Stock	60.25	60.33	59.6	60.04	851200.0
2001-08-27	ABM	Stock	18.025	18.025	17.45	17.45	175400.0
2001-08-27	ABMD-DELISTED	Stock	19.4	19.67	18.81	19.16	41900.0
2001-08-27	ABP-DELISTED	Stock	3.0	3.0	2.86	2.88	35300.0
2001-08-27	ABT	Stock	23.5449	23.5853	23.3428	23.3698	3340158.0
2001-08-27	ABTL-DELISTED	Stock	4.75	5.15	4.6	4.65	27700.0
2001-08-27	ABV-DELISTED	Stock	19.3	19.39	19.24	19.25	97400.0
2001-08-27	ABX-DELISTED	Stock	16.68	16.69	16.42	16.43	1285600.0
2001-08-27	ACAP-DELISTED	Stock	22.64	22.95	22.25	22.59	19300.0
2001-08-27	ACAS-DELISTED	Stock	28.7	29.19	28.27	28.42	140500.0
2001-08-27	ACAT-DELISTED	Stock	16.15	16.44	15.9	15.9	11400.0
2001-08-27	ACCL-DELISTED	Stock	12.8385000228882	13.078200340271	12.7581996917725	13.078200340271	275000.0
2001-08-27	ACE-DELISTED	Stock	34.2	34.32	33.2	33.8	1043800.0
2001-08-27	ACF-DELISTED	Stock	47.5	48.68	45.62	46.15	1944500.0
2001-08-27	ACG-DELISTED	Stock	8.79	8.86	8.78	8.79	268100.0
2001-08-27	ACGL	Stock	1.9589	1.9589	1.9056	1.9244	37800.0
2001-08-27	ACGN-DELISTED	Stock	1167.3288	1371.3288	1167.3288	1303.3288	24100.0
2001-08-27	ACH	Stock	13.34	14.46	13.34	13.8	400650.0
2001-08-27	ACLS	Stock	58.6	59.4	58.08	58.44	128475.0
2001-08-27	ACO-DELISTED	Stock	6.28	6.4	6.25	6.35	26900.0
2001-08-27	ACPW-DELISTED	Stock	34.35	34.65	33.75	33.75	33880.0
2001-08-27	ACS-DELISTED	Stock	42.975	43.25	42.82	43.015	377000.0
2001-08-27	ACTA-DELISTED	Stock	17.4	17.6	15.2	15.8	60100.0
2001-08-27	ACTT-DELISTED	Stock	6.29	6.5792	6.21	6.5	22500.0
2001-08-27	ACTU-DELISTED	Stock	6.6	6.79	6.44	6.71	317600.0
2001-08-27	ACXM-DELISTED	Stock	13.19	13.2	12.82	12.82	332100.0
2001-08-27	ACY-DELISTED	Stock	5.8	5.8	5.8	5.8	5000.0
2001-08-27	AD	Stock	35.9	35.9	35.2533	35.2667	141000.0
2001-08-27	ADAT-DELISTED	Stock	68.22	74.7	62.64	73.08	2597.0
2001-08-27	ADBE	Stock	17.95	18.35	17.31	17.94	7574200.0
2001-08-27	ADC	Stock	20.08	20.3	20.08	20.19	5800.0

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

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