PREVIEW / stock_daily / 2006-04-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-19.parquet
  size:    148 KB
  rows:    4,404
  symbols: 2,782

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-19	AAPL	Stock	2.3864	2.3929	2.3382	2.3446	1086033200.0
2006-04-19	MSFT	Stock	27.11	27.19	26.96	27.03	45111100.0
2006-04-19	NVDA	Stock	0.48	0.4913	0.4733	0.486	517476000.0
2006-04-19	AMZN	Stock	1.806	1.848	1.7945	1.8445	85610000.0
2006-04-19	CL	Stock	28.335	28.5	28.22	28.465	2424400.0
2006-04-19	A	Stock	27.1245	27.6824	27.1173	27.618	4215949.0
2006-04-19	AABA-DELISTED	Stock	33.4700012207031	33.9799995422363	32.7599983215332	33.5400009155273	77253600.0
2006-04-19	AACC-DELISTED	Stock	20.95	21.42	20.95	21.32	150705.0
2006-04-19	AACQ-DELISTED	Stock	5.36	5.36	5.35	5.35	11000.0
2006-04-19	AACQU-DELISTED	Stock	6.74	6.74	6.7	6.71	62000.0
2006-04-19	AACQW-DELISTED	Stock	0.73	0.73	0.71	0.72	77500.0
2006-04-19	AAI-DELISTED	Stock	15.5	15.6	14.98	15.08	3075300.0
2006-04-19	AAIC-DELISTED	Stock	187.0	189.6	184.0	185.0	1018400.0
2006-04-19	AAME	Stock	2.78	2.85	2.78	2.85	33000.0
2006-04-19	AAON	Stock	3.1118	3.2198	3.1118	3.2198	318178.0
2006-04-19	AAP	Stock	38.88	39.05	38.67	38.93	1213900.0
2006-04-19	AATI-DELISTED	Stock	10.5	12.06	10.4	12.0	1709982.0
2006-04-19	AAU-DELISTED	Stock	3.0	3.0	2.86	2.9	102600.0
2006-04-19	AAUAF-DELISTED	Stock	3.0	3.0	2.86	2.9	102600.0
2006-04-19	AAV-DELISTED	Stock	20.04	20.46	20.04	20.46	243600.0
2006-04-19	AAWW-DELISTED	Stock	44.0	46.0	44.0	46.0	29800.0
2006-04-19	AAXN-DELISTED	Stock	10.1800003051758	10.7299995422363	10.1800003051758	10.6700000762939	1763600.0
2006-04-19	AB	Stock	69.75	72.11	69.75	71.25	227400.0
2006-04-19	ABAX-DELISTED	Stock	25.48	25.82	25.43	25.54	187902.0
2006-04-19	ABB-DELISTED	Stock	13.15	13.52	13.14	13.44	4839900.0
2006-04-19	ABBC-DELISTED	Stock	13.46	13.556	13.42	13.42	2470.0
2006-04-19	ABC-DELISTED	Stock	23.84	24.0	23.58	23.75	2782600.0
2006-04-19	ABCB	Stock	22.3319	22.7598	22.0304	22.7598	24778.0
2006-04-19	ABCO-DELISTED	Stock	27.96	28.21	27.65	28.14	126070.0
2006-04-19	ABCW-DELISTED	Stock	29.17	29.53	29.13	29.49	22880.0
2006-04-19	ABD-DELISTED	Stock	21.86	21.98	21.65	21.75	394620.0
2006-04-19	ABE-DELISTED	Stock	13.2	13.2499	13.15	13.19	16600.0
2006-04-19	ABFS-DELISTED	Stock	40.34	41.3699	40.1	41.3	258315.0
2006-04-19	ABG	Stock	18.66	18.74	18.35	18.57	42900.0
2006-04-19	ABK-DELISTED	Stock	78.2	78.84	77.85	78.33	711000.0
2006-04-19	ABM	Stock	17.25	17.45	17.23	17.25	289400.0
2006-04-19	ABMD-DELISTED	Stock	13.9	14.0	13.51	13.61	91187.0
2006-04-19	ABP-DELISTED	Stock	5.79	6.25	5.6	6.23	1177700.0
2006-04-19	ABR	Stock	25.57	25.99	25.55	25.8	86900.0
2006-04-19	ABT	Stock	19.7582	19.9693	19.6958	19.8349	10276990.0
2006-04-19	ABTL-DELISTED	Stock	22.3	22.9	22.25	22.9	29135.0
2006-04-19	ABV-DELISTED	Stock	46.82	47.2	46.78	47.16	442900.0
2006-04-19	ABX-DELISTED	Stock	30.54	31.18	30.1	31.1	6081300.0
2006-04-19	ACAD	Stock	15.61	15.61	15.1	15.28	227000.0
2006-04-19	ACAP-DELISTED	Stock	48.31	48.74	47.08	47.97	41499.0
2006-04-19	ACAS-DELISTED	Stock	34.02	34.73	33.7	34.59	1484508.0
2006-04-19	ACAT-DELISTED	Stock	21.0	21.3	20.76	21.0	89576.0
2006-04-19	ACC-DELISTED	Stock	25.7	25.85	25.43	25.6	225598.0
2006-04-19	ACCL-DELISTED	Stock	7.42	7.42	7.2	7.25	60639.0
2006-04-19	ACCO	Stock	21.86	21.98	21.65	21.75	396500.0

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

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