PREVIEW / stock_daily / 2008-05-20

all stock daily files

  file:    by_date/stock_daily/2008/2008-05-20.parquet
  size:    185 KB
  rows:    5,726
  symbols: 3,466

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-05-20	AAPL	Stock	6.4936	6.6486	6.4329	6.6393	969850000.0
2008-05-20	MSFT	Stock	29.3	29.31	28.63	28.76	75767600.0
2008-05-20	NVDA	Stock	0.5812	0.588	0.5752	0.582	771404000.0
2008-05-20	AMZN	Stock	4.1085	4.135	4.0015	4.036	158244000.0
2008-05-20	TLT	Stock	92.44	92.5	91.9	92.44	1465937.0
2008-05-20	CL	Stock	35.935	36.305	35.775	35.89	7292800.0
2008-05-20	A	Stock	25.7439	25.7439	25.0429	25.4793	3842123.0
2008-05-20	AABA-DELISTED	Stock	27.69	28.2	27.32	27.49	29142100.0
2008-05-20	AACC-DELISTED	Stock	13.32	13.33	13.02	13.09	166557.0
2008-05-20	AACG	Stock	14.55	14.83	13.61	14.75	30300.0
2008-05-20	AAI-DELISTED	Stock	3.37	3.37	3.16	3.25	2652953.0
2008-05-20	AAIC-DELISTED	Stock	44.6	45.0	43.4	44.2	525501.0
2008-05-20	AAME	Stock	1.73	1.73	1.63	1.66	3300.0
2008-05-20	AAON	Stock	3.9249	3.9605	3.8835	3.9467	563962.0
2008-05-20	AAP	Stock	38.89	39.54	38.24	38.94	2311400.0
2008-05-20	AATI-DELISTED	Stock	7.55	7.68	7.23	7.39	341682.0
2008-05-20	AAU-DELISTED	Stock	2.38	2.42	2.3	2.4	68469.0
2008-05-20	AAUAF-DELISTED	Stock	2.38	2.42	2.3	2.4	69469.0
2008-05-20	AAV-DELISTED	Stock	12.8	13.17	12.74	13.04	1362942.0
2008-05-20	AAWW-DELISTED	Stock	63.91	64.25	62.4	62.71	95562.0
2008-05-20	AAXN-DELISTED	Stock	7.43	7.49	7.38	7.43	1003632.0
2008-05-20	AB	Stock	64.87	64.98	63.69	64.54	277500.0
2008-05-20	ABAX-DELISTED	Stock	28.86	29.09	28.37	28.53	254639.0
2008-05-20	ABB-DELISTED	Stock	32.51	32.76	32.28	32.55	4856531.0
2008-05-20	ABBC-DELISTED	Stock	10.49	10.55	10.25	10.27	39273.0
2008-05-20	ABBNY-DELISTED	Stock	32.53	32.76	32.28	32.57	4858625.0
2008-05-20	ABC-DELISTED	Stock	20.72	20.82	20.68	20.78	1509272.0
2008-05-20	ABCB	Stock	13.51	13.51	13.0334	13.3544	33825.0
2008-05-20	ABCO-DELISTED	Stock	22.46	22.57	22.19	22.4	267626.0
2008-05-20	ABCW-DELISTED	Stock	14.61	14.83	14.31	14.43	242810.0
2008-05-20	ABD-DELISTED	Stock	15.32	15.54	14.92	15.01	478000.0
2008-05-20	ABE-DELISTED	Stock	23.9	23.9	22.55	23.26	33009.0
2008-05-20	ABEO	Stock	3875.0	3875.0	3462.5	3875.0	4.0
2008-05-20	ABFS-DELISTED	Stock	40.83	40.83	39.04	39.25	643207.0
2008-05-20	ABG	Stock	17.18	17.21	16.77	16.98	201500.0
2008-05-20	ABII-DELISTED	Stock	63.26	64.2	63.05	63.99	8884.0
2008-05-20	ABK-DELISTED	Stock	3.67	3.7	3.47	3.53	8036473.0
2008-05-20	ABM	Stock	20.89	21.02	20.63	20.89	124800.0
2008-05-20	ABMD-DELISTED	Stock	13.45	14.11	13.45	13.93	159790.0
2008-05-20	ABP-DELISTED	Stock	4.42	4.49	4.3	4.46	433623.0
2008-05-20	ABR	Stock	15.34	15.69	15.34	15.47	146100.0
2008-05-20	ABT	Stock	26.437	26.5329	26.1299	26.2355	10568362.0
2008-05-20	ABTL-DELISTED	Stock	9.55	9.75	9.5	9.75	4169.0
2008-05-20	ABV-DELISTED	Stock	75.71	76.35	74.6	76.24	1032324.0
2008-05-20	ABVA-DELISTED	Stock	4.87	4.87	4.53	4.83	4000.0
2008-05-20	ABVT-DELISTED	Stock	60.0	60.0	60.0	60.0	85797.0
2008-05-20	ABX-DELISTED	Stock	41.38	42.53	41.2	42.29	9245971.0
2008-05-20	ACAD	Stock	8.23	8.44	8.15	8.25	143500.0
2008-05-20	ACAP-DELISTED	Stock	45.26	46.25	45.0	45.83	40402.0
2008-05-20	ACAS-DELISTED	Stock	32.85	32.85	32.28	32.49	1855170.0

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

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