PREVIEW / stock_daily / 2006-06-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-07.parquet
  size:    148 KB
  rows:    4,424
  symbols: 2,792

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-06-07	AAPL	Stock	2.1464	2.1571	2.0839	2.0914	750506400.0
2006-06-07	MSFT	Stock	22.15	22.39	22.01	22.04	73827500.0
2006-06-07	NVDA	Stock	0.3743	0.375	0.3608	0.3637	565380000.0
2006-06-07	AMZN	Stock	1.67	1.727	1.6455	1.6885	106076000.0
2006-06-07	CL	Stock	30.21	30.5	30.13	30.365	5092400.0
2006-06-07	A	Stock	24.3562	24.628	24.0343	24.2489	3134176.0
2006-06-07	AABA-DELISTED	Stock	30.7999992370605	31.25	30.3600006103516	30.5400009155273	17470100.0
2006-06-07	AACC-DELISTED	Stock	16.97	17.3	16.8	17.2	104224.0
2006-06-07	AACQU-DELISTED	Stock	6.2	6.2	6.2	6.2	300.0
2006-06-07	AACQW-DELISTED	Stock	0.49	0.5	0.45	0.45	68000.0
2006-06-07	AAI-DELISTED	Stock	12.28	12.9784	12.17	12.6	2192700.0
2006-06-07	AAIC-DELISTED	Stock	204.8	211.0	202.6	209.0	863000.0
2006-06-07	AAME	Stock	3.04	3.05	3.04	3.05	2700.0
2006-06-07	AAON	Stock	2.963	3.1421	2.9485	3.0657	517134.0
2006-06-07	AAP	Stock	37.27	37.98	37.08	37.19	959100.0
2006-06-07	AATI-DELISTED	Stock	10.91	10.96	10.7	10.9	67470.0
2006-06-07	AAU-DELISTED	Stock	2.4	2.42	2.32	2.38	48400.0
2006-06-07	AAUAF-DELISTED	Stock	2.4	2.42	2.32	2.38	48400.0
2006-06-07	AAV-DELISTED	Stock	18.44	18.45	18.02	18.04	345200.0
2006-06-07	AAWW-DELISTED	Stock	50.88	51.0075	50.48	50.98	23424.0
2006-06-07	AAXN-DELISTED	Stock	9.35000038146973	9.53999996185303	9.25	9.27000045776367	531400.0
2006-06-07	AB	Stock	63.93	64.5	62.98	62.98	154700.0
2006-06-07	ABAX-DELISTED	Stock	17.66	18.15	17.22	17.79	519238.0
2006-06-07	ABB-DELISTED	Stock	11.71	11.83	11.6	11.62	2259700.0
2006-06-07	ABBC-DELISTED	Stock	14.55	14.6	14.55	14.56	11069.0
2006-06-07	ABC-DELISTED	Stock	21.7	21.84	21.6	21.62	2908600.0
2006-06-07	ABCB	Stock	20.8048	21.3009	20.5227	20.5616	15113.0
2006-06-07	ABCO-DELISTED	Stock	24.57	25.01	24.29	24.32	355957.0
2006-06-07	ABCW-DELISTED	Stock	29.03	29.2	28.55	28.73	53800.0
2006-06-07	ABD-DELISTED	Stock	22.7	22.8	22.23	22.4	237770.0
2006-06-07	ABE-DELISTED	Stock	11.95	12.4	11.95	12.14	15600.0
2006-06-07	ABFS-DELISTED	Stock	42.51	43.0	41.87	42.39	545509.0
2006-06-07	ABG	Stock	21.69	21.83	21.3	21.39	83900.0
2006-06-07	ABK-DELISTED	Stock	78.97	79.97	78.59	79.6	1030600.0
2006-06-07	ABM	Stock	17.4	18.18	17.33	17.9	363800.0
2006-06-07	ABMD-DELISTED	Stock	12.77	13.49	12.77	13.12	65750.0
2006-06-07	ABP-DELISTED	Stock	4.56	4.7	4.39	4.49	228000.0
2006-06-07	ABR	Stock	24.59	24.92	24.03	24.17	130000.0
2006-06-07	ABT	Stock	20.3819	20.713	20.3435	20.5786	10694456.0
2006-06-07	ABTL-DELISTED	Stock	14.775	15.075	14.675	14.875	81919.0
2006-06-07	ABV-DELISTED	Stock	41.14	42.33	40.36	41.25	724800.0
2006-06-07	ABVA-DELISTED	Stock	16.93	16.94	16.69	16.78	9915.0
2006-06-07	ABX-DELISTED	Stock	29.1	29.78	28.68	28.8	4697800.0
2006-06-07	ACAD	Stock	9.93	10.05	9.81	9.83	235400.0
2006-06-07	ACAP-DELISTED	Stock	44.88	45.53	44.82	44.86	34354.0
2006-06-07	ACAS-DELISTED	Stock	33.94	34.24	33.78	34.01	555912.0
2006-06-07	ACAT-DELISTED	Stock	17.81	18.04	17.67	17.85	73862.0
2006-06-07	ACC-DELISTED	Stock	24.32	24.79	24.18	24.2	57203.0
2006-06-07	ACCL-DELISTED	Stock	7.15	7.35	7.04	7.2	72522.0
2006-06-07	ACCO	Stock	22.7	22.8	22.23	22.4	239900.0

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

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