PREVIEW / stock_daily / 2006-01-31

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-31.parquet
  size:    146 KB
  rows:    4,354
  symbols: 2,763

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-31	AAPL	Stock	2.6964	2.7264	2.6339	2.6968	913542000.0
2006-01-31	MSFT	Stock	27.91	28.38	27.87	28.15	94841300.0
2006-01-31	NVDA	Stock	0.3792	0.3812	0.3717	0.3747	384456000.0
2006-01-31	AMZN	Stock	2.238	2.2605	2.2125	2.241	81120000.0
2006-01-31	CL	Stock	27.5	27.59	27.22	27.445	7559200.0
2006-01-31	A	Stock	24.4993	24.5494	24.2561	24.2561	4088311.0
2006-01-31	AABA-DELISTED	Stock	35.2000007629395	35.2000007629395	34.310001373291	34.3800010681152	36538000.0
2006-01-31	AACC-DELISTED	Stock	24.89	24.89	24.26	24.26	88154.0
2006-01-31	AAI-DELISTED	Stock	16.95	17.0	16.71	16.9474	2511200.0
2006-01-31	AAIC-DELISTED	Stock	238.0	239.8	231.4	231.6	1188700.0
2006-01-31	AAME	Stock	2.65	2.65	2.65	2.65	2500.0
2006-01-31	AAON	Stock	2.5047	2.5468	2.5034	2.5284	211106.0
2006-01-31	AAP	Stock	42.8	43.7	42.79	43.57	782000.0
2006-01-31	AATI-DELISTED	Stock	14.9	15.21	14.55	14.9	170557.0
2006-01-31	AAU-DELISTED	Stock	3.11	3.11	2.72	2.85	122500.0
2006-01-31	AAUAF-DELISTED	Stock	3.11	3.11	2.72	2.85	122500.0
2006-01-31	AAV-DELISTED	Stock	20.81	20.97	20.75	20.92	467200.0
2006-01-31	AAWW-DELISTED	Stock	46.9	48.25	46.9	48.0	9600.0
2006-01-31	AAXN-DELISTED	Stock	9.4399995803833	9.57999992370605	9.0600004196167	9.4399995803833	1875000.0
2006-01-31	ABAX-DELISTED	Stock	20.585	20.8	19.29	19.9	500821.0
2006-01-31	ABB-DELISTED	Stock	10.83	10.94	10.79	10.93	1833600.0
2006-01-31	ABBC-DELISTED	Stock	13.2	13.53	13.2	13.45	57994.0
2006-01-31	ABC-DELISTED	Stock	21.95	22.01	21.74	21.84	3413400.0
2006-01-31	ABCB	Stock	19.9683	20.1823	19.9683	19.978	9356.0
2006-01-31	ABCO-DELISTED	Stock	24.37	25.02	24.37	24.98	677687.0
2006-01-31	ABCW-DELISTED	Stock	31.08	31.58	30.95	31.1	57800.0
2006-01-31	ABD-DELISTED	Stock	24.9	24.9	24.32	24.7	820810.0
2006-01-31	ABE-DELISTED	Stock	12.88	12.9	12.81	12.9	17700.0
2006-01-31	ABFS-DELISTED	Stock	43.37	43.64	42.49	42.78	532173.0
2006-01-31	ABG	Stock	17.8	18.13	17.6	18.0	55000.0
2006-01-31	ABK-DELISTED	Stock	76.78	77.18	76.44	76.71	712400.0
2006-01-31	ABM	Stock	19.0	19.24	18.93	19.11	150400.0
2006-01-31	ABMD-DELISTED	Stock	10.88	11.01	10.55	10.91	105806.0
2006-01-31	ABP-DELISTED	Stock	6.98	7.0	6.8	6.93	722000.0
2006-01-31	ABR	Stock	26.27	26.32	26.09	26.27	87400.0
2006-01-31	ABT	Stock	20.2716	20.7178	20.1516	20.7034	13321801.0
2006-01-31	ABTL-DELISTED	Stock	24.25	24.5	23.8	24.2	30326.0
2006-01-31	ABV-DELISTED	Stock	40.9	41.4	40.63	40.96	1741800.0
2006-01-31	ABVA-DELISTED	Stock	16.51	16.88	16.51	16.8	10400.0
2006-01-31	ABX-DELISTED	Stock	30.45	32.14	30.42	31.45	9287400.0
2006-01-31	ACAD	Stock	12.97	13.49	12.89	13.05	9334000.0
2006-01-31	ACAP-DELISTED	Stock	49.0	49.14	48.12	48.85	31418.0
2006-01-31	ACAS-DELISTED	Stock	35.55	35.68	35.33	35.55	1231846.0
2006-01-31	ACAT-DELISTED	Stock	23.51	24.0	23.03	23.25	86891.0
2006-01-31	ACC-DELISTED	Stock	24.77	24.89	24.73	24.78	67668.0
2006-01-31	ACCL-DELISTED	Stock	6.49	6.92	6.49	6.79	41793.0
2006-01-31	ACCO	Stock	24.9	24.9	24.32	24.7	867400.0
2006-01-31	ACE-DELISTED	Stock	54.83	55.07	54.47	54.72	1820282.0
2006-01-31	ACER-DELISTED	Stock	2000.0	2000.0	1000.0	1666.66662597656	200.0
2006-01-31	ACF-DELISTED	Stock	28.7	28.89	28.58	28.78	1426600.0

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

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