PREVIEW / stock_daily / 2007-07-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-26.parquet
  size:    179 KB
  rows:    5,509
  symbols: 3,320

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-26	AAPL	Stock	5.2111	5.3036	4.8914	5.2143	2186629200.0
2007-07-26	MSFT	Stock	30.24	30.53	29.51	29.98	87025300.0
2007-07-26	NVDA	Stock	0.7278	0.7497	0.718	0.7393	710268000.0
2007-07-26	AMZN	Stock	4.251	4.45	4.1715	4.2005	465342000.0
2007-07-26	TLT	Stock	86.74	87.46	86.65	87.03	2867298.0
2007-07-26	CL	Stock	34.425	34.945	34.255	34.395	12762400.0
2007-07-26	A	Stock	28.1831	28.1831	27.103	27.4964	5172181.0
2007-07-26	AABA-DELISTED	Stock	24.4	24.49	23.62	24.08	31503155.0
2007-07-26	AACC-DELISTED	Stock	14.09	14.2	13.8	14.05	291456.0
2007-07-26	AAI-DELISTED	Stock	10.0	10.29	9.82	9.97	2977703.0
2007-07-26	AAIC-DELISTED	Stock	101.0	111.8	100.8	110.0	5725700.0
2007-07-26	AAME	Stock	3.79	3.81	3.51	3.57	6900.0
2007-07-26	AAON	Stock	4.0099	4.1547	3.8808	3.9664	800381.0
2007-07-26	AAP	Stock	37.38	37.82	35.36	36.15	4068900.0
2007-07-26	AATI-DELISTED	Stock	9.65	9.66	9.1	9.16	542909.0
2007-07-26	AAU-DELISTED	Stock	2.74	2.74	2.62	2.67	54700.0
2007-07-26	AAUAF-DELISTED	Stock	2.74	2.74	2.62	2.67	54800.0
2007-07-26	AAV-DELISTED	Stock	12.9	12.92	12.66	12.9	755900.0
2007-07-26	AAWW-DELISTED	Stock	56.28	56.37	53.95	55.52	127384.0
2007-07-26	AAXN-DELISTED	Stock	14.27	30.0	13.52	14.05	6792345.0
2007-07-26	AB	Stock	85.6	86.45	83.01	84.13	893000.0
2007-07-26	ABAX-DELISTED	Stock	19.3	19.37	18.68	18.91	456795.0
2007-07-26	ABB-DELISTED	Stock	22.92	23.31	22.37	22.7	5425100.0
2007-07-26	ABBC-DELISTED	Stock	9.201	9.424	9.151	9.369	60231.0
2007-07-26	ABBNY-DELISTED	Stock	22.92	23.31	22.37	22.67	5473500.0
2007-07-26	ABC-DELISTED	Stock	26.78	26.78	23.75	23.92	5061066.0
2007-07-26	ABCB	Stock	18.6747	19.1125	18.5872	18.8401	125020.0
2007-07-26	ABCO-DELISTED	Stock	26.74	26.9	25.97	26.36	211362.0
2007-07-26	ABCW-DELISTED	Stock	22.78	23.0	22.17	22.85	351910.0
2007-07-26	ABD-DELISTED	Stock	20.5	20.92	20.18	20.78	601800.0
2007-07-26	ABE-DELISTED	Stock	22.95	23.03	21.2	21.86	46100.0
2007-07-26	ABEO	Stock	5375.0	5625.0	5375.0	5562.5	6.0
2007-07-26	ABFS-DELISTED	Stock	37.37	37.64	36.23	37.4	864166.0
2007-07-26	ABG	Stock	23.12	23.15	21.26	21.91	567300.0
2007-07-26	ABK-DELISTED	Stock	77.85	78.46	74.3	75.57	4040815.0
2007-07-26	ABM	Stock	24.7	24.8	23.49	24.19	419800.0
2007-07-26	ABMD-DELISTED	Stock	10.5	10.72	10.4	10.56	201896.0
2007-07-26	ABP-DELISTED	Stock	4.06	4.1	3.86	3.89	286100.0
2007-07-26	ABR	Stock	22.6	22.6	21.56	22.08	432200.0
2007-07-26	ABT	Stock	24.892	24.9496	24.3211	24.513	18796790.0
2007-07-26	ABTL-DELISTED	Stock	18.694	18.95	18.335	18.95	33384.0
2007-07-26	ABV-DELISTED	Stock	70.93	71.77	67.31	69.79	830900.0
2007-07-26	ABVA-DELISTED	Stock	12.71	12.75	12.57	12.694	5538.0
2007-07-26	ABVT-DELISTED	Stock	73.0	73.25	72.5	72.5	10770.0
2007-07-26	ABX-DELISTED	Stock	33.29	33.29	32.19	32.65	10515624.0
2007-07-26	ACAD	Stock	13.92	14.27	13.59	14.19	552000.0
2007-07-26	ACAP-DELISTED	Stock	39.3	39.82	37.8	38.46	115286.0
2007-07-26	ACAS-DELISTED	Stock	39.9	40.08	37.46	38.97	5842130.0
2007-07-26	ACAT-DELISTED	Stock	19.0	19.25	18.1759	19.09	231173.0
2007-07-26	ACC-DELISTED	Stock	26.53	26.7	25.83	26.33	192942.0

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

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