PREVIEW / stock_daily / 2007-06-04

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-04.parquet
  size:    177 KB
  rows:    5,417
  symbols: 3,250

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-06-04	AAPL	Stock	4.2368	4.3475	4.2107	4.3332	886673200.0
2007-06-04	MSFT	Stock	30.42	30.76	30.4	30.72	41434500.0
2007-06-04	NVDA	Stock	0.576	0.5878	0.5737	0.5845	322002000.0
2007-06-04	AMZN	Stock	3.4125	3.5325	3.3825	3.521	227610000.0
2007-06-04	TLT	Stock	85.83	86.02	85.67	85.98	877700.0
2007-06-04	CL	Stock	33.55	33.69	33.435	33.635	3051600.0
2007-06-04	A	Stock	27.1817	27.6323	27.1745	27.5322	2229950.0
2007-06-04	AABA-DELISTED	Stock	28.6	28.78	28.4	28.57	13163218.0
2007-06-04	AACC-DELISTED	Stock	19.05	19.11	19.0	19.07	78465.0
2007-06-04	AAI-DELISTED	Stock	12.39	12.41	12.05	12.16	1432660.0
2007-06-04	AAIC-DELISTED	Stock	126.6	129.2	124.8	129.0	2607000.0
2007-06-04	AAME	Stock	4.88	5.0	4.76	4.96	14500.0
2007-06-04	AAON	Stock	3.944	3.9506	3.8861	3.9506	232369.0
2007-06-04	AAP	Stock	41.56	42.05	41.47	41.98	723700.0
2007-06-04	AATI-DELISTED	Stock	9.08	9.29	9.08	9.24	619070.0
2007-06-04	AAU-DELISTED	Stock	2.38	2.52	2.32	2.48	114500.0
2007-06-04	AAUAF-DELISTED	Stock	2.38	2.52	2.32	2.48	114500.0
2007-06-04	AAV-DELISTED	Stock	12.74	13.02	12.66	13.0	934500.0
2007-06-04	AAWW-DELISTED	Stock	58.79	59.27	58.06	58.3	138253.0
2007-06-04	AAXN-DELISTED	Stock	10.55	10.59	10.31	10.48	1650747.0
2007-06-04	AB	Stock	92.08	92.08	91.28	91.81	116100.0
2007-06-04	ABAX-DELISTED	Stock	23.4	23.65	23.21	23.3	253267.0
2007-06-04	ABB-DELISTED	Stock	21.83	22.0	21.82	22.0	1201830.0
2007-06-04	ABBC-DELISTED	Stock	18.22	18.32	17.982	18.24	5898.0
2007-06-04	ABBNY-DELISTED	Stock	21.83	22.0	21.82	22.0	1202030.0
2007-06-04	ABC-DELISTED	Stock	25.61	25.73	25.5	25.68	1491000.0
2007-06-04	ABCB	Stock	22.6723	23.4309	22.6723	23.1099	32592.0
2007-06-04	ABCO-DELISTED	Stock	26.26	26.62	26.09	26.41	318493.0
2007-06-04	ABCW-DELISTED	Stock	28.42	28.65	28.31	28.5	48050.0
2007-06-04	ABD-DELISTED	Stock	25.13	25.39	25.08	25.38	279360.0
2007-06-04	ABE-DELISTED	Stock	22.01	22.17	21.9	22.0396	37100.0
2007-06-04	ABEO	Stock	6125.0	6525.0	6125.0	6525.0	1.0
2007-06-04	ABFS-DELISTED	Stock	41.0	41.1	40.24	40.24	628043.0
2007-06-04	ABG	Stock	27.23	27.68	27.2	27.5	277200.0
2007-06-04	ABK-DELISTED	Stock	89.86	89.94	88.76	89.12	1044400.0
2007-06-04	ABM	Stock	29.86	30.25	29.79	30.13	218000.0
2007-06-04	ABMD-DELISTED	Stock	11.99	12.23	11.79	11.82	201419.0
2007-06-04	ABP-DELISTED	Stock	3.99	4.02	3.92	3.92	148000.0
2007-06-04	ABR	Stock	28.84	29.21	28.73	29.05	161300.0
2007-06-04	ABT	Stock	26.6385	26.9456	26.4754	26.6865	14597749.0
2007-06-04	ABTL-DELISTED	Stock	21.75	21.9	21.3	21.5	14222.0
2007-06-04	ABV-DELISTED	Stock	70.39	70.72	69.82	70.05	301340.0
2007-06-04	ABVA-DELISTED	Stock	14.24	14.75	14.24	14.64	14266.0
2007-06-04	ABVT-DELISTED	Stock	55.0	61.0	55.0	61.0	380.0
2007-06-04	ABX-DELISTED	Stock	29.45	29.51	28.98	29.21	7488875.0
2007-06-04	ACAD	Stock	12.6	12.73	12.55	12.58	166700.0
2007-06-04	ACAP-DELISTED	Stock	41.8	41.9099	41.16	41.41	50522.0
2007-06-04	ACAS-DELISTED	Stock	48.84	48.84	48.01	48.25	782776.0
2007-06-04	ACAT-DELISTED	Stock	19.19	19.72	19.19	19.3	76807.0
2007-06-04	ACC-DELISTED	Stock	29.6	30.0	29.51	29.71	342300.0

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

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