PREVIEW / stock_daily / 2007-06-15

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-15.parquet
  size:    177 KB
  rows:    5,394
  symbols: 3,235

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-15	AAPL	Stock	4.3079	4.3096	4.2807	4.3036	811218800.0
2007-06-15	MSFT	Stock	30.86	30.88	30.43	30.49	100933000.0
2007-06-15	NVDA	Stock	0.6377	0.6642	0.6375	0.6592	1081998000.0
2007-06-15	AMZN	Stock	3.6425	3.6435	3.5595	3.62	196664000.0
2007-06-15	TLT	Stock	83.42	83.73	83.2	83.69	5827200.0
2007-06-15	CL	Stock	33.485	33.61	33.19	33.315	6199800.0
2007-06-15	A	Stock	27.8827	27.897	27.4678	27.6967	3917196.0
2007-06-15	AABA-DELISTED	Stock	27.49	27.52	27.19	27.3	21990009.0
2007-06-15	AACC-DELISTED	Stock	17.4	17.48	17.09	17.19	228116.0
2007-06-15	AAI-DELISTED	Stock	11.44	11.5	11.21	11.27	1755300.0
2007-06-15	AAIC-DELISTED	Stock	130.0	130.0	125.6	128.2	3133100.0
2007-06-15	AAME	Stock	3.9	4.21	3.9	4.05	26700.0
2007-06-15	AAON	Stock	3.8795	3.8979	3.8189	3.8387	463219.0
2007-06-15	AAP	Stock	41.19	41.26	40.83	41.0	612700.0
2007-06-15	AATI-DELISTED	Stock	9.6	9.6	9.35	9.56	550148.0
2007-06-15	AAU-DELISTED	Stock	2.26	2.3	2.26	2.3	39200.0
2007-06-15	AAUAF-DELISTED	Stock	2.26	2.3	2.26	2.3	39200.0
2007-06-15	AAV-DELISTED	Stock	13.37	13.54	13.3	13.48	834200.0
2007-06-15	AAWW-DELISTED	Stock	57.84	58.99	57.29	58.26	204955.0
2007-06-15	AAXN-DELISTED	Stock	12.54	12.664	12.2	12.28	2821665.0
2007-06-15	AB	Stock	90.5	90.96	84.26	88.3	2800100.0
2007-06-15	ABAX-DELISTED	Stock	23.16	23.18	22.61	22.73	283457.0
2007-06-15	ABB-DELISTED	Stock	22.34	22.39	22.16	22.23	2353300.0
2007-06-15	ABBC-DELISTED	Stock	17.5	17.6	17.31	17.6	36097.0
2007-06-15	ABBNY-DELISTED	Stock	22.34	22.39	22.16	22.25	2467500.0
2007-06-15	ABC-DELISTED	Stock	25.58	25.75	25.14	25.22	3552400.0
2007-06-15	ABCB	Stock	22.9738	22.9738	21.8941	22.1373	90578.0
2007-06-15	ABCO-DELISTED	Stock	27.08	27.43	26.85	27.19	490392.0
2007-06-15	ABCW-DELISTED	Stock	27.88	28.25	27.46	27.79	261390.0
2007-06-15	ABD-DELISTED	Stock	25.4	25.5	24.87	24.88	380100.0
2007-06-15	ABE-DELISTED	Stock	21.72	22.0	21.56	21.8	34400.0
2007-06-15	ABEO	Stock	6425.0	6500.0	6375.0	6500.0	9.0
2007-06-15	ABFS-DELISTED	Stock	40.35	40.75	39.74	39.89	628878.0
2007-06-15	ABG	Stock	24.41	24.81	24.36	24.68	322300.0
2007-06-15	ABK-DELISTED	Stock	88.39	88.99	87.4	88.5	1230100.0
2007-06-15	ABM	Stock	27.16	27.24	26.5	26.54	342200.0
2007-06-15	ABMD-DELISTED	Stock	11.42	11.91	11.3	11.91	348737.0
2007-06-15	ABP-DELISTED	Stock	4.11	4.24	4.11	4.17	346800.0
2007-06-15	ABR	Stock	27.6	27.63	27.36	27.63	947300.0
2007-06-15	ABT	Stock	26.1347	26.413	26.0292	26.2547	13195915.0
2007-06-15	ABTL-DELISTED	Stock	21.85	21.9	21.4	21.6	20528.0
2007-06-15	ABV-DELISTED	Stock	74.04	75.16	74.04	74.88	460400.0
2007-06-15	ABVA-DELISTED	Stock	13.83	14.05	13.83	13.87	36000.0
2007-06-15	ABX-DELISTED	Stock	28.63	29.21	28.56	29.11	6383611.0
2007-06-15	ACAD	Stock	15.24	15.34	15.0	15.12	912300.0
2007-06-15	ACAP-DELISTED	Stock	42.48	42.55	41.79	42.08	85653.0
2007-06-15	ACAS-DELISTED	Stock	45.23	46.12	45.23	46.12	1510576.0
2007-06-15	ACAT-DELISTED	Stock	19.71	19.89	19.41	19.69	112374.0
2007-06-15	ACC-DELISTED	Stock	29.41	29.52	28.74	28.84	286468.0
2007-06-15	ACCL-DELISTED	Stock	6.24	6.25	6.07	6.14	204514.0

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

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