PREVIEW / stock_daily / 2006-03-28

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-28.parquet
  size:    147 KB
  rows:    4,388
  symbols: 2,783

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-28	AAPL	Stock	2.1296	2.1479	2.0804	2.0968	1370322800.0
2006-03-28	MSFT	Stock	27.01	27.21	26.81	26.9	58520500.0
2006-03-28	NVDA	Stock	0.4426	0.4573	0.4417	0.4514	795204000.0
2006-03-28	AMZN	Stock	1.7605	1.801	1.76	1.7845	114544000.0
2006-03-28	CL	Stock	29.0	29.0	28.55	28.605	4380400.0
2006-03-28	A	Stock	26.216	26.2732	25.9013	25.9442	2805227.0
2006-03-28	AABA-DELISTED	Stock	31.4500007629395	32.5	31.4099998474121	32.3899993896484	25981500.0
2006-03-28	AACC-DELISTED	Stock	19.36	19.48	19.3	19.42	362630.0
2006-03-28	AAI-DELISTED	Stock	17.69	18.24	17.56	17.71	1443100.0
2006-03-28	AAIC-DELISTED	Stock	189.6	192.8	189.0	192.2	1369800.0
2006-03-28	AAME	Stock	2.79	2.97	2.79	2.93	3600.0
2006-03-28	AAON	Stock	3.0262	3.0512	3.0038	3.0249	157950.0
2006-03-28	AAP	Stock	41.8	41.8	41.21	41.28	548600.0
2006-03-28	AATI-DELISTED	Stock	10.66	10.76	10.62	10.66	379452.0
2006-03-28	AAU-DELISTED	Stock	2.75	2.79	2.7	2.73	62500.0
2006-03-28	AAUAF-DELISTED	Stock	2.75	2.79	2.7	2.73	62500.0
2006-03-28	AAV-DELISTED	Stock	19.6	19.64	19.5	19.55	217700.0
2006-03-28	AAWW-DELISTED	Stock	47.38	47.38	46.5	46.5	57000.0
2006-03-28	AAXN-DELISTED	Stock	10.5100002288818	10.75	10.4099998474121	10.5500001907349	1581600.0
2006-03-28	AB	Stock	64.35	64.72	63.9	64.09	192400.0
2006-03-28	ABAX-DELISTED	Stock	24.7	24.74	23.5	23.85	400275.0
2006-03-28	ABB-DELISTED	Stock	12.2	12.33	12.1	12.11	1763000.0
2006-03-28	ABBC-DELISTED	Stock	13.32	13.32	13.32	13.32	4360.0
2006-03-28	ABC-DELISTED	Stock	23.51	23.865	23.37	23.86	2001349.0
2006-03-28	ABCB	Stock	21.6413	21.6413	21.155	21.223	37218.0
2006-03-28	ABCO-DELISTED	Stock	27.4	27.5	27.11	27.19	229296.0
2006-03-28	ABCW-DELISTED	Stock	29.78	29.92	29.4	29.5	24690.0
2006-03-28	ABD-DELISTED	Stock	22.04	22.2	21.92	21.97	338310.0
2006-03-28	ABE-DELISTED	Stock	12.7	12.7	12.46	12.46	24700.0
2006-03-28	ABFS-DELISTED	Stock	41.25	41.25	40.39	40.58	420443.0
2006-03-28	ABG	Stock	20.12	20.4	19.77	20.1	63900.0
2006-03-28	ABK-DELISTED	Stock	79.0	79.81	78.94	79.45	887600.0
2006-03-28	ABM	Stock	17.5	17.86	17.5	17.61	180000.0
2006-03-28	ABMD-DELISTED	Stock	13.13	13.17	12.5	12.85	151570.0
2006-03-28	ABP-DELISTED	Stock	5.9	6.05	5.9	5.99	305600.0
2006-03-28	ABR	Stock	27.1	27.2	26.94	26.99	116400.0
2006-03-28	ABT	Stock	20.7418	20.8137	20.5306	20.6122	12479575.0
2006-03-28	ABTL-DELISTED	Stock	23.28	23.77	23.28	23.62	145963.0
2006-03-28	ABV-DELISTED	Stock	40.55	41.09	39.95	40.14	288500.0
2006-03-28	ABVA-DELISTED	Stock	19.004	19.09	18.817	18.856	20036.0
2006-03-28	ABVT-DELISTED	Stock	38.0	41.0	38.0	39.0	600.0
2006-03-28	ABX-DELISTED	Stock	26.74	26.74	25.93	26.03	3913400.0
2006-03-28	ACAD	Stock	14.84	14.98	14.59	14.9	555900.0
2006-03-28	ACAP-DELISTED	Stock	48.15	48.18	47.23	47.37	41007.0
2006-03-28	ACAS-DELISTED	Stock	35.52	35.53	35.05	35.21	918748.0
2006-03-28	ACAT-DELISTED	Stock	24.08	24.1	23.78	23.95	83301.0
2006-03-28	ACC-DELISTED	Stock	25.7	25.82	25.06	25.31	78800.0
2006-03-28	ACCL-DELISTED	Stock	7.32	7.38	7.22	7.34	60649.0
2006-03-28	ACCO	Stock	22.05	22.21	21.93	21.96	344200.0
2006-03-28	ACCP-DELISTED	Stock	1.5	1.6	1.5	1.5	28875.0

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

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