PREVIEW / stock_daily / 2007-04-03

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-03.parquet
  size:    163 KB
  rows:    4,898
  symbols: 3,081

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-04-03	AAPL	Stock	3.3621	3.4011	3.3486	3.375	583934400.0
2007-04-03	MSFT	Stock	27.86	28.06	27.75	27.87	39821300.0
2007-04-03	NVDA	Stock	0.4792	0.4845	0.4728	0.4773	473724000.0
2007-04-03	AMZN	Stock	2.021	2.069	2.02	2.0595	119364000.0
2007-04-03	TLT	Stock	88.02	88.17	87.98	87.99	617000.0
2007-04-03	CL	Stock	33.225	33.285	32.96	33.01	3891200.0
2007-04-03	A	Stock	24.3634	24.8069	24.3205	24.7139	4456125.0
2007-04-03	AABA-DELISTED	Stock	31.4099998474121	32.0	31.4099998474121	31.7199993133545	12324600.0
2007-04-03	AACC-DELISTED	Stock	15.41	15.61	15.4	15.56	82670.0
2007-04-03	AACQ-DELISTED	Stock	4.34	4.34	4.3	4.34	50350.0
2007-04-03	AACQU-DELISTED	Stock	5.45	5.45	5.42	5.42	1000.0
2007-04-03	AACQW-DELISTED	Stock	0.59	0.59	0.57	0.57	11500.0
2007-04-03	AAI-DELISTED	Stock	10.53	10.9	10.48	10.81	3060600.0
2007-04-03	AAIC-DELISTED	Stock	111.4	113.0	110.0	111.4	2446300.0
2007-04-03	AAME	Stock	4.2	4.3	4.15	4.24	20500.0
2007-04-03	AAON	Stock	3.4305	3.4305	3.358	3.3738	132131.0
2007-04-03	AAP	Stock	38.92	39.37	38.84	39.0	837500.0
2007-04-03	AATI-DELISTED	Stock	6.56	6.77	6.47	6.68	502754.0
2007-04-03	AAU-DELISTED	Stock	2.16	2.4204	2.16	2.37	196734.0
2007-04-03	AAUAF-DELISTED	Stock	2.14	2.4	2.14	2.35	198400.0
2007-04-03	AAV-DELISTED	Stock	10.32	10.36	10.22	10.34	445942.0
2007-04-03	AAWW-DELISTED	Stock	53.84	55.41	53.81	55.32	137239.0
2007-04-03	AAXN-DELISTED	Stock	7.90000009536743	8.26000022888184	7.80000019073486	8.19999980926514	3976100.0
2007-04-03	AB	Stock	88.49	90.07	88.12	89.75	233600.0
2007-04-03	ABAX-DELISTED	Stock	24.68	24.79	24.5	24.65	193826.0
2007-04-03	ABB-DELISTED	Stock	17.5	17.7	17.49	17.59	3338100.0
2007-04-03	ABBC-DELISTED	Stock	19.99	20.39	19.99	20.13	10071.0
2007-04-03	ABC-DELISTED	Stock	26.74	27.12	26.69	26.96	2155400.0
2007-04-03	ABCB	Stock	24.1702	24.5106	24.0048	24.034	45957.0
2007-04-03	ABCO-DELISTED	Stock	25.44	25.73	25.37	25.63	188003.0
2007-04-03	ABCW-DELISTED	Stock	28.17	28.58	28.08	28.38	31380.0
2007-04-03	ABD-DELISTED	Stock	24.36	24.7	24.25	24.7	579930.0
2007-04-03	ABE-DELISTED	Stock	19.17	19.5	19.17	19.43	16900.0
2007-04-03	ABFS-DELISTED	Stock	35.43	36.15	35.36	36.14	627054.0
2007-04-03	ABG	Stock	28.38	28.75	28.33	28.7	343100.0
2007-04-03	ABK-DELISTED	Stock	86.25	87.23	86.25	86.58	493714.0
2007-04-03	ABM	Stock	26.45	26.45	26.36	26.38	307100.0
2007-04-03	ABMD-DELISTED	Stock	13.48	13.85	13.31	13.41	261654.0
2007-04-03	ABP-DELISTED	Stock	3.15	3.19	3.1	3.12	146600.0
2007-04-03	ABR	Stock	30.45	30.45	29.87	29.95	115000.0
2007-04-03	ABT	Stock	26.8736	27.2239	26.8592	27.1903	15136932.0
2007-04-03	ABTL-DELISTED	Stock	17.125	17.974	17.125	17.725	45646.0
2007-04-03	ABV-DELISTED	Stock	55.24	56.86	55.24	56.73	516200.0
2007-04-03	ABVA-DELISTED	Stock	15.29	15.38	14.57	14.9	11182.0
2007-04-03	ABX-DELISTED	Stock	28.72	29.25	28.7	29.09	4140000.0
2007-04-03	ACAD	Stock	14.72	16.55	14.72	16.41	1758900.0
2007-04-03	ACAP-DELISTED	Stock	40.09	40.34	39.27	39.39	61100.0
2007-04-03	ACAS-DELISTED	Stock	44.9	45.52	44.86	45.46	2510735.0
2007-04-03	ACAT-DELISTED	Stock	19.6	19.6	19.27	19.34	48200.0
2007-04-03	ACC-DELISTED	Stock	30.68	30.9	30.46	30.69	200800.0

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

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