PREVIEW / stock_daily / 2005-01-04

all stock daily files

  file:    by_date/stock_daily/2005/2005-01-04.parquet
  size:    135 KB
  rows:    3,981
  symbols: 2,499

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-01-04	AAPL	Stock	1.1391	1.1691	1.1245	1.1418	1096810400.0
2005-01-04	MSFT	Stock	26.87	27.1	26.66	26.84	109442100.0
2005-01-04	NVDA	Stock	0.1979	0.1982	0.1842	0.1872	790224000.0
2005-01-04	AMZN	Stock	2.1335	2.163	2.075	2.107	388370000.0
2005-01-04	CL	Stock	25.06	25.24	24.835	24.835	3895800.0
2005-01-04	A	Stock	17.01	17.1602	16.4878	16.6309	3746920.0
2005-01-04	AABA-DELISTED	Stock	38.4500007629395	38.5400009155273	36.4599990844727	36.5800018310547	26625300.0
2005-01-04	AACC-DELISTED	Stock	21.65	21.71	20.96	21.0	61047.0
2005-01-04	AAI-DELISTED	Stock	10.7	10.7	9.68	9.94	3527900.0
2005-01-04	AAIC-DELISTED	Stock	384.0	384.4	372.2	373.6	1290600.0
2005-01-04	AAME	Stock	3.11	3.15	3.03	3.15	4800.0
2005-01-04	AAON	Stock	1.9463	1.9898	1.9424	1.9621	266541.0
2005-01-04	AAP	Stock	29.1	29.1667	28.6733	28.84	958650.0
2005-01-04	AAV-DELISTED	Stock	17.56	18.2	17.44	17.56	46300.0
2005-01-04	AAXN-DELISTED	Stock	30.2700004577637	30.2700004577637	28.5	28.6900005340576	9883700.0
2005-01-04	ABAX-DELISTED	Stock	14.23	14.23	13.21	13.38	209842.0
2005-01-04	ABB-DELISTED	Stock	5.71	5.75	5.6	5.6	268700.0
2005-01-04	ABBC-DELISTED	Stock	13.0	13.3	12.95	13.081	199091.0
2005-01-04	ABC-DELISTED	Stock	14.6	14.62	14.28	14.4	7236400.0
2005-01-04	ABCB	Stock	17.1428	17.1428	16.2107	16.3323	13941.0
2005-01-04	ABCO-DELISTED	Stock	18.94	18.94	18.35	18.545	369682.0
2005-01-04	ABCW-DELISTED	Stock	28.95	29.23	28.5	28.59	51990.0
2005-01-04	ABE-DELISTED	Stock	10.01	10.03	9.86	9.87	48000.0
2005-01-04	ABFS-DELISTED	Stock	45.16	45.49	43.54	43.6	182217.0
2005-01-04	ABG	Stock	13.89	13.9	13.61	13.86	34500.0
2005-01-04	ABK-DELISTED	Stock	82.85	82.92	81.14	81.35	343200.0
2005-01-04	ABM	Stock	18.82	19.19	18.41	18.52	209200.0
2005-01-04	ABMD-DELISTED	Stock	15.18	15.2	14.76	14.9	137731.0
2005-01-04	ABP-DELISTED	Stock	2.26	2.33	2.26	2.3	70400.0
2005-01-04	ABR	Stock	24.4	24.45	24.0	24.04	64900.0
2005-01-04	ABT	Stock	22.3971	22.4211	22.0468	22.1668	7886828.0
2005-01-04	ABTL-DELISTED	Stock	30.5	30.95	28.75	29.0	149100.0
2005-01-04	ABV-DELISTED	Stock	28.68	28.87	27.43	27.53	372300.0
2005-01-04	ABVA-DELISTED	Stock	15.0	15.039	15.0	15.032	1300.0
2005-01-04	ABX-DELISTED	Stock	23.5	23.51	22.9	22.93	2575100.0
2005-01-04	ACAD	Stock	6.65	6.65	6.28	6.28	6800.0
2005-01-04	ACAP-DELISTED	Stock	35.87	36.35	35.6	35.64	54879.0
2005-01-04	ACAS-DELISTED	Stock	33.07	33.18	32.01	32.07	781686.0
2005-01-04	ACAT-DELISTED	Stock	25.95	26.06	25.27	25.48	104427.0
2005-01-04	ACC-DELISTED	Stock	22.65	22.65	21.6	22.01	61700.0
2005-01-04	ACCL-DELISTED	Stock	7.41	7.48	6.733	6.76	223508.0
2005-01-04	ACE-DELISTED	Stock	42.29	42.58	42.21	42.27	881727.0
2005-01-04	ACF-DELISTED	Stock	24.1	24.27	23.42	23.6	1090700.0
2005-01-04	ACFC-DELISTED	Stock	69.75	71.25	69.28	69.49	3302.0
2005-01-04	ACG-DELISTED	Stock	8.19	8.19	8.15	8.16	358500.0
2005-01-04	ACGL	Stock	4.23	4.2344	4.1767	4.1778	1253700.0
2005-01-04	ACGN-DELISTED	Stock	555.3288	566.6712	532.6712	544.0	99300.0
2005-01-04	ACH	Stock	18.76	18.9	18.2467	18.3267	264150.0
2005-01-04	ACH-DELISTED	Stock	14.57	14.57	14.173	14.19	556578.0
2005-01-04	ACLS	Stock	31.64	32.12	29.32	29.56	262275.0

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

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