PREVIEW / stock_daily / 2007-10-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-18.parquet
  size:    178 KB
  rows:    5,508
  symbols: 3,321

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-18	AAPL	Stock	6.125	6.2211	6.1089	6.1964	823676000.0
2007-10-18	MSFT	Stock	31.22	31.23	30.63	31.16	49208600.0
2007-10-18	NVDA	Stock	0.9852	0.9918	0.9605	0.9878	340620000.0
2007-10-18	AMZN	Stock	4.4685	4.5215	4.4575	4.4925	106590000.0
2007-10-18	TLT	Stock	89.11	89.34	89.02	89.13	1374100.0
2007-10-18	CL	Stock	36.365	36.5	36.155	36.43	3355800.0
2007-10-18	A	Stock	27.5036	27.6109	27.2103	27.4893	969373.0
2007-10-18	AABA-DELISTED	Stock	28.58	29.6	28.47	29.35	28314575.0
2007-10-18	AACC-DELISTED	Stock	10.77	11.59	10.5	10.92	226846.0
2007-10-18	AAI-DELISTED	Stock	9.7	9.75	9.62	9.69	1336700.0
2007-10-18	AAIC-DELISTED	Stock	91.0	91.8	88.6	90.8	3704400.0
2007-10-18	AAME	Stock	2.62	2.64	2.53	2.62	8400.0
2007-10-18	AAON	Stock	3.7412	3.7531	3.5338	3.5852	758869.0
2007-10-18	AAP	Stock	32.87	33.11	32.6	32.83	576600.0
2007-10-18	AATI-DELISTED	Stock	11.93	11.93	11.61	11.85	485241.0
2007-10-18	AAU-DELISTED	Stock	2.79	2.85	2.71	2.79	218400.0
2007-10-18	AAUAF-DELISTED	Stock	2.79	2.85	2.71	2.79	218400.0
2007-10-18	AAV-DELISTED	Stock	12.5	12.82	12.5	12.8	976000.0
2007-10-18	AAWW-DELISTED	Stock	56.41	56.91	56.0	56.9	77200.0
2007-10-18	AAXN-DELISTED	Stock	16.32	16.75	16.12	16.5	1227583.0
2007-10-18	AB	Stock	87.95	88.45	86.05	87.27	161500.0
2007-10-18	ABAX-DELISTED	Stock	24.8	24.8	24.21	24.73	168671.0
2007-10-18	ABB-DELISTED	Stock	28.02	28.22	27.93	28.13	1946100.0
2007-10-18	ABBC-DELISTED	Stock	9.66	9.66	9.33	9.43	96806.0
2007-10-18	ABBNY-DELISTED	Stock	28.02	28.22	27.9301	28.16	1946100.0
2007-10-18	ABC-DELISTED	Stock	22.35	22.48	22.24	22.28	1098000.0
2007-10-18	ABCB	Stock	18.0814	18.0814	17.5075	17.8772	35059.0
2007-10-18	ABCO-DELISTED	Stock	30.01	30.33	29.91	30.2	122588.0
2007-10-18	ABCW-DELISTED	Stock	25.29	25.43	25.07	25.09	47700.0
2007-10-18	ABD-DELISTED	Stock	20.56	20.97	20.35	20.7	305500.0
2007-10-18	ABE-DELISTED	Stock	26.68	27.75	26.2501	27.17	43600.0
2007-10-18	ABEO	Stock	4687.5	4875.0	4687.5	4875.0	7.0
2007-10-18	ABFS-DELISTED	Stock	31.75	31.8	30.95	31.16	455261.0
2007-10-18	ABG	Stock	19.32	19.52	18.77	19.05	628700.0
2007-10-18	ABK-DELISTED	Stock	59.52	62.2	59.28	60.68	3243102.0
2007-10-18	ABM	Stock	23.15	23.5	23.1	23.35	390000.0
2007-10-18	ABMD-DELISTED	Stock	12.83	13.41	12.83	13.195	130601.0
2007-10-18	ABP-DELISTED	Stock	4.3	4.59	4.3	4.48	581800.0
2007-10-18	ABR	Stock	18.32	18.33	18.0	18.13	289000.0
2007-10-18	ABT	Stock	24.6137	24.964	24.561	24.7913	12289912.0
2007-10-18	ABTL-DELISTED	Stock	13.352	13.45	13.008	13.45	18833.0
2007-10-18	ABV-DELISTED	Stock	76.76	80.61	76.52	79.88	594300.0
2007-10-18	ABVA-DELISTED	Stock	9.73	9.73	9.73	9.73	200.0
2007-10-18	ABVT-DELISTED	Stock	83.5	83.5	83.0	83.0	24250.0
2007-10-18	ABX-DELISTED	Stock	41.11	42.36	41.05	42.11	6418800.0
2007-10-18	ACAD	Stock	15.15	15.47	15.0	15.1	185200.0
2007-10-18	ACAP-DELISTED	Stock	41.75	42.25	41.41	41.78	46940.0
2007-10-18	ACAS-DELISTED	Stock	42.94	43.56	42.44	43.03	868258.0
2007-10-18	ACAT-DELISTED	Stock	15.98	16.37	15.98	16.37	65873.0
2007-10-18	ACC-DELISTED	Stock	28.64	28.87	28.09	28.83	147111.0

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

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