PREVIEW / stock_daily / 2007-02-06

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-06.parquet
  size:    161 KB
  rows:    4,827
  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-06	AAPL	Stock	3.0161	3.0168	2.9593	3.0054	864393600.0
2007-02-06	MSFT	Stock	29.59	29.75	29.22	29.51	79281100.0
2007-02-06	NVDA	Stock	0.5517	0.5657	0.5435	0.5587	775386000.0
2007-02-06	AMZN	Stock	1.86	1.9205	1.854	1.9135	172254000.0
2007-02-06	TLT	Stock	87.2	87.83	87.16	87.8	770500.0
2007-02-06	CL	Stock	33.62	33.865	33.405	33.495	5123200.0
2007-02-06	A	Stock	22.9757	23.0114	22.711	22.8898	3516110.0
2007-02-06	AABA-DELISTED	Stock	28.6100006103516	29.5599994659424	28.6000003814697	29.3500003814697	24506800.0
2007-02-06	AACC-DELISTED	Stock	15.78	16.081	15.73	15.89	79644.0
2007-02-06	AACQ-DELISTED	Stock	5.54	5.56	5.53	5.55	71253.0
2007-02-06	AACQU-DELISTED	Stock	7.07	7.07	7.01	7.03	3800.0
2007-02-06	AACQW-DELISTED	Stock	0.76	0.77	0.76	0.77	10000.0
2007-02-06	AAI-DELISTED	Stock	11.63	11.93	11.41	11.9	3558000.0
2007-02-06	AAIC-DELISTED	Stock	155.4	158.8	154.6	156.0	1109000.0
2007-02-06	AAME	Stock	3.31	3.4	3.31	3.4	3000.0
2007-02-06	AAON	Stock	3.6069	3.6517	3.5779	3.6504	72900.0
2007-02-06	AAP	Stock	37.54	37.97	37.47	37.97	535600.0
2007-02-06	AATI-DELISTED	Stock	5.57	5.65	5.5	5.64	218812.0
2007-02-06	AAU-DELISTED	Stock	2.41	2.5	2.41	2.42	24500.0
2007-02-06	AAUAF-DELISTED	Stock	2.41	2.5	2.41	2.42	24500.0
2007-02-06	AAV-DELISTED	Stock	10.81	10.82	10.7	10.76	429100.0
2007-02-06	AAWW-DELISTED	Stock	49.24	49.59	49.0	49.48	33180.0
2007-02-06	AAXN-DELISTED	Stock	7.84000015258789	7.94000005722046	7.80000019073486	7.90000009536743	820400.0
2007-02-06	AB	Stock	91.65	91.87	91.27	91.39	185700.0
2007-02-06	ABAX-DELISTED	Stock	22.15	22.72	22.11	22.69	317334.0
2007-02-06	ABB-DELISTED	Stock	18.28	18.41	18.23	18.38	1367700.0
2007-02-06	ABBC-DELISTED	Stock	19.48	19.48	19.25	19.25	4408.0
2007-02-06	ABC-DELISTED	Stock	26.22	26.26	26.0	26.18	1706200.0
2007-02-06	ABCB	Stock	23.9464	23.9562	22.8766	23.3434	86568.0
2007-02-06	ABCO-DELISTED	Stock	27.9	27.91	27.55	27.64	215982.0
2007-02-06	ABCW-DELISTED	Stock	29.43	29.54	29.25	29.45	31730.0
2007-02-06	ABD-DELISTED	Stock	24.0	24.19	23.79	24.04	490120.0
2007-02-06	ABE-DELISTED	Stock	18.6	18.81	18.46	18.81	42100.0
2007-02-06	ABFS-DELISTED	Stock	39.3	40.0	39.25	39.77	359844.0
2007-02-06	ABG	Stock	24.4	24.5	24.3	24.47	286100.0
2007-02-06	ABK-DELISTED	Stock	88.8	90.63	88.37	90.1	1240600.0
2007-02-06	ABM	Stock	26.22	26.6	26.2	26.57	520800.0
2007-02-06	ABMD-DELISTED	Stock	14.47	14.75	14.38	14.67	230025.0
2007-02-06	ABP-DELISTED	Stock	3.4	3.45	3.23	3.26	133100.0
2007-02-06	ABR	Stock	31.72	32.95	31.69	32.95	370700.0
2007-02-06	ABT	Stock	25.2855	25.3095	25.0504	25.1703	7121926.0
2007-02-06	ABTL-DELISTED	Stock	19.425	19.625	19.325	19.525	20959.0
2007-02-06	ABV-DELISTED	Stock	52.88	53.02	52.41	52.85	216500.0
2007-02-06	ABVA-DELISTED	Stock	16.5	16.5	16.38	16.38	3725.0
2007-02-06	ABX-DELISTED	Stock	30.6	30.61	30.12	30.5	2485300.0
2007-02-06	ACAD	Stock	7.16	7.23	7.1	7.15	104100.0
2007-02-06	ACAP-DELISTED	Stock	38.32	39.21	38.32	38.93	24391.0
2007-02-06	ACAS-DELISTED	Stock	48.51	48.89	47.55	48.07	2149029.0
2007-02-06	ACAT-DELISTED	Stock	17.92	18.43	17.81	17.82	164048.0
2007-02-06	ACC-DELISTED	Stock	32.26	32.39	32.02	32.37	134040.0

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

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