PREVIEW / stock_daily / 2007-11-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-12.parquet
  size:    180 KB
  rows:    5,572
  symbols: 3,366

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-11-12	AAPL	Stock	5.9029	5.9893	5.3796	5.4914	1769065200.0
2007-11-12	MSFT	Stock	33.32	33.71	33.02	33.38	84865200.0
2007-11-12	NVDA	Stock	0.8338	0.8398	0.7508	0.7508	715732000.0
2007-11-12	AMZN	Stock	3.913	4.0045	3.825	3.85	187938000.0
2007-11-12	TLT	Stock	91.99	91.99	91.345	91.66	460535.0
2007-11-12	CL	Stock	38.255	38.79	38.09	38.39	6894600.0
2007-11-12	A	Stock	23.5122	24.299	23.5122	23.97	3924885.0
2007-11-12	AABA-DELISTED	Stock	25.8	26.2	24.69	24.75	31288375.0
2007-11-12	AACC-DELISTED	Stock	10.32	10.59	10.24	10.53	175208.0
2007-11-12	AAI-DELISTED	Stock	8.75	9.15	8.7	9.14	1683970.0
2007-11-12	AAIC-DELISTED	Stock	73.0	77.0	72.0	73.6	2971600.0
2007-11-12	AAME	Stock	2.26	2.29	2.07	2.19	32600.0
2007-11-12	AAON	Stock	3.5259	3.7254	3.4686	3.6109	567000.0
2007-11-12	AAP	Stock	34.99	35.54	34.45	34.59	1790900.0
2007-11-12	AATI-DELISTED	Stock	11.01	11.01	9.95	10.25	1148581.0
2007-11-12	AAU-DELISTED	Stock	2.91	2.91	2.63	2.72	137900.0
2007-11-12	AAUAF-DELISTED	Stock	2.91	2.91	2.63	2.72	138300.0
2007-11-12	AAV-DELISTED	Stock	11.7	11.7	11.15	11.15	1225044.0
2007-11-12	AAWW-DELISTED	Stock	54.91	55.86	54.91	55.5	161998.0
2007-11-12	AAXN-DELISTED	Stock	14.0	14.06	13.0	13.1601	2717315.0
2007-11-12	AB	Stock	74.49	77.88	73.75	75.04	643900.0
2007-11-12	ABAX-DELISTED	Stock	31.89	32.27	31.42	31.82	334778.0
2007-11-12	ABB-DELISTED	Stock	29.16	29.37	28.51	28.58	6981371.0
2007-11-12	ABBC-DELISTED	Stock	8.95	9.04	8.95	8.97	48331.0
2007-11-12	ABBNY-DELISTED	Stock	29.16	29.37	28.51	28.56	6981371.0
2007-11-12	ABC-DELISTED	Stock	21.69	22.34	21.69	22.12	3084972.0
2007-11-12	ABCB	Stock	13.9574	14.5896	13.792	14.3853	44621.0
2007-11-12	ABCO-DELISTED	Stock	31.9	32.24	31.7	32.04	299874.0
2007-11-12	ABCW-DELISTED	Stock	23.64	24.52	23.22	24.02	152560.0
2007-11-12	ABD-DELISTED	Stock	19.87	20.65	19.67	19.8	380430.0
2007-11-12	ABE-DELISTED	Stock	23.9	24.2	22.62	22.62	40835.0
2007-11-12	ABEO	Stock	4000.0	4000.0	3750.0	3750.0	14.0
2007-11-12	ABFS-DELISTED	Stock	25.21	25.8	24.59	25.27	665954.0
2007-11-12	ABG	Stock	17.37	17.85	17.22	17.33	421100.0
2007-11-12	ABK-DELISTED	Stock	26.0	28.52	26.0	26.36	7572701.0
2007-11-12	ABM	Stock	21.23	22.12	21.13	21.77	374100.0
2007-11-12	ABMD-DELISTED	Stock	12.15	12.7	12.15	12.28	159312.0
2007-11-12	ABP-DELISTED	Stock	4.17	4.17	3.62	3.75	528986.0
2007-11-12	ABR	Stock	18.06	19.04	18.06	18.65	466400.0
2007-11-12	ABT	Stock	25.9668	26.6145	25.9668	26.2307	12048145.0
2007-11-12	ABTL-DELISTED	Stock	13.259	13.75	13.112	13.75	118893.0
2007-11-12	ABV-DELISTED	Stock	72.47	73.97	69.25	69.55	1299440.0
2007-11-12	ABVA-DELISTED	Stock	8.51	8.54	8.43	8.43	1300.0
2007-11-12	ABX-DELISTED	Stock	44.01	44.15	41.75	41.84	11579891.0
2007-11-12	ACAD	Stock	11.29	12.0	11.22	11.64	605500.0
2007-11-12	ACAP-DELISTED	Stock	41.37	41.98	40.31	40.49	47937.0
2007-11-12	ACAS-DELISTED	Stock	38.42	39.69	38.26	38.26	1882083.0
2007-11-12	ACAT-DELISTED	Stock	13.0	13.18	12.91	13.02	154911.0
2007-11-12	ACC-DELISTED	Stock	26.5	27.17	26.21	26.34	124511.0
2007-11-12	ACCL-DELISTED	Stock	7.51	7.61	7.25	7.46	72261.0

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

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