PREVIEW / stock_daily / 2007-03-01

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-01.parquet
  size:    161 KB
  rows:    4,850
  symbols: 3,045

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-01	AAPL	Stock	3.0011	3.1539	2.9911	3.1093	1415528800.0
2007-03-01	MSFT	Stock	27.82	28.33	27.73	28.09	80175700.0
2007-03-01	NVDA	Stock	0.5055	0.5198	0.4988	0.5103	837228000.0
2007-03-01	AMZN	Stock	1.966	1.966	1.9025	1.9425	185116000.0
2007-03-01	TLT	Stock	90.28	90.43	89.65	89.74	2423990.0
2007-03-01	CL	Stock	33.18	33.62	32.935	33.465	4852000.0
2007-03-01	A	Stock	22.2818	22.6466	22.0386	22.4893	4067201.0
2007-03-01	AABA-DELISTED	Stock	30.1299991607666	31.2299995422363	30.0	30.8600006103516	24012900.0
2007-03-01	AACC-DELISTED	Stock	14.53	15.33	14.53	15.16	51793.0
2007-03-01	AACQ-DELISTED	Stock	4.95	5.0	4.95	5.0	80322.0
2007-03-01	AACQU-DELISTED	Stock	6.26	6.26	6.26	6.26	300.0
2007-03-01	AACQW-DELISTED	Stock	0.68	0.68	0.68	0.68	17500.0
2007-03-01	AAI-DELISTED	Stock	10.29	10.5	10.1	10.33	913092.0
2007-03-01	AAIC-DELISTED	Stock	133.4	140.0	130.2	136.2	1837288.0
2007-03-01	AAME	Stock	3.5	3.54	3.34	3.37	7300.0
2007-03-01	AAON	Stock	3.624	3.6543	3.599	3.628	352350.0
2007-03-01	AAP	Stock	37.55	37.66	36.6	36.91	1432400.0
2007-03-01	AATI-DELISTED	Stock	6.37	6.49	6.26	6.3	376082.0
2007-03-01	AAU-DELISTED	Stock	2.32	2.32	2.2	2.2	80250.0
2007-03-01	AAUAF-DELISTED	Stock	2.32	2.32	2.2	2.2	80250.0
2007-03-01	AAV-DELISTED	Stock	10.6	10.6	10.45	10.5	292490.0
2007-03-01	AAWW-DELISTED	Stock	48.65	49.6	47.57	49.18	80877.0
2007-03-01	AAXN-DELISTED	Stock	7.80000019073486	7.98999977111816	7.65999984741211	7.90999984741211	1343000.0
2007-03-01	AB	Stock	84.6	84.6	81.62	82.92	698600.0
2007-03-01	ABAX-DELISTED	Stock	22.5	23.0	22.16	22.659	347085.0
2007-03-01	ABB-DELISTED	Stock	16.4	16.68	16.22	16.57	1601532.0
2007-03-01	ABBC-DELISTED	Stock	19.25	19.45	19.25	19.45	3819.0
2007-03-01	ABC-DELISTED	Stock	25.85	26.45	25.52	26.2	1314170.0
2007-03-01	ABCB	Stock	23.7713	24.7732	23.6838	23.9756	39172.0
2007-03-01	ABCO-DELISTED	Stock	25.87	26.44	25.23	26.04	170113.0
2007-03-01	ABCW-DELISTED	Stock	28.04	28.64	27.56	28.22	41440.0
2007-03-01	ABD-DELISTED	Stock	21.62	22.06	21.33	21.54	302510.0
2007-03-01	ABE-DELISTED	Stock	17.6	17.6	16.31	17.4	86800.0
2007-03-01	ABFS-DELISTED	Stock	39.4	39.68	38.78	38.89	308273.0
2007-03-01	ABG	Stock	26.37	26.99	26.29	26.55	229100.0
2007-03-01	ABK-DELISTED	Stock	87.0	89.24	86.34	88.8	907287.0
2007-03-01	ABM	Stock	25.85	27.13	25.65	26.86	361700.0
2007-03-01	ABMD-DELISTED	Stock	13.75	13.9	13.54	13.73	94243.0
2007-03-01	ABP-DELISTED	Stock	3.06	3.06	2.82	3.0	115740.0
2007-03-01	ABR	Stock	30.54	30.95	29.94	30.66	223000.0
2007-03-01	ABT	Stock	25.7892	26.2451	25.6357	25.8036	20889746.0
2007-03-01	ABTL-DELISTED	Stock	18.856	19.399	18.806	19.3	7525.0
2007-03-01	ABV-DELISTED	Stock	47.08	49.66	46.67	49.38	626200.0
2007-03-01	ABVA-DELISTED	Stock	15.85	15.85	15.85	15.85	25000.0
2007-03-01	ABX-DELISTED	Stock	29.6	29.84	29.05	29.27	6349420.0
2007-03-01	ACAD	Stock	6.73	6.95	6.66	6.86	229900.0
2007-03-01	ACAP-DELISTED	Stock	36.78	36.96	36.2	36.63	30881.0
2007-03-01	ACAS-DELISTED	Stock	43.98	44.41	43.34	44.17	900839.0
2007-03-01	ACAT-DELISTED	Stock	18.88	18.99	18.49	18.88	26039.0
2007-03-01	ACC-DELISTED	Stock	30.1	31.08	29.77	30.71	134451.0

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

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