PREVIEW / stock_daily / 2007-09-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-17.parquet
  size:    176 KB
  rows:    5,466
  symbols: 3,297

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-17	AAPL	Stock	4.9639	5.0211	4.9143	4.9432	793371600.0
2007-09-17	MSFT	Stock	28.79	28.88	28.62	28.73	39536500.0
2007-09-17	NVDA	Stock	0.8075	0.816	0.7958	0.8045	374828000.0
2007-09-17	AMZN	Stock	4.349	4.367	4.299	4.3455	89690000.0
2007-09-17	TLT	Stock	89.82	90.39	89.76	90.38	1285400.0
2007-09-17	CL	Stock	33.78	34.335	33.77	34.12	4495800.0
2007-09-17	A	Stock	25.7368	25.9299	25.5866	25.7725	1395763.0
2007-09-17	AABA-DELISTED	Stock	24.48	25.1	24.38	24.95	18126422.0
2007-09-17	AACC-DELISTED	Stock	9.65	9.91	9.55	9.57	129516.0
2007-09-17	AAI-DELISTED	Stock	10.32	10.37	10.1	10.18	892100.0
2007-09-17	AAIC-DELISTED	Stock	97.2	97.6	94.2	96.0	3288500.0
2007-09-17	AAME	Stock	2.85	2.91	2.85	2.89	1000.0
2007-09-17	AAON	Stock	3.7017	3.8064	3.6425	3.7215	432337.0
2007-09-17	AAP	Stock	33.85	33.97	33.55	33.6	688200.0
2007-09-17	AATI-DELISTED	Stock	9.91	10.15	9.85	10.03	1138411.0
2007-09-17	AAU-DELISTED	Stock	2.18	2.25	2.16	2.16	40600.0
2007-09-17	AAUAF-DELISTED	Stock	2.18	2.25	2.1599	2.16	40600.0
2007-09-17	AAV-DELISTED	Stock	11.42	11.43	11.25	11.29	431145.0
2007-09-17	AAWW-DELISTED	Stock	52.22	52.29	51.43	51.47	124853.0
2007-09-17	AAXN-DELISTED	Stock	14.75	14.96	14.35	14.9	2186093.0
2007-09-17	AB	Stock	80.6	81.23	79.58	80.07	185100.0
2007-09-17	ABAX-DELISTED	Stock	20.95	21.06	20.59	20.9	274638.0
2007-09-17	ABB-DELISTED	Stock	23.59	23.67	23.35	23.47	1054000.0
2007-09-17	ABBC-DELISTED	Stock	9.54	9.93	9.54	9.69	120142.0
2007-09-17	ABBNY-DELISTED	Stock	23.59	23.67	23.35	23.49	1118200.0
2007-09-17	ABC-DELISTED	Stock	21.5	22.88	21.5	22.56	3651200.0
2007-09-17	ABCB	Stock	17.4881	17.6243	17.3325	17.4784	17170.0
2007-09-17	ABCO-DELISTED	Stock	27.8	28.23	27.73	28.07	342698.0
2007-09-17	ABCW-DELISTED	Stock	27.81	28.07	27.27	27.58	77760.0
2007-09-17	ABD-DELISTED	Stock	21.37	21.37	20.86	21.0	511330.0
2007-09-17	ABE-DELISTED	Stock	21.75	21.86	21.46	21.49	20000.0
2007-09-17	ABEO	Stock	6000.0	6000.0	5625.0	5625.0	8.0
2007-09-17	ABFS-DELISTED	Stock	33.73	33.79	33.08	33.34	219416.0
2007-09-17	ABG	Stock	20.33	21.25	20.33	20.73	320400.0
2007-09-17	ABK-DELISTED	Stock	61.8	61.97	59.95	61.8	1524600.0
2007-09-17	ABM	Stock	19.95	20.16	19.81	19.85	598600.0
2007-09-17	ABMD-DELISTED	Stock	11.19	11.38	11.15	11.16	63662.0
2007-09-17	ABP-DELISTED	Stock	3.49	3.52	3.4	3.4	53900.0
2007-09-17	ABR	Stock	19.95	19.95	19.04	19.51	196500.0
2007-09-17	ABT	Stock	24.9064	25.0839	24.7145	24.9448	8405377.0
2007-09-17	ABTL-DELISTED	Stock	14.753	14.852	14.555	14.6	8258.0
2007-09-17	ABV-DELISTED	Stock	68.0	68.89	67.0	67.39	436306.0
2007-09-17	ABVA-DELISTED	Stock	10.07	10.1	9.96	10.058	12300.0
2007-09-17	ABVT-DELISTED	Stock	74.469	77.5	74.469	77.5	41194.0
2007-09-17	ABX-DELISTED	Stock	37.84	37.98	37.05	37.45	5690056.0
2007-09-17	ACAD	Stock	15.32	15.5	14.86	14.9	118700.0
2007-09-17	ACAP-DELISTED	Stock	37.09	37.12	36.08	36.63	28698.0
2007-09-17	ACAS-DELISTED	Stock	39.3	40.0	39.04	39.22	1225910.0
2007-09-17	ACAT-DELISTED	Stock	16.02	16.04	15.81	15.82	89465.0
2007-09-17	ACC-DELISTED	Stock	28.47	28.69	28.18	28.2	117255.0

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

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