PREVIEW / stock_daily / 2004-09-27

all stock daily files

  file:    by_date/stock_daily/2004/2004-09-27.parquet
  size:    128 KB
  rows:    3,809
  symbols: 2,376

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
2004-09-27	AAPL	Stock	0.6598	0.6782	0.6577	0.6702	397516000.0
2004-09-27	MSFT	Stock	27.17	27.32	27.13	27.19	47813600.0
2004-09-27	NVDA	Stock	0.1162	0.1175	0.1129	0.115	406020000.0
2004-09-27	AMZN	Stock	2.0455	2.0505	1.9875	1.9965	167948000.0
2004-09-27	CL	Stock	22.7	22.775	22.575	22.615	9241400.0
2004-09-27	A	Stock	15.5222	15.5866	15.2361	15.2718	4113475.0
2004-09-27	AABA-DELISTED	Stock	32.5400009155273	32.7200012207031	31.6499996185303	31.8199996948242	15218800.0
2004-09-27	AACC-DELISTED	Stock	16.92	17.18	16.5	16.88	25609.0
2004-09-27	AAI-DELISTED	Stock	10.28	10.28	9.73	9.76	1924400.0
2004-09-27	AAIC-DELISTED	Stock	408.4	409.0	395.0	396.2	1585000.0
2004-09-27	AAME	Stock	3.12	3.14	3.02	3.14	3800.0
2004-09-27	AAON	Stock	2.3612	2.398	2.3111	2.3111	42525.0
2004-09-27	AAP	Stock	23.4333	23.4333	23.1	23.22	1537200.0
2004-09-27	AAV-DELISTED	Stock	16.88	16.92	16.65	16.88	29300.0
2004-09-27	AAXN-DELISTED	Stock	19.5300006866455	19.5849990844727	18.8649997711182	19.1800003051758	6961200.0
2004-09-27	ABAX-DELISTED	Stock	13.51	13.51	12.73	13.05	337820.0
2004-09-27	ABB-DELISTED	Stock	5.92	5.95	5.87	5.87	178600.0
2004-09-27	ABC-DELISTED	Stock	13.72	13.72	13.56	13.59	3236000.0
2004-09-27	ABCB	Stock	15.6352	15.6352	15.2867	15.4082	14188.0
2004-09-27	ABCO-DELISTED	Stock	16.51	16.6	16.315	16.375	64900.0
2004-09-27	ABCW-DELISTED	Stock	25.71	25.71	25.39	25.5	42790.0
2004-09-27	ABE-DELISTED	Stock	7.8	7.88	7.8	7.84	11900.0
2004-09-27	ABFS-DELISTED	Stock	35.95	36.33	35.55	35.91	204079.0
2004-09-27	ABG	Stock	13.15	13.15	12.69	12.8	489100.0
2004-09-27	ABK-DELISTED	Stock	77.5	77.5	76.79	76.98	326300.0
2004-09-27	ABM	Stock	20.04	20.33	19.92	19.96	94100.0
2004-09-27	ABMD-DELISTED	Stock	9.87	10.04	8.65	8.72	732724.0
2004-09-27	ABP-DELISTED	Stock	2.2	2.34	2.17	2.25	343000.0
2004-09-27	ABR	Stock	20.95	21.2	20.95	20.95	7300.0
2004-09-27	ABT	Stock	20.2332	20.4779	20.2092	20.3579	7018549.0
2004-09-27	ABTL-DELISTED	Stock	42.4	42.8	40.75	42.15	51500.0
2004-09-27	ABV-DELISTED	Stock	22.0	22.11	22.0	22.05	175700.0
2004-09-27	ABVA-DELISTED	Stock	14.98	14.98	14.98	14.98	200.0
2004-09-27	ABVT-DELISTED	Stock	23.63	24.0	23.63	24.0	7600.0
2004-09-27	ABX-DELISTED	Stock	20.03	20.17	19.89	20.02	1106212.0
2004-09-27	ACAD	Stock	7.25	7.25	7.03	7.2	5300.0
2004-09-27	ACAP-DELISTED	Stock	30.41	30.41	29.75	29.8	25943.0
2004-09-27	ACAS-DELISTED	Stock	31.69	31.74	31.31	31.31	1239671.0
2004-09-27	ACAT-DELISTED	Stock	25.83	26.16	25.45	25.46	66902.0
2004-09-27	ACC-DELISTED	Stock	18.6	18.7	18.4	18.45	376200.0
2004-09-27	ACCL-DELISTED	Stock	5.8	5.87	5.57	5.65	186545.0
2004-09-27	ACE-DELISTED	Stock	39.19	39.23	38.16	38.34	1297700.0
2004-09-27	ACF-DELISTED	Stock	21.32	21.35	20.99	21.16	901000.0
2004-09-27	ACG-DELISTED	Stock	8.15	8.18	8.14	8.16	305000.0
2004-09-27	ACGL	Stock	4.2544	4.2544	4.18	4.1844	934200.0
2004-09-27	ACGN-DELISTED	Stock	714.0	782.0	702.6712	748.0	333700.0
2004-09-27	ACH	Stock	16.6667	16.6667	16.3	16.4	122250.0
2004-09-27	ACH-DELISTED	Stock	15.25	15.324	15.155	15.297	322001.0
2004-09-27	ACLS	Stock	32.32	32.32	30.76	31.36	141800.0
2004-09-27	ACO-DELISTED	Stock	18.25	18.34	18.0	18.05	58100.0

> showing 50 of 3,809 rows — these rows as CSV

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