PREVIEW / stock_daily / 2007-11-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-05.parquet
  size:    180 KB
  rows:    5,581
  symbols: 3,386

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-11-05	AAPL	Stock	6.6175	6.7486	6.58	6.6493	804176800.0
2007-11-05	MSFT	Stock	36.76	37.1	36.63	36.73	75485400.0
2007-11-05	NVDA	Stock	0.9108	0.9405	0.905	0.9185	436636000.0
2007-11-05	AMZN	Stock	4.2175	4.301	4.138	4.2185	149062000.0
2007-11-05	TLT	Stock	91.16	91.39	90.8	91.0	1021500.0
2007-11-05	CL	Stock	37.38	37.85	37.035	37.685	5425600.0
2007-11-05	A	Stock	25.4006	25.7439	25.1431	25.5293	2982353.0
2007-11-05	AABA-DELISTED	Stock	30.71	32.37	30.35	31.37	43564605.0
2007-11-05	AACC-DELISTED	Stock	10.06	10.365	10.01	10.25	284473.0
2007-11-05	AAI-DELISTED	Stock	9.85	10.0	9.69	9.83	1465750.0
2007-11-05	AAIC-DELISTED	Stock	73.0	81.0	73.0	80.4	1871877.0
2007-11-05	AAME	Stock	2.26	2.29	2.1	2.2	5800.0
2007-11-05	AAON	Stock	3.3659	3.4212	3.2612	3.279	268312.0
2007-11-05	AAP	Stock	34.48	35.89	34.01	35.15	3371200.0
2007-11-05	AATI-DELISTED	Stock	11.48	11.9	11.4	11.58	566228.0
2007-11-05	AAU-DELISTED	Stock	3.26	3.32	3.15	3.17	117000.0
2007-11-05	AAUAF-DELISTED	Stock	3.26	3.32	3.15	3.17	117900.0
2007-11-05	AAV-DELISTED	Stock	12.41	12.49	12.26	12.39	818199.0
2007-11-05	AAWW-DELISTED	Stock	56.77	57.74	56.62	57.52	59212.0
2007-11-05	AAXN-DELISTED	Stock	15.79	16.29	15.51	15.62	1699435.0
2007-11-05	AB	Stock	78.7	79.68	77.97	78.46	297800.0
2007-11-05	ABAX-DELISTED	Stock	29.45	29.76	28.76	29.28	156769.0
2007-11-05	ABB-DELISTED	Stock	31.0	31.17	30.58	30.96	4048811.0
2007-11-05	ABBC-DELISTED	Stock	8.74	8.94	8.71	8.87	49330.0
2007-11-05	ABBNY-DELISTED	Stock	31.0	31.17	30.58	30.92	4048811.0
2007-11-05	ABC-DELISTED	Stock	21.8	21.98	21.45	21.7	3183064.0
2007-11-05	ABCB	Stock	15.076	15.2413	14.5896	14.7452	42050.0
2007-11-05	ABCO-DELISTED	Stock	31.5	32.6	31.5	31.89	339600.0
2007-11-05	ABCW-DELISTED	Stock	22.72	23.12	22.4	22.64	88860.0
2007-11-05	ABD-DELISTED	Stock	20.04	20.11	19.5	19.67	234730.0
2007-11-05	ABE-DELISTED	Stock	27.05	27.05	25.9	26.06	31308.0
2007-11-05	ABEO	Stock	3750.0	3875.0	3750.0	3875.0	5.0
2007-11-05	ABFS-DELISTED	Stock	25.52	26.3	25.44	25.94	688226.0
2007-11-05	ABG	Stock	17.64	17.74	16.82	16.85	795600.0
2007-11-05	ABK-DELISTED	Stock	21.84	25.85	20.55	24.72	22097633.0
2007-11-05	ABM	Stock	22.47	22.74	21.89	22.29	472000.0
2007-11-05	ABMD-DELISTED	Stock	13.04	13.42	12.82	13.17	122804.0
2007-11-05	ABP-DELISTED	Stock	4.85	4.85	4.46	4.47	382660.0
2007-11-05	ABR	Stock	16.34	16.93	16.2	16.37	546700.0
2007-11-05	ABT	Stock	26.1491	26.1491	25.7173	25.9188	9700709.0
2007-11-05	ABTL-DELISTED	Stock	10.9	11.55	10.75	11.25	13609.0
2007-11-05	ABV-DELISTED	Stock	79.59	81.28	79.51	80.5	598996.0
2007-11-05	ABVA-DELISTED	Stock	8.47	8.5	7.5	8.12	291033.0
2007-11-05	ABVT-DELISTED	Stock	91.0	91.0	89.95	89.99	10890.0
2007-11-05	ABX-DELISTED	Stock	45.08	46.49	44.89	46.03	8114361.0
2007-11-05	ACAD	Stock	15.03	15.22	14.93	15.0	242500.0
2007-11-05	ACAP-DELISTED	Stock	42.09	42.75	41.17	42.62	31846.0
2007-11-05	ACAS-DELISTED	Stock	42.08	42.22	40.5	41.4	2382231.0
2007-11-05	ACAT-DELISTED	Stock	13.63	13.93	13.14	13.39	92776.0
2007-11-05	ACC-DELISTED	Stock	25.99	26.69	25.6	26.35	283300.0

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

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