PREVIEW / stock_daily / 2007-05-22

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-22.parquet
  size:    176 KB
  rows:    5,385
  symbols: 3,236

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-22	AAPL	Stock	4.0175	4.0625	4.0004	4.055	572409600.0
2007-05-22	MSFT	Stock	30.9	30.93	30.66	30.69	39999500.0
2007-05-22	NVDA	Stock	0.586	0.594	0.5765	0.5887	401736000.0
2007-05-22	AMZN	Stock	3.424	3.4535	3.3605	3.444	344226000.0
2007-05-22	TLT	Stock	87.18	87.2	86.68	86.74	920500.0
2007-05-22	CL	Stock	33.475	33.535	33.32	33.475	3123200.0
2007-05-22	A	Stock	27.432	27.7182	27.3319	27.568	5547823.0
2007-05-22	AABA-DELISTED	Stock	29.33	29.35	28.78	28.92	17827104.0
2007-05-22	AACC-DELISTED	Stock	18.52	18.73	18.51	18.7	147911.0
2007-05-22	AAI-DELISTED	Stock	11.93	12.3	11.89	12.25	1166390.0
2007-05-22	AAIC-DELISTED	Stock	115.0	121.2	115.0	119.4	1989575.0
2007-05-22	AAME	Stock	5.1	5.19	4.92	5.19	22600.0
2007-05-22	AAON	Stock	3.7689	4.0033	3.7584	3.919	583959.0
2007-05-22	AAP	Stock	41.39	41.43	40.9	41.11	832600.0
2007-05-22	AATI-DELISTED	Stock	7.99	8.05	7.9	8.03	414293.0
2007-05-22	AAU-DELISTED	Stock	2.37	2.39	2.34	2.37	52100.0
2007-05-22	AAUAF-DELISTED	Stock	2.37	2.39	2.34	2.37	52100.0
2007-05-22	AAV-DELISTED	Stock	13.2	13.32	12.62	12.78	1662000.0
2007-05-22	AAWW-DELISTED	Stock	58.92	59.35	58.75	58.96	97898.0
2007-05-22	AAXN-DELISTED	Stock	9.29	9.42	9.22	9.23	750534.0
2007-05-22	AB	Stock	90.21	90.88	89.91	90.14	229000.0
2007-05-22	ABAX-DELISTED	Stock	21.55	22.34	21.462	22.26	243768.0
2007-05-22	ABB-DELISTED	Stock	20.59	20.9	20.55	20.81	2086900.0
2007-05-22	ABBC-DELISTED	Stock	18.24	18.48	18.24	18.45	3782.0
2007-05-22	ABBNY-DELISTED	Stock	20.59	20.9	20.55	20.81	2135700.0
2007-05-22	ABC-DELISTED	Stock	25.7	25.84	25.46	25.65	2692040.0
2007-05-22	ABCB	Stock	22.2054	23.2851	22.2054	23.0419	60557.0
2007-05-22	ABCO-DELISTED	Stock	24.59	25.38	24.57	25.04	439451.0
2007-05-22	ABCW-DELISTED	Stock	28.28	28.94	28.28	28.94	91450.0
2007-05-22	ABD-DELISTED	Stock	23.27	23.46	23.25	23.37	267070.0
2007-05-22	ABE-DELISTED	Stock	21.75	22.19	21.75	22.1	44400.0
2007-05-22	ABEO	Stock	6250.0	6375.0	6250.0	6375.0	6.0
2007-05-22	ABFS-DELISTED	Stock	39.42	39.8	39.19	39.74	456788.0
2007-05-22	ABG	Stock	27.1	27.64	27.05	27.43	316900.0
2007-05-22	ABK-DELISTED	Stock	95.1	95.1	93.74	94.23	998200.0
2007-05-22	ABM	Stock	28.64	29.34	28.64	29.22	233700.0
2007-05-22	ABMD-DELISTED	Stock	11.92	12.1	11.89	11.9	164897.0
2007-05-22	ABP-DELISTED	Stock	3.7	3.75	3.35	3.57	426300.0
2007-05-22	ABR	Stock	28.2	28.41	28.0	28.29	122200.0
2007-05-22	ABT	Stock	28.0155	28.0683	27.6317	27.6797	12513756.0
2007-05-22	ABTL-DELISTED	Stock	22.27	23.23	21.32	22.43	48716.0
2007-05-22	ABV-DELISTED	Stock	69.5	70.48	67.46	67.55	1012800.0
2007-05-22	ABVA-DELISTED	Stock	13.85	13.85	13.64	13.64	2399.0
2007-05-22	ABX-DELISTED	Stock	30.26	30.3	29.48	29.52	3696450.0
2007-05-22	ACAD	Stock	13.35	13.59	13.23	13.35	137200.0
2007-05-22	ACAP-DELISTED	Stock	38.27	39.85	38.27	39.84	103041.0
2007-05-22	ACAS-DELISTED	Stock	46.86	47.69	46.86	47.45	908647.0
2007-05-22	ACAT-DELISTED	Stock	19.48	19.69	19.34	19.6	71342.0
2007-05-22	ACC-DELISTED	Stock	27.8	28.1	27.49	27.7	188800.0
2007-05-22	ACCL-DELISTED	Stock	6.49	6.49	6.25	6.35	31581.0

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

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