PREVIEW / stock_daily / 2007-09-10

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-10.parquet
  size:    177 KB
  rows:    5,497
  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-09-10	AAPL	Stock	4.8925	4.93	4.7839	4.8825	1487838800.0
2007-09-10	MSFT	Stock	28.67	28.75	28.41	28.48	37247600.0
2007-09-10	NVDA	Stock	0.8625	0.8775	0.8395	0.8465	872112000.0
2007-09-10	AMZN	Stock	4.2465	4.258	4.1255	4.167	107338000.0
2007-09-10	TLT	Stock	90.5	91.27	90.5	90.86	2495150.0
2007-09-10	CL	Stock	32.655	33.525	32.65	33.345	6455600.0
2007-09-10	A	Stock	26.0587	26.1087	25.5794	25.8226	2804248.0
2007-09-10	AABA-DELISTED	Stock	23.85	23.85	23.1	23.31	13490359.0
2007-09-10	AACC-DELISTED	Stock	10.5	10.65	9.87	10.04	182986.0
2007-09-10	AAI-DELISTED	Stock	10.42	10.48	10.09	10.11	1211900.0
2007-09-10	AAIC-DELISTED	Stock	92.2	93.6	89.2	91.4	1123000.0
2007-09-10	AAME	Stock	3.19	3.19	3.19	3.19	1600.0
2007-09-10	AAON	Stock	4.0138	4.0237	3.7709	3.844	506250.0
2007-09-10	AAP	Stock	33.78	33.98	32.48	33.1	1887400.0
2007-09-10	AATI-DELISTED	Stock	9.27	9.49	9.08	9.4	262921.0
2007-09-10	AAU-DELISTED	Stock	2.33	2.38	2.29	2.32	30200.0
2007-09-10	AAUAF-DELISTED	Stock	2.33	2.38	2.29	2.32	30200.0
2007-09-10	AAV-DELISTED	Stock	11.34	11.34	11.05	11.11	579300.0
2007-09-10	AAWW-DELISTED	Stock	50.26	50.78	48.89	49.2	55572.0
2007-09-10	AAXN-DELISTED	Stock	14.59	14.97	14.18	14.47	1060523.0
2007-09-10	AB	Stock	81.98	81.99	77.54	79.18	352400.0
2007-09-10	ABAX-DELISTED	Stock	19.93	20.07	19.36	19.8	97891.0
2007-09-10	ABB-DELISTED	Stock	23.16	23.16	22.57	22.94	2201800.0
2007-09-10	ABBC-DELISTED	Stock	9.38	9.5	9.35	9.35	17511.0
2007-09-10	ABBNY-DELISTED	Stock	23.16	23.16	22.57	22.95	2278200.0
2007-09-10	ABC-DELISTED	Stock	23.8	23.8	23.18	23.24	2689000.0
2007-09-10	ABCB	Stock	18.9957	19.2097	18.0231	18.6358	33209.0
2007-09-10	ABCO-DELISTED	Stock	28.27	28.29	27.5	27.7	124948.0
2007-09-10	ABCW-DELISTED	Stock	26.58	26.65	25.96	26.37	222880.0
2007-09-10	ABD-DELISTED	Stock	21.95	22.18	20.97	21.15	474300.0
2007-09-10	ABE-DELISTED	Stock	21.5	21.5	20.71	21.162	23500.0
2007-09-10	ABEO	Stock	5800.0	6350.0	5612.5	5625.0	116.0
2007-09-10	ABFS-DELISTED	Stock	34.19	34.42	32.97	33.21	446825.0
2007-09-10	ABG	Stock	21.28	21.37	20.45	20.78	524600.0
2007-09-10	ABK-DELISTED	Stock	60.52	61.19	58.54	60.18	2302400.0
2007-09-10	ABM	Stock	20.84	20.89	19.74	20.19	506400.0
2007-09-10	ABMD-DELISTED	Stock	11.99	12.23	11.5	11.81	125848.0
2007-09-10	ABP-DELISTED	Stock	3.45	3.48	3.25	3.33	169400.0
2007-09-10	ABR	Stock	18.74	18.94	18.01	18.14	184100.0
2007-09-10	ABT	Stock	24.9448	25.1799	24.7385	24.7961	7304502.0
2007-09-10	ABTL-DELISTED	Stock	15.45	15.45	14.8	15.05	5359.0
2007-09-10	ABV-DELISTED	Stock	66.36	66.49	63.76	65.18	512300.0
2007-09-10	ABVA-DELISTED	Stock	10.05	10.09	9.99	10.07	10750.0
2007-09-10	ABVT-DELISTED	Stock	75.0	75.0	74.95	74.95	1665.0
2007-09-10	ABX-DELISTED	Stock	36.79	37.24	36.16	36.97	6855000.0
2007-09-10	ACAD	Stock	15.15	15.48	14.63	15.04	202300.0
2007-09-10	ACAP-DELISTED	Stock	37.6	38.28	36.35	37.38	28779.0
2007-09-10	ACAS-DELISTED	Stock	38.65	39.26	38.45	38.85	1526375.0
2007-09-10	ACAT-DELISTED	Stock	16.1	16.44	15.94	16.0	124073.0
2007-09-10	ACC-DELISTED	Stock	27.3	27.96	26.62	27.44	144900.0

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

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