PREVIEW / stock_daily / 2006-10-16

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-16.parquet
  size:    152 KB
  rows:    4,544
  symbols: 2,869

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-10-16	AAPL	Stock	2.6854	2.71	2.6711	2.6929	508692800.0
2006-10-16	MSFT	Stock	28.48	28.6	28.33	28.45	49744800.0
2006-10-16	NVDA	Stock	0.5647	0.5738	0.5518	0.5618	478968000.0
2006-10-16	AMZN	Stock	1.6425	1.66	1.6275	1.63	135388000.0
2006-10-16	CL	Stock	30.2	30.235	29.995	30.045	6898600.0
2006-10-16	A	Stock	24.6781	24.7711	24.4635	24.5494	2612582.0
2006-10-16	AABA-DELISTED	Stock	24.3400001525879	24.5200004577637	23.75	24.1800003051758	36496400.0
2006-10-16	AACC-DELISTED	Stock	17.63	17.65	17.27	17.53	153512.0
2006-10-16	AACQ-DELISTED	Stock	5.35	5.36	5.35	5.35	2700.0
2006-10-16	AACQU-DELISTED	Stock	6.06	6.06	6.03	6.03	4000.0
2006-10-16	AACQW-DELISTED	Stock	0.36	0.37	0.36	0.36	110000.0
2006-10-16	AAI-DELISTED	Stock	10.62	10.9	10.52	10.58	2231600.0
2006-10-16	AAIC-DELISTED	Stock	162.6	166.4	162.6	165.4	682000.0
2006-10-16	AAME	Stock	2.58	2.6	2.58	2.6	2700.0
2006-10-16	AAON	Stock	3.1684	3.1802	3.1486	3.1592	142762.0
2006-10-16	AAP	Stock	35.5	35.67	35.26	35.54	814000.0
2006-10-16	AATI-DELISTED	Stock	5.38	5.75	5.35	5.58	1080281.0
2006-10-16	AAU-DELISTED	Stock	2.45	2.49	2.4	2.42	72200.0
2006-10-16	AAUAF-DELISTED	Stock	2.45	2.49	2.4	2.42	72200.0
2006-10-16	AAV-DELISTED	Stock	12.54	13.21	12.45	13.14	1166400.0
2006-10-16	AAWW-DELISTED	Stock	48.75	50.21	46.64	47.49	650140.0
2006-10-16	AAXN-DELISTED	Stock	9.60000038146973	9.97999954223633	9.43000030517578	9.6899995803833	1692400.0
2006-10-16	AB	Stock	75.84	76.75	74.92	76.27	730400.0
2006-10-16	ABAX-DELISTED	Stock	22.2	22.78	22.12	22.51	288341.0
2006-10-16	ABB-DELISTED	Stock	13.89	14.19	13.89	14.16	4234400.0
2006-10-16	ABBC-DELISTED	Stock	15.6	15.75	15.567	15.75	8174.0
2006-10-16	ABC-DELISTED	Stock	23.08	23.14	23.0	23.01	2100600.0
2006-10-16	ABCB	Stock	27.7203	27.7203	27.3701	27.4576	26526.0
2006-10-16	ABCO-DELISTED	Stock	27.51	27.9	27.47	27.88	54642.0
2006-10-16	ABCW-DELISTED	Stock	29.24	29.52	29.15	29.47	36590.0
2006-10-16	ABD-DELISTED	Stock	23.12	23.49	23.04	23.14	144700.0
2006-10-16	ABE-DELISTED	Stock	14.6	14.6	14.48	14.5801	31800.0
2006-10-16	ABFS-DELISTED	Stock	48.95	49.66	48.71	49.43	246345.0
2006-10-16	ABG	Stock	22.98	23.16	22.56	22.69	508900.0
2006-10-16	ABK-DELISTED	Stock	84.46	85.27	84.46	85.22	390900.0
2006-10-16	ABM	Stock	19.54	19.88	19.54	19.7	126600.0
2006-10-16	ABMD-DELISTED	Stock	13.38	14.29	13.37	14.07	132017.0
2006-10-16	ABP-DELISTED	Stock	3.58	3.7	3.58	3.65	200700.0
2006-10-16	ABR	Stock	27.1	27.4	27.04	27.17	51300.0
2006-10-16	ABT	Stock	22.4546	22.7281	22.4402	22.6322	8887662.0
2006-10-16	ABTL-DELISTED	Stock	15.849	16.401	15.799	16.351	56455.0
2006-10-16	ABV-DELISTED	Stock	46.85	46.88	46.34	46.45	176800.0
2006-10-16	ABVA-DELISTED	Stock	16.75	16.99	16.75	16.99	3010.0
2006-10-16	ABX-DELISTED	Stock	30.2	30.27	29.43	30.21	5675900.0
2006-10-16	ACAD	Stock	10.18	10.19	9.9	10.01	228800.0
2006-10-16	ACAP-DELISTED	Stock	51.0	51.82	50.54	51.78	21905.0
2006-10-16	ACAS-DELISTED	Stock	41.8	42.05	41.8	41.98	731700.0
2006-10-16	ACAT-DELISTED	Stock	17.11	17.27	16.98	17.04	52667.0
2006-10-16	ACC-DELISTED	Stock	26.38	26.81	26.38	26.67	82591.0
2006-10-16	ACCL-DELISTED	Stock	6.22	6.29	6.14	6.14	32915.0

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

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