PREVIEW / stock_daily / 2007-01-08

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-08.parquet
  size:    160 KB
  rows:    4,796
  symbols: 3,006

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-01-08	AAPL	Stock	3.07	3.0904	3.0457	3.0525	797106800.0
2007-01-08	MSFT	Stock	29.65	30.1	29.53	29.93	50220200.0
2007-01-08	NVDA	Stock	0.563	0.576	0.5533	0.5652	657270000.0
2007-01-08	AMZN	Stock	1.911	1.9155	1.8585	1.875	135660000.0
2007-01-08	TLT	Stock	89.12	89.37	89.05	89.37	414200.0
2007-01-08	CL	Stock	32.68	32.92	32.57	32.855	4049600.0
2007-01-08	A	Stock	24.3062	24.3777	24.0916	24.299	2176966.0
2007-01-08	AABA-DELISTED	Stock	27.7000007629395	28.0400009155273	27.4300003051758	27.9200000762939	25713700.0
2007-01-08	AACC-DELISTED	Stock	16.13	16.15	15.91	16.04	29954.0
2007-01-08	AACQ-DELISTED	Stock	5.46	5.47	5.46	5.47	32500.0
2007-01-08	AACQU-DELISTED	Stock	6.51	6.51	6.5	6.51	6500.0
2007-01-08	AACQW-DELISTED	Stock	0.54	0.55	0.54	0.55	22500.0
2007-01-08	AAI-DELISTED	Stock	11.45	11.46	11.17	11.2589	1784100.0
2007-01-08	AAIC-DELISTED	Stock	159.2	161.8	156.4	159.8	1317700.0
2007-01-08	AAME	Stock	3.45	3.62	3.45	3.59	9000.0
2007-01-08	AAON	Stock	3.4647	3.5226	3.3778	3.4897	159469.0
2007-01-08	AAP	Stock	35.16	35.35	34.98	35.14	479600.0
2007-01-08	AATI-DELISTED	Stock	5.34	5.34	5.21	5.24	218675.0
2007-01-08	AAU-DELISTED	Stock	2.25	2.35	2.1	2.3299	73700.0
2007-01-08	AAUAF-DELISTED	Stock	2.25	2.35	2.1	2.3299	73700.0
2007-01-08	AAV-DELISTED	Stock	10.6501	10.83	10.45	10.53	480700.0
2007-01-08	AAWW-DELISTED	Stock	45.09	45.67	44.74	45.61	91346.0
2007-01-08	AAXN-DELISTED	Stock	8.25	8.31999969482422	8.0600004196167	8.1899995803833	1488500.0
2007-01-08	AB	Stock	80.7	82.22	80.7	81.99	271800.0
2007-01-08	ABAX-DELISTED	Stock	19.41	19.63	19.31	19.45	85680.0
2007-01-08	ABB-DELISTED	Stock	17.33	17.3301	17.08	17.19	1243800.0
2007-01-08	ABBC-DELISTED	Stock	19.1	19.12	18.9	18.9	12680.0
2007-01-08	ABC-DELISTED	Stock	23.2	23.3	22.95	23.22	2594200.0
2007-01-08	ABCB	Stock	27.3993	27.4965	26.9714	27.3507	21899.0
2007-01-08	ABCO-DELISTED	Stock	26.82	27.01	26.78	26.82	180740.0
2007-01-08	ABCW-DELISTED	Stock	28.51	28.77	28.3	28.63	29640.0
2007-01-08	ABD-DELISTED	Stock	25.84	26.28	25.84	26.1	183300.0
2007-01-08	ABE-DELISTED	Stock	18.11	18.1196	17.86	18.1	35500.0
2007-01-08	ABFS-DELISTED	Stock	39.92	39.96	39.05	39.54	386725.0
2007-01-08	ABG	Stock	23.37	23.63	23.0	23.51	199500.0
2007-01-08	ABK-DELISTED	Stock	87.9	88.54	87.71	88.46	335600.0
2007-01-08	ABM	Stock	23.11	23.27	22.86	23.16	448700.0
2007-01-08	ABMD-DELISTED	Stock	14.31	14.79	13.99	14.1	141201.0
2007-01-08	ABP-DELISTED	Stock	3.13	3.25	3.13	3.25	161100.0
2007-01-08	ABR	Stock	29.56	29.98	29.35	29.91	35800.0
2007-01-08	ABT	Stock	23.9036	24.0524	23.8173	24.0284	12734681.0
2007-01-08	ABTL-DELISTED	Stock	17.8	17.8	17.35	17.65	27828.0
2007-01-08	ABV-DELISTED	Stock	47.95	48.55	47.7	48.48	649200.0
2007-01-08	ABVA-DELISTED	Stock	16.28	16.29	16.17	16.19	11394.0
2007-01-08	ABX-DELISTED	Stock	29.51	29.59	29.02	29.39	3328100.0
2007-01-08	ACAD	Stock	8.28	8.28	8.0	8.07	177000.0
2007-01-08	ACAP-DELISTED	Stock	38.09	39.18	38.09	38.97	64596.0
2007-01-08	ACAS-DELISTED	Stock	45.93	45.98	45.4	45.8	1072963.0
2007-01-08	ACAT-DELISTED	Stock	16.9	17.04	16.71	16.93	46063.0
2007-01-08	ACC-DELISTED	Stock	28.65	28.99	28.56	28.82	78212.0

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

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