PREVIEW / stock_daily / 2007-11-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-23.parquet
  size:    171 KB
  rows:    5,382
  symbols: 3,235

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-23	AAPL	Stock	6.1429	6.1446	6.0625	6.1264	465757600.0
2007-11-23	MSFT	Stock	34.36	34.44	33.71	34.11	33467200.0
2007-11-23	NVDA	Stock	0.748	0.7588	0.7385	0.7555	141976000.0
2007-11-23	AMZN	Stock	4.0055	4.0725	3.949	4.0715	55618000.0
2007-11-23	TLT	Stock	93.44	93.8	93.31	93.73	437327.0
2007-11-23	CL	Stock	39.195	39.63	39.195	39.5	2712400.0
2007-11-23	A	Stock	26.3734	26.4807	26.1516	26.402	1195709.0
2007-11-23	AABA-DELISTED	Stock	25.99	26.4	25.76	26.14	9255601.0
2007-11-23	AACC-DELISTED	Stock	10.7	11.19	10.7	11.02	98391.0
2007-11-23	AAI-DELISTED	Stock	8.59	8.65	8.39	8.53	539025.0
2007-11-23	AAIC-DELISTED	Stock	58.6	60.8	58.6	60.0	709384.0
2007-11-23	AAON	Stock	3.6128	3.763	3.599	3.7116	178200.0
2007-11-23	AAP	Stock	34.38	34.46	34.1	34.24	379700.0
2007-11-23	AATI-DELISTED	Stock	10.31	10.6	10.2201	10.5	78667.0
2007-11-23	AAU-DELISTED	Stock	2.82	2.82	2.68	2.75	46000.0
2007-11-23	AAUAF-DELISTED	Stock	2.82	2.82	2.68	2.75	46100.0
2007-11-23	AAV-DELISTED	Stock	10.96	10.96	10.77	10.93	338140.0
2007-11-23	AAWW-DELISTED	Stock	54.76	54.78	53.92	53.95	75424.0
2007-11-23	AAXN-DELISTED	Stock	13.1	13.1888	12.94	13.05	583906.0
2007-11-23	AB	Stock	73.01	77.28	73.01	76.88	259100.0
2007-11-23	ABAX-DELISTED	Stock	32.06	32.35	31.84	32.06	205742.0
2007-11-23	ABB-DELISTED	Stock	26.79	27.21	26.72	27.16	1755080.0
2007-11-23	ABBC-DELISTED	Stock	8.99	9.34	8.99	9.19	22704.0
2007-11-23	ABBNY-DELISTED	Stock	26.79	27.21	26.72	27.15	1755080.0
2007-11-23	ABC-DELISTED	Stock	22.08	22.08	21.82	21.93	1711200.0
2007-11-23	ABCB	Stock	14.3173	14.7063	14.2103	14.2492	26012.0
2007-11-23	ABCO-DELISTED	Stock	31.87	32.41	31.57	32.19	28874.0
2007-11-23	ABCW-DELISTED	Stock	23.93	24.85	23.93	24.62	28690.0
2007-11-23	ABD-DELISTED	Stock	17.99	18.45	17.81	18.37	164030.0
2007-11-23	ABE-DELISTED	Stock	23.03	24.14	23.03	24.13	15990.0
2007-11-23	ABEO	Stock	3750.0	3787.5	3687.5	3750.0	3.0
2007-11-23	ABFS-DELISTED	Stock	22.18	22.68	22.18	22.41	346753.0
2007-11-23	ABG	Stock	16.9	17.46	16.9	17.43	134900.0
2007-11-23	ABII-DELISTED	Stock	55.76	57.35	55.76	57.0	20750.0
2007-11-23	ABK-DELISTED	Stock	25.58	26.15	24.81	25.49	3179820.0
2007-11-23	ABM	Stock	19.85	20.26	19.7	19.92	148200.0
2007-11-23	ABMD-DELISTED	Stock	12.21	12.58	12.0	12.39	55893.0
2007-11-23	ABP-DELISTED	Stock	3.5	3.58	3.43	3.55	95040.0
2007-11-23	ABR	Stock	16.52	17.27	16.38	17.13	121100.0
2007-11-23	ABT	Stock	26.485	26.6289	26.2595	26.6241	4326803.0
2007-11-23	ABTL-DELISTED	Stock	14.494	15.15	14.415	15.15	10954.0
2007-11-23	ABV-DELISTED	Stock	69.85	70.25	68.85	68.98	366563.0
2007-11-23	ABVA-DELISTED	Stock	8.04	8.05	8.0	8.04	660.0
2007-11-23	ABX-DELISTED	Stock	42.97	43.22	41.99	43.08	3847540.0
2007-11-23	ACAD	Stock	10.32	10.32	10.1	10.27	107300.0
2007-11-23	ACAP-DELISTED	Stock	41.53	42.85	41.53	42.6	39731.0
2007-11-23	ACAS-DELISTED	Stock	37.5	38.07	37.25	37.84	847790.0
2007-11-23	ACAT-DELISTED	Stock	11.43	12.46	11.43	12.2	59086.0
2007-11-23	ACC-DELISTED	Stock	25.28	25.6	24.95	25.41	50500.0
2007-11-23	ACCL-DELISTED	Stock	7.42	7.51	7.25	7.51	17199.0

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

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