PREVIEW / stock_daily / 2006-02-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-02-07.parquet
  size:    145 KB
  rows:    4,340
  symbols: 2,752

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-02-07	AAPL	Stock	2.4382	2.4814	2.3814	2.4143	1388830800.0
2006-02-07	MSFT	Stock	26.95	27.15	26.81	26.94	72159500.0
2006-02-07	NVDA	Stock	0.3779	0.3779	0.3636	0.3637	399408000.0
2006-02-07	AMZN	Stock	1.9045	1.91	1.86	1.876	148072000.0
2006-02-07	CL	Stock	27.0	27.05	26.795	26.91	3252200.0
2006-02-07	A	Stock	24.7139	24.8069	23.9771	24.3205	3002065.0
2006-02-07	AABA-DELISTED	Stock	33.0099983215332	33.0999984741211	32.3199996948242	33.0200004577637	37236800.0
2006-02-07	AACC-DELISTED	Stock	17.87	18.3	17.39	17.6	513400.0
2006-02-07	AACQU-DELISTED	Stock	6.7	6.7	6.65	6.65	4565.0
2006-02-07	AAI-DELISTED	Stock	16.81	16.89	16.62	16.68	953000.0
2006-02-07	AAIC-DELISTED	Stock	222.0	225.8	218.0	225.4	1142200.0
2006-02-07	AAON	Stock	2.5969	2.6667	2.5758	2.6522	305269.0
2006-02-07	AAP	Stock	43.84	43.84	42.74	42.95	560500.0
2006-02-07	AATI-DELISTED	Stock	13.49	13.98	13.49	13.84	219864.0
2006-02-07	AAU-DELISTED	Stock	2.91	2.91	2.7	2.7	113200.0
2006-02-07	AAUAF-DELISTED	Stock	2.91	2.91	2.7	2.7	113200.0
2006-02-07	AAV-DELISTED	Stock	21.22	21.22	20.42	20.5	742200.0
2006-02-07	AAWW-DELISTED	Stock	47.75	47.75	47.75	47.75	6200.0
2006-02-07	AAXN-DELISTED	Stock	9.02999973297119	9.4399995803833	8.96000003814697	9.01000022888184	1109500.0
2006-02-07	ABAX-DELISTED	Stock	20.35	20.5	20.2	20.33	251795.0
2006-02-07	ABB-DELISTED	Stock	10.85	10.89	10.79	10.84	1064000.0
2006-02-07	ABBC-DELISTED	Stock	13.48	13.48	13.28	13.28	3409.0
2006-02-07	ABC-DELISTED	Stock	21.74	21.96	21.6	21.68	2490600.0
2006-02-07	ABCB	Stock	19.4529	19.8419	19.4529	19.5501	6786.0
2006-02-07	ABCO-DELISTED	Stock	25.33	25.38	25.0	25.02	196749.0
2006-02-07	ABCW-DELISTED	Stock	30.4	30.86	30.27	30.61	48490.0
2006-02-07	ABD-DELISTED	Stock	23.83	24.18	23.42	23.6	258900.0
2006-02-07	ABE-DELISTED	Stock	12.81	12.82	12.61	12.67	57400.0
2006-02-07	ABFS-DELISTED	Stock	43.0	43.0	42.27	42.54	413608.0
2006-02-07	ABG	Stock	17.97	18.22	17.82	18.12	57600.0
2006-02-07	ABK-DELISTED	Stock	75.9	76.41	75.75	75.92	425600.0
2006-02-07	ABM	Stock	19.13	19.4	18.92	18.95	110100.0
2006-02-07	ABMD-DELISTED	Stock	10.8	10.8	10.26	10.34	86268.0
2006-02-07	ABP-DELISTED	Stock	7.25	7.25	6.65	6.8	1066700.0
2006-02-07	ABR	Stock	25.26	25.6	25.01	25.09	55200.0
2006-02-07	ABT	Stock	20.2476	20.3291	20.046	20.2044	8333055.0
2006-02-07	ABTL-DELISTED	Stock	24.75	25.0	24.2	24.2	34718.0
2006-02-07	ABV-DELISTED	Stock	40.1	40.19	39.15	39.26	422400.0
2006-02-07	ABVA-DELISTED	Stock	17.33	17.33	17.33	17.33	100.0
2006-02-07	ABVT-DELISTED	Stock	31.0	31.0	31.0	31.0	200.0
2006-02-07	ABX-DELISTED	Stock	29.85	30.01	28.55	29.01	6943900.0
2006-02-07	ACAD	Stock	13.75	14.5	13.49	13.57	506600.0
2006-02-07	ACAP-DELISTED	Stock	47.76	47.76	45.77	45.98	58947.0
2006-02-07	ACAS-DELISTED	Stock	35.9	35.95	35.52	35.71	728670.0
2006-02-07	ACAT-DELISTED	Stock	22.65	23.14	22.61	23.0	99689.0
2006-02-07	ACC-DELISTED	Stock	24.98	25.06	24.5	24.77	57500.0
2006-02-07	ACCL-DELISTED	Stock	6.38	6.4	6.23	6.25	80739.0
2006-02-07	ACCO	Stock	23.83	24.18	23.42	23.6	277800.0
2006-02-07	ACCP-DELISTED	Stock	1.05	1.2	1.05	1.05	51813.0
2006-02-07	ACE-DELISTED	Stock	54.27	54.53	53.86	54.21	1069800.0

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

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