PREVIEW / stock_daily / 2007-09-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-13.parquet
  size:    176 KB
  rows:    5,458
  symbols: 3,284

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-13	AAPL	Stock	4.9582	4.9643	4.8804	4.9	656163200.0
2007-09-13	MSFT	Stock	29.12	29.26	28.96	29.16	35288600.0
2007-09-13	NVDA	Stock	0.8462	0.8472	0.8248	0.8308	452864000.0
2007-09-13	AMZN	Stock	4.3975	4.4035	4.325	4.363	119670000.0
2007-09-13	TLT	Stock	90.3	90.33	89.58	89.78	2020535.0
2007-09-13	CL	Stock	34.205	34.55	33.635	33.8	5534400.0
2007-09-13	A	Stock	26.0587	26.1087	25.9084	25.9943	1909948.0
2007-09-13	AABA-DELISTED	Stock	23.66	23.96	23.61	23.69	8872413.0
2007-09-13	AACC-DELISTED	Stock	9.84	9.9	9.65	9.85	83711.0
2007-09-13	AAI-DELISTED	Stock	10.3	10.59	10.2	10.39	729300.0
2007-09-13	AAIC-DELISTED	Stock	98.0	98.0	94.2	97.2	1555100.0
2007-09-13	AAME	Stock	3.03	3.03	2.88	2.99	2200.0
2007-09-13	AAON	Stock	3.8677	3.8993	3.7551	3.8044	258694.0
2007-09-13	AAP	Stock	33.27	34.07	33.15	33.58	777600.0
2007-09-13	AATI-DELISTED	Stock	9.84	9.95	9.77	9.85	431404.0
2007-09-13	AAU-DELISTED	Stock	2.23	2.28	2.18	2.18	32800.0
2007-09-13	AAUAF-DELISTED	Stock	2.23	2.28	2.18	2.18	32800.0
2007-09-13	AAV-DELISTED	Stock	11.5	11.6	11.42	11.45	348200.0
2007-09-13	AAWW-DELISTED	Stock	51.43	55.12	51.43	52.96	247526.0
2007-09-13	AAXN-DELISTED	Stock	14.82	14.83	14.4	14.43	944982.0
2007-09-13	AB	Stock	80.07	80.47	79.0	79.12	282200.0
2007-09-13	ABAX-DELISTED	Stock	20.49	20.49	20.07	20.32	102862.0
2007-09-13	ABB-DELISTED	Stock	23.81	24.17	23.69	24.03	1790700.0
2007-09-13	ABBC-DELISTED	Stock	9.47	9.7	9.45	9.67	137921.0
2007-09-13	ABBNY-DELISTED	Stock	23.81	24.17	23.69	24.04	1891500.0
2007-09-13	ABC-DELISTED	Stock	23.12	23.16	22.87	22.92	2049000.0
2007-09-13	ABCB	Stock	17.5562	18.2954	17.4395	17.9842	40097.0
2007-09-13	ABCO-DELISTED	Stock	28.26	28.26	27.76	27.88	150283.0
2007-09-13	ABCW-DELISTED	Stock	27.52	27.78	27.24	27.47	62620.0
2007-09-13	ABD-DELISTED	Stock	20.92	21.34	20.68	20.83	541900.0
2007-09-13	ABE-DELISTED	Stock	21.71	22.0	21.71	21.9399	28100.0
2007-09-13	ABEO	Stock	5250.0	5750.0	5250.0	5687.5	14.0
2007-09-13	ABFS-DELISTED	Stock	33.43	33.77	32.91	33.44	116050.0
2007-09-13	ABG	Stock	20.12	20.46	19.73	20.16	335400.0
2007-09-13	ABK-DELISTED	Stock	62.15	63.69	61.51	63.0	2134900.0
2007-09-13	ABM	Stock	20.21	20.29	19.77	20.07	431700.0
2007-09-13	ABMD-DELISTED	Stock	11.56	11.75	11.27	11.56	113024.0
2007-09-13	ABP-DELISTED	Stock	3.47	3.48	3.37	3.38	73700.0
2007-09-13	ABR	Stock	18.88	19.48	18.77	19.18	88300.0
2007-09-13	ABT	Stock	25.2855	25.4246	24.94	25.0264	10907878.0
2007-09-13	ABTL-DELISTED	Stock	14.8	15.0	14.7	14.8	9361.0
2007-09-13	ABV-DELISTED	Stock	68.53	70.12	67.99	68.48	454500.0
2007-09-13	ABVA-DELISTED	Stock	9.96	10.0	9.96	10.0	800.0
2007-09-13	ABVT-DELISTED	Stock	75.0	76.25	75.0	75.75	20036.0
2007-09-13	ABX-DELISTED	Stock	37.09	37.32	36.7	37.08	4622900.0
2007-09-13	ACAD	Stock	15.99	15.99	15.47	15.76	190400.0
2007-09-13	ACAP-DELISTED	Stock	36.85	36.85	35.81	35.83	83996.0
2007-09-13	ACAS-DELISTED	Stock	38.88	39.3	38.75	39.22	1305322.0
2007-09-13	ACAT-DELISTED	Stock	16.13	16.14	15.79	16.01	87085.0
2007-09-13	ACC-DELISTED	Stock	27.95	28.8	27.85	28.54	114800.0

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

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