PREVIEW / stock_daily / 2007-02-02

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-02.parquet
  size:    161 KB
  rows:    4,815
  symbols: 3,017

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-02	AAPL	Stock	3.0043	3.0446	2.9893	3.0268	621530000.0
2007-02-02	MSFT	Stock	30.82	30.84	30.13	30.19	60401700.0
2007-02-02	NVDA	Stock	0.5202	0.5333	0.5158	0.5308	586590000.0
2007-02-02	AMZN	Stock	1.8615	1.887	1.834	1.8695	517014000.0
2007-02-02	TLT	Stock	87.08	87.39	87.08	87.2	814700.0
2007-02-02	CL	Stock	33.95	34.055	33.75	33.87	4740400.0
2007-02-02	A	Stock	23.083	23.0901	22.5036	22.6109	7517605.0
2007-02-02	AABA-DELISTED	Stock	28.5699996948242	28.9200000762939	28.4500007629395	28.7700004577637	16483100.0
2007-02-02	AACC-DELISTED	Stock	15.83	15.92	15.63	15.72	33488.0
2007-02-02	AACQ-DELISTED	Stock	5.54	5.57	5.48	5.5	58938.0
2007-02-02	AACQU-DELISTED	Stock	7.05	7.08	7.0	7.08	6500.0
2007-02-02	AACQW-DELISTED	Stock	0.78	0.8	0.75	0.75	420600.0
2007-02-02	AAI-DELISTED	Stock	11.12	11.42	11.05	11.29	1971400.0
2007-02-02	AAIC-DELISTED	Stock	156.4	156.998	153.6	156.2	831800.0
2007-02-02	AAME	Stock	3.33	3.35	3.27	3.35	2300.0
2007-02-02	AAON	Stock	3.6754	3.6807	3.6412	3.6609	113147.0
2007-02-02	AAP	Stock	37.65	37.75	37.46	37.49	800300.0
2007-02-02	AATI-DELISTED	Stock	5.63	5.7	5.62	5.68	396071.0
2007-02-02	AAU-DELISTED	Stock	2.48	2.4901	2.42	2.44	11900.0
2007-02-02	AAUAF-DELISTED	Stock	2.48	2.4901	2.42	2.44	11900.0
2007-02-02	AAV-DELISTED	Stock	10.75	10.82	10.69	10.7	495400.0
2007-02-02	AAWW-DELISTED	Stock	49.0	50.0	48.9	49.43	219547.0
2007-02-02	AAXN-DELISTED	Stock	7.80000019073486	7.88000011444092	7.73999977111816	7.82000017166138	537600.0
2007-02-02	AB	Stock	91.05	91.61	90.45	91.54	202500.0
2007-02-02	ABAX-DELISTED	Stock	22.01	22.29	21.93	22.1	135904.0
2007-02-02	ABB-DELISTED	Stock	18.16	18.22	18.09	18.22	1349000.0
2007-02-02	ABBC-DELISTED	Stock	19.48	19.59	19.41	19.56	12479.0
2007-02-02	ABC-DELISTED	Stock	26.22	26.44	26.14	26.18	1693000.0
2007-02-02	ABCB	Stock	25.2595	25.6778	25.065	25.1234	29096.0
2007-02-02	ABCO-DELISTED	Stock	28.37	28.37	27.88	27.93	157820.0
2007-02-02	ABCW-DELISTED	Stock	29.89	29.91	29.56	29.68	36650.0
2007-02-02	ABD-DELISTED	Stock	23.76	24.18	23.38	24.11	607700.0
2007-02-02	ABE-DELISTED	Stock	18.38	18.72	18.31	18.61	18500.0
2007-02-02	ABFS-DELISTED	Stock	38.83	39.49	38.77	39.34	607097.0
2007-02-02	ABG	Stock	24.67	24.7	24.35	24.46	157100.0
2007-02-02	ABK-DELISTED	Stock	88.66	88.91	88.33	88.56	378700.0
2007-02-02	ABM	Stock	26.1	26.1	25.67	25.74	353000.0
2007-02-02	ABMD-DELISTED	Stock	14.39	14.55	14.35	14.48	77348.0
2007-02-02	ABP-DELISTED	Stock	3.3	3.33	3.25	3.28	81500.0
2007-02-02	ABR	Stock	31.89	32.02	31.61	31.78	66000.0
2007-02-02	ABT	Stock	25.2135	25.4294	25.1607	25.2711	9661942.0
2007-02-02	ABTL-DELISTED	Stock	19.074	20.28	18.524	20.18	56614.0
2007-02-02	ABV-DELISTED	Stock	52.44	52.49	52.1	52.31	411500.0
2007-02-02	ABVA-DELISTED	Stock	16.51	16.6	16.4	16.55	27509.0
2007-02-02	ABVT-DELISTED	Stock	58.0	58.0	58.0	58.0	2.0
2007-02-02	ABX-DELISTED	Stock	29.99	30.19	29.71	29.99	3740957.0
2007-02-02	ACAD	Stock	7.3	7.46	7.28	7.33	87000.0
2007-02-02	ACAP-DELISTED	Stock	38.98	39.01	38.05	38.07	30005.0
2007-02-02	ACAS-DELISTED	Stock	49.4	49.92	49.36	49.65	769168.0
2007-02-02	ACAT-DELISTED	Stock	18.895	19.075	18.625	18.885	63196.0

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

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