PREVIEW / stock_daily / 2007-10-08

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-08.parquet
  size:    177 KB
  rows:    5,456
  symbols: 3,287

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-10-08	AAPL	Stock	5.8389	5.9968	5.8204	5.9968	835928800.0
2007-10-08	MSFT	Stock	29.66	29.85	29.6	29.84	30265400.0
2007-10-08	NVDA	Stock	0.9298	0.9398	0.9188	0.9382	252484000.0
2007-10-08	AMZN	Stock	4.711	4.7925	4.7	4.7925	148568000.0
2007-10-08	TLT	Stock	87.77	88.5	87.77	88.21	280100.0
2007-10-08	CL	Stock	36.09	36.2	35.96	36.0	3944400.0
2007-10-08	A	Stock	26.9886	27.1745	26.917	27.103	1396602.0
2007-10-08	AABA-DELISTED	Stock	28.01	28.17	27.75	28.02	15103431.0
2007-10-08	AACC-DELISTED	Stock	11.93	11.99	11.64	11.66	201283.0
2007-10-08	AAI-DELISTED	Stock	10.33	10.89	10.3	10.46	1143700.0
2007-10-08	AAIC-DELISTED	Stock	95.8	96.4	94.4	94.8	973400.0
2007-10-08	AAME	Stock	2.59	2.76	2.59	2.69	3300.0
2007-10-08	AAON	Stock	4.0672	4.1205	4.0099	4.0435	172125.0
2007-10-08	AAP	Stock	35.54	35.66	34.9	35.35	654700.0
2007-10-08	AATI-DELISTED	Stock	11.71	11.99	11.57	11.83	350046.0
2007-10-08	AAU-DELISTED	Stock	2.61	2.61	2.5	2.51	54800.0
2007-10-08	AAUAF-DELISTED	Stock	2.61	2.61	2.5	2.51	54800.0
2007-10-08	AAV-DELISTED	Stock	12.18	12.29	12.04	12.25	358600.0
2007-10-08	AAWW-DELISTED	Stock	53.93	54.3	52.7201	53.8	43109.0
2007-10-08	AAXN-DELISTED	Stock	18.3	18.89	18.08	18.56	3186578.0
2007-10-08	AB	Stock	91.7	92.03	91.29	91.57	115300.0
2007-10-08	ABAX-DELISTED	Stock	25.12	25.38	25.09	25.27	376281.0
2007-10-08	ABB-DELISTED	Stock	26.95	26.96	26.76	26.87	1103200.0
2007-10-08	ABBC-DELISTED	Stock	9.75	9.85	9.75	9.85	32634.0
2007-10-08	ABBNY-DELISTED	Stock	26.95	26.96	26.76	26.84	1103200.0
2007-10-08	ABC-DELISTED	Stock	22.95	23.04	22.66	22.7	1393800.0
2007-10-08	ABCB	Stock	17.8577	18.0328	17.6535	17.9939	27554.0
2007-10-08	ABCO-DELISTED	Stock	30.8	31.1	30.57	31.03	122778.0
2007-10-08	ABCW-DELISTED	Stock	28.13	28.19	27.63	27.78	100400.0
2007-10-08	ABD-DELISTED	Stock	24.6	25.12	24.49	25.03	340740.0
2007-10-08	ABE-DELISTED	Stock	25.22	25.22	24.7	24.8	20700.0
2007-10-08	ABEO	Stock	4837.5	5000.0	4812.5	5000.0	13.0
2007-10-08	ABFS-DELISTED	Stock	34.84	34.84	33.68	33.87	188202.0
2007-10-08	ABG	Stock	21.25	21.25	20.28	20.37	493900.0
2007-10-08	ABK-DELISTED	Stock	70.13	70.13	68.65	68.67	1553300.0
2007-10-08	ABM	Stock	22.5	23.53	21.5	23.21	777300.0
2007-10-08	ABMD-DELISTED	Stock	13.24	13.35	12.91	13.31	174069.0
2007-10-08	ABP-DELISTED	Stock	4.01	4.07	4.0	4.02	113400.0
2007-10-08	ABR	Stock	20.45	20.67	19.98	20.13	98000.0
2007-10-08	ABT	Stock	26.4274	26.5569	26.2547	26.3602	5505211.0
2007-10-08	ABTL-DELISTED	Stock	16.925	16.925	16.074	16.275	17787.0
2007-10-08	ABV-DELISTED	Stock	81.18	81.18	75.04	79.89	312402.0
2007-10-08	ABVA-DELISTED	Stock	10.05	10.12	10.05	10.11	1565.0
2007-10-08	ABVT-DELISTED	Stock	80.0	80.0	80.0	80.0	2384.0
2007-10-08	ABX-DELISTED	Stock	40.56	40.82	40.1	40.57	3520300.0
2007-10-08	ACAD	Stock	15.23	15.26	14.98	15.08	153000.0
2007-10-08	ACAP-DELISTED	Stock	40.54	41.24	40.04	41.05	32917.0
2007-10-08	ACAS-DELISTED	Stock	44.93	45.02	44.78	44.9	1150378.0
2007-10-08	ACAT-DELISTED	Stock	17.88	17.88	17.47	17.67	52405.0
2007-10-08	ACC-DELISTED	Stock	29.85	30.08	28.99	29.9	275068.0

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

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