PREVIEW / stock_daily / 2007-08-22

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-22.parquet
  size:    177 KB
  rows:    5,487
  symbols: 3,304

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-08-22	AAPL	Stock	4.6864	4.7411	4.6546	4.7325	1061765600.0
2007-08-22	MSFT	Stock	28.27	28.32	28.01	28.22	44763500.0
2007-08-22	NVDA	Stock	0.8088	0.8115	0.7925	0.8068	566154000.0
2007-08-22	AMZN	Stock	3.912	3.9745	3.892	3.925	136962000.0
2007-08-22	TLT	Stock	87.05	87.31	86.81	87.12	1137787.0
2007-08-22	CL	Stock	33.5	33.53	33.05	33.395	3292000.0
2007-08-22	A	Stock	24.4063	24.671	24.2346	24.5923	2837940.0
2007-08-22	AABA-DELISTED	Stock	23.22	23.52	23.18	23.23	17478938.0
2007-08-22	AACC-DELISTED	Stock	10.05	11.0	9.99	10.94	548051.0
2007-08-22	AAI-DELISTED	Stock	10.37	10.5	10.3	10.43	2136100.0
2007-08-22	AAIC-DELISTED	Stock	89.0	94.0	88.8	91.8	2441200.0
2007-08-22	AAME	Stock	2.91	2.93	2.7	2.76	16000.0
2007-08-22	AAON	Stock	4.1798	4.2963	4.1343	4.239	274387.0
2007-08-22	AAP	Stock	33.76	33.9	33.22	33.63	1132300.0
2007-08-22	AATI-DELISTED	Stock	8.75	8.99	8.75	8.84	459312.0
2007-08-22	AAU-DELISTED	Stock	2.25	2.3	2.22	2.22	59100.0
2007-08-22	AAUAF-DELISTED	Stock	2.25	2.3	2.22	2.22	59100.0
2007-08-22	AAV-DELISTED	Stock	11.6	11.8	11.6	11.72	411700.0
2007-08-22	AAWW-DELISTED	Stock	51.06	51.49	50.26	51.18	112822.0
2007-08-22	AAXN-DELISTED	Stock	13.72	13.73	13.42	13.59	1512566.0
2007-08-22	AB	Stock	83.88	84.99	81.66	82.79	252800.0
2007-08-22	ABAX-DELISTED	Stock	21.03	21.23	20.6	20.82	64135.0
2007-08-22	ABB-DELISTED	Stock	22.82	23.16	22.82	23.13	2264400.0
2007-08-22	ABBC-DELISTED	Stock	9.6	9.61	9.5	9.6	80502.0
2007-08-22	ABBNY-DELISTED	Stock	22.82	23.16	22.82	23.1	2323600.0
2007-08-22	ABC-DELISTED	Stock	23.2	23.5	23.14	23.5	4320800.0
2007-08-22	ABCB	Stock	21.8455	21.8552	21.437	21.544	30947.0
2007-08-22	ABCO-DELISTED	Stock	28.98	29.09	28.7	28.86	174061.0
2007-08-22	ABCW-DELISTED	Stock	28.0	28.06	27.32	27.37	169810.0
2007-08-22	ABD-DELISTED	Stock	23.98	24.18	23.15	23.93	276500.0
2007-08-22	ABE-DELISTED	Stock	20.0	20.5	19.87	20.47	32100.0
2007-08-22	ABEO	Stock	3437.5	4375.0	3062.5	4187.5	12.0
2007-08-22	ABFS-DELISTED	Stock	36.47	37.17	36.44	36.46	551483.0
2007-08-22	ABG	Stock	22.77	22.78	21.77	22.01	881300.0
2007-08-22	ABK-DELISTED	Stock	63.14	65.08	62.48	63.87	3910000.0
2007-08-22	ABM	Stock	22.69	23.66	22.69	23.45	192400.0
2007-08-22	ABMD-DELISTED	Stock	11.94	12.42	11.31	11.49	292744.0
2007-08-22	ABP-DELISTED	Stock	3.74	3.75	3.62	3.68	93300.0
2007-08-22	ABR	Stock	18.99	20.39	18.87	19.76	496000.0
2007-08-22	ABT	Stock	25.1847	25.4006	24.8153	25.0168	11213839.0
2007-08-22	ABTL-DELISTED	Stock	15.375	15.475	15.275	15.375	5295.0
2007-08-22	ABV-DELISTED	Stock	64.7	65.04	63.29	64.99	650100.0
2007-08-22	ABVA-DELISTED	Stock	9.94	10.04	9.86	9.86	6707.0
2007-08-22	ABVT-DELISTED	Stock	78.0	79.04	78.0	79.04	2746.0
2007-08-22	ABX-DELISTED	Stock	32.41	33.39	32.23	33.17	4417600.0
2007-08-22	ACAD	Stock	15.05	15.35	14.7	14.8	214100.0
2007-08-22	ACAP-DELISTED	Stock	39.56	41.28	39.48	41.15	131878.0
2007-08-22	ACAS-DELISTED	Stock	40.8	41.48	40.01	40.65	1678540.0
2007-08-22	ACAT-DELISTED	Stock	18.02	18.14	17.65	17.98	72786.0
2007-08-22	ACC-DELISTED	Stock	27.97	28.62	27.62	28.15	170300.0

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

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