PREVIEW / stock_daily / 2007-05-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-09.parquet
  size:    168 KB
  rows:    5,116
  symbols: 3,157

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-09	AAPL	Stock	3.7468	3.82	3.7461	3.8171	717757600.0
2007-05-09	MSFT	Stock	30.7	30.93	30.57	30.78	51735000.0
2007-05-09	NVDA	Stock	0.5508	0.5605	0.5445	0.5573	417870000.0
2007-05-09	AMZN	Stock	3.1	3.1475	3.065	3.1425	177498000.0
2007-05-09	TLT	Stock	88.65	88.66	88.26	88.29	634900.0
2007-05-09	CL	Stock	33.7	34.0	33.515	33.92	3296400.0
2007-05-09	A	Stock	26.5308	26.824	26.4735	26.7811	2682343.0
2007-05-09	AABA-DELISTED	Stock	30.165	30.44	29.95	30.2	18386748.0
2007-05-09	AACC-DELISTED	Stock	18.95	19.23	18.9	18.92	202986.0
2007-05-09	AAI-DELISTED	Stock	11.67	11.93	11.58	11.79	1519592.0
2007-05-09	AAIC-DELISTED	Stock	113.8	117.4	112.0	115.4	1239900.0
2007-05-09	AAME	Stock	5.34	5.35	5.1	5.14	12500.0
2007-05-09	AAON	Stock	3.5621	3.7531	3.5556	3.7531	1635694.0
2007-05-09	AAP	Stock	41.69	42.26	41.6	42.0	934700.0
2007-05-09	AATI-DELISTED	Stock	7.73	7.83	7.52	7.64	654134.0
2007-05-09	AAU-DELISTED	Stock	2.43	2.55	2.43	2.52	70700.0
2007-05-09	AAUAF-DELISTED	Stock	2.43	2.55	2.43	2.52	70700.0
2007-05-09	AAV-DELISTED	Stock	11.68	11.86	11.63	11.84	622800.0
2007-05-09	AAWW-DELISTED	Stock	59.17	59.21	58.53	58.9	74329.0
2007-05-09	AAXN-DELISTED	Stock	9.46	9.72	9.4	9.611	1427152.0
2007-05-09	AB	Stock	90.3	90.71	89.81	90.33	246800.0
2007-05-09	ABAX-DELISTED	Stock	22.77	22.77	22.52	22.63	237418.0
2007-05-09	ABB-DELISTED	Stock	19.71	19.83	19.7	19.82	1549075.0
2007-05-09	ABBC-DELISTED	Stock	18.55	18.76	18.55	18.65	5118.0
2007-05-09	ABBNY-DELISTED	Stock	19.71	19.83	19.7	19.83	1550575.0
2007-05-09	ABC-DELISTED	Stock	25.64	26.02	25.62	25.96	2237400.0
2007-05-09	ABCB	Stock	22.1179	22.2638	21.8163	22.0012	37218.0
2007-05-09	ABCO-DELISTED	Stock	24.3	25.16	24.16	24.71	829366.0
2007-05-09	ABCW-DELISTED	Stock	28.39	28.71	28.39	28.55	47050.0
2007-05-09	ABD-DELISTED	Stock	22.45	25.75	22.36	22.75	634100.0
2007-05-09	ABE-DELISTED	Stock	20.35	20.75	20.33	20.75	38800.0
2007-05-09	ABFS-DELISTED	Stock	39.3	39.46	38.9	39.27	338259.0
2007-05-09	ABG	Stock	28.21	28.21	27.78	27.97	343200.0
2007-05-09	ABK-DELISTED	Stock	94.44	95.0	93.88	94.63	896500.0
2007-05-09	ABM	Stock	28.81	29.5	28.71	29.41	231100.0
2007-05-09	ABMD-DELISTED	Stock	12.41	12.82	12.35	12.71	156766.0
2007-05-09	ABP-DELISTED	Stock	3.59	4.05	3.51	4.01	515100.0
2007-05-09	ABR	Stock	29.47	30.01	29.34	30.01	130800.0
2007-05-09	ABT	Stock	28.1163	28.3274	27.9388	28.1547	8826178.0
2007-05-09	ABTL-DELISTED	Stock	18.025	18.025	17.324	17.575	14096.0
2007-05-09	ABV-DELISTED	Stock	61.04	62.94	60.96	62.93	505100.0
2007-05-09	ABVA-DELISTED	Stock	13.39	13.45	13.35	13.4	8178.0
2007-05-09	ABVT-DELISTED	Stock	65.0	65.0	65.0	65.0	968.0
2007-05-09	ABX-DELISTED	Stock	30.87	31.48	30.75	30.95	5587800.0
2007-05-09	ACAD	Stock	13.71	14.13	13.22	14.07	382000.0
2007-05-09	ACAP-DELISTED	Stock	39.31	40.11	39.2	40.01	71391.0
2007-05-09	ACAS-DELISTED	Stock	45.8	46.51	45.62	46.44	1048298.0
2007-05-09	ACAT-DELISTED	Stock	18.01	18.79	18.01	18.53	60372.0
2007-05-09	ACC-DELISTED	Stock	29.2	29.67	29.08	29.5	61900.0
2007-05-09	ACCL-DELISTED	Stock	6.47	6.47	6.26	6.35	60261.0

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

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