PREVIEW / stock_daily / 2007-06-08

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-08.parquet
  size:    175 KB
  rows:    5,369
  symbols: 3,230

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-06-08	AAPL	Stock	4.4936	4.4939	4.3675	4.4461	1241682400.0
2007-06-08	MSFT	Stock	29.58	30.06	29.41	30.05	61346200.0
2007-06-08	NVDA	Stock	0.5948	0.61	0.5875	0.6092	533268000.0
2007-06-08	AMZN	Stock	3.6235	3.662	3.5525	3.662	204090000.0
2007-06-08	TLT	Stock	83.61	84.12	83.36	83.8	5307599.0
2007-06-08	CL	Stock	33.11	33.385	32.955	33.345	4357200.0
2007-06-08	A	Stock	26.681	26.8598	26.4235	26.8455	3713647.0
2007-06-08	AABA-DELISTED	Stock	27.02	27.45	26.96	27.39	18025559.0
2007-06-08	AACC-DELISTED	Stock	18.61	18.81	18.61	18.79	77390.0
2007-06-08	AAI-DELISTED	Stock	11.65	11.94	11.57	11.88	1422100.0
2007-06-08	AAIC-DELISTED	Stock	128.0	130.4	126.0	130.0	2300500.0
2007-06-08	AAME	Stock	4.4	4.6	3.99	4.5	8700.0
2007-06-08	AAON	Stock	3.7821	3.8914	3.7215	3.8742	194400.0
2007-06-08	AAP	Stock	40.66	42.2	40.66	42.04	1196000.0
2007-06-08	AATI-DELISTED	Stock	9.2	9.43	9.2	9.41	475751.0
2007-06-08	AAU-DELISTED	Stock	2.31	2.38	2.28	2.35	45100.0
2007-06-08	AAUAF-DELISTED	Stock	2.31	2.38	2.28	2.35	45100.0
2007-06-08	AAV-DELISTED	Stock	12.54	12.77	12.41	12.75	821600.0
2007-06-08	AAWW-DELISTED	Stock	56.62	57.7	56.55	57.62	89589.0
2007-06-08	AAXN-DELISTED	Stock	10.8	10.95	10.65	10.898	1555766.0
2007-06-08	AB	Stock	88.59	88.78	86.95	87.61	331000.0
2007-06-08	ABAX-DELISTED	Stock	22.66	22.87	22.48	22.61	127802.0
2007-06-08	ABB-DELISTED	Stock	21.03	21.23	20.88	21.23	1973350.0
2007-06-08	ABBC-DELISTED	Stock	17.39	17.99	17.39	17.96	8970.0
2007-06-08	ABBNY-DELISTED	Stock	21.03	21.24	20.88	21.24	2312350.0
2007-06-08	ABC-DELISTED	Stock	25.48	25.68	25.45	25.6	1596140.0
2007-06-08	ABCB	Stock	21.5926	22.079	21.4856	22.0401	21179.0
2007-06-08	ABCO-DELISTED	Stock	26.21	26.56	26.12	26.52	182484.0
2007-06-08	ABCW-DELISTED	Stock	28.28	28.5	27.89	28.32	63250.0
2007-06-08	ABD-DELISTED	Stock	24.78	25.2	24.71	25.13	175000.0
2007-06-08	ABE-DELISTED	Stock	20.76	21.3	20.6	21.13	25300.0
2007-06-08	ABEO	Stock	6062.5	6375.0	6000.0	6375.0	2.0
2007-06-08	ABFS-DELISTED	Stock	39.32	39.88	38.7	39.62	356796.0
2007-06-08	ABG	Stock	24.91	24.93	24.4	24.78	631500.0
2007-06-08	ABK-DELISTED	Stock	87.35	88.64	87.04	88.51	1094900.0
2007-06-08	ABM	Stock	27.3	27.46	26.75	27.26	369900.0
2007-06-08	ABMD-DELISTED	Stock	11.55	11.61	11.34	11.54	127169.0
2007-06-08	ABP-DELISTED	Stock	4.01	4.2	3.89	3.99	223500.0
2007-06-08	ABR	Stock	27.52	27.73	27.48	27.7	123500.0
2007-06-08	ABT	Stock	25.9092	26.0771	25.7317	26.0483	12291997.0
2007-06-08	ABTL-DELISTED	Stock	20.1	20.7	20.1	20.55	13876.0
2007-06-08	ABV-DELISTED	Stock	66.5	68.31	66.44	68.26	482260.0
2007-06-08	ABVA-DELISTED	Stock	14.18	14.49	14.18	14.22	9040.0
2007-06-08	ABX-DELISTED	Stock	28.12	28.55	28.0	28.25	7190100.0
2007-06-08	ACAD	Stock	13.24	14.13	13.13	13.96	2180700.0
2007-06-08	ACAP-DELISTED	Stock	40.41	41.87	40.41	41.57	65209.0
2007-06-08	ACAS-DELISTED	Stock	45.28	45.46	44.48	45.38	1197358.0
2007-06-08	ACAT-DELISTED	Stock	19.205	19.505	19.205	19.355	131692.0
2007-06-08	ACC-DELISTED	Stock	28.95	29.24	28.6	29.18	108000.0
2007-06-08	ACCL-DELISTED	Stock	6.15	6.25	6.03	6.15	39018.0

> showing 50 of 5,369 rows — these rows as CSV

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