PREVIEW / stock_daily / 2007-07-18

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-18.parquet
  size:    177 KB
  rows:    5,437
  symbols: 3,272

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-07-18	AAPL	Stock	4.9354	4.9443	4.8586	4.9329	756856800.0
2007-07-18	MSFT	Stock	30.51	30.97	30.5	30.92	64414400.0
2007-07-18	NVDA	Stock	0.7638	0.7662	0.7458	0.7608	550656000.0
2007-07-18	AMZN	Stock	3.6635	3.6745	3.6125	3.666	125794000.0
2007-07-18	TLT	Stock	84.93	85.54	84.81	85.21	1836795.0
2007-07-18	CL	Stock	33.885	34.065	33.67	33.875	6275600.0
2007-07-18	A	Stock	28.176	28.4263	28.0186	28.3405	2861846.0
2007-07-18	AABA-DELISTED	Stock	26.07	26.72	26.02	26.19	59961934.0
2007-07-18	AACC-DELISTED	Stock	14.99	15.3	14.96	15.22	400365.0
2007-07-18	AAI-DELISTED	Stock	10.4	10.62	10.31	10.39	1277600.0
2007-07-18	AAIC-DELISTED	Stock	101.8	102.2	98.8	102.0	2104700.0
2007-07-18	AAME	Stock	3.99	4.01	3.85	3.93	28100.0
2007-07-18	AAON	Stock	4.4616	4.5366	4.3839	4.48	335644.0
2007-07-18	AAP	Stock	39.43	39.63	38.98	39.26	858400.0
2007-07-18	AATI-DELISTED	Stock	10.27	10.32	10.01	10.15	338028.0
2007-07-18	AAU-DELISTED	Stock	2.67	2.69	2.6	2.68	81300.0
2007-07-18	AAUAF-DELISTED	Stock	2.67	2.69	2.6	2.68	81300.0
2007-07-18	AAV-DELISTED	Stock	13.85	13.88	13.75	13.85	446300.0
2007-07-18	AAWW-DELISTED	Stock	59.92	60.51	59.65	60.32	101549.0
2007-07-18	AAXN-DELISTED	Stock	16.0	16.161	15.76	15.8618	2459396.0
2007-07-18	AB	Stock	89.61	91.16	88.0	89.12	326300.0
2007-07-18	ABAX-DELISTED	Stock	19.0	19.15	18.85	19.08	320253.0
2007-07-18	ABB-DELISTED	Stock	24.25	24.36	23.86	24.05	4226065.0
2007-07-18	ABBC-DELISTED	Stock	9.405	9.692	9.405	9.685	222208.0
2007-07-18	ABBNY-DELISTED	Stock	24.25	24.36	23.8578	24.08	4232765.0
2007-07-18	ABC-DELISTED	Stock	25.12	25.12	24.32	24.56	4637428.0
2007-07-18	ABCB	Stock	21.6413	21.8941	21.3981	21.7872	50275.0
2007-07-18	ABCO-DELISTED	Stock	28.26	28.41	27.67	28.17	185208.0
2007-07-18	ABCW-DELISTED	Stock	24.17	24.3	23.08	23.56	316600.0
2007-07-18	ABD-DELISTED	Stock	21.9	22.25	21.84	22.24	422200.0
2007-07-18	ABE-DELISTED	Stock	22.35	22.37	21.91	22.06	22700.0
2007-07-18	ABEO	Stock	6050.0	6050.0	5687.5	5750.0	16.0
2007-07-18	ABFS-DELISTED	Stock	40.48	41.63	40.0	41.52	525558.0
2007-07-18	ABG	Stock	24.05	25.02	23.65	23.78	378000.0
2007-07-18	ABK-DELISTED	Stock	83.98	84.74	82.26	83.42	2973221.0
2007-07-18	ABM	Stock	25.25	25.27	24.61	24.89	240800.0
2007-07-18	ABMD-DELISTED	Stock	11.05	11.4	10.97	11.3	284940.0
2007-07-18	ABP-DELISTED	Stock	4.26	4.39	4.16	4.29	294300.0
2007-07-18	ABR	Stock	24.98	25.01	24.4	24.96	185500.0
2007-07-18	ABT	Stock	25.9092	26.3746	25.6981	25.7653	21692997.0
2007-07-18	ABTL-DELISTED	Stock	21.15	21.6	20.35	20.85	50099.0
2007-07-18	ABV-DELISTED	Stock	74.33	74.7	73.6	74.53	656900.0
2007-07-18	ABVA-DELISTED	Stock	12.64	12.65	12.32	12.406	1200.0
2007-07-18	ABX-DELISTED	Stock	32.11	33.83	32.11	33.77	12887299.0
2007-07-18	ACAD	Stock	13.51	13.64	13.14	13.44	363900.0
2007-07-18	ACAP-DELISTED	Stock	38.08	38.55	37.01	37.02	132935.0
2007-07-18	ACAS-DELISTED	Stock	45.0	45.25	43.97	44.54	2255618.0
2007-07-18	ACAT-DELISTED	Stock	19.75	20.02	19.75	19.98	65949.0
2007-07-18	ACC-DELISTED	Stock	28.1	28.17	27.46	28.04	95820.0
2007-07-18	ACCL-DELISTED	Stock	6.28	6.48	6.23	6.43	41213.0

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

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