PREVIEW / stock_daily / 2006-03-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-09.parquet
  size:    145 KB
  rows:    4,346
  symbols: 2,745

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-09	AAPL	Stock	2.3564	2.3739	2.2789	2.2832	799304800.0
2006-03-09	MSFT	Stock	27.27	27.42	27.0	27.0	45360700.0
2006-03-09	NVDA	Stock	0.4047	0.4114	0.4017	0.4019	536700000.0
2006-03-09	AMZN	Stock	1.84	1.848	1.795	1.806	144002000.0
2006-03-09	CL	Stock	28.125	28.835	28.01	28.64	8716800.0
2006-03-09	A	Stock	26.2804	26.3162	25.8727	25.9013	4092785.0
2006-03-09	AABA-DELISTED	Stock	31.0499992370605	31.3199996948242	30.25	30.2800006866455	18277000.0
2006-03-09	AACC-DELISTED	Stock	19.57	19.86	19.36	19.59	72048.0
2006-03-09	AACQW-DELISTED	Stock	0.65	0.65	0.65	0.65	1000.0
2006-03-09	AAI-DELISTED	Stock	17.29	17.36	16.8	16.97	823700.0
2006-03-09	AAIC-DELISTED	Stock	179.8	182.4	179.2	180.0	1625900.0
2006-03-09	AAME	Stock	2.71	2.89	2.52	2.87	20800.0
2006-03-09	AAON	Stock	2.8629	2.8866	2.8576	2.8721	116944.0
2006-03-09	AAP	Stock	42.45	42.45	41.6	41.87	2104600.0
2006-03-09	AATI-DELISTED	Stock	12.73	12.87	12.67	12.7	311298.0
2006-03-09	AAU-DELISTED	Stock	2.72	2.79	2.6	2.6	36732.0
2006-03-09	AAUAF-DELISTED	Stock	2.68	2.75	2.6	2.6	37300.0
2006-03-09	AAV-DELISTED	Stock	18.6	18.93	18.32	18.32	281200.0
2006-03-09	AAWW-DELISTED	Stock	44.25	44.5	43.5	44.5	311100.0
2006-03-09	AAXN-DELISTED	Stock	9.38000011444092	9.75	9.35999965667725	9.44999980926514	1160800.0
2006-03-09	AB	Stock	63.44	64.18	62.43	62.6	160800.0
2006-03-09	ABAX-DELISTED	Stock	20.43	20.98	20.02	20.1	306703.0
2006-03-09	ABB-DELISTED	Stock	11.7	11.75	11.61	11.65	2235700.0
2006-03-09	ABBC-DELISTED	Stock	13.27	13.3	13.25	13.3	2900.0
2006-03-09	ABC-DELISTED	Stock	22.86	23.12	22.8	22.99	2384600.0
2006-03-09	ABCB	Stock	20.6491	20.9507	20.4255	20.4352	16142.0
2006-03-09	ABCO-DELISTED	Stock	26.95	27.17	26.65	26.86	219464.0
2006-03-09	ABCW-DELISTED	Stock	29.77	29.79	29.3	29.32	25010.0
2006-03-09	ABD-DELISTED	Stock	22.28	22.42	22.16	22.23	89040.0
2006-03-09	ABE-DELISTED	Stock	12.36	12.65	12.36	12.639	32900.0
2006-03-09	ABFS-DELISTED	Stock	41.56	41.88	41.0	41.08	313904.0
2006-03-09	ABG	Stock	19.7	19.7	19.4	19.48	66500.0
2006-03-09	ABK-DELISTED	Stock	77.6	78.15	77.31	77.41	748800.0
2006-03-09	ABM	Stock	18.66	18.95	18.58	18.71	105200.0
2006-03-09	ABMD-DELISTED	Stock	10.74	10.77	10.39	10.51	62986.0
2006-03-09	ABP-DELISTED	Stock	5.63	5.79	5.5	5.54	298200.0
2006-03-09	ABR	Stock	26.66	27.0	26.65	26.85	51700.0
2006-03-09	ABT	Stock	20.8617	20.9049	20.6314	20.7226	13240517.0
2006-03-09	ABTL-DELISTED	Stock	20.3	20.9	20.3	20.45	39310.0
2006-03-09	ABV-DELISTED	Stock	42.15	42.37	41.04	41.42	608800.0
2006-03-09	ABX-DELISTED	Stock	26.77	26.84	25.51	25.68	5577800.0
2006-03-09	ACAD	Stock	14.59	14.96	14.55	14.83	407900.0
2006-03-09	ACAP-DELISTED	Stock	46.71	48.02	46.66	48.02	34592.0
2006-03-09	ACAS-DELISTED	Stock	35.0	35.26	34.93	35.22	741386.0
2006-03-09	ACAT-DELISTED	Stock	23.61	23.61	23.15	23.15	31514.0
2006-03-09	ACC-DELISTED	Stock	27.27	27.3699	26.33	26.5	49900.0
2006-03-09	ACCL-DELISTED	Stock	6.8	6.95	6.74	6.75	93537.0
2006-03-09	ACCO	Stock	22.31	22.45	22.19	22.2	90600.0
2006-03-09	ACCP-DELISTED	Stock	1.85	1.85	1.35	1.35	25000.0
2006-03-09	ACE-DELISTED	Stock	55.0	55.06	54.0	54.06	934900.0

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

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