PREVIEW / stock_daily / 2007-05-08

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-08.parquet
  size:    168 KB
  rows:    5,104
  symbols: 3,148

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-05-08	AAPL	Stock	3.6954	3.7554	3.6936	3.7521	783997200.0
2007-05-08	MSFT	Stock	30.68	30.94	30.58	30.75	60551700.0
2007-05-08	NVDA	Stock	0.5473	0.5562	0.5367	0.5548	737100000.0
2007-05-08	AMZN	Stock	3.027	3.092	2.985	3.0915	271022000.0
2007-05-08	TLT	Stock	89.01	89.01	88.64	88.64	488322.0
2007-05-08	CL	Stock	33.625	33.925	33.58	33.75	4620000.0
2007-05-08	A	Stock	26.5021	26.7668	26.4521	26.7096	3203936.0
2007-05-08	AABA-DELISTED	Stock	30.24	31.1	30.21	30.41	26415658.0
2007-05-08	AACC-DELISTED	Stock	18.69	18.8	18.53	18.61	255518.0
2007-05-08	AAI-DELISTED	Stock	11.46	11.82	11.39	11.71	1320500.0
2007-05-08	AAIC-DELISTED	Stock	111.6	114.0	110.0	113.8	1571000.0
2007-05-08	AAME	Stock	5.07	5.31	5.07	5.31	4200.0
2007-05-08	AAON	Stock	3.3883	3.4449	3.3317	3.4449	130612.0
2007-05-08	AAP	Stock	41.91	42.92	41.5	41.75	4380200.0
2007-05-08	AATI-DELISTED	Stock	8.05	8.07	7.95	7.99	816284.0
2007-05-08	AAU-DELISTED	Stock	2.54	2.56	2.45	2.45	75900.0
2007-05-08	AAUAF-DELISTED	Stock	2.54	2.56	2.45	2.45	75900.0
2007-05-08	AAV-DELISTED	Stock	11.75	11.84	11.6	11.67	523500.0
2007-05-08	AAWW-DELISTED	Stock	59.44	59.71	58.52	59.58	110290.0
2007-05-08	AAXN-DELISTED	Stock	9.8	9.8	9.36	9.56	2671417.0
2007-05-08	AB	Stock	91.5	91.59	90.12	90.85	239100.0
2007-05-08	ABAX-DELISTED	Stock	22.89	22.89	22.63	22.81	246693.0
2007-05-08	ABB-DELISTED	Stock	19.72	19.74	19.54	19.73	2012100.0
2007-05-08	ABBC-DELISTED	Stock	18.75	18.75	18.58	18.65	7321.0
2007-05-08	ABBNY-DELISTED	Stock	19.72	19.74	19.54	19.73	2165200.0
2007-05-08	ABC-DELISTED	Stock	25.62	25.82	25.6	25.74	1908000.0
2007-05-08	ABCB	Stock	22.8571	23.0516	21.9526	22.1568	61790.0
2007-05-08	ABCO-DELISTED	Stock	24.7	25.0	24.0	24.98	607870.0
2007-05-08	ABCW-DELISTED	Stock	28.25	28.59	28.15	28.52	68940.0
2007-05-08	ABD-DELISTED	Stock	22.51	22.71	22.25	22.55	421100.0
2007-05-08	ABE-DELISTED	Stock	20.73	20.9	20.51	20.58	47100.0
2007-05-08	ABFS-DELISTED	Stock	39.47	39.8	39.0	39.39	492584.0
2007-05-08	ABG	Stock	28.4	28.5	28.01	28.41	222400.0
2007-05-08	ABK-DELISTED	Stock	94.11	94.75	93.93	94.66	783700.0
2007-05-08	ABM	Stock	28.85	28.99	28.54	28.99	199500.0
2007-05-08	ABMD-DELISTED	Stock	12.9	12.9	12.28	12.43	295136.0
2007-05-08	ABP-DELISTED	Stock	3.82	3.93	3.65	3.72	166900.0
2007-05-08	ABR	Stock	30.25	30.77	29.47	29.78	126800.0
2007-05-08	ABT	Stock	28.2554	28.265	27.9531	28.2314	7418091.0
2007-05-08	ABTL-DELISTED	Stock	17.6	18.101	17.148	17.95	17452.0
2007-05-08	ABV-DELISTED	Stock	60.36	61.32	60.08	60.95	297860.0
2007-05-08	ABVA-DELISTED	Stock	13.75	13.75	13.33	13.42	11100.0
2007-05-08	ABVT-DELISTED	Stock	63.0	63.0	55.0	63.0	2964.0
2007-05-08	ABX-DELISTED	Stock	30.9	31.22	30.59	31.17	5753783.0
2007-05-08	ACAD	Stock	13.19	13.71	12.76	13.64	770800.0
2007-05-08	ACAP-DELISTED	Stock	40.37	40.41	39.27	39.29	61611.0
2007-05-08	ACAS-DELISTED	Stock	45.94	46.02	45.31	45.85	959580.0
2007-05-08	ACAT-DELISTED	Stock	18.44	18.48	18.08	18.13	106195.0
2007-05-08	ACC-DELISTED	Stock	29.27	29.71	29.16	29.32	120300.0
2007-05-08	ACCL-DELISTED	Stock	6.42	6.51	6.33	6.45	40147.0

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

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