PREVIEW / stock_daily / 2005-04-07

all stock daily files

  file:    by_date/stock_daily/2005/2005-04-07.parquet
  size:    135 KB
  rows:    4,030
  symbols: 2,521

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-04-07	AAPL	Stock	1.5118	1.5625	1.5089	1.5557	506987600.0
2005-04-07	MSFT	Stock	24.66	25.13	24.63	25.1	77451500.0
2005-04-07	NVDA	Stock	0.1954	0.2	0.1921	0.198	506352000.0
2005-04-07	AMZN	Stock	1.734	1.746	1.725	1.745	76146000.0
2005-04-07	CL	Stock	26.455	26.77	26.315	26.77	3203400.0
2005-04-07	A	Stock	15.4506	15.4793	15.2933	15.4363	4072374.0
2005-04-07	AABA-DELISTED	Stock	34.4500007629395	35.25	34.4500007629395	35.0699996948242	20575000.0
2005-04-07	AACC-DELISTED	Stock	19.11	19.54	18.98	19.43	100429.0
2005-04-07	AACQU-DELISTED	Stock	6.34	6.35	6.34	6.35	11500.0
2005-04-07	AAI-DELISTED	Stock	9.5	9.7	9.47	9.53	1585500.0
2005-04-07	AAIC-DELISTED	Stock	283.6	297.0	283.2	288.4	3254700.0
2005-04-07	AAON	Stock	2.1267	2.1728	2.1267	2.1728	28856.0
2005-04-07	AAP	Stock	34.2	34.2733	33.9267	34.2067	495600.0
2005-04-07	AAV-DELISTED	Stock	15.35	15.81	15.28	15.35	35900.0
2005-04-07	AAXN-DELISTED	Stock	9.60999965667725	9.67000007629395	9.35999965667725	9.39999961853027	3799400.0
2005-04-07	ABAX-DELISTED	Stock	8.46	8.5	8.34	8.49	56956.0
2005-04-07	ABB-DELISTED	Stock	6.36	6.44	6.34	6.42	1579500.0
2005-04-07	ABBC-DELISTED	Stock	12.59	12.59	12.45	12.53	19401.0
2005-04-07	ABC-DELISTED	Stock	14.72	14.85	14.7	14.8	6238000.0
2005-04-07	ABCB	Stock	18.4413	18.6455	18.2565	18.4899	22824.0
2005-04-07	ABCO-DELISTED	Stock	21.98	21.98	21.57	21.61	149764.0
2005-04-07	ABCW-DELISTED	Stock	27.87	28.08	27.54	27.91	40740.0
2005-04-07	ABE-DELISTED	Stock	9.4	9.5	9.4	9.5	7100.0
2005-04-07	ABFS-DELISTED	Stock	37.75	37.97	36.92	37.81	481102.0
2005-04-07	ABG	Stock	15.15	15.38	14.9	15.32	59800.0
2005-04-07	ABK-DELISTED	Stock	75.9	76.83	75.55	76.6	606800.0
2005-04-07	ABM	Stock	19.0	19.38	19.0	19.23	105400.0
2005-04-07	ABMD-DELISTED	Stock	11.17	11.28	11.12	11.24	52288.0
2005-04-07	ABP-DELISTED	Stock	3.04	3.12	2.99	3.05	228900.0
2005-04-07	ABR	Stock	25.5	25.5	25.37	25.45	30900.0
2005-04-07	ABT	Stock	22.8433	23.2655	22.8145	23.1983	9074614.0
2005-04-07	ABTL-DELISTED	Stock	25.0	25.7	24.75	25.3	23300.0
2005-04-07	ABV-DELISTED	Stock	28.45	28.8	28.31	28.71	272300.0
2005-04-07	ABVA-DELISTED	Stock	15.34	15.46	15.34	15.43	701.0
2005-04-07	ABX-DELISTED	Stock	24.09	24.49	24.05	24.07	2280950.0
2005-04-07	ACAD	Stock	7.05	7.05	6.91	6.91	500.0
2005-04-07	ACAP-DELISTED	Stock	34.85	35.01	34.57	35.0	45701.0
2005-04-07	ACAS-DELISTED	Stock	31.82	31.82	31.48	31.64	582908.0
2005-04-07	ACAT-DELISTED	Stock	28.04	28.16	27.89	28.01	25319.0
2005-04-07	ACC-DELISTED	Stock	21.2	21.4	21.1	21.11	7800.0
2005-04-07	ACCL-DELISTED	Stock	5.77	5.89	5.75	5.82	100972.0
2005-04-07	ACE-DELISTED	Stock	41.31	41.51	41.17	41.33	1234300.0
2005-04-07	ACF-DELISTED	Stock	23.69	24.3	23.6	24.13	1121000.0
2005-04-07	ACFC-DELISTED	Stock	61.63	62.14	61.63	61.94	687.0
2005-04-07	ACG-DELISTED	Stock	8.08	8.1	8.05	8.1	343000.0
2005-04-07	ACGL	Stock	4.5489	4.5778	4.5222	4.5778	2245500.0
2005-04-07	ACGN-DELISTED	Stock	736.6712	736.6712	691.3288	702.6712	53300.0
2005-04-07	ACH	Stock	18.2	18.7	18.2	18.7	193650.0
2005-04-07	ACH-DELISTED	Stock	14.812	15.37	14.812	15.263	444830.0
2005-04-07	ACLS	Stock	27.92	28.16	27.4	28.16	168300.0

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

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