PREVIEW / stock_daily / 2007-05-31

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-31.parquet
  size:    177 KB
  rows:    5,390
  symbols: 3,228

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-05-31	AAPL	Stock	4.2882	4.3632	4.2693	4.3282	1297066400.0
2007-05-31	MSFT	Stock	31.12	31.16	30.61	30.69	85290500.0
2007-05-31	NVDA	Stock	0.5725	0.5808	0.5698	0.5773	481572000.0
2007-05-31	AMZN	Stock	3.534	3.537	3.4285	3.457	186204000.0
2007-05-31	TLT	Stock	86.56	86.58	86.04	86.38	1725900.0
2007-05-31	CL	Stock	33.46	33.565	33.255	33.48	5966600.0
2007-05-31	A	Stock	27.3104	27.4177	27.2532	27.3033	3032961.0
2007-05-31	AABA-DELISTED	Stock	28.76	28.85	28.49	28.69	14424630.0
2007-05-31	AACC-DELISTED	Stock	19.12	19.23	19.09	19.14	157117.0
2007-05-31	AAI-DELISTED	Stock	12.3	12.47	12.29	12.39	1090140.0
2007-05-31	AAIC-DELISTED	Stock	128.0	128.8	124.0	125.4	2247600.0
2007-05-31	AAME	Stock	5.18	5.2	4.85	4.9	11500.0
2007-05-31	AAON	Stock	3.9401	3.9506	3.8295	3.9124	350072.0
2007-05-31	AAP	Stock	41.32	41.71	41.22	41.42	1040100.0
2007-05-31	AATI-DELISTED	Stock	9.02	9.05	8.77	8.86	1204339.0
2007-05-31	AAU-DELISTED	Stock	2.27	2.39	2.26	2.34	34000.0
2007-05-31	AAUAF-DELISTED	Stock	2.27	2.39	2.26	2.34	34000.0
2007-05-31	AAV-DELISTED	Stock	12.64	12.67	12.07	12.39	1317100.0
2007-05-31	AAWW-DELISTED	Stock	58.54	59.03	57.93	58.54	110169.0
2007-05-31	AAXN-DELISTED	Stock	11.09	11.09	10.42	10.52	4322519.0
2007-05-31	AB	Stock	89.85	92.05	89.85	91.41	139000.0
2007-05-31	ABAX-DELISTED	Stock	22.78	22.89	22.29	22.89	456151.0
2007-05-31	ABB-DELISTED	Stock	21.38	21.55	21.35	21.47	2460275.0
2007-05-31	ABBC-DELISTED	Stock	18.16	18.5	18.13	18.39	15376.0
2007-05-31	ABBNY-DELISTED	Stock	21.38	21.55	21.35	21.47	2460275.0
2007-05-31	ABC-DELISTED	Stock	26.06	26.16	25.46	25.58	5438200.0
2007-05-31	ABCB	Stock	23.0322	23.0322	22.4388	22.6334	9870.0
2007-05-31	ABCO-DELISTED	Stock	25.49	26.07	25.49	26.02	265368.0
2007-05-31	ABCW-DELISTED	Stock	28.47	28.83	28.32	28.63	68660.0
2007-05-31	ABD-DELISTED	Stock	25.08	25.56	24.95	24.98	598490.0
2007-05-31	ABE-DELISTED	Stock	22.31	22.35	22.17	22.29	26300.0
2007-05-31	ABEO	Stock	5750.0	5950.0	5750.0	5950.0	9.0
2007-05-31	ABFS-DELISTED	Stock	40.61	41.3	40.47	41.28	473238.0
2007-05-31	ABG	Stock	27.42	27.49	27.0	27.28	355100.0
2007-05-31	ABK-DELISTED	Stock	89.6	91.15	89.53	89.61	1518700.0
2007-05-31	ABM	Stock	29.5	29.77	29.37	29.51	177100.0
2007-05-31	ABMD-DELISTED	Stock	11.27	11.49	11.06	11.16	283880.0
2007-05-31	ABP-DELISTED	Stock	4.0	4.1	3.9	3.94	331100.0
2007-05-31	ABR	Stock	29.15	29.25	28.49	28.49	90400.0
2007-05-31	ABT	Stock	26.8016	27.1327	26.7728	27.0367	14242601.0
2007-05-31	ABTL-DELISTED	Stock	21.9	21.9	21.55	21.8	16639.0
2007-05-31	ABV-DELISTED	Stock	68.13	69.25	67.51	67.73	646800.0
2007-05-31	ABVA-DELISTED	Stock	14.19	14.27	14.1801	14.26	1475.0
2007-05-31	ABVT-DELISTED	Stock	55.0	61.0	55.0	61.0	316.0
2007-05-31	ABX-DELISTED	Stock	29.09	29.33	28.96	29.11	9810138.0
2007-05-31	ACAD	Stock	12.93	13.0	12.69	12.79	202200.0
2007-05-31	ACAP-DELISTED	Stock	41.67	41.67	40.37	40.88	118504.0
2007-05-31	ACAS-DELISTED	Stock	48.2	48.79	48.2	48.49	1573418.0
2007-05-31	ACAT-DELISTED	Stock	18.99	19.26	18.98	19.12	137932.0
2007-05-31	ACC-DELISTED	Stock	28.93	29.4	28.82	29.4	392519.0

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

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