PREVIEW / stock_daily / 2007-02-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-05.parquet
  size:    160 KB
  rows:    4,812
  symbols: 3,019

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-05	AAPL	Stock	3.0107	3.0439	2.9979	2.9979	578852400.0
2007-02-05	MSFT	Stock	29.97	30.02	29.41	29.61	99102100.0
2007-02-05	NVDA	Stock	0.5333	0.544	0.5325	0.5395	579906000.0
2007-02-05	AMZN	Stock	1.8625	1.871	1.8385	1.858	122218000.0
2007-02-05	TLT	Stock	87.4	87.46	87.16	87.32	395500.0
2007-02-05	CL	Stock	33.765	33.795	33.48	33.745	3623200.0
2007-02-05	A	Stock	22.6323	22.804	22.3462	22.7682	3511916.0
2007-02-05	AABA-DELISTED	Stock	28.6700000762939	28.7999992370605	28.3600006103516	28.5599994659424	11163300.0
2007-02-05	AACC-DELISTED	Stock	15.68	15.77	15.61	15.76	42274.0
2007-02-05	AACQ-DELISTED	Stock	5.5	5.54	5.47	5.53	16900.0
2007-02-05	AACQW-DELISTED	Stock	0.75	0.75	0.74	0.74	19000.0
2007-02-05	AAI-DELISTED	Stock	11.2	11.41	11.13	11.15	913300.0
2007-02-05	AAIC-DELISTED	Stock	155.6	157.6	154.384	155.2	790700.0
2007-02-05	AAME	Stock	3.37	3.46	3.31	3.4	4400.0
2007-02-05	AAON	Stock	3.6609	3.6609	3.5766	3.5924	113906.0
2007-02-05	AAP	Stock	37.54	37.84	37.36	37.52	543200.0
2007-02-05	AATI-DELISTED	Stock	5.65	5.81	5.53	5.6	240785.0
2007-02-05	AAU-DELISTED	Stock	2.43	2.43	2.41	2.41	36200.0
2007-02-05	AAUAF-DELISTED	Stock	2.43	2.43	2.41	2.41	36200.0
2007-02-05	AAV-DELISTED	Stock	10.81	10.81	10.71	10.77	371800.0
2007-02-05	AAWW-DELISTED	Stock	49.25	49.3599	48.9	49.01	74056.0
2007-02-05	AAXN-DELISTED	Stock	7.82000017166138	8.0	7.57000017166138	7.82999992370605	804700.0
2007-02-05	AB	Stock	91.53	92.23	90.88	91.02	302100.0
2007-02-05	ABAX-DELISTED	Stock	22.21	22.45	22.05	22.13	101681.0
2007-02-05	ABB-DELISTED	Stock	18.11	18.16	18.04	18.06	1178500.0
2007-02-05	ABBC-DELISTED	Stock	19.65	19.65	19.38	19.43	10017.0
2007-02-05	ABC-DELISTED	Stock	26.16	26.31	26.08	26.26	1311200.0
2007-02-05	ABCB	Stock	25.0456	25.0456	23.606	23.927	47294.0
2007-02-05	ABCO-DELISTED	Stock	27.89	28.06	27.62	27.88	110711.0
2007-02-05	ABCW-DELISTED	Stock	29.68	29.68	29.12	29.3	36750.0
2007-02-05	ABD-DELISTED	Stock	24.11	24.15	23.8	23.98	453950.0
2007-02-05	ABE-DELISTED	Stock	18.36	18.7	18.36	18.63	30100.0
2007-02-05	ABFS-DELISTED	Stock	39.32	39.57	38.7	39.29	641396.0
2007-02-05	ABG	Stock	24.47	24.47	24.18	24.29	187000.0
2007-02-05	ABK-DELISTED	Stock	88.33	88.37	87.65	87.95	351000.0
2007-02-05	ABM	Stock	25.79	26.29	25.76	26.19	387900.0
2007-02-05	ABMD-DELISTED	Stock	14.36	14.75	14.225	14.42	139167.0
2007-02-05	ABP-DELISTED	Stock	3.27	3.47	3.2	3.35	125000.0
2007-02-05	ABR	Stock	31.65	31.88	31.38	31.67	77000.0
2007-02-05	ABT	Stock	25.1415	25.2615	25.036	25.1895	6987078.0
2007-02-05	ABTL-DELISTED	Stock	20.0	20.0	19.3	19.35	30937.0
2007-02-05	ABV-DELISTED	Stock	52.45	52.9	52.32	52.89	368000.0
2007-02-05	ABVA-DELISTED	Stock	16.55	16.62	16.55	16.59	3120.0
2007-02-05	ABVT-DELISTED	Stock	57.0	57.5	57.0	57.5	51.0
2007-02-05	ABX-DELISTED	Stock	30.21	30.43	29.94	30.37	3575700.0
2007-02-05	ACAD	Stock	7.29	7.41	7.06	7.1	137100.0
2007-02-05	ACAP-DELISTED	Stock	38.35	38.6	37.97	38.25	34448.0
2007-02-05	ACAS-DELISTED	Stock	49.7	49.96	49.7	49.79	716774.0
2007-02-05	ACAT-DELISTED	Stock	18.76	18.85	17.84	17.9	135619.0
2007-02-05	ACC-DELISTED	Stock	32.17	32.17	31.68	32.05	369000.0

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

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