PREVIEW / stock_daily / 2007-03-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-07.parquet
  size:    161 KB
  rows:    4,855
  symbols: 3,052

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-07	AAPL	Stock	3.1446	3.1775	3.1232	3.1329	626284400.0
2007-03-07	MSFT	Stock	27.76	27.9	27.55	27.61	52044700.0
2007-03-07	NVDA	Stock	0.5052	0.5075	0.4912	0.4933	811656000.0
2007-03-07	AMZN	Stock	1.934	1.966	1.914	1.918	172892000.0
2007-03-07	TLT	Stock	90.08	90.5	89.98	90.43	915400.0
2007-03-07	CL	Stock	33.31	33.31	32.935	32.935	5254200.0
2007-03-07	A	Stock	22.0315	22.1674	21.9099	22.0172	3562244.0
2007-03-07	AABA-DELISTED	Stock	30.9500007629395	31.0300006866455	30.3299999237061	30.3899993896484	16014300.0
2007-03-07	AACC-DELISTED	Stock	15.11	15.74	15.11	15.6	126672.0
2007-03-07	AACQ-DELISTED	Stock	4.66	4.88	4.66	4.71	81300.0
2007-03-07	AACQW-DELISTED	Stock	0.55	0.57	0.55	0.56	85000.0
2007-03-07	AAI-DELISTED	Stock	9.94	10.12	9.87	9.96	1960600.0
2007-03-07	AAIC-DELISTED	Stock	123.0	134.0	122.0	123.2	3668900.0
2007-03-07	AAME	Stock	3.13	3.57	2.9	3.5	12900.0
2007-03-07	AAON	Stock	3.4542	3.5503	3.3567	3.4252	179212.0
2007-03-07	AAP	Stock	37.35	38.06	37.17	37.88	893200.0
2007-03-07	AATI-DELISTED	Stock	6.28	6.4	6.12	6.14	513317.0
2007-03-07	AAU-DELISTED	Stock	2.34	2.34	2.24	2.25	36900.0
2007-03-07	AAUAF-DELISTED	Stock	2.34	2.34	2.24	2.25	36900.0
2007-03-07	AAV-DELISTED	Stock	10.13	10.36	10.11	10.31	497300.0
2007-03-07	AAWW-DELISTED	Stock	46.98	47.5	46.27	47.14	78258.0
2007-03-07	AAXN-DELISTED	Stock	7.90000009536743	7.92999982833862	7.71999979019165	7.73000001907349	862900.0
2007-03-07	AB	Stock	84.35	84.48	83.01	83.02	366700.0
2007-03-07	ABAX-DELISTED	Stock	22.04	22.38	21.82	22.02	185950.0
2007-03-07	ABB-DELISTED	Stock	16.51	16.57	16.29	16.35	3476500.0
2007-03-07	ABBC-DELISTED	Stock	19.2	19.24	19.01	19.1	15581.0
2007-03-07	ABC-DELISTED	Stock	26.18	26.32	25.82	25.82	3361446.0
2007-03-07	ABCB	Stock	24.2188	24.4036	23.5866	23.7616	53051.0
2007-03-07	ABCO-DELISTED	Stock	25.7	26.05	25.48	25.49	163077.0
2007-03-07	ABCW-DELISTED	Stock	27.86	28.08	27.71	27.82	70790.0
2007-03-07	ABD-DELISTED	Stock	21.29	21.41	21.05	21.05	368200.0
2007-03-07	ABE-DELISTED	Stock	17.25	17.48	16.9	17.14	21100.0
2007-03-07	ABFS-DELISTED	Stock	37.45	38.0	37.25	37.72	334719.0
2007-03-07	ABG	Stock	26.58	26.87	26.33	26.37	153300.0
2007-03-07	ABK-DELISTED	Stock	88.63	88.63	87.13	87.51	824000.0
2007-03-07	ABM	Stock	27.0	27.66	26.61	27.19	423200.0
2007-03-07	ABMD-DELISTED	Stock	13.16	13.3	12.96	13.19	89047.0
2007-03-07	ABP-DELISTED	Stock	2.98	3.1	2.98	3.05	117700.0
2007-03-07	ABR	Stock	29.35	29.96	29.35	29.4	209500.0
2007-03-07	ABT	Stock	25.2615	25.4246	25.2135	25.2807	16849104.0
2007-03-07	ABTL-DELISTED	Stock	18.5	18.65	17.9	18.25	17207.0
2007-03-07	ABV-DELISTED	Stock	50.6	51.68	50.58	50.9	522800.0
2007-03-07	ABVA-DELISTED	Stock	15.51	15.57	15.38	15.38	2800.0
2007-03-07	ABX-DELISTED	Stock	28.31	28.55	28.08	28.15	4541600.0
2007-03-07	ACAD	Stock	7.07	7.23	6.76	6.78	254400.0
2007-03-07	ACAP-DELISTED	Stock	37.35	37.35	36.11	36.23	118360.0
2007-03-07	ACAS-DELISTED	Stock	43.39	43.82	43.02	43.03	1775375.0
2007-03-07	ACAT-DELISTED	Stock	18.85	19.06	18.68	18.69	95531.0
2007-03-07	ACC-DELISTED	Stock	29.68	30.0	29.1	29.15	176000.0
2007-03-07	ACCL-DELISTED	Stock	6.25	6.3	6.2	6.25	55594.0

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

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