PREVIEW / stock_daily / 2006-03-06

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-06.parquet
  size:    147 KB
  rows:    4,360
  symbols: 2,755

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-03-06	AAPL	Stock	2.4175	2.4186	2.3193	2.3386	912665600.0
2006-03-06	MSFT	Stock	26.92	27.15	26.83	26.91	53054100.0
2006-03-06	NVDA	Stock	0.4177	0.4204	0.4068	0.4088	529020000.0
2006-03-06	AMZN	Stock	1.866	1.879	1.8385	1.843	85166000.0
2006-03-06	CL	Stock	27.365	27.49	27.06	27.15	2400800.0
2006-03-06	A	Stock	25.8941	25.9943	25.6652	25.8798	2164943.0
2006-03-06	AABA-DELISTED	Stock	31.5300006866455	31.9400005340576	31.4500007629395	31.5699996948242	17211200.0
2006-03-06	AACC-DELISTED	Stock	19.82	19.92	19.49	19.64	115410.0
2006-03-06	AACQU-DELISTED	Stock	6.6	6.6	6.6	6.6	2000.0
2006-03-06	AAI-DELISTED	Stock	17.5	18.0	17.1	17.35	954700.0
2006-03-06	AAIC-DELISTED	Stock	186.6	195.8	186.2	188.0	1814900.0
2006-03-06	AAME	Stock	2.71	3.0	2.71	3.0	9800.0
2006-03-06	AAON	Stock	2.8049	2.876	2.7694	2.8418	135928.0
2006-03-06	AAP	Stock	42.46	42.48	41.8	42.41	1065300.0
2006-03-06	AATI-DELISTED	Stock	12.41	12.75	12.35	12.73	774636.0
2006-03-06	AAU-DELISTED	Stock	2.85	2.91	2.66	2.78	78600.0
2006-03-06	AAUAF-DELISTED	Stock	2.85	2.91	2.66	2.78	78600.0
2006-03-06	AAV-DELISTED	Stock	19.19	19.19	18.74	18.8	591700.0
2006-03-06	AAXN-DELISTED	Stock	9.80000019073486	10.0500001907349	9.80000019073486	9.90999984741211	1577100.0
2006-03-06	AB	Stock	63.5	63.9	63.43	63.7	256100.0
2006-03-06	ABAX-DELISTED	Stock	22.99	23.26	22.01	22.23	231769.0
2006-03-06	ABB-DELISTED	Stock	12.35	12.39	12.14	12.19	2381800.0
2006-03-06	ABBC-DELISTED	Stock	13.316	13.37	13.316	13.34	7594.0
2006-03-06	ABC-DELISTED	Stock	22.75	22.8	22.46	22.58	1665800.0
2006-03-06	ABCB	Stock	21.3398	21.4468	21.1161	21.2036	18609.0
2006-03-06	ABCO-DELISTED	Stock	27.77	27.77	27.0	27.09	152862.0
2006-03-06	ABCW-DELISTED	Stock	30.32	30.33	29.92	29.92	80250.0
2006-03-06	ABD-DELISTED	Stock	22.96	23.1	22.66	22.96	156800.0
2006-03-06	ABE-DELISTED	Stock	13.24	13.73	13.19	13.21	62800.0
2006-03-06	ABFS-DELISTED	Stock	42.1	42.18	41.27	41.51	488629.0
2006-03-06	ABG	Stock	18.47	19.82	18.47	19.6	68600.0
2006-03-06	ABK-DELISTED	Stock	75.45	76.16	75.29	75.53	559700.0
2006-03-06	ABM	Stock	18.45	18.87	18.45	18.77	106700.0
2006-03-06	ABMD-DELISTED	Stock	10.61	10.8	10.59	10.66	114952.0
2006-03-06	ABP-DELISTED	Stock	6.09	6.2	5.6	5.72	680500.0
2006-03-06	ABR	Stock	25.7	26.83	25.7	26.55	48500.0
2006-03-06	ABT	Stock	21.0152	21.1736	20.9001	20.9577	7061276.0
2006-03-06	ABTL-DELISTED	Stock	22.32	22.37	21.33	21.63	42148.0
2006-03-06	ABV-DELISTED	Stock	43.2	43.75	42.91	43.01	417700.0
2006-03-06	ABVA-DELISTED	Stock	18.967	18.991	18.857	18.983	5000.0
2006-03-06	ABX-DELISTED	Stock	28.04	28.12	27.05	27.52	3678630.0
2006-03-06	ACAD	Stock	15.22	15.67	14.96	14.99	447400.0
2006-03-06	ACAP-DELISTED	Stock	48.78	49.48	48.61	49.35	23902.0
2006-03-06	ACAS-DELISTED	Stock	35.92	35.99	35.53	35.6	763277.0
2006-03-06	ACAT-DELISTED	Stock	24.35	24.35	24.01	24.08	142848.0
2006-03-06	ACC-DELISTED	Stock	25.28	25.85	25.17	25.8	62100.0
2006-03-06	ACCL-DELISTED	Stock	6.75	6.77	6.62	6.73	74301.0
2006-03-06	ACCO	Stock	22.96	23.1	22.66	22.96	159100.0
2006-03-06	ACCP-DELISTED	Stock	1.15	2.05	1.1	1.95	584716.0
2006-03-06	ACE-DELISTED	Stock	55.3	55.5	54.39	54.52	849500.0

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

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