PREVIEW / stock_daily / 2007-08-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-17.parquet
  size:    178 KB
  rows:    5,538
  symbols: 3,346

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-08-17	AAPL	Stock	4.3575	4.4107	4.2793	4.3593	1195062400.0
2007-08-17	MSFT	Stock	28.09	28.25	27.82	28.25	76747700.0
2007-08-17	NVDA	Stock	0.7292	0.752	0.7065	0.7513	728712000.0
2007-08-17	AMZN	Stock	3.7245	3.752	3.6555	3.751	144812000.0
2007-08-17	TLT	Stock	86.4	86.91	86.05	86.79	2114400.0
2007-08-17	CL	Stock	33.145	33.69	32.405	33.685	6679600.0
2007-08-17	A	Stock	23.4979	25.0358	23.3476	24.1989	7606099.0
2007-08-17	AABA-DELISTED	Stock	23.26	23.63	22.76	23.57	18659613.0
2007-08-17	AACC-DELISTED	Stock	9.44	9.63	9.27	9.53	312759.0
2007-08-17	AAI-DELISTED	Stock	10.35	10.49	9.9	10.15	2463900.0
2007-08-17	AAIC-DELISTED	Stock	92.6	98.662	85.6	91.2	3306605.0
2007-08-17	AAME	Stock	3.08	3.67	3.08	3.17	9200.0
2007-08-17	AAON	Stock	4.3022	4.3167	4.1139	4.214	432844.0
2007-08-17	AAP	Stock	31.63	32.17	31.09	31.68	1891500.0
2007-08-17	AATI-DELISTED	Stock	8.78	8.82	8.5	8.52	703226.0
2007-08-17	AAU-DELISTED	Stock	2.18	2.38	2.18	2.21	113600.0
2007-08-17	AAUAF-DELISTED	Stock	2.18	2.38	2.18	2.21	113600.0
2007-08-17	AAV-DELISTED	Stock	11.51	11.7	11.38	11.51	851800.0
2007-08-17	AAWW-DELISTED	Stock	52.02	54.66	49.19	50.38	154309.0
2007-08-17	AAXN-DELISTED	Stock	14.74	14.75	13.8	14.1	2814703.0
2007-08-17	AB	Stock	82.5	83.98	78.92	81.01	573900.0
2007-08-17	ABAX-DELISTED	Stock	21.11	21.18	20.44	20.79	195827.0
2007-08-17	ABB-DELISTED	Stock	21.95	22.29	21.26	21.97	5067100.0
2007-08-17	ABBC-DELISTED	Stock	9.2	9.35	9.06	9.26	199894.0
2007-08-17	ABBNY-DELISTED	Stock	21.95	22.29	21.26	21.99	5184600.0
2007-08-17	ABC-DELISTED	Stock	23.26	23.26	22.2	23.02	3592800.0
2007-08-17	ABCB	Stock	22.4583	22.6334	21.2327	21.3592	107542.0
2007-08-17	ABCO-DELISTED	Stock	29.49	29.74	28.61	29.16	261444.0
2007-08-17	ABCW-DELISTED	Stock	26.97	27.91	26.47	27.62	256430.0
2007-08-17	ABD-DELISTED	Stock	24.65	24.74	23.36	23.9	559500.0
2007-08-17	ABE-DELISTED	Stock	19.64	21.13	17.9	19.46	66100.0
2007-08-17	ABEO	Stock	4125.0	4250.0	3687.5	4187.5	7.0
2007-08-17	ABFS-DELISTED	Stock	36.28	37.5	34.83	35.3	419911.0
2007-08-17	ABG	Stock	21.8	22.05	21.25	21.87	894400.0
2007-08-17	ABK-DELISTED	Stock	63.96	66.81	61.44	66.26	6413000.0
2007-08-17	ABM	Stock	22.72	23.24	21.85	22.82	472400.0
2007-08-17	ABMD-DELISTED	Stock	12.64	12.76	12.31	12.48	425319.0
2007-08-17	ABP-DELISTED	Stock	3.71	3.95	3.71	3.9	125000.0
2007-08-17	ABR	Stock	19.14	21.1	18.6	19.07	591100.0
2007-08-17	ABT	Stock	25.5206	25.7892	24.8296	25.2999	16513130.0
2007-08-17	ABTL-DELISTED	Stock	15.2	15.401	14.897	15.25	44099.0
2007-08-17	ABV-DELISTED	Stock	58.92	60.75	56.91	59.19	1442900.0
2007-08-17	ABVA-DELISTED	Stock	9.95	9.95	9.72	9.72	23100.0
2007-08-17	ABVT-DELISTED	Stock	74.0	75.0	74.0	75.0	1200.0
2007-08-17	ABX-DELISTED	Stock	31.28	31.81	30.15	30.55	8639200.0
2007-08-17	ACAD	Stock	15.58	15.73	14.7	15.05	430900.0
2007-08-17	ACAP-DELISTED	Stock	42.0	42.0	40.29	40.59	112712.0
2007-08-17	ACAS-DELISTED	Stock	39.9	41.0	38.73	40.45	3545083.0
2007-08-17	ACAT-DELISTED	Stock	18.06	18.06	17.16	17.33	131560.0
2007-08-17	ACC-DELISTED	Stock	26.94	28.33	26.48	27.06	524459.0

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

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