PREVIEW / stock_daily / 2006-11-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-27.parquet
  size:    155 KB
  rows:    4,620
  symbols: 2,924

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-11-27	AAPL	Stock	3.3039	3.3271	3.1964	3.1979	1074836000.0
2006-11-27	MSFT	Stock	29.69	29.74	29.33	29.48	72722100.0
2006-11-27	NVDA	Stock	0.6127	0.6208	0.5843	0.5885	585294000.0
2006-11-27	AMZN	Stock	2.109	2.14	2.036	2.0425	179456000.0
2006-11-27	CL	Stock	32.815	32.86	32.37	32.505	4282600.0
2006-11-27	A	Stock	23.927	23.9342	23.2117	23.3262	3723573.0
2006-11-27	AABA-DELISTED	Stock	27.5	28.5	27.1700000762939	27.2700004577637	19922300.0
2006-11-27	AACC-DELISTED	Stock	17.29	17.33	16.55	16.57	90716.0
2006-11-27	AACQ-DELISTED	Stock	5.48	5.48	5.45	5.47	27500.0
2006-11-27	AACQU-DELISTED	Stock	6.68	6.68	6.6	6.6	3700.0
2006-11-27	AACQW-DELISTED	Stock	0.63	0.64	0.6	0.62	52200.0
2006-11-27	AAI-DELISTED	Stock	13.31	13.34	12.62	12.72	2012700.0
2006-11-27	AAIC-DELISTED	Stock	149.4	149.4	144.0	145.2	1744100.0
2006-11-27	AAME	Stock	2.8	2.89	2.79	2.81	8200.0
2006-11-27	AAON	Stock	3.6214	3.6517	3.387	3.4041	236166.0
2006-11-27	AAP	Stock	37.88	37.88	36.8	36.84	703900.0
2006-11-27	AATI-DELISTED	Stock	5.63	5.646	5.41	5.48	274377.0
2006-11-27	AAU-DELISTED	Stock	2.7	2.7094	2.59	2.64	107300.0
2006-11-27	AAUAF-DELISTED	Stock	2.7	2.7094	2.59	2.64	107300.0
2006-11-27	AAV-DELISTED	Stock	12.7	12.81	12.59	12.75	962000.0
2006-11-27	AAWW-DELISTED	Stock	40.07	40.52	39.75	40.03	142419.0
2006-11-27	AAXN-DELISTED	Stock	8.86999988555908	8.86999988555908	8.5	8.55000019073486	934800.0
2006-11-27	AB	Stock	76.91	76.91	74.29	74.91	321200.0
2006-11-27	ABAX-DELISTED	Stock	19.88	20.12	19.49	19.82	152042.0
2006-11-27	ABB-DELISTED	Stock	16.04	16.0501	15.67	15.7201	2107200.0
2006-11-27	ABBC-DELISTED	Stock	15.8717	15.944	15.6	15.6	8444.0
2006-11-27	ABC-DELISTED	Stock	22.54	22.65	22.4	22.48	3363600.0
2006-11-27	ABCB	Stock	27.0783	27.4285	25.5805	26.5628	49864.0
2006-11-27	ABCO-DELISTED	Stock	28.29	28.6	27.83	28.05	2199867.0
2006-11-27	ABCW-DELISTED	Stock	28.72	28.73	28.36	28.45	49550.0
2006-11-27	ABD-DELISTED	Stock	25.31	25.41	24.63	25.0	271040.0
2006-11-27	ABE-DELISTED	Stock	17.18	17.2	16.28	16.6	76800.0
2006-11-27	ABFS-DELISTED	Stock	38.92	38.99	38.5	38.5	273437.0
2006-11-27	ABG	Stock	23.25	23.73	23.08	23.59	404700.0
2006-11-27	ABK-DELISTED	Stock	83.7	83.85	83.29	83.66	890300.0
2006-11-27	ABM	Stock	20.73	20.73	20.2	20.31	112700.0
2006-11-27	ABMD-DELISTED	Stock	12.78	12.815	12.3	12.34	127216.0
2006-11-27	ABP-DELISTED	Stock	3.74	3.77	3.65	3.73	104900.0
2006-11-27	ABR	Stock	28.68	28.71	28.2	28.49	91300.0
2006-11-27	ABT	Stock	22.4019	22.493	22.1764	22.2579	10822009.0
2006-11-27	ABTL-DELISTED	Stock	15.724	15.724	14.626	14.626	28564.0
2006-11-27	ABV-DELISTED	Stock	46.56	46.6	45.0	45.32	515800.0
2006-11-27	ABVA-DELISTED	Stock	16.4	16.4	16.1	16.15	21669.0
2006-11-27	ABX-DELISTED	Stock	29.9	29.99	29.63	29.72	5381500.0
2006-11-27	ACAD	Stock	9.21	9.3	8.99	9.04	155100.0
2006-11-27	ACAP-DELISTED	Stock	40.09	40.09	37.82	37.83	36933.0
2006-11-27	ACAS-DELISTED	Stock	44.99	45.04	43.87	43.88	871126.0
2006-11-27	ACAT-DELISTED	Stock	17.37	17.42	16.94	16.95	126000.0
2006-11-27	ACC-DELISTED	Stock	28.54	28.67	28.05	28.12	142200.0
2006-11-27	ACCL-DELISTED	Stock	6.3	6.36	6.15	6.21	52517.0

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

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