PREVIEW / stock_daily / 2006-04-06

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-06.parquet
  size:    148 KB
  rows:    4,376
  symbols: 2,757

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-06	AAPL	Stock	2.4393	2.5732	2.4357	2.5443	2663768800.0
2006-04-06	MSFT	Stock	27.66	27.72	27.37	27.56	51885500.0
2006-04-06	NVDA	Stock	0.5078	0.514	0.5008	0.5102	789312000.0
2006-04-06	AMZN	Stock	1.86	1.942	1.8565	1.9255	185892000.0
2006-04-06	CL	Stock	28.99	29.085	28.85	29.015	2677200.0
2006-04-06	A	Stock	27.289	27.5751	27.2532	27.5393	3291731.0
2006-04-06	AABA-DELISTED	Stock	32.1199989318848	33.1399993896484	32.1100006103516	32.7900009155273	21572600.0
2006-04-06	AACC-DELISTED	Stock	19.71	19.92	19.65	19.8403	114710.0
2006-04-06	AACQU-DELISTED	Stock	6.78	6.78	6.78	6.78	500.0
2006-04-06	AACQW-DELISTED	Stock	0.73	0.73	0.73	0.73	235.0
2006-04-06	AAI-DELISTED	Stock	17.9	17.91	17.3	17.39	1336900.0
2006-04-06	AAIC-DELISTED	Stock	182.0	184.0	181.0	181.4	1122100.0
2006-04-06	AAME	Stock	2.91	3.01	2.91	3.01	1100.0
2006-04-06	AAON	Stock	3.1421	3.2553	3.1289	3.2421	470812.0
2006-04-06	AAP	Stock	41.14	41.23	40.89	41.09	720800.0
2006-04-06	AATI-DELISTED	Stock	11.18	11.25	11.14	11.22	598743.0
2006-04-06	AAU-DELISTED	Stock	2.92	3.15	2.9	3.05	217300.0
2006-04-06	AAUAF-DELISTED	Stock	2.92	3.15	2.9	3.05	217300.0
2006-04-06	AAV-DELISTED	Stock	19.04	19.29	19.04	19.27	165500.0
2006-04-06	AAWW-DELISTED	Stock	44.0	46.0	44.0	46.0	207300.0
2006-04-06	AAXN-DELISTED	Stock	11.1000003814697	11.3800001144409	10.6800003051758	11.0200004577637	2063100.0
2006-04-06	AB	Stock	68.84	68.84	67.9	68.53	199300.0
2006-04-06	ABAX-DELISTED	Stock	23.85	24.2	23.71	24.05	336006.0
2006-04-06	ABB-DELISTED	Stock	12.84	12.93	12.73	12.88	3867400.0
2006-04-06	ABBC-DELISTED	Stock	13.4	13.56	13.4	13.54	30800.0
2006-04-06	ABC-DELISTED	Stock	24.2	24.22	23.58	23.65	2201000.0
2006-04-06	ABCB	Stock	22.0984	22.5166	22.0109	22.4972	5141.0
2006-04-06	ABCO-DELISTED	Stock	27.98	27.98	27.49	27.78	80708.0
2006-04-06	ABCW-DELISTED	Stock	29.8	29.85	29.55	29.76	39680.0
2006-04-06	ABD-DELISTED	Stock	22.4	23.47	22.4	23.46	647280.0
2006-04-06	ABE-DELISTED	Stock	13.13	13.33	13.05	13.05	51700.0
2006-04-06	ABFS-DELISTED	Stock	40.26	41.31	40.12	41.13	246394.0
2006-04-06	ABG	Stock	19.37	19.37	18.98	19.05	97600.0
2006-04-06	ABK-DELISTED	Stock	78.64	79.23	78.31	79.0	738000.0
2006-04-06	ABM	Stock	18.47	18.47	18.06	18.31	126500.0
2006-04-06	ABMD-DELISTED	Stock	13.31	13.96	13.28	13.74	144675.0
2006-04-06	ABP-DELISTED	Stock	5.42	5.54	5.4	5.47	480600.0
2006-04-06	ABR	Stock	26.65	26.79	26.53	26.59	77200.0
2006-04-06	ABT	Stock	20.4683	20.6218	20.4107	20.569	12706128.0
2006-04-06	ABTL-DELISTED	Stock	23.5	23.8	23.3	23.8	22845.0
2006-04-06	ABV-DELISTED	Stock	45.83	46.45	45.83	46.12	603200.0
2006-04-06	ABVA-DELISTED	Stock	18.823	18.823	18.757	18.777	1733.0
2006-04-06	ABX-DELISTED	Stock	29.27	29.91	29.16	29.69	6589500.0
2006-04-06	ACAD	Stock	16.19	16.19	15.7	15.8	247100.0
2006-04-06	ACAP-DELISTED	Stock	47.05	47.1	46.5	46.75	57294.0
2006-04-06	ACAS-DELISTED	Stock	35.47	35.47	35.08	35.09	1104416.0
2006-04-06	ACAT-DELISTED	Stock	23.31	23.34	22.82	23.05	80892.0
2006-04-06	ACC-DELISTED	Stock	25.07	25.21	24.78	24.82	61436.0
2006-04-06	ACCL-DELISTED	Stock	7.25	7.37	7.18	7.35	65326.0
2006-04-06	ACCO	Stock	22.4	23.48	22.4	23.46	648500.0

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

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