PREVIEW / stock_daily / 2007-01-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-05.parquet
  size:    159 KB
  rows:    4,790
  symbols: 3,006

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-05	AAPL	Stock	3.0632	3.0786	3.0143	3.0375	834741600.0
2007-01-05	MSFT	Stock	29.63	29.75	29.45	29.64	44607200.0
2007-01-05	NVDA	Stock	0.5843	0.5867	0.557	0.561	1243344000.0
2007-01-05	AMZN	Stock	1.936	1.9395	1.88	1.9185	132394000.0
2007-01-05	TLT	Stock	89.4	89.4	88.75	89.22	1298400.0
2007-01-05	CL	Stock	32.875	32.95	32.67	32.73	3619200.0
2007-01-05	A	Stock	24.5351	24.6066	24.3205	24.3848	3741887.0
2007-01-05	AABA-DELISTED	Stock	26.7000007629395	27.8700008392334	26.6599998474121	27.7399997711182	64264600.0
2007-01-05	AACC-DELISTED	Stock	16.74	16.74	16.17	16.2	71880.0
2007-01-05	AACQ-DELISTED	Stock	5.45	5.48	5.45	5.48	40400.0
2007-01-05	AAI-DELISTED	Stock	11.79	11.85	11.43	11.48	1489200.0
2007-01-05	AAIC-DELISTED	Stock	161.6	161.6	158.6	160.0	1838700.0
2007-01-05	AAME	Stock	3.18	3.43	3.17	3.42	18600.0
2007-01-05	AAON	Stock	3.5266	3.5819	3.4449	3.4568	353869.0
2007-01-05	AAP	Stock	35.7	35.79	34.9	35.02	781500.0
2007-01-05	AATI-DELISTED	Stock	5.41	5.42	5.29	5.35	265388.0
2007-01-05	AAU-DELISTED	Stock	2.32	2.32	2.2551	2.275	85080.0
2007-01-05	AAUAF-DELISTED	Stock	2.32	2.32	2.26	2.2799	84900.0
2007-01-05	AAV-DELISTED	Stock	10.0	10.5	9.75	10.4015	1097700.0
2007-01-05	AAWW-DELISTED	Stock	45.08	45.74	44.661	45.16	169528.0
2007-01-05	AAXN-DELISTED	Stock	8.15999984741211	8.19999980926514	7.90000009536743	8.06999969482422	2018300.0
2007-01-05	AB	Stock	80.95	81.0	79.73	80.74	169900.0
2007-01-05	ABAX-DELISTED	Stock	19.47	19.55	19.23	19.45	158897.0
2007-01-05	ABB-DELISTED	Stock	16.97	16.99	16.84	16.92	3468600.0
2007-01-05	ABBC-DELISTED	Stock	19.22	19.22	19.01	19.1	6566.0
2007-01-05	ABC-DELISTED	Stock	23.06	23.2017	22.79	22.84	3082627.0
2007-01-05	ABCB	Stock	27.6133	27.6717	26.6212	27.1172	32797.0
2007-01-05	ABCO-DELISTED	Stock	27.15	27.22	26.55	26.88	200426.0
2007-01-05	ABCW-DELISTED	Stock	29.04	29.04	28.4	28.41	51380.0
2007-01-05	ABD-DELISTED	Stock	26.25	26.54	25.95	26.1	152320.0
2007-01-05	ABE-DELISTED	Stock	18.44	18.45	17.95	18.14	41700.0
2007-01-05	ABFS-DELISTED	Stock	40.65	40.66	39.19	39.75	752930.0
2007-01-05	ABG	Stock	23.25	23.48	23.0	23.43	268400.0
2007-01-05	ABK-DELISTED	Stock	89.38	89.38	87.79	88.17	654900.0
2007-01-05	ABM	Stock	23.6	23.62	22.93	23.07	429400.0
2007-01-05	ABMD-DELISTED	Stock	14.36	15.0	14.05	14.12	199047.0
2007-01-05	ABP-DELISTED	Stock	3.06	3.1	2.99	3.06	182300.0
2007-01-05	ABR	Stock	30.05	30.05	29.3	29.56	90300.0
2007-01-05	ABT	Stock	23.942	23.99	23.6397	23.942	14649854.0
2007-01-05	ABTL-DELISTED	Stock	18.576	18.827	17.923	18.224	24057.0
2007-01-05	ABV-DELISTED	Stock	49.18	49.18	47.46	47.83	438000.0
2007-01-05	ABVA-DELISTED	Stock	15.9	16.11	15.8	16.11	13821.0
2007-01-05	ABX-DELISTED	Stock	29.42	29.5	28.9	29.5	6059400.0
2007-01-05	ACAD	Stock	8.71	8.71	8.3	8.3	141500.0
2007-01-05	ACAP-DELISTED	Stock	39.54	39.54	37.85	37.97	50255.0
2007-01-05	ACAS-DELISTED	Stock	46.32	46.32	45.69	45.83	618294.0
2007-01-05	ACAT-DELISTED	Stock	17.145	17.23	16.68	16.83	139013.0
2007-01-05	ACC-DELISTED	Stock	29.39	29.44	28.87	28.91	103155.0
2007-01-05	ACCL-DELISTED	Stock	6.02	6.1	6.02	6.06	50584.0
2007-01-05	ACCO	Stock	26.25	26.54	25.95	26.1	179600.0

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

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