PREVIEW / stock_daily / 2007-10-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-16.parquet
  size:    179 KB
  rows:    5,527
  symbols: 3,340

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-10-16	AAPL	Stock	5.9121	6.0779	5.8982	6.0564	1067830400.0
2007-10-16	MSFT	Stock	30.24	30.58	30.23	30.32	56286200.0
2007-10-16	NVDA	Stock	0.9088	0.9342	0.9055	0.918	276360000.0
2007-10-16	AMZN	Stock	4.4345	4.5025	4.425	4.4765	170230000.0
2007-10-16	TLT	Stock	87.65	87.98	87.54	87.58	855500.0
2007-10-16	CL	Stock	36.82	36.88	36.415	36.645	4480800.0
2007-10-16	A	Stock	27.5894	28.1259	27.2246	27.3963	3666535.0
2007-10-16	AABA-DELISTED	Stock	27.37	27.48	26.55	26.67	56536542.0
2007-10-16	AACC-DELISTED	Stock	11.0	11.0988	10.66	10.7	255212.0
2007-10-16	AAI-DELISTED	Stock	9.81	9.81	9.61	9.64	1202800.0
2007-10-16	AAIC-DELISTED	Stock	91.2	94.0	90.4	92.8	1307700.0
2007-10-16	AAME	Stock	2.55	2.56	2.55	2.56	3800.0
2007-10-16	AAON	Stock	3.9249	3.9249	3.8064	3.8617	264769.0
2007-10-16	AAP	Stock	34.42	34.72	33.58	33.62	837200.0
2007-10-16	AATI-DELISTED	Stock	11.96	12.11	11.8	11.81	256788.0
2007-10-16	AAU-DELISTED	Stock	3.38	3.38	3.02	3.02	259400.0
2007-10-16	AAUAF-DELISTED	Stock	3.38	3.38	3.02	3.02	259400.0
2007-10-16	AAV-DELISTED	Stock	12.28	12.33	12.2	12.28	559800.0
2007-10-16	AAWW-DELISTED	Stock	55.75	56.49	54.94	56.04	192044.0
2007-10-16	AAXN-DELISTED	Stock	17.18	17.2	16.77	17.11	1704986.0
2007-10-16	AB	Stock	87.88	87.88	86.1	87.28	238400.0
2007-10-16	ABAX-DELISTED	Stock	25.12	25.41	24.72	24.88	151836.0
2007-10-16	ABB-DELISTED	Stock	27.47	27.71	27.36	27.4	2410700.0
2007-10-16	ABBC-DELISTED	Stock	9.69	9.69	9.54	9.55	74995.0
2007-10-16	ABBNY-DELISTED	Stock	27.47	27.71	27.36	27.44	2410700.0
2007-10-16	ABC-DELISTED	Stock	22.56	22.56	22.2	22.34	2071600.0
2007-10-16	ABCB	Stock	18.0425	18.0911	17.9647	18.0036	24161.0
2007-10-16	ABCO-DELISTED	Stock	29.9	30.4	29.9	30.09	121478.0
2007-10-16	ABCW-DELISTED	Stock	26.11	26.37	25.46	25.46	106400.0
2007-10-16	ABD-DELISTED	Stock	21.07	21.07	20.52	20.69	405310.0
2007-10-16	ABE-DELISTED	Stock	27.54	27.54	26.4	27.0	44200.0
2007-10-16	ABEO	Stock	4862.5	4875.0	4625.0	4875.0	4.0
2007-10-16	ABFS-DELISTED	Stock	32.29	32.84	32.29	32.49	244030.0
2007-10-16	ABG	Stock	20.06	20.52	19.49	19.77	623600.0
2007-10-16	ABK-DELISTED	Stock	65.92	66.94	64.03	64.54	2411400.0
2007-10-16	ABM	Stock	23.34	23.44	22.94	23.17	337300.0
2007-10-16	ABMD-DELISTED	Stock	12.98	13.04	12.69	12.81	110750.0
2007-10-16	ABP-DELISTED	Stock	4.19	4.3	4.19	4.27	177600.0
2007-10-16	ABR	Stock	18.57	18.81	18.0	18.5	302500.0
2007-10-16	ABT	Stock	25.0024	25.0839	24.7721	24.9352	18149854.0
2007-10-16	ABTL-DELISTED	Stock	13.7	14.343	13.502	13.7	16531.0
2007-10-16	ABV-DELISTED	Stock	76.3	76.4	74.56	75.5	712500.0
2007-10-16	ABVA-DELISTED	Stock	10.25	10.25	9.78	9.78	1545.0
2007-10-16	ABX-DELISTED	Stock	42.92	43.06	41.92	42.1	6372010.0
2007-10-16	ACAD	Stock	15.24	15.34	14.67	14.83	315400.0
2007-10-16	ACAP-DELISTED	Stock	41.34	41.83	40.82	41.65	46502.0
2007-10-16	ACAS-DELISTED	Stock	44.73	44.73	42.96	43.16	2644957.0
2007-10-16	ACAT-DELISTED	Stock	16.99	17.25	16.35	16.38	99400.0
2007-10-16	ACC-DELISTED	Stock	29.35	29.68	28.75	28.79	106600.0
2007-10-16	ACCL-DELISTED	Stock	7.1	7.27	7.0	7.16	163897.0

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

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