PREVIEW / stock_daily / 2007-02-08

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-08.parquet
  size:    162 KB
  rows:    4,825
  symbols: 3,028

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
2007-02-08	AAPL	Stock	3.0511	3.0896	3.0504	3.0779	679030800.0
2007-02-08	MSFT	Stock	29.24	29.8	29.2	29.26	48749000.0
2007-02-08	NVDA	Stock	0.5717	0.5812	0.5667	0.573	726276000.0
2007-02-08	AMZN	Stock	1.9475	1.9755	1.9335	1.955	109672000.0
2007-02-08	TLT	Stock	87.99	88.31	87.91	88.13	980200.0
2007-02-08	CL	Stock	33.575	33.685	33.385	33.515	3133800.0
2007-02-08	A	Stock	23.2117	23.4406	23.0901	23.3691	3546446.0
2007-02-08	AABA-DELISTED	Stock	29.75	30.2399997711182	29.7299995422363	30.0799999237061	15561700.0
2007-02-08	AACC-DELISTED	Stock	15.98	16.02	15.8	15.84	27886.0
2007-02-08	AACQ-DELISTED	Stock	5.55	5.55	5.54	5.54	14164.0
2007-02-08	AACQW-DELISTED	Stock	0.76	0.77	0.75	0.76	76928.0
2007-02-08	AAI-DELISTED	Stock	11.7	11.77	11.62	11.73	1186600.0
2007-02-08	AAIC-DELISTED	Stock	155.0	156.374	149.8	152.8	2774100.0
2007-02-08	AAME	Stock	3.49	3.49	3.39	3.4	9300.0
2007-02-08	AAON	Stock	3.6346	3.6793	3.5911	3.6793	100997.0
2007-02-08	AAP	Stock	38.25	38.74	37.97	38.73	638400.0
2007-02-08	AATI-DELISTED	Stock	5.59	5.86	5.56	5.83	261385.0
2007-02-08	AAU-DELISTED	Stock	2.42	2.46	2.41	2.41	22100.0
2007-02-08	AAUAF-DELISTED	Stock	2.42	2.46	2.41	2.41	22100.0
2007-02-08	AAV-DELISTED	Stock	10.73	10.77	10.7	10.72	320900.0
2007-02-08	AAWW-DELISTED	Stock	49.59	49.81	49.34	49.81	30059.0
2007-02-08	AAXN-DELISTED	Stock	7.98000001907349	7.98999977111816	7.8600001335144	7.8899998664856	861100.0
2007-02-08	AB	Stock	92.4	92.48	91.43	92.2	240500.0
2007-02-08	ABAX-DELISTED	Stock	22.24	22.34	21.83	21.9	92224.0
2007-02-08	ABB-DELISTED	Stock	18.42	18.54	18.37	18.49	1224800.0
2007-02-08	ABBC-DELISTED	Stock	19.3	19.52	19.3	19.52	1157.0
2007-02-08	ABC-DELISTED	Stock	26.24	26.47	26.12	26.34	1119000.0
2007-02-08	ABCB	Stock	24.0826	24.0924	23.7033	23.8298	16758.0
2007-02-08	ABCO-DELISTED	Stock	27.23	27.31	27.07	27.11	170181.0
2007-02-08	ABCW-DELISTED	Stock	29.59	29.61	29.31	29.52	69780.0
2007-02-08	ABD-DELISTED	Stock	23.88	23.9	23.15	23.55	915200.0
2007-02-08	ABE-DELISTED	Stock	18.75	18.75	18.55	18.6405	10000.0
2007-02-08	ABFS-DELISTED	Stock	39.6	39.63	39.09	39.16	289279.0
2007-02-08	ABG	Stock	25.02	25.3	24.89	25.18	233600.0
2007-02-08	ABK-DELISTED	Stock	89.43	89.43	88.56	89.06	436800.0
2007-02-08	ABM	Stock	26.41	26.75	26.4	26.59	297200.0
2007-02-08	ABMD-DELISTED	Stock	14.68	15.02	14.64	14.99	176569.0
2007-02-08	ABP-DELISTED	Stock	3.37	3.38	3.22	3.22	244900.0
2007-02-08	ABR	Stock	32.74	32.81	31.61	32.27	213800.0
2007-02-08	ABT	Stock	25.1415	25.2135	24.9784	25.0168	10063568.0
2007-02-08	ABTL-DELISTED	Stock	19.05	19.449	19.001	19.2	16566.0
2007-02-08	ABV-DELISTED	Stock	51.75	52.05	51.43	51.55	200800.0
2007-02-08	ABVA-DELISTED	Stock	16.3	16.31	16.08	16.3045	6375.0
2007-02-08	ABX-DELISTED	Stock	30.35	30.88	30.19	30.79	4426200.0
2007-02-08	ACAD	Stock	7.2	7.2	7.08	7.09	106200.0
2007-02-08	ACAP-DELISTED	Stock	38.89	39.2	38.76	38.89	15643.0
2007-02-08	ACAS-DELISTED	Stock	47.06	47.71	47.022	47.29	985681.0
2007-02-08	ACAT-DELISTED	Stock	18.005	18.165	17.825	18.165	25355.0
2007-02-08	ACC-DELISTED	Stock	32.32	32.4	32.06	32.32	242480.0
2007-02-08	ACCL-DELISTED	Stock	6.18	6.25	6.17	6.25	44166.0

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

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