PREVIEW / stock_daily / 2008-07-23

all stock daily files

  file:    by_date/stock_daily/2008/2008-07-23.parquet
  size:    184 KB
  rows:    5,759
  symbols: 3,482

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
2008-07-23	AAPL	Stock	5.8925	6.0132	5.77	5.9379	1061768400.0
2008-07-23	MSFT	Stock	25.86	26.84	25.85	26.43	79408800.0
2008-07-23	NVDA	Stock	0.2865	0.296	0.2852	0.293	594876000.0
2008-07-23	AMZN	Stock	3.373	3.6035	3.373	3.527	358324000.0
2008-07-23	TLT	Stock	90.22	90.37	89.752	90.17	2871887.0
2008-07-23	CL	Stock	35.185	35.3	34.95	35.055	5792600.0
2008-07-23	A	Stock	25.2074	25.8155	25.1288	25.7511	3923487.0
2008-07-23	AABA-DELISTED	Stock	21.91	22.48	20.0	20.39	47062297.0
2008-07-23	AACC-DELISTED	Stock	12.0	12.4	11.3	12.19	141360.0
2008-07-23	AACG	Stock	15.0	15.0	13.98	14.75	14100.0
2008-07-23	AAI-DELISTED	Stock	2.66	3.14	2.47	3.03	13377355.0
2008-07-23	AAIC-DELISTED	Stock	39.4	41.6	36.8	39.8	1052153.0
2008-07-23	AAME	Stock	1.39	1.41	1.38	1.4	3000.0
2008-07-23	AAON	Stock	3.6128	3.6602	3.5516	3.6425	572569.0
2008-07-23	AAP	Stock	41.79	42.54	40.89	41.48	2644300.0
2008-07-23	AATI-DELISTED	Stock	4.57	4.815	4.55	4.65	422509.0
2008-07-23	AAU-DELISTED	Stock	2.05	2.05	1.9	1.92	88501.0
2008-07-23	AAUAF-DELISTED	Stock	2.05	2.05	1.9	1.92	89501.0
2008-07-23	AAV-DELISTED	Stock	11.61	11.64	11.27	11.28	686553.0
2008-07-23	AAWW-DELISTED	Stock	50.43	50.94	49.27	49.56	274691.0
2008-07-23	AAXN-DELISTED	Stock	5.7	5.77	5.63	5.7	845703.0
2008-07-23	AB	Stock	54.51	55.84	52.62	54.97	755800.0
2008-07-23	ABAX-DELISTED	Stock	23.33	24.05	23.255	23.9	402241.0
2008-07-23	ABB-DELISTED	Stock	28.6	28.74	28.35	28.46	4660870.0
2008-07-23	ABBC-DELISTED	Stock	9.78	9.78	9.25	9.61	83827.0
2008-07-23	ABBNY-DELISTED	Stock	28.6	28.74	28.35	28.42	4673198.0
2008-07-23	ABC-DELISTED	Stock	19.86	20.0	19.4	20.0	3516498.0
2008-07-23	ABCB	Stock	9.8334	10.4948	9.6778	10.0668	45854.0
2008-07-23	ABCO-DELISTED	Stock	18.808	19.232	18.113	19.217	275031.0
2008-07-23	ABCW-DELISTED	Stock	7.45	8.32	7.3	7.78	309720.0
2008-07-23	ABD-DELISTED	Stock	8.3	8.78	8.29	8.62	822690.0
2008-07-23	ABE-DELISTED	Stock	20.42	20.5	20.2301	20.41	11636.0
2008-07-23	ABEO	Stock	3625.0	4000.0	3625.0	3812.5	15.0
2008-07-23	ABFS-DELISTED	Stock	39.84	39.9	35.36	35.94	5216697.0
2008-07-23	ABG	Stock	12.88	13.74	12.67	12.94	738100.0
2008-07-23	ABII-DELISTED	Stock	70.97	74.94	69.0	74.13	22261.0
2008-07-23	ABK-DELISTED	Stock	2.47	2.68	2.23	2.45	21568581.0
2008-07-23	ABM	Stock	22.88	23.71	22.88	23.64	257200.0
2008-07-23	ABMD-DELISTED	Stock	19.37	19.5	18.81	19.07	194223.0
2008-07-23	ABP-DELISTED	Stock	4.17	4.18	3.84	3.85	628482.0
2008-07-23	ABR	Stock	11.05	12.49	10.61	10.74	539700.0
2008-07-23	ABT	Stock	27.7516	27.8236	27.2574	27.3438	16933931.0
2008-07-23	ABTL-DELISTED	Stock	5.85	5.85	5.3	5.45	19871.0
2008-07-23	ABV-DELISTED	Stock	58.55	60.57	58.27	59.73	564333.0
2008-07-23	ABVA-DELISTED	Stock	3.77	3.8	3.03	3.39	24737.0
2008-07-23	ABX-DELISTED	Stock	47.41	47.84	43.57	43.89	14944346.0
2008-07-23	ACAD	Stock	3.64	3.67	3.39	3.53	313900.0
2008-07-23	ACAP-DELISTED	Stock	48.46	48.46	47.53	48.05	66584.0
2008-07-23	ACAS-DELISTED	Stock	22.15	23.75	21.63	23.48	3908314.0
2008-07-23	ACAT-DELISTED	Stock	8.08	8.5	8.08	8.14	162681.0

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

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