PREVIEW / stock_daily / 2006-01-24

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-24.parquet
  size:    146 KB
  rows:    4,341
  symbols: 2,748

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
2006-01-24	AAPL	Stock	2.8129	2.8364	2.7061	2.7157	1142254400.0
2006-01-24	MSFT	Stock	26.34	26.45	26.22	26.28	63040700.0
2006-01-24	NVDA	Stock	0.368	0.3767	0.367	0.369	388896000.0
2006-01-24	AMZN	Stock	2.183	2.2215	2.171	2.201	86848000.0
2006-01-24	CL	Stock	26.86	27.04	26.705	26.875	3732800.0
2006-01-24	A	Stock	24.4993	24.7139	24.4278	24.5494	2460760.0
2006-01-24	AABA-DELISTED	Stock	34.5499992370605	35.2000007629395	34.5099983215332	34.8699989318848	31667800.0
2006-01-24	AACC-DELISTED	Stock	23.2	23.89	23.2	23.63	45916.0
2006-01-24	AACQ-DELISTED	Stock	5.25	5.25	5.22	5.22	14000.0
2006-01-24	AACQU-DELISTED	Stock	6.5	6.5	6.5	6.5	3000.0
2006-01-24	AACQW-DELISTED	Stock	0.645	0.65	0.645	0.65	62100.0
2006-01-24	AAI-DELISTED	Stock	14.7	16.1	14.44	15.45	4843200.0
2006-01-24	AAIC-DELISTED	Stock	217.0	223.802	217.0	221.8	913800.0
2006-01-24	AAME	Stock	2.65	2.67	2.65	2.67	1000.0
2006-01-24	AAON	Stock	2.4678	2.5152	2.4573	2.5021	179212.0
2006-01-24	AAP	Stock	41.78	42.85	41.78	42.81	678700.0
2006-01-24	AATI-DELISTED	Stock	14.12	14.2	14.01	14.09	131759.0
2006-01-24	AAU-DELISTED	Stock	2.78	2.78	2.67	2.74	58100.0
2006-01-24	AAUAF-DELISTED	Stock	2.78	2.78	2.67	2.74	58100.0
2006-01-24	AAV-DELISTED	Stock	19.09	20.55	18.95	20.4	5011400.0
2006-01-24	AAWW-DELISTED	Stock	44.5	44.5	43.5	44.5	28600.0
2006-01-24	AAXN-DELISTED	Stock	8.10999965667725	9.0	8.10999965667725	8.77999973297119	3370600.0
2006-01-24	ABAX-DELISTED	Stock	18.22	18.84	17.86	18.6	295869.0
2006-01-24	ABB-DELISTED	Stock	10.52	10.54	10.37	10.4	5195100.0
2006-01-24	ABBC-DELISTED	Stock	13.07	13.18	13.068	13.1	6827.0
2006-01-24	ABC-DELISTED	Stock	20.52	20.93	20.5	20.85	2742000.0
2006-01-24	ABCB	Stock	19.696	19.91	19.5793	19.8322	19534.0
2006-01-24	ABCO-DELISTED	Stock	23.12	23.98	23.06	23.85	744276.0
2006-01-24	ABCW-DELISTED	Stock	31.52	31.93	31.22	31.88	28870.0
2006-01-24	ABD-DELISTED	Stock	23.93	24.08	23.78	24.02	228330.0
2006-01-24	ABE-DELISTED	Stock	12.5	12.84	12.5	12.84	29900.0
2006-01-24	ABFS-DELISTED	Stock	43.48	44.95	43.471	44.83	467634.0
2006-01-24	ABG	Stock	16.77	17.49	16.73	17.37	55700.0
2006-01-24	ABK-DELISTED	Stock	74.5	74.93	74.05	74.33	461800.0
2006-01-24	ABM	Stock	19.15	19.32	19.05	19.29	165900.0
2006-01-24	ABMD-DELISTED	Stock	10.37	10.7	10.37	10.6	32834.0
2006-01-24	ABP-DELISTED	Stock	6.38	6.66	6.27	6.65	647300.0
2006-01-24	ABR	Stock	26.33	26.6	26.02	26.35	54200.0
2006-01-24	ABT	Stock	19.4511	19.5519	19.1344	19.2208	6725511.0
2006-01-24	ABTL-DELISTED	Stock	25.53	25.63	25.07	25.32	44075.0
2006-01-24	ABV-DELISTED	Stock	40.57	40.8	40.4	40.65	485500.0
2006-01-24	ABVA-DELISTED	Stock	16.51	16.52	16.51	16.51	875.0
2006-01-24	ABX-DELISTED	Stock	29.7	29.86	29.17	29.86	5559061.0
2006-01-24	ACAD	Stock	9.95	10.09	9.6	10.09	37200.0
2006-01-24	ACAP-DELISTED	Stock	47.86	48.25	46.67	47.13	36311.0
2006-01-24	ACAS-DELISTED	Stock	34.79	35.0	34.71	34.81	699818.0
2006-01-24	ACAT-DELISTED	Stock	23.13	24.6999	22.9527	24.02	461933.0
2006-01-24	ACC-DELISTED	Stock	24.9	24.9	24.46	24.62	118200.0
2006-01-24	ACCL-DELISTED	Stock	6.4	6.65	6.24	6.54	148851.0
2006-01-24	ACCO	Stock	23.9	24.05	23.75	24.05	229400.0

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

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