PREVIEW / stock_daily / 2007-03-02

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-02.parquet
  size:    161 KB
  rows:    4,809
  symbols: 3,008

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-03-02	AAPL	Stock	3.0989	3.1264	3.0432	3.0504	860000400.0
2007-03-02	MSFT	Stock	28.02	28.16	27.76	27.76	63254700.0
2007-03-02	NVDA	Stock	0.5058	0.512	0.4952	0.4962	682728000.0
2007-03-02	AMZN	Stock	1.916	1.9435	1.8845	1.8845	155756000.0
2007-03-02	TLT	Stock	89.96	90.48	89.67	90.2	1619800.0
2007-03-02	CL	Stock	33.435	33.53	33.255	33.325	4891200.0
2007-03-02	A	Stock	22.4249	22.5536	21.9528	21.9742	3432789.0
2007-03-02	AABA-DELISTED	Stock	30.5400009155273	30.8899993896484	30.2800006866455	30.4200000762939	18136600.0
2007-03-02	AACC-DELISTED	Stock	15.06	15.28	15.0	15.08	73775.0
2007-03-02	AACQ-DELISTED	Stock	5.0	5.0	4.95	4.95	12000.0
2007-03-02	AACQU-DELISTED	Stock	6.3	6.3	6.1	6.1	4475.0
2007-03-02	AACQW-DELISTED	Stock	0.64	0.64	0.56	0.64	76200.0
2007-03-02	AAI-DELISTED	Stock	10.37	10.46	10.12	10.14	903900.0
2007-03-02	AAIC-DELISTED	Stock	134.4	135.6	130.2	130.4	1481600.0
2007-03-02	AAME	Stock	3.35	3.49	3.34	3.45	5600.0
2007-03-02	AAON	Stock	3.6135	3.6135	3.5727	3.5793	378928.0
2007-03-02	AAP	Stock	36.91	36.92	36.2	36.28	760500.0
2007-03-02	AATI-DELISTED	Stock	6.27	6.32	5.97	6.03	256052.0
2007-03-02	AAU-DELISTED	Stock	2.17	2.31	2.01	2.2	158700.0
2007-03-02	AAUAF-DELISTED	Stock	2.17	2.31	2.01	2.2	158700.0
2007-03-02	AAV-DELISTED	Stock	10.49	10.55	10.26	10.32	467000.0
2007-03-02	AAWW-DELISTED	Stock	48.88	49.29	47.79	48.6	111233.0
2007-03-02	AAXN-DELISTED	Stock	7.8600001335144	7.90000009536743	7.69000005722046	7.73999977111816	1198400.0
2007-03-02	AB	Stock	82.98	84.32	81.87	82.21	306100.0
2007-03-02	ABAX-DELISTED	Stock	22.6	22.67	22.1	22.29	131826.0
2007-03-02	ABB-DELISTED	Stock	16.54	16.75	16.46	16.51	1420500.0
2007-03-02	ABBC-DELISTED	Stock	19.37	19.41	19.25	19.27	11987.0
2007-03-02	ABC-DELISTED	Stock	26.16	26.27	25.82	25.82	907400.0
2007-03-02	ABCB	Stock	23.8103	24.0048	22.9544	23.0224	64464.0
2007-03-02	ABCO-DELISTED	Stock	26.06	26.3	25.6	25.61	153066.0
2007-03-02	ABCW-DELISTED	Stock	28.17	28.3	27.61	27.61	71230.0
2007-03-02	ABD-DELISTED	Stock	21.48	21.72	21.19	21.21	259300.0
2007-03-02	ABE-DELISTED	Stock	17.3	17.591	17.1	17.13	43200.0
2007-03-02	ABFS-DELISTED	Stock	38.87	38.87	37.58	37.66	407177.0
2007-03-02	ABG	Stock	26.45	26.98	26.35	26.72	345900.0
2007-03-02	ABK-DELISTED	Stock	88.7	88.78	87.91	87.99	625500.0
2007-03-02	ABM	Stock	26.7	26.96	26.3	26.33	300100.0
2007-03-02	ABMD-DELISTED	Stock	13.62	14.12	13.39	13.53	160323.0
2007-03-02	ABP-DELISTED	Stock	2.99	3.0	2.84	2.86	185200.0
2007-03-02	ABR	Stock	31.25	31.25	29.74	29.74	232400.0
2007-03-02	ABT	Stock	25.6837	25.7413	25.2279	25.4342	16151313.0
2007-03-02	ABTL-DELISTED	Stock	19.0	19.598	17.703	18.75	26233.0
2007-03-02	ABV-DELISTED	Stock	49.75	50.49	48.65	48.65	623000.0
2007-03-02	ABVA-DELISTED	Stock	15.8	15.8	15.8	15.8	10200.0
2007-03-02	ABVT-DELISTED	Stock	58.0	58.0	58.0	58.0	1.0
2007-03-02	ABX-DELISTED	Stock	28.95	29.28	28.31	28.47	5628300.0
2007-03-02	ACAD	Stock	6.77	7.5	6.77	6.94	245000.0
2007-03-02	ACAP-DELISTED	Stock	36.55	37.19	35.92	35.93	29659.0
2007-03-02	ACAS-DELISTED	Stock	44.17	44.41	43.2	43.25	793871.0
2007-03-02	ACAT-DELISTED	Stock	18.715	18.906	18.414	18.585	55640.0

> showing 50 of 4,809 rows — these rows as CSV

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