PREVIEW / stock_daily / 2006-04-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-07.parquet
  size:    147 KB
  rows:    4,381
  symbols: 2,764

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-04-07	AAPL	Stock	2.5332	2.5432	2.4454	2.4925	1545238800.0
2006-04-07	MSFT	Stock	27.61	27.72	27.23	27.25	47249400.0
2006-04-07	NVDA	Stock	0.508	0.5125	0.4988	0.5088	682674000.0
2006-04-07	AMZN	Stock	1.9275	1.9335	1.85	1.8545	114090000.0
2006-04-07	CL	Stock	29.015	29.055	28.735	28.775	3163800.0
2006-04-07	A	Stock	27.4535	27.5393	26.9313	27.0815	3174718.0
2006-04-07	AABA-DELISTED	Stock	32.8499984741211	32.9700012207031	32.2099990844727	32.2700004577637	12980200.0
2006-04-07	AACC-DELISTED	Stock	19.8	20.0	19.71	19.72	154895.0
2006-04-07	AACQW-DELISTED	Stock	0.73	0.73	0.69	0.69	95500.0
2006-04-07	AAI-DELISTED	Stock	17.45	17.54	17.14	17.26	1052400.0
2006-04-07	AAIC-DELISTED	Stock	181.6	183.0	181.0	181.4	791800.0
2006-04-07	AAME	Stock	3.0	3.09	3.0	3.09	10200.0
2006-04-07	AAON	Stock	3.2698	3.2843	3.1737	3.2145	310584.0
2006-04-07	AAP	Stock	41.17	41.66	40.83	41.02	575600.0
2006-04-07	AATI-DELISTED	Stock	11.28	11.32	11.1172	11.26	412979.0
2006-04-07	AAU-DELISTED	Stock	3.08	3.09	2.95	3.06	77600.0
2006-04-07	AAUAF-DELISTED	Stock	3.08	3.09	2.95	3.06	77600.0
2006-04-07	AAV-DELISTED	Stock	19.17	19.29	19.01	19.04	210700.0
2006-04-07	AAWW-DELISTED	Stock	45.0	46.0	45.0	46.0	157500.0
2006-04-07	AAXN-DELISTED	Stock	11.0699996948242	11.1400003433228	10.5699996948242	10.6800003051758	2980600.0
2006-04-07	AB	Stock	68.28	68.5	67.6	68.02	137700.0
2006-04-07	ABAX-DELISTED	Stock	24.13	24.49	23.536	23.82	387712.0
2006-04-07	ABB-DELISTED	Stock	13.11	13.22	12.87	13.03	2215100.0
2006-04-07	ABBC-DELISTED	Stock	13.53	13.54	13.5	13.52	39722.0
2006-04-07	ABC-DELISTED	Stock	23.72	23.85	23.0	23.02	3729800.0
2006-04-07	ABCB	Stock	22.4097	22.5459	21.6316	21.7483	10178.0
2006-04-07	ABCO-DELISTED	Stock	27.99	28.39	27.36	27.4	148902.0
2006-04-07	ABCW-DELISTED	Stock	29.92	29.99	28.92	29.05	59510.0
2006-04-07	ABD-DELISTED	Stock	23.35	23.36	22.79	22.84	127000.0
2006-04-07	ABE-DELISTED	Stock	13.06	13.23	12.94	13.1	62800.0
2006-04-07	ABFS-DELISTED	Stock	41.38	41.68	40.63	40.88	179073.0
2006-04-07	ABG	Stock	19.1	19.27	18.5	18.67	117700.0
2006-04-07	ABK-DELISTED	Stock	79.0	79.02	77.66	77.69	495600.0
2006-04-07	ABM	Stock	18.4	18.42	17.77	17.86	238000.0
2006-04-07	ABMD-DELISTED	Stock	13.84	13.98	13.6	13.64	98063.0
2006-04-07	ABP-DELISTED	Stock	5.44	5.44	5.21	5.23	553800.0
2006-04-07	ABR	Stock	26.62	26.75	26.0	26.06	122700.0
2006-04-07	ABT	Stock	20.569	20.6266	20.1756	20.1948	7422259.0
2006-04-07	ABTL-DELISTED	Stock	23.8	23.9	23.15	23.15	34049.0
2006-04-07	ABV-DELISTED	Stock	46.1	46.1	44.79	45.35	659500.0
2006-04-07	ABVA-DELISTED	Stock	18.921	18.946	18.839	18.839	3160.0
2006-04-07	ABX-DELISTED	Stock	29.58	29.73	29.19	29.29	6694000.0
2006-04-07	ACAD	Stock	15.76	15.79	15.22	15.24	257000.0
2006-04-07	ACAP-DELISTED	Stock	47.16	47.39	46.75	46.85	32080.0
2006-04-07	ACAS-DELISTED	Stock	35.22	35.25	34.82	34.93	872712.0
2006-04-07	ACAT-DELISTED	Stock	23.1	23.37	22.7	22.71	88062.0
2006-04-07	ACC-DELISTED	Stock	24.88	25.06	23.97	24.0	57100.0
2006-04-07	ACCL-DELISTED	Stock	7.4	7.41	7.2	7.21	67419.0
2006-04-07	ACCO	Stock	23.35	23.36	22.79	22.84	132700.0
2006-04-07	ACCP-DELISTED	Stock	1.1	1.5	1.1	1.5	18890.0

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

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