PREVIEW / stock_daily / 2007-10-03

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-03.parquet
  size:    178 KB
  rows:    5,501
  symbols: 3,322

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-10-03	AAPL	Stock	5.635	5.685	5.6075	5.64	692518400.0
2007-10-03	MSFT	Stock	29.71	29.85	29.29	29.45	37633900.0
2007-10-03	NVDA	Stock	0.9188	0.9188	0.8808	0.8955	467196000.0
2007-10-03	AMZN	Stock	4.6095	4.64	4.589	4.623	101044000.0
2007-10-03	TLT	Stock	89.33	89.43	88.73	88.9	1164600.0
2007-10-03	CL	Stock	35.975	36.08	35.595	35.69	3684000.0
2007-10-03	A	Stock	26.4235	26.5021	26.0587	26.3448	1886741.0
2007-10-03	AABA-DELISTED	Stock	27.16	27.38	26.82	27.17	18052475.0
2007-10-03	AACC-DELISTED	Stock	11.88	12.0	11.79	11.93	126801.0
2007-10-03	AAI-DELISTED	Stock	10.24	10.44	10.2	10.35	1492100.0
2007-10-03	AAIC-DELISTED	Stock	97.4	97.6	93.6	94.0	1290700.0
2007-10-03	AAME	Stock	2.75	2.91	2.67	2.7	5500.0
2007-10-03	AAON	Stock	4.0198	4.0632	3.9605	3.9763	293625.0
2007-10-03	AAP	Stock	33.09	33.73	33.02	33.71	1643900.0
2007-10-03	AATI-DELISTED	Stock	11.7	11.7	11.25	11.37	539490.0
2007-10-03	AAU-DELISTED	Stock	2.39	2.47	2.36	2.45	95500.0
2007-10-03	AAUAF-DELISTED	Stock	2.39	2.47	2.361	2.45	95500.0
2007-10-03	AAV-DELISTED	Stock	12.17	12.2	12.0	12.04	749800.0
2007-10-03	AAWW-DELISTED	Stock	52.36	53.14	52.36	52.58	115225.0
2007-10-03	AAXN-DELISTED	Stock	17.03	17.3	16.55	16.581	2512587.0
2007-10-03	AB	Stock	90.92	91.33	89.98	91.09	238500.0
2007-10-03	ABAX-DELISTED	Stock	23.77	23.94	23.07	23.57	179616.0
2007-10-03	ABB-DELISTED	Stock	27.0	27.07	26.63	26.76	3616600.0
2007-10-03	ABBC-DELISTED	Stock	9.85	9.88	9.72	9.73	156404.0
2007-10-03	ABBNY-DELISTED	Stock	27.0	27.07	26.63	26.73	3616600.0
2007-10-03	ABC-DELISTED	Stock	22.74	23.26	22.32	22.44	2062800.0
2007-10-03	ABCB	Stock	17.8285	18.3537	17.4686	17.4881	42667.0
2007-10-03	ABCO-DELISTED	Stock	30.85	31.2	30.47	30.69	290952.0
2007-10-03	ABCW-DELISTED	Stock	27.32	27.78	27.2	27.25	55710.0
2007-10-03	ABD-DELISTED	Stock	23.29	23.72	22.99	23.36	703470.0
2007-10-03	ABE-DELISTED	Stock	24.95	24.95	23.87	23.905	35700.0
2007-10-03	ABEO	Stock	5425.0	5500.0	5375.0	5375.0	4.0
2007-10-03	ABFS-DELISTED	Stock	33.55	33.55	32.67	32.91	302444.0
2007-10-03	ABG	Stock	20.52	20.73	20.22	20.54	467800.0
2007-10-03	ABK-DELISTED	Stock	63.89	66.3	63.89	65.68	2500300.0
2007-10-03	ABM	Stock	20.94	21.01	20.13	20.24	249900.0
2007-10-03	ABMD-DELISTED	Stock	12.36	13.07	12.33	13.02	332561.0
2007-10-03	ABP-DELISTED	Stock	4.0	4.05	3.86	4.03	147900.0
2007-10-03	ABR	Stock	20.63	20.98	20.38	20.74	157600.0
2007-10-03	ABT	Stock	26.4034	26.8016	26.3458	26.6433	9706544.0
2007-10-03	ABTL-DELISTED	Stock	16.998	17.3	16.927	17.25	6054.0
2007-10-03	ABV-DELISTED	Stock	78.3	78.53	77.55	77.95	524500.0
2007-10-03	ABVA-DELISTED	Stock	10.03	10.11	10.02	10.11	1800.0
2007-10-03	ABX-DELISTED	Stock	39.47	39.65	39.15	39.43	9053576.0
2007-10-03	ACAD	Stock	14.88	15.28	14.83	15.2	279800.0
2007-10-03	ACAP-DELISTED	Stock	40.31	40.71	39.45	40.41	49223.0
2007-10-03	ACAS-DELISTED	Stock	43.46	43.98	43.25	43.69	1105406.0
2007-10-03	ACAT-DELISTED	Stock	16.6	17.2	16.47	16.93	111868.0
2007-10-03	ACC-DELISTED	Stock	29.25	29.52	29.18	29.43	122444.0
2007-10-03	ACCL-DELISTED	Stock	7.42	7.67	7.3	7.6	220238.0

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

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