PREVIEW / stock_daily / 2007-11-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-21.parquet
  size:    179 KB
  rows:    5,588
  symbols: 3,385

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-11-21	AAPL	Stock	5.9229	6.1554	5.8811	6.0164	1217809600.0
2007-11-21	MSFT	Stock	34.4	34.73	34.18	34.23	89518700.0
2007-11-21	NVDA	Stock	0.735	0.7605	0.7328	0.7428	648452000.0
2007-11-21	AMZN	Stock	3.962	4.043	3.9325	3.988	133566000.0
2007-11-21	TLT	Stock	93.4	93.58	93.24	93.45	1297750.0
2007-11-21	CL	Stock	39.14	39.965	38.965	39.015	8023000.0
2007-11-21	A	Stock	25.9514	26.5451	25.7225	26.2518	3251888.0
2007-11-21	AABA-DELISTED	Stock	26.12	26.58	25.52	25.69	23334690.0
2007-11-21	AACC-DELISTED	Stock	10.62	10.76	10.47	10.5	122463.0
2007-11-21	AAI-DELISTED	Stock	8.39	8.7	7.95	8.33	2263166.0
2007-11-21	AAIC-DELISTED	Stock	55.6	60.8	51.4	59.2	4115291.0
2007-11-21	AAME	Stock	1.87	2.09	1.67	1.72	23800.0
2007-11-21	AAON	Stock	3.5477	3.7333	3.5477	3.5556	633319.0
2007-11-21	AAP	Stock	34.43	34.7	34.06	34.1	924400.0
2007-11-21	AATI-DELISTED	Stock	10.66	10.66	10.14	10.24	410223.0
2007-11-21	AAU-DELISTED	Stock	2.81	2.9	2.65	2.81	72332.0
2007-11-21	AAUAF-DELISTED	Stock	2.81	2.9	2.65	2.8099	74064.0
2007-11-21	AAV-DELISTED	Stock	10.8	10.98	10.8	10.91	499102.0
2007-11-21	AAWW-DELISTED	Stock	53.98	54.39	53.51	53.83	57921.0
2007-11-21	AAXN-DELISTED	Stock	13.02	13.25	12.77	13.05	1531181.0
2007-11-21	AB	Stock	73.0	74.46	71.31	72.78	360700.0
2007-11-21	ABAX-DELISTED	Stock	32.2	32.51	31.61	31.87	287149.0
2007-11-21	ABB-DELISTED	Stock	26.89	27.15	26.5	26.81	6512275.0
2007-11-21	ABBC-DELISTED	Stock	9.05	9.05	8.93	8.96	75652.0
2007-11-21	ABBNY-DELISTED	Stock	26.89	27.15	26.5	26.84	6512275.0
2007-11-21	ABC-DELISTED	Stock	22.14	22.14	21.66	21.77	2505200.0
2007-11-21	ABCB	Stock	13.6656	14.4535	13.6656	14.1324	19123.0
2007-11-21	ABCO-DELISTED	Stock	31.52	32.17	31.46	31.57	125830.0
2007-11-21	ABCW-DELISTED	Stock	24.1	24.1	23.23	23.7	103320.0
2007-11-21	ABD-DELISTED	Stock	17.895	18.115	17.775	17.845	365860.0
2007-11-21	ABE-DELISTED	Stock	24.2	24.2	22.88	23.1499	28900.0
2007-11-21	ABEO	Stock	3625.0	3750.0	3625.0	3750.0	5.0
2007-11-21	ABFS-DELISTED	Stock	22.03	23.17	22.0	22.23	936407.0
2007-11-21	ABG	Stock	17.35	17.53	16.69	16.72	522200.0
2007-11-21	ABII-DELISTED	Stock	55.76	57.09	55.76	56.9	68872.0
2007-11-21	ABK-DELISTED	Stock	22.4	25.03	22.4	24.15	7907250.0
2007-11-21	ABM	Stock	20.29	20.4	19.66	19.66	325400.0
2007-11-21	ABMD-DELISTED	Stock	12.09	12.24	11.85	12.05	155345.0
2007-11-21	ABP-DELISTED	Stock	3.32	3.44	3.27	3.43	246100.0
2007-11-21	ABR	Stock	16.58	16.73	16.18	16.36	254300.0
2007-11-21	ABT	Stock	26.3938	26.6241	26.1779	26.2595	11677157.0
2007-11-21	ABTL-DELISTED	Stock	15.068	15.63	14.098	14.2	24201.0
2007-11-21	ABV-DELISTED	Stock	72.17	72.17	67.46	68.42	862504.0
2007-11-21	ABVA-DELISTED	Stock	8.85	8.85	7.84	7.84	1200.0
2007-11-21	ABVT-DELISTED	Stock	77.0	81.5	77.0	81.5	951.0
2007-11-21	ABX-DELISTED	Stock	42.6	42.6	40.64	41.74	7463860.0
2007-11-21	ACAD	Stock	10.5	10.57	10.12	10.26	306200.0
2007-11-21	ACAP-DELISTED	Stock	41.18	42.7	40.43	40.95	52724.0
2007-11-21	ACAS-DELISTED	Stock	37.5	37.9	36.5	37.1	1834156.0
2007-11-21	ACAT-DELISTED	Stock	11.77	11.9	11.34	11.34	100752.0

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

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