PREVIEW / stock_daily / 2007-01-11

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-11.parquet
  size:    161 KB
  rows:    4,821
  symbols: 3,030

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-01-11	AAPL	Stock	3.4264	3.4564	3.3964	3.4214	1440252800.0
2007-01-11	MSFT	Stock	29.76	30.75	29.65	30.7	99464300.0
2007-01-11	NVDA	Stock	0.5815	0.586	0.5698	0.5793	924504000.0
2007-01-11	AMZN	Stock	1.8585	1.9	1.8585	1.87	129312000.0
2007-01-11	TLT	Stock	88.79	88.8	88.26	88.45	1302500.0
2007-01-11	CL	Stock	33.02	33.225	32.92	33.15	2874600.0
2007-01-11	A	Stock	24.1989	24.3491	23.8555	24.1059	2919443.0
2007-01-11	AABA-DELISTED	Stock	28.7600002288818	29.3700008392334	28.7000007629395	29.2000007629395	28457500.0
2007-01-11	AACC-DELISTED	Stock	15.93	16.53	15.93	16.43	60385.0
2007-01-11	AACQ-DELISTED	Stock	5.45	5.58	5.45	5.58	409950.0
2007-01-11	AACQU-DELISTED	Stock	6.75	6.9	6.65	6.9	7500.0
2007-01-11	AACQW-DELISTED	Stock	0.55	0.69	0.55	0.68	228500.0
2007-01-11	AAI-DELISTED	Stock	11.94	12.39	11.92	12.39	2656500.0
2007-01-11	AAIC-DELISTED	Stock	167.4	167.8	164.2	165.0	894800.0
2007-01-11	AAME	Stock	3.74	3.75	3.1	3.18	23700.0
2007-01-11	AAON	Stock	3.5108	3.5806	3.5016	3.5806	82772.0
2007-01-11	AAP	Stock	35.62	36.47	35.62	36.4	575700.0
2007-01-11	AATI-DELISTED	Stock	5.37	5.58	5.37	5.52	749249.0
2007-01-11	AAU-DELISTED	Stock	2.23	2.3299	2.22	2.24	16700.0
2007-01-11	AAUAF-DELISTED	Stock	2.23	2.3299	2.22	2.24	16700.0
2007-01-11	AAV-DELISTED	Stock	10.12	10.49	10.12	10.2	443700.0
2007-01-11	AAWW-DELISTED	Stock	46.27	47.5	46.27	46.95	195526.0
2007-01-11	AAXN-DELISTED	Stock	8.34000015258789	8.39999961853027	8.14999961853027	8.22000026702881	1149700.0
2007-01-11	AB	Stock	84.6	87.05	84.48	86.86	365600.0
2007-01-11	ABAX-DELISTED	Stock	18.96	19.25	18.91	19.11	57583.0
2007-01-11	ABB-DELISTED	Stock	17.07	17.31	17.07	17.22	1861800.0
2007-01-11	ABBC-DELISTED	Stock	19.2	19.2	19.04	19.14	10614.0
2007-01-11	ABC-DELISTED	Stock	23.3	23.8	23.28	23.62	2344000.0
2007-01-11	ABCB	Stock	27.7203	27.9343	27.2243	27.623	15113.0
2007-01-11	ABCO-DELISTED	Stock	26.89	27.12	26.72	26.81	245241.0
2007-01-11	ABCW-DELISTED	Stock	28.93	29.09	28.73	28.95	88440.0
2007-01-11	ABD-DELISTED	Stock	25.98	26.12	25.79	25.97	120800.0
2007-01-11	ABE-DELISTED	Stock	16.81	17.46	16.81	17.45	32600.0
2007-01-11	ABFS-DELISTED	Stock	38.96	39.4	38.71	39.03	337001.0
2007-01-11	ABG	Stock	23.16	23.61	23.04	23.54	204100.0
2007-01-11	ABK-DELISTED	Stock	87.99	88.72	87.73	88.34	477800.0
2007-01-11	ABM	Stock	23.53	24.42	23.5	23.98	456100.0
2007-01-11	ABMD-DELISTED	Stock	13.8	14.29	13.8	14.28	135001.0
2007-01-11	ABP-DELISTED	Stock	3.18	3.23	3.12	3.14	153500.0
2007-01-11	ABR	Stock	30.08	30.7	30.02	30.5	72200.0
2007-01-11	ABT	Stock	24.2011	24.4602	24.0716	24.1579	12554189.0
2007-01-11	ABTL-DELISTED	Stock	16.95	17.15	16.8	17.1	14245.0
2007-01-11	ABV-DELISTED	Stock	48.18	49.13	48.07	49.0	290700.0
2007-01-11	ABVA-DELISTED	Stock	16.16	16.29	16.16	16.29	2117.0
2007-01-11	ABVT-DELISTED	Stock	59.0	59.0	59.0	59.0	170.0
2007-01-11	ABX-DELISTED	Stock	28.98	29.41	28.75	28.84	4171600.0
2007-01-11	ACAD	Stock	7.75	7.98	7.72	7.79	158400.0
2007-01-11	ACAP-DELISTED	Stock	38.99	39.05	38.55	39.0	28242.0
2007-01-11	ACAS-DELISTED	Stock	46.82	47.25	46.73	47.17	1028219.0
2007-01-11	ACAT-DELISTED	Stock	16.96	17.26	16.96	17.25	68727.0

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

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