PREVIEW / stock_daily / 2007-04-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-20.parquet
  size:    163 KB
  rows:    4,908
  symbols: 3,088

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-04-20	AAPL	Stock	3.2461	3.2564	3.2339	3.2489	522779600.0
2007-04-20	MSFT	Stock	28.98	29.1	28.7	29.02	60311500.0
2007-04-20	NVDA	Stock	0.533	0.5333	0.5245	0.5315	590052000.0
2007-04-20	AMZN	Stock	2.2545	2.2585	2.226	2.2475	119610000.0
2007-04-20	TLT	Stock	88.45	88.45	88.06	88.15	664429.0
2007-04-20	CL	Stock	33.365	33.65	33.285	33.645	3754200.0
2007-04-20	A	Stock	25.5293	25.5722	25.1717	25.3791	4468008.0
2007-04-20	AABA-DELISTED	Stock	27.8600006103516	27.8600006103516	27.3700008392334	27.4599990844727	39123300.0
2007-04-20	AACC-DELISTED	Stock	16.26	16.29	16.05	16.2	78585.0
2007-04-20	AACQ-DELISTED	Stock	4.54	4.59	4.54	4.59	6100.0
2007-04-20	AACQW-DELISTED	Stock	0.64	0.64	0.64	0.64	2500.0
2007-04-20	AAI-DELISTED	Stock	11.9	12.03	11.52	11.66	2159800.0
2007-04-20	AAIC-DELISTED	Stock	121.4	123.0	120.4	122.4	1697200.0
2007-04-20	AAME	Stock	4.5	4.8	4.49	4.79	20700.0
2007-04-20	AAON	Stock	3.3185	3.3501	3.3001	3.3053	143522.0
2007-04-20	AAP	Stock	40.4	40.8	40.23	40.8	664900.0
2007-04-20	AATI-DELISTED	Stock	6.68	6.83	6.68	6.76	139615.0
2007-04-20	AAU-DELISTED	Stock	2.56	2.63	2.56	2.59	55900.0
2007-04-20	AAUAF-DELISTED	Stock	2.56	2.63	2.56	2.59	55900.0
2007-04-20	AAV-DELISTED	Stock	11.24	11.37	11.18	11.32	923420.0
2007-04-20	AAWW-DELISTED	Stock	59.41	60.05	59.15	59.79	210764.0
2007-04-20	AAXN-DELISTED	Stock	8.5	8.52000045776367	8.28999996185303	8.34000015258789	753900.0
2007-04-20	AB	Stock	93.2	93.9	92.75	93.8	101600.0
2007-04-20	ABAX-DELISTED	Stock	25.91	26.17	25.3722	25.43	254854.0
2007-04-20	ABB-DELISTED	Stock	18.78	18.83	18.57	18.73	1760000.0
2007-04-20	ABBC-DELISTED	Stock	19.96	20.01	19.76	19.76	12650.0
2007-04-20	ABC-DELISTED	Stock	27.38	27.52	27.17	27.38	2075000.0
2007-04-20	ABCB	Stock	24.6078	24.6564	24.141	24.3841	46677.0
2007-04-20	ABCO-DELISTED	Stock	25.87	25.87	25.45	25.49	126208.0
2007-04-20	ABCW-DELISTED	Stock	28.4	28.71	28.07	28.42	41380.0
2007-04-20	ABD-DELISTED	Stock	24.66	24.83	24.32	24.4	689000.0
2007-04-20	ABE-DELISTED	Stock	20.68	20.75	20.555	20.6145	15500.0
2007-04-20	ABFS-DELISTED	Stock	38.47	39.0	38.25	38.94	523117.0
2007-04-20	ABG	Stock	28.48	28.5	27.85	27.94	527000.0
2007-04-20	ABK-DELISTED	Stock	90.2	90.57	89.86	90.06	1123300.0
2007-04-20	ABM	Stock	27.82	27.9	27.68	27.85	283800.0
2007-04-20	ABMD-DELISTED	Stock	13.83	13.83	13.55	13.75	169770.0
2007-04-20	ABP-DELISTED	Stock	3.08	3.16	3.04	3.06	72200.0
2007-04-20	ABR	Stock	32.0	32.06	31.73	31.85	74100.0
2007-04-20	ABT	Stock	27.7948	27.8236	27.4494	27.7564	15603168.0
2007-04-20	ABTL-DELISTED	Stock	17.5	17.5	16.95	17.4	21700.0
2007-04-20	ABV-DELISTED	Stock	60.5	60.79	59.69	59.89	432000.0
2007-04-20	ABVA-DELISTED	Stock	15.21	15.21	14.75	15.0	7302.0
2007-04-20	ABX-DELISTED	Stock	29.18	29.34	28.8	28.88	5509789.0
2007-04-20	ACAD	Stock	14.86	14.9	14.4	14.6	383400.0
2007-04-20	ACAP-DELISTED	Stock	39.66	39.66	38.81	39.53	117501.0
2007-04-20	ACAS-DELISTED	Stock	47.23	47.51	46.96	47.19	935032.0
2007-04-20	ACAT-DELISTED	Stock	18.48	18.62	18.28	18.38	74252.0
2007-04-20	ACC-DELISTED	Stock	30.49	30.49	30.23	30.26	99900.0
2007-04-20	ACCL-DELISTED	Stock	6.43	6.49	6.33	6.49	27196.0

> showing 50 of 4,908 rows — these rows as CSV

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