PREVIEW / stock_daily / 2005-08-04

all stock daily files

  file:    by_date/stock_daily/2005/2005-08-04.parquet
  size:    140 KB
  rows:    4,159
  symbols: 2,617

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-04	AAPL	Stock	1.5318	1.5357	1.5104	1.5254	269304000.0
2005-08-04	MSFT	Stock	27.16	27.5	27.05	27.32	91461400.0
2005-08-04	NVDA	Stock	0.2302	0.2312	0.2291	0.2296	356424000.0
2005-08-04	AMZN	Stock	2.2775	2.2885	2.271	2.273	99544000.0
2005-08-04	CL	Stock	26.56	26.56	26.125	26.19	3551800.0
2005-08-04	A	Stock	19.0987	19.1059	18.6695	18.7339	2370728.0
2005-08-04	AABA-DELISTED	Stock	34.2599983215332	34.5999984741211	34.0	34.060001373291	11143400.0
2005-08-04	AACC-DELISTED	Stock	26.94	26.94	26.64	26.72	110502.0
2005-08-04	AACQ-DELISTED	Stock	5.05	5.05	5.05	5.05	20000.0
2005-08-04	AACQU-DELISTED	Stock	6.0	6.0	6.0	6.0	1000.0
2005-08-04	AAI-DELISTED	Stock	11.77	11.85	11.21	11.28	1273000.0
2005-08-04	AAIC-DELISTED	Stock	273.0	273.0	261.8	264.0	2127100.0
2005-08-04	AAON	Stock	2.2782	2.3177	2.2545	2.294	564216.0
2005-08-04	AAP	Stock	46.8667	46.8667	46.02	46.3533	2976750.0
2005-08-04	AATI-DELISTED	Stock	11.855	12.25	11.31	11.9	3676050.0
2005-08-04	AAV-DELISTED	Stock	15.22	15.23	15.02	15.22	43200.0
2005-08-04	AAXN-DELISTED	Stock	9.53999996185303	9.53999996185303	9.07999992370605	9.23999977111816	2430600.0
2005-08-04	ABAX-DELISTED	Stock	13.08	13.22	12.82	12.89	74948.0
2005-08-04	ABB-DELISTED	Stock	7.22	7.25	7.16	7.19	536900.0
2005-08-04	ABBC-DELISTED	Stock	12.97	13.0	12.85	13.0	21676.0
2005-08-04	ABC-DELISTED	Stock	17.99	18.05	17.86	17.98	2877200.0
2005-08-04	ABCB	Stock	19.375	19.4236	18.8207	18.8207	6683.0
2005-08-04	ABCO-DELISTED	Stock	26.02	26.34	25.34	25.36	267347.0
2005-08-04	ABE-DELISTED	Stock	10.8	10.82	10.62	10.62	8800.0
2005-08-04	ABFS-DELISTED	Stock	34.89	34.96	34.5	34.62	200634.0
2005-08-04	ABG	Stock	17.64	17.93	17.3	17.34	118400.0
2005-08-04	ABK-DELISTED	Stock	70.4	70.43	69.74	69.8	483200.0
2005-08-04	ABM	Stock	20.0	20.0	19.38	19.46	134100.0
2005-08-04	ABMD-DELISTED	Stock	10.97	10.97	9.98	10.29	172520.0
2005-08-04	ABP-DELISTED	Stock	4.67	4.75	4.5	4.63	292900.0
2005-08-04	ABR	Stock	31.1	31.16	30.59	30.59	94700.0
2005-08-04	ABT	Stock	22.5986	22.7233	22.4738	22.565	6616507.0
2005-08-04	ABTL-DELISTED	Stock	28.85	28.85	26.88	27.8	30904.0
2005-08-04	ABV-DELISTED	Stock	32.7	32.73	32.18	32.38	320700.0
2005-08-04	ABVA-DELISTED	Stock	16.0	16.5	16.0	16.5	5418.0
2005-08-04	ABX-DELISTED	Stock	26.05	26.68	26.02	26.18	3180200.0
2005-08-04	ACAD	Stock	9.18	9.52	8.74	9.47	70800.0
2005-08-04	ACAP-DELISTED	Stock	39.75	39.99	39.34	39.93	39393.0
2005-08-04	ACAS-DELISTED	Stock	38.81	39.32	38.52	39.05	784879.0
2005-08-04	ACAT-DELISTED	Stock	21.86	21.98	21.06	21.1	44769.0
2005-08-04	ACC-DELISTED	Stock	24.82	24.91	24.46	24.6	135599.0
2005-08-04	ACCL-DELISTED	Stock	5.23	5.28	5.0	5.28	182829.0
2005-08-04	ACE-DELISTED	Stock	46.73	46.86	46.21	46.41	937700.0
2005-08-04	ACF-DELISTED	Stock	26.64	26.75	26.25	26.27	691900.0
2005-08-04	ACFC-DELISTED	Stock	71.86	72.22	69.67	70.13	27024.0
2005-08-04	ACG-DELISTED	Stock	8.33	8.35	8.31	8.33	355100.0
2005-08-04	ACGL	Stock	5.0889	5.1344	5.0778	5.09	752400.0
2005-08-04	ACGN-DELISTED	Stock	566.6712	623.3288	566.6712	623.3288	102600.0
2005-08-04	ACH	Stock	20.0	20.0667	19.66	19.7133	273750.0
2005-08-04	ACH-DELISTED	Stock	15.19	15.2	15.055	15.155	102459.0

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

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