PREVIEW / stock_daily / 2005-07-28

all stock daily files

  file:    by_date/stock_daily/2005/2005-07-28.parquet
  size:    139 KB
  rows:    4,169
  symbols: 2,622

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-07-28	AAPL	Stock	1.5661	1.5714	1.5464	1.5643	251311200.0
2005-07-28	MSFT	Stock	25.75	25.85	25.66	25.75	44738700.0
2005-07-28	NVDA	Stock	0.2251	0.2283	0.222	0.2272	411240000.0
2005-07-28	AMZN	Stock	2.177	2.2905	2.1685	2.284	502830000.0
2005-07-28	CL	Stock	26.125	26.73	26.08	26.65	7042200.0
2005-07-28	A	Stock	18.8841	18.9413	18.7768	18.8984	1375492.0
2005-07-28	AABA-DELISTED	Stock	34.2299995422363	34.310001373291	33.9799995422363	34.0099983215332	11871600.0
2005-07-28	AACC-DELISTED	Stock	25.27	26.45	25.27	26.19	334989.0
2005-07-28	AACQ-DELISTED	Stock	5.0	5.05	5.0	5.01	122500.0
2005-07-28	AACQU-DELISTED	Stock	5.8	5.9	5.8	5.9	58200.0
2005-07-28	AACQW-DELISTED	Stock	0.52	0.52	0.5	0.5	73000.0
2005-07-28	AAI-DELISTED	Stock	11.47	11.48	11.22	11.34	1111000.0
2005-07-28	AAIC-DELISTED	Stock	281.0	285.0	271.6	284.4	3388000.0
2005-07-28	AAME	Stock	3.0	3.0	3.0	3.0	7000.0
2005-07-28	AAON	Stock	2.5021	2.5284	2.4494	2.5284	66825.0
2005-07-28	AAP	Stock	44.3333	46.28	44.2667	45.9933	995250.0
2005-07-28	AAV-DELISTED	Stock	14.79	14.93	14.7	14.79	34700.0
2005-07-28	AAXN-DELISTED	Stock	10.1000003814697	10.1000003814697	9.78999996185303	9.97999954223633	1432900.0
2005-07-28	ABAX-DELISTED	Stock	12.25	12.56	11.7	11.97	226459.0
2005-07-28	ABB-DELISTED	Stock	6.8	6.92	6.77	6.87	1688200.0
2005-07-28	ABBC-DELISTED	Stock	12.51	12.51	12.47	12.47	700.0
2005-07-28	ABC-DELISTED	Stock	17.65	18.08	17.65	18.0	4531600.0
2005-07-28	ABCB	Stock	19.3069	19.3653	19.2097	19.3653	5963.0
2005-07-28	ABCO-DELISTED	Stock	24.43	25.2	24.43	24.96	179356.0
2005-07-28	ABCW-DELISTED	Stock	32.3	32.61	31.81	32.25	52800.0
2005-07-28	ABE-DELISTED	Stock	10.37	10.5	10.37	10.41	19200.0
2005-07-28	ABFS-DELISTED	Stock	34.63	35.35	34.18	35.08	371714.0
2005-07-28	ABG	Stock	16.95	17.08	16.8	17.0	138600.0
2005-07-28	ABK-DELISTED	Stock	71.3	71.87	71.16	71.84	321100.0
2005-07-28	ABM	Stock	19.62	19.97	19.51	19.97	156500.0
2005-07-28	ABMD-DELISTED	Stock	9.85	9.91	9.51	9.9	54071.0
2005-07-28	ABP-DELISTED	Stock	4.24	4.35	4.15	4.28	241800.0
2005-07-28	ABR	Stock	30.6	30.86	30.45	30.65	160800.0
2005-07-28	ABT	Stock	22.2867	22.6226	22.1668	22.4642	7670696.0
2005-07-28	ABTL-DELISTED	Stock	24.57	26.23	24.12	26.03	47173.0
2005-07-28	ABV-DELISTED	Stock	30.78	31.35	30.73	31.26	255600.0
2005-07-28	ABVA-DELISTED	Stock	15.95	16.4	15.86	16.4	10257.0
2005-07-28	ABVT-DELISTED	Stock	25.0	25.0	25.0	25.0	500.0
2005-07-28	ABX-DELISTED	Stock	24.4	24.5	24.21	24.36	2024900.0
2005-07-28	ACAD	Stock	9.44	9.57	9.44	9.51	17800.0
2005-07-28	ACAP-DELISTED	Stock	38.75	39.42	38.73	39.22	57058.0
2005-07-28	ACAS-DELISTED	Stock	37.6	37.92	37.51	37.79	332880.0
2005-07-28	ACAT-DELISTED	Stock	21.3	21.8	20.98	21.79	65497.0
2005-07-28	ACC-DELISTED	Stock	24.5	25.2	24.42	25.01	253700.0
2005-07-28	ACCL-DELISTED	Stock	5.53	5.65	5.43	5.56	119562.0
2005-07-28	ACE-DELISTED	Stock	46.84	46.89	46.45	46.75	424300.0
2005-07-28	ACF-DELISTED	Stock	26.64	27.0	26.61	26.9	607000.0
2005-07-28	ACFC-DELISTED	Stock	69.64	70.71	69.39	70.71	3901.0
2005-07-28	ACG-DELISTED	Stock	8.33	8.38	8.32	8.35	499900.0
2005-07-28	ACGL	Stock	5.0433	5.2156	5.0333	5.1867	1285200.0

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

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