PREVIEW / stock_daily / 2005-07-27

all stock daily files

  file:    by_date/stock_daily/2005/2005-07-27.parquet
  size:    139 KB
  rows:    4,167
  symbols: 2,623

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
2005-07-27	AAPL	Stock	1.5654	1.5739	1.5239	1.5711	283749200.0
2005-07-27	MSFT	Stock	25.61	25.8	25.53	25.72	57977300.0
2005-07-27	NVDA	Stock	0.2213	0.2265	0.2176	0.2255	807828000.0
2005-07-27	AMZN	Stock	2.1005	2.187	2.092	2.1825	921512000.0
2005-07-27	CL	Stock	26.025	26.28	26.0	26.0	6243200.0
2005-07-27	A	Stock	18.6338	19.0486	18.598	18.8841	3298581.0
2005-07-27	AABA-DELISTED	Stock	34.2200012207031	34.3699989318848	33.9500007629395	34.2900009155273	20497500.0
2005-07-27	AACC-DELISTED	Stock	24.7	24.93	23.46	24.9	186978.0
2005-07-27	AACQ-DELISTED	Stock	5.0	5.0	5.0	5.0	10000.0
2005-07-27	AACQW-DELISTED	Stock	0.47	0.47	0.47	0.47	10000.0
2005-07-27	AAI-DELISTED	Stock	11.44	11.7	11.36	11.51	1819700.0
2005-07-27	AAIC-DELISTED	Stock	290.2	294.2	286.8	294.0	859400.0
2005-07-27	AAME	Stock	3.0	3.0	3.0	3.0	21500.0
2005-07-27	AAON	Stock	2.5455	2.5481	2.4797	2.4968	59991.0
2005-07-27	AAP	Stock	44.0867	44.2267	43.8	44.1333	644100.0
2005-07-27	AAV-DELISTED	Stock	14.84	14.89	14.7	14.84	21200.0
2005-07-27	AAXN-DELISTED	Stock	10.0600004196167	10.1999998092651	9.57999992370605	9.96000003814697	3811900.0
2005-07-27	ABAX-DELISTED	Stock	12.43	12.73	12.2001	12.25	153568.0
2005-07-27	ABB-DELISTED	Stock	6.58	6.69	6.55	6.68	541700.0
2005-07-27	ABBC-DELISTED	Stock	12.56	12.65	12.53	12.58	4931.0
2005-07-27	ABC-DELISTED	Stock	17.56	17.67	17.5	17.64	4040000.0
2005-07-27	ABCB	Stock	19.054	19.2875	18.8887	19.1708	6786.0
2005-07-27	ABCO-DELISTED	Stock	25.09	25.15	24.38	24.8	185407.0
2005-07-27	ABCW-DELISTED	Stock	32.03	32.1	31.49	32.01	15807.0
2005-07-27	ABE-DELISTED	Stock	10.32	10.36	10.29	10.3	6900.0
2005-07-27	ABFS-DELISTED	Stock	34.55	34.9	33.79	34.35	469064.0
2005-07-27	ABG	Stock	16.94	16.95	16.52	16.75	89300.0
2005-07-27	ABK-DELISTED	Stock	71.61	71.96	71.12	71.33	565600.0
2005-07-27	ABM	Stock	19.8	19.84	19.59	19.6	149400.0
2005-07-27	ABMD-DELISTED	Stock	9.74	9.92	9.64	9.9	61607.0
2005-07-27	ABP-DELISTED	Stock	4.17	4.22	4.06	4.22	248500.0
2005-07-27	ABR	Stock	30.05	30.45	29.8	30.45	151300.0
2005-07-27	ABT	Stock	22.0612	22.3011	21.9556	22.1908	6142351.0
2005-07-27	ABTL-DELISTED	Stock	23.5	24.8	23.5	24.65	40193.0
2005-07-27	ABV-DELISTED	Stock	30.02	30.72	29.68	30.57	541500.0
2005-07-27	ABX-DELISTED	Stock	24.44	24.6	24.23	24.37	1419949.0
2005-07-27	ACAD	Stock	9.61	9.73	9.43	9.48	19800.0
2005-07-27	ACAP-DELISTED	Stock	38.79	38.93	38.21	38.8	57214.0
2005-07-27	ACAS-DELISTED	Stock	37.5	37.55	37.25	37.5	401006.0
2005-07-27	ACAT-DELISTED	Stock	20.68	21.14	20.49	21.13	64328.0
2005-07-27	ACC-DELISTED	Stock	24.2	24.36	24.15	24.36	139500.0
2005-07-27	ACCL-DELISTED	Stock	5.52	5.69	5.52	5.6	119709.0
2005-07-27	ACE-DELISTED	Stock	46.19	46.55	45.9	46.51	773300.0
2005-07-27	ACF-DELISTED	Stock	26.96	26.98	26.4	26.66	657900.0
2005-07-27	ACFC-DELISTED	Stock	68.98	69.9	68.98	69.64	520.0
2005-07-27	ACG-DELISTED	Stock	8.34	8.35	8.31	8.33	285400.0
2005-07-27	ACGL	Stock	5.0244	5.0422	5.0033	5.0422	696600.0
2005-07-27	ACGN-DELISTED	Stock	600.6712	623.3288	555.3288	566.6712	163000.0
2005-07-27	ACH	Stock	19.42	19.66	19.2267	19.6133	238500.0
2005-07-27	ACH-DELISTED	Stock	14.438	14.548	14.438	14.498	135598.0

> showing 50 of 4,167 rows — these rows as CSV

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