PREVIEW / stock_daily / 2007-05-01

all stock daily files

  file:    by_date/stock_daily/2007/2007-05-01.parquet
  size:    167 KB
  rows:    5,026
  symbols: 3,125

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-01	AAPL	Stock	3.5568	3.5839	3.5196	3.5525	532523600.0
2007-05-01	MSFT	Stock	29.94	30.42	29.9	30.4	73539300.0
2007-05-01	NVDA	Stock	0.5582	0.5618	0.5495	0.554	544554000.0
2007-05-01	AMZN	Stock	3.056	3.102	3.014	3.102	370380000.0
2007-05-01	TLT	Stock	88.58	88.64	88.11	88.49	487200.0
2007-05-01	CL	Stock	33.925	34.055	33.6	34.05	4810800.0
2007-05-01	A	Stock	24.6638	25.7439	24.6066	25.7439	6170632.0
2007-05-01	AABA-DELISTED	Stock	28.25	28.35	27.53	27.73	17331733.0
2007-05-01	AACC-DELISTED	Stock	18.39	18.65	18.33	18.58	309957.0
2007-05-01	AAI-DELISTED	Stock	10.98	11.11	10.75	11.07	2052305.0
2007-05-01	AAIC-DELISTED	Stock	110.4	112.2	107.6	111.6	1850150.0
2007-05-01	AAME	Stock	5.35	5.35	5.18	5.19	11100.0
2007-05-01	AAON	Stock	3.3251	3.3804	3.25	3.3804	212625.0
2007-05-01	AAP	Stock	41.31	41.31	40.71	40.94	1111100.0
2007-05-01	AATI-DELISTED	Stock	8.15	8.15	7.71	7.99	427757.0
2007-05-01	AAU-DELISTED	Stock	2.5	2.55	2.5	2.5	46800.0
2007-05-01	AAUAF-DELISTED	Stock	2.5	2.55	2.5	2.5	46800.0
2007-05-01	AAV-DELISTED	Stock	11.35	11.4	11.28	11.29	420100.0
2007-05-01	AAWW-DELISTED	Stock	57.68	58.02	56.37	57.5	123093.0
2007-05-01	AAXN-DELISTED	Stock	8.77	9.14	8.72	9.09	2600822.0
2007-05-01	AB	Stock	90.22	90.94	89.09	90.35	210100.0
2007-05-01	ABAX-DELISTED	Stock	22.8	23.3	22.56	23.28	379851.0
2007-05-01	ABB-DELISTED	Stock	20.03	20.2	19.85	20.0	3282700.0
2007-05-01	ABBC-DELISTED	Stock	18.52	18.72	18.4	18.43	11352.0
2007-05-01	ABBNY-DELISTED	Stock	20.03	20.2	19.85	20.0	3293000.0
2007-05-01	ABC-DELISTED	Stock	25.06	25.18	24.98	25.16	3250000.0
2007-05-01	ABCB	Stock	22.2833	22.8181	22.147	22.789	28068.0
2007-05-01	ABCO-DELISTED	Stock	23.71	23.8	23.6	23.64	297710.0
2007-05-01	ABCW-DELISTED	Stock	26.91	27.59	26.64	27.55	63950.0
2007-05-01	ABD-DELISTED	Stock	23.67	24.21	23.53	24.12	535610.0
2007-05-01	ABE-DELISTED	Stock	20.47	21.08	19.3	20.81	82600.0
2007-05-01	ABFS-DELISTED	Stock	39.56	39.78	39.0	39.34	667690.0
2007-05-01	ABG	Stock	28.87	29.16	28.37	28.95	457500.0
2007-05-01	ABK-DELISTED	Stock	93.51	93.51	91.77	92.77	1063863.0
2007-05-01	ABM	Stock	28.14	28.57	27.67	28.42	285800.0
2007-05-01	ABMD-DELISTED	Stock	12.8	13.0	12.67	12.98	168126.0
2007-05-01	ABP-DELISTED	Stock	3.5	3.52	3.36	3.48	174600.0
2007-05-01	ABR	Stock	31.04	31.59	30.67	30.9	79900.0
2007-05-01	ABT	Stock	27.1375	27.4398	27.0751	27.3534	9612755.0
2007-05-01	ABTL-DELISTED	Stock	17.449	18.102	17.147	17.901	33666.0
2007-05-01	ABV-DELISTED	Stock	58.67	59.25	58.19	59.05	164520.0
2007-05-01	ABVA-DELISTED	Stock	14.27	14.47	14.27	14.47	16116.0
2007-05-01	ABX-DELISTED	Stock	28.09	28.19	27.71	27.95	5296533.0
2007-05-01	ACAD	Stock	13.62	13.71	13.01	13.5	821300.0
2007-05-01	ACAP-DELISTED	Stock	39.66	40.11	39.51	39.96	52476.0
2007-05-01	ACAS-DELISTED	Stock	48.65	48.94	47.38	48.25	1209294.0
2007-05-01	ACAT-DELISTED	Stock	17.78	18.26	17.78	18.13	77050.0
2007-05-01	ACC-DELISTED	Stock	30.65	30.91	29.1	29.21	228900.0
2007-05-01	ACCL-DELISTED	Stock	6.5	6.51	6.31	6.45	70867.0
2007-05-01	ACCO	Stock	23.76	24.3	23.62	24.03	576000.0

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

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