PREVIEW / stock_daily / 2007-10-02

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-02.parquet
  size:    178 KB
  rows:    5,511
  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-02	AAPL	Stock	5.5911	5.6639	5.5675	5.6589	792069600.0
2007-10-02	MSFT	Stock	29.7	29.85	29.57	29.7	33700900.0
2007-10-02	NVDA	Stock	0.942	0.9438	0.9215	0.9352	284960000.0
2007-10-02	AMZN	Stock	4.693	4.695	4.57	4.618	97344000.0
2007-10-02	TLT	Stock	88.75	89.37	88.68	89.22	887800.0
2007-10-02	CL	Stock	35.905	36.195	35.685	36.155	3973600.0
2007-10-02	A	Stock	26.3948	26.6452	26.3948	26.4664	2910916.0
2007-10-02	AABA-DELISTED	Stock	27.22	27.24	26.6196	26.95	15433362.0
2007-10-02	AACC-DELISTED	Stock	12.05	12.3372	11.8	11.98	356435.0
2007-10-02	AAI-DELISTED	Stock	9.94	10.45	9.94	10.27	2015900.0
2007-10-02	AAIC-DELISTED	Stock	96.0	98.0	95.808	97.2	988200.0
2007-10-02	AAME	Stock	2.67	2.84	2.67	2.74	12900.0
2007-10-02	AAON	Stock	3.9506	4.0553	3.9348	4.0356	683944.0
2007-10-02	AAP	Stock	33.35	33.6	32.99	33.21	1028400.0
2007-10-02	AATI-DELISTED	Stock	11.18	11.7	11.15	11.68	884556.0
2007-10-02	AAU-DELISTED	Stock	2.33	2.39	2.25	2.39	90900.0
2007-10-02	AAUAF-DELISTED	Stock	2.33	2.39	2.25	2.39	90900.0
2007-10-02	AAV-DELISTED	Stock	12.26	12.27	12.05	12.13	801500.0
2007-10-02	AAWW-DELISTED	Stock	53.19	53.19	52.32	52.69	45300.0
2007-10-02	AAXN-DELISTED	Stock	16.37	17.08	16.21	16.95	3266734.0
2007-10-02	AB	Stock	90.32	91.52	89.83	90.88	271800.0
2007-10-02	ABAX-DELISTED	Stock	22.89	23.9	22.69	23.8	210978.0
2007-10-02	ABB-DELISTED	Stock	27.03	27.14	26.72	27.06	2595700.0
2007-10-02	ABBC-DELISTED	Stock	9.82	9.9	9.75	9.87	209192.0
2007-10-02	ABBNY-DELISTED	Stock	27.03	27.14	26.72	27.06	2595700.0
2007-10-02	ABC-DELISTED	Stock	22.6	22.75	22.4	22.7	2581980.0
2007-10-02	ABCB	Stock	18.0231	18.4704	17.9355	17.9647	49144.0
2007-10-02	ABCO-DELISTED	Stock	30.28	31.09	30.08	30.86	264247.0
2007-10-02	ABCW-DELISTED	Stock	27.51	27.61	27.31	27.47	102580.0
2007-10-02	ABD-DELISTED	Stock	23.24	23.55	23.02	23.38	205800.0
2007-10-02	ABE-DELISTED	Stock	24.55	25.1	24.51	24.59	33800.0
2007-10-02	ABEO	Stock	5437.5	5500.0	5187.5	5437.5	15.0
2007-10-02	ABFS-DELISTED	Stock	32.83	33.71	32.83	33.61	301631.0
2007-10-02	ABG	Stock	19.32	20.69	19.3	20.56	848900.0
2007-10-02	ABK-DELISTED	Stock	64.48	65.46	64.18	64.79	1831500.0
2007-10-02	ABM	Stock	20.5	21.05	20.3	21.02	224700.0
2007-10-02	ABMD-DELISTED	Stock	12.5	12.53	12.4	12.48	423696.0
2007-10-02	ABP-DELISTED	Stock	4.0	4.1	3.95	4.05	177000.0
2007-10-02	ABR	Stock	20.19	21.26	20.19	20.64	161500.0
2007-10-02	ABT	Stock	26.437	26.7776	26.413	26.6097	11327845.0
2007-10-02	ABTL-DELISTED	Stock	16.45	16.801	16.45	16.75	16011.0
2007-10-02	ABV-DELISTED	Stock	76.71	78.87	76.19	78.63	775700.0
2007-10-02	ABVA-DELISTED	Stock	10.07	10.1	10.02	10.1	2650.0
2007-10-02	ABVT-DELISTED	Stock	76.0	77.0	75.97	76.5	25800.0
2007-10-02	ABX-DELISTED	Stock	40.02	40.2	38.81	39.26	7358681.0
2007-10-02	ACAD	Stock	15.55	15.55	14.91	14.96	197900.0
2007-10-02	ACAP-DELISTED	Stock	40.3	40.71	39.8	40.63	37135.0
2007-10-02	ACAS-DELISTED	Stock	43.5	43.96	43.37	43.75	1311917.0
2007-10-02	ACAT-DELISTED	Stock	16.695	16.765	16.485	16.705	129634.0
2007-10-02	ACC-DELISTED	Stock	29.9	30.12	29.58	29.62	120310.0

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

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