PREVIEW / stock_daily / 2008-01-18

all stock daily files

  file:    by_date/stock_daily/2008/2008-01-18.parquet
  size:    181 KB
  rows:    5,688
  symbols: 3,448

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-01-18	AAPL	Stock	5.7754	5.9196	5.7004	5.7629	1724343600.0
2008-01-18	MSFT	Stock	33.16	34.0	32.97	33.01	117062000.0
2008-01-18	NVDA	Stock	0.5843	0.6242	0.563	0.621	920428000.0
2008-01-18	AMZN	Stock	3.9965	4.1155	3.902	3.988	267286000.0
2008-01-18	TLT	Stock	95.55	95.77	95.22	95.25	2676795.0
2008-01-18	CL	Stock	38.83	38.94	37.83	38.5	13300000.0
2008-01-18	A	Stock	25.1502	25.1502	23.6767	24.0773	9815777.0
2008-01-18	AABA-DELISTED	Stock	21.25	21.61	20.07	20.78	41442951.0
2008-01-18	AACC-DELISTED	Stock	8.62	8.94	8.24	8.42	167857.0
2008-01-18	AAI-DELISTED	Stock	7.26	7.46	7.1	7.35	1942000.0
2008-01-18	AAIC-DELISTED	Stock	62.4	65.8	60.2	63.0	1862708.0
2008-01-18	AAME	Stock	1.43	1.5	1.43	1.49	7200.0
2008-01-18	AAON	Stock	3.1921	3.2988	3.1111	3.1368	490556.0
2008-01-18	AAP	Stock	31.47	32.2	31.19	31.82	1507600.0
2008-01-18	AATI-DELISTED	Stock	7.26	7.48	6.89	7.34	683742.0
2008-01-18	AAU-DELISTED	Stock	2.51	2.63	2.47	2.51	68290.0
2008-01-18	AAUAF-DELISTED	Stock	2.51	2.6299	2.47	2.5101	69790.0
2008-01-18	AAV-DELISTED	Stock	9.11	9.29	9.01	9.06	537423.0
2008-01-18	AAWW-DELISTED	Stock	49.77	51.06	49.73	50.11	156862.0
2008-01-18	AAXN-DELISTED	Stock	9.99	10.32	9.58	9.65	3221888.0
2008-01-18	AB	Stock	61.89	63.17	56.9	57.8	2091200.0
2008-01-18	ABAX-DELISTED	Stock	36.51	36.86	35.43	35.78	667907.0
2008-01-18	ABB-DELISTED	Stock	23.99	24.2	23.25	23.67	7229313.0
2008-01-18	ABBC-DELISTED	Stock	8.83	9.01	8.79	8.93	37956.0
2008-01-18	ABBNY-DELISTED	Stock	23.99	24.2	23.25	23.68	7229313.0
2008-01-18	ABC-DELISTED	Stock	23.52	23.58	22.88	23.33	4647670.0
2008-01-18	ABCB	Stock	13.4419	13.5295	12.6833	13.189	63538.0
2008-01-18	ABCO-DELISTED	Stock	32.23	32.9	30.94	31.21	358206.0
2008-01-18	ABCW-DELISTED	Stock	20.78	21.28	19.79	20.89	121780.0
2008-01-18	ABD-DELISTED	Stock	13.34	13.74	13.22	13.41	587560.0
2008-01-18	ABE-DELISTED	Stock	22.06	22.56	20.0	21.96	92300.0
2008-01-18	ABEO	Stock	3687.5	3687.5	3300.0	3437.5	11.0
2008-01-18	ABFS-DELISTED	Stock	19.95	20.37	19.3	20.01	767722.0
2008-01-18	ABG	Stock	12.62	12.79	12.08	12.19	777400.0
2008-01-18	ABII-DELISTED	Stock	61.56	62.5	60.0001	61.5	18364.0
2008-01-18	ABK-DELISTED	Stock	7.15	7.47	6.0	6.76	25673377.0
2008-01-18	ABM	Stock	19.59	19.59	18.64	18.87	543400.0
2008-01-18	ABMD-DELISTED	Stock	14.08	14.41	13.43	13.68	244201.0
2008-01-18	ABP-DELISTED	Stock	3.44	3.51	3.36	3.48	164190.0
2008-01-18	ABR	Stock	15.7	16.0	14.6	15.03	367800.0
2008-01-18	ABT	Stock	28.8072	29.2006	28.193	28.5145	20703418.0
2008-01-18	ABTL-DELISTED	Stock	13.275	13.526	12.825	12.875	8065.0
2008-01-18	ABV-DELISTED	Stock	65.89	70.67	65.36	67.5	1112200.0
2008-01-18	ABVA-DELISTED	Stock	6.75	6.75	6.4	6.46	4400.0
2008-01-18	ABVT-DELISTED	Stock	73.0	73.0	73.0	73.0	500.0
2008-01-18	ABX-DELISTED	Stock	47.4	47.73	45.14	46.54	15700288.0
2008-01-18	ACAD	Stock	11.84	11.96	11.45	11.75	307500.0
2008-01-18	ACAP-DELISTED	Stock	39.58	40.5	38.48	38.87	76857.0
2008-01-18	ACAS-DELISTED	Stock	29.66	30.23	28.23	28.81	5541903.0
2008-01-18	ACAT-DELISTED	Stock	7.48	7.78	7.16	7.62	148911.0

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

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