PREVIEW / stock_daily / 2006-08-15

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-15.parquet
  size:    148 KB
  rows:    4,470
  symbols: 2,818

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-08-15	AAPL	Stock	2.3336	2.375	2.3143	2.3732	861352800.0
2006-08-15	MSFT	Stock	24.55	24.65	24.44	24.62	48994500.0
2006-08-15	NVDA	Stock	0.398	0.4275	0.3942	0.4253	902172000.0
2006-08-15	AMZN	Stock	1.3485	1.393	1.331	1.3885	164032000.0
2006-08-15	CL	Stock	30.15	30.225	29.955	30.05	3008400.0
2006-08-15	A	Stock	22.0959	22.7825	21.9599	22.2604	8751200.0
2006-08-15	AABA-DELISTED	Stock	27.5799999237061	28.2000007629395	27.4799995422363	28.1700000762939	15298500.0
2006-08-15	AACC-DELISTED	Stock	15.65	15.68	15.15	15.48	175022.0
2006-08-15	AACQ-DELISTED	Stock	5.35	5.35	5.35	5.35	1500.0
2006-08-15	AACQW-DELISTED	Stock	0.37	0.42	0.35	0.42	50000.0
2006-08-15	AAI-DELISTED	Stock	11.22	11.31	11.1	11.23	1095700.0
2006-08-15	AAIC-DELISTED	Stock	182.4	187.4	180.4	184.2	1009700.0
2006-08-15	AAME	Stock	2.76	2.76	2.7	2.7	3700.0
2006-08-15	AAON	Stock	2.984	3.067	2.9458	3.0644	88847.0
2006-08-15	AAP	Stock	29.46	29.5	29.05	29.1	757000.0
2006-08-15	AATI-DELISTED	Stock	9.19	9.51	9.11	9.5	135918.0
2006-08-15	AAU-DELISTED	Stock	2.56	2.5699	2.5	2.53	30100.0
2006-08-15	AAUAF-DELISTED	Stock	2.56	2.5699	2.5	2.53	30100.0
2006-08-15	AAV-DELISTED	Stock	16.01	16.14	15.93	15.93	374800.0
2006-08-15	AAWW-DELISTED	Stock	40.3	40.4	38.7	39.04	167230.0
2006-08-15	AAXN-DELISTED	Stock	7.09000015258789	7.1399998664856	7.01000022888184	7.1399998664856	510800.0
2006-08-15	AB	Stock	68.0	68.99	67.61	68.47	444400.0
2006-08-15	ABAX-DELISTED	Stock	22.06	22.98	21.98	22.98	161368.0
2006-08-15	ABB-DELISTED	Stock	13.2	13.26	13.1299	13.232	4528900.0
2006-08-15	ABBC-DELISTED	Stock	14.78	14.78	14.66	14.75	4767.0
2006-08-15	ABC-DELISTED	Stock	21.86	21.86	21.73	21.74	2318800.0
2006-08-15	ABCB	Stock	26.0668	26.5824	25.8431	25.8723	49144.0
2006-08-15	ABCO-DELISTED	Stock	24.94	25.36	24.65	25.31	301953.0
2006-08-15	ABCW-DELISTED	Stock	28.9	29.35	28.69	28.82	72990.0
2006-08-15	ABD-DELISTED	Stock	18.45	18.65	18.42	18.51	443940.0
2006-08-15	ABE-DELISTED	Stock	13.4	13.84	13.4	13.68	11400.0
2006-08-15	ABFS-DELISTED	Stock	42.6	44.4	42.6	44.15	210817.0
2006-08-15	ABG	Stock	20.5	20.6	20.33	20.48	89600.0
2006-08-15	ABK-DELISTED	Stock	83.5	83.73	83.22	83.45	745500.0
2006-08-15	ABM	Stock	16.66	16.97	16.5	16.96	118200.0
2006-08-15	ABMD-DELISTED	Stock	13.32	13.73	13.28	13.7	136296.0
2006-08-15	ABP-DELISTED	Stock	3.92	4.04	3.87	4.01	231200.0
2006-08-15	ABR	Stock	24.65	24.95	24.65	24.85	99000.0
2006-08-15	ABT	Stock	23.1983	23.3615	23.1216	23.3471	9519591.0
2006-08-15	ABTL-DELISTED	Stock	14.95	15.15	14.45	14.75	22109.0
2006-08-15	ABV-DELISTED	Stock	41.65	42.42	41.28	42.2	435900.0
2006-08-15	ABVA-DELISTED	Stock	16.52	16.7	16.52	16.7	1755.0
2006-08-15	ABX-DELISTED	Stock	30.53	31.1	30.53	31.01	2613900.0
2006-08-15	ACAD	Stock	5.78	6.35	5.74	6.32	655600.0
2006-08-15	ACAP-DELISTED	Stock	47.68	48.35	47.56	47.79	22412.0
2006-08-15	ACAS-DELISTED	Stock	37.5	37.85	37.34	37.72	1337873.0
2006-08-15	ACAT-DELISTED	Stock	17.7	18.019	17.521	17.88	33889.0
2006-08-15	ACC-DELISTED	Stock	25.0	25.15	24.9	25.08	78900.0
2006-08-15	ACCL-DELISTED	Stock	6.24	6.3	6.2	6.2	26586.0
2006-08-15	ACCO	Stock	18.45	18.65	18.42	18.51	447000.0

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

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