PREVIEW / stock_daily / 2005-08-09

all stock daily files

  file:    by_date/stock_daily/2005/2005-08-09.parquet
  size:    140 KB
  rows:    4,163
  symbols: 2,616

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-08-09	AAPL	Stock	1.5332	1.5675	1.5325	1.565	380839200.0
2005-08-09	MSFT	Stock	27.22	27.51	27.01	27.35	64761800.0
2005-08-09	NVDA	Stock	0.2366	0.2372	0.2331	0.2357	291900000.0
2005-08-09	AMZN	Stock	2.288	2.322	2.2875	2.2965	91824000.0
2005-08-09	CL	Stock	26.365	26.39	26.24	26.315	2637400.0
2005-08-09	A	Stock	18.1688	18.3834	18.1116	18.2976	1702904.0
2005-08-09	AABA-DELISTED	Stock	34.1500015258789	34.3199996948242	33.9099998474121	34.060001373291	9987400.0
2005-08-09	AACC-DELISTED	Stock	27.75	28.2	27.3	27.45	394024.0
2005-08-09	AACQ-DELISTED	Stock	5.05	5.05	5.05	5.05	7000.0
2005-08-09	AACQU-DELISTED	Stock	6.0	6.0	6.0	6.0	5500.0
2005-08-09	AAI-DELISTED	Stock	11.05	11.24	10.96	11.12	537600.0
2005-08-09	AAIC-DELISTED	Stock	259.0	259.0	252.0	252.0	2204100.0
2005-08-09	AAME	Stock	2.88	2.89	2.51	2.87	7800.0
2005-08-09	AAON	Stock	2.1597	2.1873	2.1267	2.1728	176175.0
2005-08-09	AAP	Stock	45.82	45.8467	44.9867	45.66	1856850.0
2005-08-09	AATI-DELISTED	Stock	11.2	11.79	11.0	11.74	569721.0
2005-08-09	AAV-DELISTED	Stock	15.18	16.25	15.15	15.18	38200.0
2005-08-09	AAXN-DELISTED	Stock	8.88000011444092	9.0	8.78999996185303	8.81999969482422	1101000.0
2005-08-09	ABAX-DELISTED	Stock	11.53	11.91	11.49	11.56	149462.0
2005-08-09	ABB-DELISTED	Stock	7.2	7.28	7.18	7.27	795800.0
2005-08-09	ABBC-DELISTED	Stock	12.85	12.85	12.7	12.76	35350.0
2005-08-09	ABC-DELISTED	Stock	18.19	18.29	18.15	18.27	2358800.0
2005-08-09	ABCB	Stock	18.8401	19.2	18.4315	18.4315	10795.0
2005-08-09	ABCO-DELISTED	Stock	25.53	26.03	25.47	25.99	251642.0
2005-08-09	ABCW-DELISTED	Stock	30.73	30.92	30.14	30.18	14040.0
2005-08-09	ABE-DELISTED	Stock	10.49	10.5	10.46	10.5	6500.0
2005-08-09	ABFS-DELISTED	Stock	34.23	34.79	34.001	34.25	189882.0
2005-08-09	ABG	Stock	17.82	17.93	17.63	17.86	77700.0
2005-08-09	ABK-DELISTED	Stock	69.22	69.39	68.97	69.18	535600.0
2005-08-09	ABM	Stock	19.49	19.59	19.25	19.48	107800.0
2005-08-09	ABMD-DELISTED	Stock	9.95	10.1	9.94	10.04	121101.0
2005-08-09	ABP-DELISTED	Stock	4.85	4.85	4.65	4.68	365500.0
2005-08-09	ABR	Stock	27.75	27.75	26.68	26.9	243100.0
2005-08-09	ABT	Stock	22.2627	22.4259	22.2627	22.3587	6493539.0
2005-08-09	ABTL-DELISTED	Stock	26.32	26.97	21.98	22.63	356609.0
2005-08-09	ABV-DELISTED	Stock	32.0	32.86	31.93	32.86	559700.0
2005-08-09	ABVA-DELISTED	Stock	16.4	16.4	16.4	16.4	4200.0
2005-08-09	ABVT-DELISTED	Stock	25.0	25.0	25.0	25.0	18900.0
2005-08-09	ABX-DELISTED	Stock	26.07	26.25	25.86	26.14	1451600.0
2005-08-09	ACAD	Stock	8.8	9.0	8.78	8.87	14400.0
2005-08-09	ACAP-DELISTED	Stock	40.01	40.37	39.75	40.37	89332.0
2005-08-09	ACAS-DELISTED	Stock	38.25	38.75	37.89	38.43	835750.0
2005-08-09	ACAT-DELISTED	Stock	21.08	21.41	20.72	20.82	41542.0
2005-08-09	ACC-DELISTED	Stock	23.9	24.24	23.9	24.06	196900.0
2005-08-09	ACCL-DELISTED	Stock	5.74	5.86	5.41	5.46	120179.0
2005-08-09	ACE-DELISTED	Stock	45.6	45.71	45.22	45.53	736900.0
2005-08-09	ACF-DELISTED	Stock	27.1	27.14	25.36	25.54	3037600.0
2005-08-09	ACFC-DELISTED	Stock	70.15	70.15	69.39	69.39	1361.0
2005-08-09	ACG-DELISTED	Stock	8.22	8.23	8.19	8.22	427900.0
2005-08-09	ACGL	Stock	5.0856	5.1133	5.0256	5.1133	680400.0

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

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