PREVIEW / stock_daily / 2006-07-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-07.parquet
  size:    148 KB
  rows:    4,434
  symbols: 2,796

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
2006-07-07	AAPL	Stock	1.9814	2.0196	1.9525	1.9786	799360800.0
2006-07-07	MSFT	Stock	23.39	23.55	23.3	23.3	63168800.0
2006-07-07	NVDA	Stock	0.3355	0.3362	0.3192	0.3228	541230000.0
2006-07-07	AMZN	Stock	1.8355	1.864	1.7875	1.8055	100082000.0
2006-07-07	CL	Stock	30.38	30.6	30.38	30.44	3195800.0
2006-07-07	A	Stock	22.5322	22.5322	21.9886	22.1888	2374783.0
2006-07-07	AABA-DELISTED	Stock	32.939998626709	33.0499992370605	32.3699989318848	32.5	12372500.0
2006-07-07	AACC-DELISTED	Stock	19.24	19.4	18.88	18.9	65773.0
2006-07-07	AACQU-DELISTED	Stock	6.2	6.2	6.2	6.2	2700.0
2006-07-07	AACQW-DELISTED	Stock	0.46	0.48	0.46	0.48	24165.0
2006-07-07	AAI-DELISTED	Stock	14.5	14.57	14.1	14.29	916700.0
2006-07-07	AAIC-DELISTED	Stock	215.8	223.0	214.6	217.0	1189100.0
2006-07-07	AAME	Stock	2.98	2.98	2.98	2.98	200.0
2006-07-07	AAON	Stock	3.3146	3.3146	3.1328	3.1605	154153.0
2006-07-07	AAP	Stock	30.04	30.17	29.51	29.7	1596700.0
2006-07-07	AATI-DELISTED	Stock	9.8	9.91	9.49	9.54	59339.0
2006-07-07	AAU-DELISTED	Stock	2.4	2.43	2.32	2.43	87700.0
2006-07-07	AAUAF-DELISTED	Stock	2.4	2.43	2.32	2.43	87700.0
2006-07-07	AAV-DELISTED	Stock	16.29	16.46	16.19	16.34	481000.0
2006-07-07	AAWW-DELISTED	Stock	49.27	49.27	46.54	47.47	149547.0
2006-07-07	AAXN-DELISTED	Stock	8.27999973297119	8.46000003814697	8.19999980926514	8.22999954223633	731600.0
2006-07-07	AB	Stock	61.09	61.7	60.75	60.75	131600.0
2006-07-07	ABAX-DELISTED	Stock	21.6	21.82	21.29	21.58	311809.0
2006-07-07	ABB-DELISTED	Stock	12.59	12.71	12.41	12.48	2106600.0
2006-07-07	ABBC-DELISTED	Stock	14.47	14.47	14.11	14.35	36367.0
2006-07-07	ABC-DELISTED	Stock	20.88	21.2	20.88	21.1	1964000.0
2006-07-07	ABCB	Stock	22.3027	22.3027	21.3981	21.5051	18609.0
2006-07-07	ABCO-DELISTED	Stock	23.65	23.95	23.3	23.43	92511.0
2006-07-07	ABCW-DELISTED	Stock	29.96	30.28	29.58	29.62	36430.0
2006-07-07	ABD-DELISTED	Stock	21.65	21.75	21.46	21.48	274000.0
2006-07-07	ABE-DELISTED	Stock	12.25	12.3	12.21	12.23	8300.0
2006-07-07	ABFS-DELISTED	Stock	49.5	49.5	47.83	48.09	479441.0
2006-07-07	ABG	Stock	20.84	21.12	20.72	20.79	73200.0
2006-07-07	ABK-DELISTED	Stock	82.37	83.08	82.02	82.82	899600.0
2006-07-07	ABM	Stock	16.72	16.77	16.55	16.56	128500.0
2006-07-07	ABMD-DELISTED	Stock	13.22	13.76	13.22	13.59	110159.0
2006-07-07	ABP-DELISTED	Stock	4.67	4.85	4.5	4.62	177300.0
2006-07-07	ABR	Stock	25.4	25.44	25.01	25.13	67300.0
2006-07-07	ABT	Stock	21.0632	21.2072	20.9721	21.0152	8290121.0
2006-07-07	ABTL-DELISTED	Stock	15.6	15.7	15.5	15.5	37172.0
2006-07-07	ABV-DELISTED	Stock	41.71	41.89	41.04	41.17	317900.0
2006-07-07	ABVA-DELISTED	Stock	16.52	16.52	16.52	16.52	153.0
2006-07-07	ABVT-DELISTED	Stock	48.5	48.5	48.5	48.5	60500.0
2006-07-07	ABX-DELISTED	Stock	30.08	30.68	29.98	30.2	3337415.0
2006-07-07	ACAD	Stock	8.42	8.43	8.05	8.07	167200.0
2006-07-07	ACAP-DELISTED	Stock	50.66	51.06	49.83	50.03	36898.0
2006-07-07	ACAS-DELISTED	Stock	33.91	34.02	33.62	33.6449	596517.0
2006-07-07	ACAT-DELISTED	Stock	17.93	18.61	17.79	18.52	39477.0
2006-07-07	ACC-DELISTED	Stock	25.05	25.15	24.78	24.94	59300.0
2006-07-07	ACCL-DELISTED	Stock	7.01	7.05	6.94	6.94	28195.0

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

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