PREVIEW / stock_daily / 2007-04-02

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-02.parquet
  size:    162 KB
  rows:    4,880
  symbols: 3,066

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-02	AAPL	Stock	3.3621	3.3661	3.3221	3.3446	501992400.0
2007-04-02	MSFT	Stock	27.89	27.93	27.56	27.74	41977600.0
2007-04-02	NVDA	Stock	0.4785	0.4825	0.4713	0.4792	400830000.0
2007-04-02	AMZN	Stock	1.9925	2.0235	1.9775	2.021	141826000.0
2007-04-02	TLT	Stock	88.11	88.22	88.01	88.1	579520.0
2007-04-02	CL	Stock	33.355	33.51	32.985	33.03	4609200.0
2007-04-02	A	Stock	24.0558	24.3205	23.9557	24.2918	3137112.0
2007-04-02	AABA-DELISTED	Stock	31.2199993133545	31.3999996185303	30.9300003051758	31.2800006866455	8668800.0
2007-04-02	AACC-DELISTED	Stock	15.5	15.6	15.4	15.41	66808.0
2007-04-02	AACQU-DELISTED	Stock	5.45	5.45	5.45	5.45	400.0
2007-04-02	AACQW-DELISTED	Stock	0.57	0.57	0.57	0.57	12600.0
2007-04-02	AAI-DELISTED	Stock	10.35	10.53	10.18	10.4	1801300.0
2007-04-02	AAIC-DELISTED	Stock	110.4	111.8	108.4	110.6	1602600.0
2007-04-02	AAME	Stock	4.0	4.13	3.8	4.13	18300.0
2007-04-02	AAON	Stock	3.4357	3.4357	3.3791	3.4173	117703.0
2007-04-02	AAP	Stock	38.67	38.95	38.56	38.78	783800.0
2007-04-02	AATI-DELISTED	Stock	6.59	6.64	6.36	6.53	300022.0
2007-04-02	AAU-DELISTED	Stock	2.08	2.11	2.02	2.07	60600.0
2007-04-02	AAUAF-DELISTED	Stock	2.08	2.11	2.02	2.07	60600.0
2007-04-02	AAV-DELISTED	Stock	10.28	10.35	10.161	10.35	432900.0
2007-04-02	AAWW-DELISTED	Stock	52.73	53.81	52.73	53.69	129006.0
2007-04-02	AAXN-DELISTED	Stock	8.0	8.13000011444092	8.0	8.11999988555908	543200.0
2007-04-02	AB	Stock	88.5	88.68	87.56	88.48	213700.0
2007-04-02	ABAX-DELISTED	Stock	24.4	24.8	24.25	24.6	210671.0
2007-04-02	ABB-DELISTED	Stock	17.31	17.35	17.16	17.28	1534000.0
2007-04-02	ABBC-DELISTED	Stock	19.86	20.0	19.82	19.92	3339.0
2007-04-02	ABC-DELISTED	Stock	26.555	26.76	26.38	26.66	2428972.0
2007-04-02	ABCB	Stock	23.9075	24.0924	23.8784	24.0728	39994.0
2007-04-02	ABCO-DELISTED	Stock	25.31	25.55	25.05	25.36	187010.0
2007-04-02	ABCW-DELISTED	Stock	28.46	28.46	27.86	28.11	50210.0
2007-04-02	ABD-DELISTED	Stock	24.07	24.35	24.04	24.34	730100.0
2007-04-02	ABE-DELISTED	Stock	19.01	19.07	18.9101	19.01	22700.0
2007-04-02	ABFS-DELISTED	Stock	35.35	35.38	34.9	35.13	791693.0
2007-04-02	ABG	Stock	28.25	28.38	28.1	28.25	232200.0
2007-04-02	ABK-DELISTED	Stock	86.29	86.41	85.42	86.18	719400.0
2007-04-02	ABM	Stock	26.36	26.56	26.18	26.36	392000.0
2007-04-02	ABMD-DELISTED	Stock	13.68	13.68	13.32	13.45	228503.0
2007-04-02	ABP-DELISTED	Stock	3.21	3.21	3.16	3.16	90300.0
2007-04-02	ABR	Stock	30.42	30.45	29.98	30.24	77000.0
2007-04-02	ABT	Stock	26.7728	26.9888	26.4658	26.7776	13061067.0
2007-04-02	ABTL-DELISTED	Stock	17.751	17.751	16.948	17.199	30672.0
2007-04-02	ABV-DELISTED	Stock	55.15	55.38	54.52	55.33	474700.0
2007-04-02	ABVA-DELISTED	Stock	15.12	15.38	15.0	15.38	1400.0
2007-04-02	ABX-DELISTED	Stock	28.47	28.88	28.4	28.78	4255000.0
2007-04-02	ACAD	Stock	14.99	15.45	14.04	14.64	1231500.0
2007-04-02	ACAP-DELISTED	Stock	39.91	40.49	39.85	40.05	49264.0
2007-04-02	ACAS-DELISTED	Stock	44.58	44.83	44.1	44.83	1646113.0
2007-04-02	ACAT-DELISTED	Stock	19.61	19.61	19.4	19.54	31426.0
2007-04-02	ACC-DELISTED	Stock	30.4	30.54	30.12	30.49	170100.0
2007-04-02	ACCL-DELISTED	Stock	6.29	6.54	6.29	6.51	60045.0

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

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