PREVIEW / stock_daily / 2005-01-27

all stock daily files

  file:    by_date/stock_daily/2005/2005-01-27.parquet
  size:    132 KB
  rows:    3,956
  symbols: 2,473

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-27	AAPL	Stock	1.2886	1.3021	1.2777	1.2971	496227200.0
2005-01-27	MSFT	Stock	25.95	26.16	25.85	26.11	93204100.0
2005-01-27	NVDA	Stock	0.1771	0.1917	0.176	0.1909	1002912000.0
2005-01-27	AMZN	Stock	2.0635	2.12	2.057	2.1155	160768000.0
2005-01-27	CL	Stock	25.975	26.46	25.485	26.345	14601800.0
2005-01-27	A	Stock	15.6724	15.9013	15.5222	15.7368	2677310.0
2005-01-27	AABA-DELISTED	Stock	35.3800010681152	35.4900016784668	34.3499984741211	34.7299995422363	21450800.0
2005-01-27	AACC-DELISTED	Stock	20.69	20.85	19.6	20.39	44006.0
2005-01-27	AAI-DELISTED	Stock	7.89	8.06	7.882	8.03	1284400.0
2005-01-27	AAIC-DELISTED	Stock	392.8	395.0	388.2	389.4	585400.0
2005-01-27	AAME	Stock	3.0	3.09	3.0	3.07	26800.0
2005-01-27	AAON	Stock	1.8621	1.866	1.8305	1.8449	82772.0
2005-01-27	AAP	Stock	28.2733	28.58	28.26	28.5533	287850.0
2005-01-27	AAV-DELISTED	Stock	17.63	17.69	17.52	17.63	60700.0
2005-01-27	AAXN-DELISTED	Stock	16.4899997711182	18.0300006866455	16.1800003051758	17.5599994659424	11014800.0
2005-01-27	ABAX-DELISTED	Stock	13.34	13.38	12.95	13.05	73313.0
2005-01-27	ABB-DELISTED	Stock	5.51	5.52	5.45	5.48	174200.0
2005-01-27	ABBC-DELISTED	Stock	13.2	13.2	13.05	13.12	48512.0
2005-01-27	ABC-DELISTED	Stock	14.52	14.58	14.31	14.37	4285600.0
2005-01-27	ABCB	Stock	15.2381	16.0891	15.2381	15.8054	7896.0
2005-01-27	ABCO-DELISTED	Stock	17.89	17.895	17.745	17.81	145062.0
2005-01-27	ABCW-DELISTED	Stock	26.75	27.1	26.75	27.0	18930.0
2005-01-27	ABE-DELISTED	Stock	9.57	9.65	9.51	9.6	31200.0
2005-01-27	ABFS-DELISTED	Stock	41.2	41.2	39.24	39.8	713923.0
2005-01-27	ABG	Stock	16.8	17.15	16.8	16.92	89600.0
2005-01-27	ABK-DELISTED	Stock	76.58	77.12	75.8	76.43	1441200.0
2005-01-27	ABM	Stock	18.34	18.5	18.13	18.27	105600.0
2005-01-27	ABMD-DELISTED	Stock	11.15	11.87	11.03	11.57	155960.0
2005-01-27	ABP-DELISTED	Stock	2.04	2.26	2.04	2.25	227500.0
2005-01-27	ABR	Stock	23.67	23.92	23.52	23.74	63900.0
2005-01-27	ABT	Stock	21.97	22.0948	21.7733	21.8117	8253856.0
2005-01-27	ABTL-DELISTED	Stock	27.8	28.75	27.55	27.95	43100.0
2005-01-27	ABV-DELISTED	Stock	25.0	25.06	24.52	24.82	330000.0
2005-01-27	ABVA-DELISTED	Stock	15.7	15.9	15.7	15.71	432.0
2005-01-27	ABVT-DELISTED	Stock	30.0	30.0	30.0	30.0	300.0
2005-01-27	ABX-DELISTED	Stock	22.1	22.24	21.91	22.19	758800.0
2005-01-27	ACAD	Stock	6.6	7.0	6.6	7.0	12800.0
2005-01-27	ACAP-DELISTED	Stock	35.01	35.45	34.98	34.98	32789.0
2005-01-27	ACAS-DELISTED	Stock	33.55	33.93	33.45	33.71	695303.0
2005-01-27	ACAT-DELISTED	Stock	25.17	25.36	25.06	25.32	76771.0
2005-01-27	ACC-DELISTED	Stock	20.74	20.91	19.09	19.24	68000.0
2005-01-27	ACCL-DELISTED	Stock	5.34	5.66	4.74	5.65	708765.0
2005-01-27	ACE-DELISTED	Stock	42.97	43.24	42.65	42.75	610200.0
2005-01-27	ACF-DELISTED	Stock	23.9	24.3	23.9	24.03	815200.0
2005-01-27	ACFC-DELISTED	Stock	66.33	66.33	66.02	66.22	433.0
2005-01-27	ACG-DELISTED	Stock	8.2	8.23	8.19	8.23	375000.0
2005-01-27	ACGL	Stock	4.1033	4.1389	4.0933	4.0989	729000.0
2005-01-27	ACGN-DELISTED	Stock	748.0	782.0	646.0	691.3288	746300.0
2005-01-27	ACH	Stock	18.78	19.12	18.6	19.0267	218100.0
2005-01-27	ACH-DELISTED	Stock	13.495	13.652	13.433	13.555	139246.0

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

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