PREVIEW / stock_daily / 2006-01-06

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-06.parquet
  size:    145 KB
  rows:    4,323
  symbols: 2,729

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-06	AAPL	Stock	2.6875	2.7393	2.6625	2.725	704457600.0
2006-01-06	MSFT	Stock	26.89	27.0	26.49	26.91	100963000.0
2006-01-06	NVDA	Stock	0.3387	0.3416	0.3254	0.3403	623388000.0
2006-01-06	AMZN	Stock	2.3985	2.429	2.366	2.3935	123058000.0
2006-01-06	CL	Stock	27.425	27.535	27.29	27.41	3814000.0
2006-01-06	A	Stock	24.6781	24.8856	24.3848	24.7854	6146307.0
2006-01-06	AABA-DELISTED	Stock	42.8800010681152	43.5699996948242	42.7999992370605	43.2099990844727	29418400.0
2006-01-06	AACC-DELISTED	Stock	22.75	23.0	22.41	22.41	75164.0
2006-01-06	AACQW-DELISTED	Stock	0.54	0.54	0.54	0.54	10000.0
2006-01-06	AAI-DELISTED	Stock	16.5	16.85	16.18	16.78	1069300.0
2006-01-06	AAIC-DELISTED	Stock	212.2	215.4	211.4	214.4	909100.0
2006-01-06	AAME	Stock	2.66	2.66	2.66	2.66	1000.0
2006-01-06	AAON	Stock	2.3835	2.4033	2.3835	2.3835	53916.0
2006-01-06	AAP	Stock	44.05	44.14	43.76	43.99	1078200.0
2006-01-06	AATI-DELISTED	Stock	13.92	14.0	13.55	13.7	73657.0
2006-01-06	AAU-DELISTED	Stock	2.35	2.61	2.34	2.58	240300.0
2006-01-06	AAUAF-DELISTED	Stock	2.35	2.61	2.34	2.58	240300.0
2006-01-06	AAV-DELISTED	Stock	18.73	18.77	18.6	18.7	194700.0
2006-01-06	AAWW-DELISTED	Stock	44.5	44.7	44.0	44.25	87700.0
2006-01-06	AAXN-DELISTED	Stock	7.59000015258789	7.6399998664856	7.5	7.57000017166138	2584600.0
2006-01-06	ABAX-DELISTED	Stock	17.66	17.8	17.52	17.74	128570.0
2006-01-06	ABB-DELISTED	Stock	10.71	10.72	10.59	10.65	1697100.0
2006-01-06	ABBC-DELISTED	Stock	13.3	13.5	13.3	13.473	9652.0
2006-01-06	ABC-DELISTED	Stock	20.8	20.82	20.4	20.5	3411800.0
2006-01-06	ABCB	Stock	19.482	19.6862	19.3555	19.6182	7403.0
2006-01-06	ABCO-DELISTED	Stock	23.73	23.74	23.42	23.52	261560.0
2006-01-06	ABCW-DELISTED	Stock	31.4	31.59	31.09	31.41	29560.0
2006-01-06	ABD-DELISTED	Stock	24.13	24.28	23.87	24.26	213150.0
2006-01-06	ABE-DELISTED	Stock	12.43	12.56	12.37	12.55	58600.0
2006-01-06	ABFS-DELISTED	Stock	44.72	45.04	44.29	44.68	266231.0
2006-01-06	ABG	Stock	16.67	17.08	16.67	16.67	14400.0
2006-01-06	ABK-DELISTED	Stock	78.38	79.57	78.38	79.4	513500.0
2006-01-06	ABM	Stock	19.89	20.0	19.84	19.99	138700.0
2006-01-06	ABMD-DELISTED	Stock	9.74	9.8	9.44	9.77	42697.0
2006-01-06	ABP-DELISTED	Stock	5.82	6.03	5.82	5.96	543100.0
2006-01-06	ABR	Stock	26.65	26.73	26.15	26.59	152300.0
2006-01-06	ABT	Stock	19.2208	19.6622	19.0145	19.619	13729262.0
2006-01-06	ABTL-DELISTED	Stock	25.18	25.42	24.93	25.32	35550.0
2006-01-06	ABV-DELISTED	Stock	41.95	42.26	40.8	40.93	596100.0
2006-01-06	ABVA-DELISTED	Stock	16.25	16.389	16.25	16.389	51302.0
2006-01-06	ABX-DELISTED	Stock	29.46	30.09	29.46	30.05	4907961.0
2006-01-06	ACAD	Stock	10.07	10.75	9.97	10.46	238900.0
2006-01-06	ACAP-DELISTED	Stock	46.28	48.14	46.28	47.9	73071.0
2006-01-06	ACAS-DELISTED	Stock	35.37	35.94	35.3	35.84	3177948.0
2006-01-06	ACAT-DELISTED	Stock	21.91	22.39	21.56	22.22	41677.0
2006-01-06	ACC-DELISTED	Stock	24.83	25.5	24.75	25.43	68900.0
2006-01-06	ACCL-DELISTED	Stock	7.56	7.8	7.51	7.78	78788.0
2006-01-06	ACCO	Stock	24.15	24.31	23.89	24.24	226500.0
2006-01-06	ACE-DELISTED	Stock	55.59	56.19	55.38	56.01	715400.0
2006-01-06	ACF-DELISTED	Stock	25.74	26.03	25.58	25.94	884200.0

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

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