PREVIEW / stock_daily / 2007-02-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-09.parquet
  size:    161 KB
  rows:    4,832
  symbols: 3,033

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-09	AAPL	Stock	3.0671	3.0786	2.9718	2.9739	860540800.0
2007-02-09	MSFT	Stock	29.35	29.4	28.93	28.98	69823100.0
2007-02-09	NVDA	Stock	0.5758	0.5807	0.542	0.5442	937956000.0
2007-02-09	AMZN	Stock	1.9595	1.9655	1.933	1.936	119202000.0
2007-02-09	TLT	Stock	87.89	87.92	87.55	87.63	878500.0
2007-02-09	CL	Stock	33.59	33.7	33.335	33.46	3514800.0
2007-02-09	A	Stock	23.3619	23.5908	23.2761	23.3619	3297602.0
2007-02-09	AABA-DELISTED	Stock	30.0699996948242	30.1599998474121	29.5100002288818	29.7399997711182	18172200.0
2007-02-09	AACC-DELISTED	Stock	15.86	16.0	15.62	15.73	47367.0
2007-02-09	AACQ-DELISTED	Stock	5.54	5.55	5.53	5.55	15500.0
2007-02-09	AACQU-DELISTED	Stock	7.03	7.03	7.03	7.03	2500.0
2007-02-09	AACQW-DELISTED	Stock	0.76	0.77	0.75	0.75	73824.0
2007-02-09	AAI-DELISTED	Stock	11.7	11.77	11.41	11.54	1080300.0
2007-02-09	AAIC-DELISTED	Stock	152.4	154.2	143.2	146.8	2362000.0
2007-02-09	AAME	Stock	3.44	3.59	3.32	3.55	10800.0
2007-02-09	AAON	Stock	3.6701	3.6793	3.6333	3.6688	108591.0
2007-02-09	AAP	Stock	38.95	39.0	38.13	38.52	578000.0
2007-02-09	AATI-DELISTED	Stock	5.79	6.0	5.4	5.46	519896.0
2007-02-09	AAU-DELISTED	Stock	2.41	2.52	2.41	2.42	49600.0
2007-02-09	AAUAF-DELISTED	Stock	2.41	2.52	2.41	2.42	49600.0
2007-02-09	AAV-DELISTED	Stock	10.73	10.76	10.65	10.75	372800.0
2007-02-09	AAWW-DELISTED	Stock	49.62	49.62	48.99	49.17	50988.0
2007-02-09	AAXN-DELISTED	Stock	7.84999990463257	7.94000005722046	7.75	7.76000022888184	558700.0
2007-02-09	AB	Stock	92.2	92.89	90.33	90.7	202600.0
2007-02-09	ABAX-DELISTED	Stock	21.83	21.92	21.41	21.54	166009.0
2007-02-09	ABB-DELISTED	Stock	18.52	18.71	18.48	18.55	1450200.0
2007-02-09	ABBC-DELISTED	Stock	19.33	19.48	19.3	19.31	6521.0
2007-02-09	ABC-DELISTED	Stock	26.4	26.78	26.35	26.76	2705600.0
2007-02-09	ABCB	Stock	23.9075	23.9756	22.9057	23.3337	39583.0
2007-02-09	ABCO-DELISTED	Stock	27.14	27.25	26.81	26.87	191646.0
2007-02-09	ABCW-DELISTED	Stock	29.53	29.57	28.8	28.9	54150.0
2007-02-09	ABD-DELISTED	Stock	23.55	23.57	23.22	23.41	504800.0
2007-02-09	ABE-DELISTED	Stock	18.62	18.89	18.6	18.64	24700.0
2007-02-09	ABFS-DELISTED	Stock	39.29	39.7	38.92	39.14	198869.0
2007-02-09	ABG	Stock	25.14	25.44	25.1	25.17	154800.0
2007-02-09	ABK-DELISTED	Stock	89.24	89.59	88.01	88.3	495600.0
2007-02-09	ABM	Stock	26.54	26.7	26.43	26.6	221900.0
2007-02-09	ABMD-DELISTED	Stock	14.93	15.06	14.69	14.76	134935.0
2007-02-09	ABP-DELISTED	Stock	3.26	3.26	3.17	3.18	102700.0
2007-02-09	ABR	Stock	32.5	33.28	32.21	32.53	445400.0
2007-02-09	ABT	Stock	25.1175	25.2519	25.0168	25.0791	7892038.0
2007-02-09	ABTL-DELISTED	Stock	19.35	19.5	18.25	18.95	18097.0
2007-02-09	ABV-DELISTED	Stock	51.6	52.04	51.01	51.2	485000.0
2007-02-09	ABVA-DELISTED	Stock	16.39	16.39	16.17	16.17	2850.0
2007-02-09	ABVT-DELISTED	Stock	57.5	57.5	56.0	57.0	238.0
2007-02-09	ABX-DELISTED	Stock	30.98	31.21	30.66	30.83	3877400.0
2007-02-09	ACAD	Stock	7.07	7.14	7.02	7.05	210500.0
2007-02-09	ACAP-DELISTED	Stock	38.75	39.29	37.97	37.99	18540.0
2007-02-09	ACAS-DELISTED	Stock	47.38	47.5	43.39	45.44	2899348.0
2007-02-09	ACAT-DELISTED	Stock	18.055	18.226	17.675	17.675	36558.0

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

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