PREVIEW / stock_daily / 2005-09-01

all stock daily files

  file:    by_date/stock_daily/2005/2005-09-01.parquet
  size:    140 KB
  rows:    4,187
  symbols: 2,634

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-09-01	AAPL	Stock	1.6786	1.6846	1.6461	1.6521	356367200.0
2005-09-01	MSFT	Stock	27.38	27.39	27.15	27.2	75974500.0
2005-09-01	NVDA	Stock	0.2549	0.2581	0.2536	0.2557	556884000.0
2005-09-01	AMZN	Stock	2.126	2.1485	2.0875	2.092	88580000.0
2005-09-01	CL	Stock	26.275	26.43	26.08	26.32	2779600.0
2005-09-01	A	Stock	22.8255	23.1903	22.804	23.0973	6032650.0
2005-09-01	AABA-DELISTED	Stock	33.2799987792969	33.5099983215332	33.0400009155273	33.2400016784668	11848500.0
2005-09-01	AACC-DELISTED	Stock	28.93	29.0	28.1501	28.22	123393.0
2005-09-01	AACQ-DELISTED	Stock	5.1	5.1	5.1	5.1	35716.0
2005-09-01	AACQU-DELISTED	Stock	6.1	6.1	6.1	6.1	4000.0
2005-09-01	AACQW-DELISTED	Stock	0.52	0.54	0.48	0.54	108924.0
2005-09-01	AAI-DELISTED	Stock	10.24	10.33	9.75	9.78	1887500.0
2005-09-01	AAIC-DELISTED	Stock	233.8	242.0	231.2	237.0	1683200.0
2005-09-01	AAON	Stock	2.3625	2.4691	2.3625	2.3993	181491.0
2005-09-01	AAP	Stock	40.3133	40.5667	39.5	39.5733	1250100.0
2005-09-01	AATI-DELISTED	Stock	12.9	13.28	12.77	13.28	104570.0
2005-09-01	AAV-DELISTED	Stock	16.9	19.87	16.58	16.9	38600.0
2005-09-01	AAXN-DELISTED	Stock	8.6899995803833	8.69999980926514	8.52000045776367	8.53999996185303	1147600.0
2005-09-01	ABAX-DELISTED	Stock	11.39	11.88	11.35	11.76	117148.0
2005-09-01	ABB-DELISTED	Stock	7.43	7.53	7.43	7.51	2571900.0
2005-09-01	ABBC-DELISTED	Stock	12.76	12.79	12.61	12.79	2300.0
2005-09-01	ABC-DELISTED	Stock	18.64	18.71	18.49	18.64	1668400.0
2005-09-01	ABCB	Stock	17.955	18.0911	17.6146	18.0911	10795.0
2005-09-01	ABCO-DELISTED	Stock	25.99	26.51	25.93	26.24	103473.0
2005-09-01	ABCW-DELISTED	Stock	30.47	30.92	29.98	30.92	55960.0
2005-09-01	ABD-DELISTED	Stock	25.83	26.94	25.83	26.93	513500.0
2005-09-01	ABE-DELISTED	Stock	10.58	10.6	10.5	10.54	19100.0
2005-09-01	ABFS-DELISTED	Stock	33.67	35.06	33.22	34.92	288305.0
2005-09-01	ABG	Stock	17.05	17.1	16.77	17.1	50700.0
2005-09-01	ABK-DELISTED	Stock	68.33	68.5	67.86	67.9	935600.0
2005-09-01	ABM	Stock	19.83	20.02	19.5	19.66	121200.0
2005-09-01	ABMD-DELISTED	Stock	9.94	9.94	9.67	9.72	66822.0
2005-09-01	ABP-DELISTED	Stock	4.69	4.79	4.6	4.6	336200.0
2005-09-01	ABR	Stock	28.5	28.51	28.03	28.13	113200.0
2005-09-01	ABT	Stock	21.7445	21.8837	21.5142	21.6582	7044810.0
2005-09-01	ABTL-DELISTED	Stock	24.9	25.8	24.9	25.35	94378.0
2005-09-01	ABV-DELISTED	Stock	32.25	32.7	31.92	32.5	228500.0
2005-09-01	ABVA-DELISTED	Stock	16.3	16.4	16.3	16.4	8000.0
2005-09-01	ABX-DELISTED	Stock	26.69	27.56	26.6	27.28	3221400.0
2005-09-01	ACAD	Stock	9.5	9.95	9.45	9.91	280700.0
2005-09-01	ACAP-DELISTED	Stock	44.23	44.62	43.96	44.49	23269.0
2005-09-01	ACAS-DELISTED	Stock	37.8	38.18	37.51	38.12	502084.0
2005-09-01	ACAT-DELISTED	Stock	21.54	21.72	21.2	21.55	60993.0
2005-09-01	ACC-DELISTED	Stock	23.56	24.2	23.56	23.79	80200.0
2005-09-01	ACCL-DELISTED	Stock	5.4	5.64	5.29	5.52	84294.0
2005-09-01	ACCO	Stock	25.88	27.0	25.88	26.88	514300.0
2005-09-01	ACE-DELISTED	Stock	44.32	44.8	44.11	44.72	1513300.0
2005-09-01	ACF-DELISTED	Stock	24.93	24.99	24.65	24.88	1288600.0
2005-09-01	ACFC-DELISTED	Stock	72.6	73.01	72.35	72.96	2100.0
2005-09-01	ACG-DELISTED	Stock	8.37	8.38	8.32	8.33	447000.0

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

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