PREVIEW / stock_daily / 2008-07-18

all stock daily files

  file:    by_date/stock_daily/2008/2008-07-18.parquet
  size:    183 KB
  rows:    5,732
  symbols: 3,460

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-18	AAPL	Stock	6.0186	6.0589	5.8929	5.8982	868414400.0
2008-07-18	MSFT	Stock	26.36	26.47	25.11	25.86	150277000.0
2008-07-18	NVDA	Stock	0.282	0.2908	0.274	0.289	899720000.0
2008-07-18	AMZN	Stock	3.497	3.542	3.42	3.456	165960000.0
2008-07-18	TLT	Stock	90.76	91.2	90.3	90.3	3475162.0
2008-07-18	CL	Stock	34.925	34.925	34.35	34.42	6401400.0
2008-07-18	A	Stock	25.1502	25.4936	24.8283	25.4435	3765373.0
2008-07-18	AABA-DELISTED	Stock	22.54	22.55	21.86	22.45	22102855.0
2008-07-18	AACC-DELISTED	Stock	11.0	11.0	10.69	10.94	111506.0
2008-07-18	AACG	Stock	12.03	12.03	11.97	11.97	1900.0
2008-07-18	AAI-DELISTED	Stock	2.0	2.13	1.85	1.98	3770811.0
2008-07-18	AAIC-DELISTED	Stock	40.0	40.8	34.4	36.0	521135.0
2008-07-18	AAME	Stock	1.61	1.63	1.55	1.55	3900.0
2008-07-18	AAON	Stock	3.4153	3.4627	3.3146	3.4074	524475.0
2008-07-18	AAP	Stock	41.09	41.96	40.6	40.97	1605600.0
2008-07-18	AATI-DELISTED	Stock	4.6	4.94	4.48	4.74	518237.0
2008-07-18	AAU-DELISTED	Stock	2.1	2.1	2.01	2.09	59870.0
2008-07-18	AAUAF-DELISTED	Stock	2.1	2.1	2.01	2.085	61470.0
2008-07-18	AAV-DELISTED	Stock	11.41	11.7	11.26	11.48	556283.0
2008-07-18	AAWW-DELISTED	Stock	49.03	49.47	48.17	48.45	131746.0
2008-07-18	AAXN-DELISTED	Stock	5.73	5.74	5.47	5.65	757192.0
2008-07-18	AB	Stock	52.26	52.26	49.29	50.47	400300.0
2008-07-18	ABAX-DELISTED	Stock	23.01	23.37	22.14	22.53	229273.0
2008-07-18	ABB-DELISTED	Stock	28.26	28.7	28.1	28.27	3898745.0
2008-07-18	ABBC-DELISTED	Stock	9.28	9.3	9.06	9.21	62627.0
2008-07-18	ABBNY-DELISTED	Stock	28.26	28.7	28.1	28.27	3960315.0
2008-07-18	ABC-DELISTED	Stock	19.08	19.29	18.86	18.9	2372888.0
2008-07-18	ABCB	Stock	8.8218	9.0553	8.5885	8.9483	64978.0
2008-07-18	ABCO-DELISTED	Stock	18.645	18.815	18.03	18.16	209358.0
2008-07-18	ABCW-DELISTED	Stock	7.65	7.7	6.88	7.18	335340.0
2008-07-18	ABD-DELISTED	Stock	7.92	7.95	7.7	7.89	1452470.0
2008-07-18	ABE-DELISTED	Stock	20.33	20.33	19.74	20.01	34533.0
2008-07-18	ABEO	Stock	3562.5	3812.5	3562.5	3812.5	4.0
2008-07-18	ABFS-DELISTED	Stock	42.15	42.89	41.26	42.63	1672743.0
2008-07-18	ABG	Stock	11.91	11.91	11.19	11.54	427700.0
2008-07-18	ABII-DELISTED	Stock	69.05	71.73	66.76	69.98	145281.0
2008-07-18	ABK-DELISTED	Stock	2.2	2.27	2.0	2.22	14430874.0
2008-07-18	ABM	Stock	22.67	22.67	21.91	21.96	391000.0
2008-07-18	ABMD-DELISTED	Stock	18.9	19.01	18.2	18.45	143266.0
2008-07-18	ABP-DELISTED	Stock	4.06	4.35	4.06	4.24	298084.0
2008-07-18	ABR	Stock	9.75	10.69	9.04	9.28	448200.0
2008-07-18	ABT	Stock	27.7132	27.9963	27.4973	27.6269	22540434.0
2008-07-18	ABTL-DELISTED	Stock	5.8555	5.9068	5.3418	5.65	23099.0
2008-07-18	ABV-DELISTED	Stock	62.31	62.54	60.26	61.01	591498.0
2008-07-18	ABVA-DELISTED	Stock	3.68	4.0	3.68	3.78	12727.0
2008-07-18	ABVT-DELISTED	Stock	59.4	60.0	59.4	60.0	85752.0
2008-07-18	ABX-DELISTED	Stock	47.37	48.14	46.84	47.31	7497997.0
2008-07-18	ACAD	Stock	3.73	3.73	3.49	3.49	136100.0
2008-07-18	ACAP-DELISTED	Stock	42.86	43.81	41.88	43.61	124144.0
2008-07-18	ACAS-DELISTED	Stock	21.97	22.1	20.64	21.16	3097146.0

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

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