PREVIEW / stock_daily / 2007-10-12

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-12.parquet
  size:    178 KB
  rows:    5,513
  symbols: 3,328

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-12	AAPL	Stock	5.8218	5.9743	5.7786	5.9732	988176000.0
2007-10-12	MSFT	Stock	30.03	30.4	29.95	30.17	31121100.0
2007-10-12	NVDA	Stock	0.8915	0.9033	0.8778	0.9033	409952000.0
2007-10-12	AMZN	Stock	4.471	4.6195	4.446	4.6185	167198000.0
2007-10-12	TLT	Stock	87.52	88.1788	87.48	87.63	1133900.0
2007-10-12	CL	Stock	36.75	37.245	36.575	37.17	5370000.0
2007-10-12	A	Stock	26.7382	27.0458	26.588	26.9027	1222551.0
2007-10-12	AABA-DELISTED	Stock	27.76	28.51	27.65	28.47	22130345.0
2007-10-12	AACC-DELISTED	Stock	11.4	11.4	10.96	11.0	283604.0
2007-10-12	AAI-DELISTED	Stock	10.01	10.06	9.91	9.98	1127922.0
2007-10-12	AAIC-DELISTED	Stock	94.2	96.4	93.0	95.8	951000.0
2007-10-12	AAME	Stock	2.49	2.75	2.43	2.51	6900.0
2007-10-12	AAON	Stock	3.9644	4.0296	3.9427	4.0	72900.0
2007-10-12	AAP	Stock	35.04	35.05	34.42	34.86	884400.0
2007-10-12	AATI-DELISTED	Stock	12.13	12.49	12.0801	12.09	258369.0
2007-10-12	AAU-DELISTED	Stock	3.0	3.01	2.89	3.0	137600.0
2007-10-12	AAUAF-DELISTED	Stock	3.0	3.0075	2.885	3.0	137600.0
2007-10-12	AAV-DELISTED	Stock	12.27	12.29	12.2	12.21	400800.0
2007-10-12	AAWW-DELISTED	Stock	54.07	54.67	54.07	54.5	92925.0
2007-10-12	AAXN-DELISTED	Stock	17.42	17.86	17.29	17.85	1742870.0
2007-10-12	AB	Stock	90.2	90.94	89.13	90.66	172600.0
2007-10-12	ABAX-DELISTED	Stock	24.97	25.84	24.73	25.05	310793.0
2007-10-12	ABB-DELISTED	Stock	27.38	27.98	27.32	27.91	2632200.0
2007-10-12	ABBC-DELISTED	Stock	9.7	9.73	9.62	9.65	43987.0
2007-10-12	ABBNY-DELISTED	Stock	27.38	27.98	27.32	27.87	2631900.0
2007-10-12	ABC-DELISTED	Stock	22.7	22.8	22.6	22.7	1557200.0
2007-10-12	ABCB	Stock	17.6924	18.4704	17.6924	18.2954	21282.0
2007-10-12	ABCO-DELISTED	Stock	30.5	31.02	30.4	30.44	167450.0
2007-10-12	ABCW-DELISTED	Stock	27.39	27.96	27.09	27.49	92650.0
2007-10-12	ABD-DELISTED	Stock	22.51	22.8	20.88	21.66	1745580.0
2007-10-12	ABE-DELISTED	Stock	27.0	27.1	26.25	26.74	31000.0
2007-10-12	ABEO	Stock	4900.0	4987.5	4812.5	4962.5	18.0
2007-10-12	ABFS-DELISTED	Stock	33.07	33.294	32.85	33.01	187969.0
2007-10-12	ABG	Stock	20.22	20.22	19.8	20.03	274600.0
2007-10-12	ABK-DELISTED	Stock	70.33	72.78	68.44	68.87	2596507.0
2007-10-12	ABM	Stock	23.98	24.17	23.88	24.05	660300.0
2007-10-12	ABMD-DELISTED	Stock	13.25	13.5	12.82	13.33	328665.0
2007-10-12	ABP-DELISTED	Stock	3.97	4.13	3.95	4.07	102200.0
2007-10-12	ABR	Stock	19.76	19.9	18.88	19.08	321900.0
2007-10-12	ABT	Stock	25.5685	25.5973	25.1319	25.2567	16902459.0
2007-10-12	ABTL-DELISTED	Stock	15.4	15.6	14.9	14.9	13641.0
2007-10-12	ABV-DELISTED	Stock	77.65	79.39	77.58	78.79	505700.0
2007-10-12	ABVA-DELISTED	Stock	10.05	10.31	9.8	9.81	5716.0
2007-10-12	ABVT-DELISTED	Stock	83.0	84.9	83.0	84.9	732.0
2007-10-12	ABX-DELISTED	Stock	42.01	42.5	41.63	42.28	5403850.0
2007-10-12	ACAD	Stock	15.84	16.25	15.76	15.95	234700.0
2007-10-12	ACAP-DELISTED	Stock	41.38	42.37	40.84	42.37	42812.0
2007-10-12	ACAS-DELISTED	Stock	45.13	45.38	44.93	44.95	1735687.0
2007-10-12	ACAT-DELISTED	Stock	17.55	17.7	17.32	17.4	35997.0
2007-10-12	ACC-DELISTED	Stock	30.11	30.52	29.96	30.11	206299.0

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

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