PREVIEW / stock_daily / 2006-07-12

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-12.parquet
  size:    148 KB
  rows:    4,460
  symbols: 2,812

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-07-12	AAPL	Stock	1.9704	1.9729	1.89	1.8914	927329200.0
2006-07-12	MSFT	Stock	22.79	22.88	22.62	22.64	77379300.0
2006-07-12	NVDA	Stock	0.318	0.3217	0.3035	0.3038	461034000.0
2006-07-12	AMZN	Stock	1.78	1.795	1.7285	1.7315	97894000.0
2006-07-12	CL	Stock	30.875	30.925	30.61	30.71	2477400.0
2006-07-12	A	Stock	21.588	21.588	19.9428	20.3863	9756362.0
2006-07-12	AABA-DELISTED	Stock	33.0299987792969	33.7400016784668	32.9900016784668	33.3800010681152	18708400.0
2006-07-12	AACC-DELISTED	Stock	19.85	19.93	19.38	19.38	124409.0
2006-07-12	AACQU-DELISTED	Stock	6.18	6.18	6.13	6.13	4000.0
2006-07-12	AACQW-DELISTED	Stock	0.45	0.45	0.45	0.45	10000.0
2006-07-12	AAI-DELISTED	Stock	14.1	14.25	13.7	14.05	938600.0
2006-07-12	AAIC-DELISTED	Stock	212.8	215.0	208.2	212.4	1671100.0
2006-07-12	AAME	Stock	2.96	2.96	2.96	2.96	2100.0
2006-07-12	AAON	Stock	3.1526	3.1881	3.1368	3.1394	142003.0
2006-07-12	AAP	Stock	29.25	29.36	28.9	29.0	1173700.0
2006-07-12	AATI-DELISTED	Stock	9.18	9.18	8.82	8.83	54270.0
2006-07-12	AAU-DELISTED	Stock	2.48	2.53	2.3812	2.5	65382.0
2006-07-12	AAUAF-DELISTED	Stock	2.51	2.56	2.4101	2.5	64600.0
2006-07-12	AAV-DELISTED	Stock	15.44	15.47	15.35	15.46	585800.0
2006-07-12	AAWW-DELISTED	Stock	47.2	47.75	45.06	46.0	103967.0
2006-07-12	AAXN-DELISTED	Stock	8.56999969482422	8.72999954223633	8.14999961853027	8.22000026702881	582400.0
2006-07-12	AB	Stock	59.0	60.06	58.26	58.43	356400.0
2006-07-12	ABAX-DELISTED	Stock	20.72	21.24	20.72	20.73	166969.0
2006-07-12	ABB-DELISTED	Stock	12.53	12.53	12.25	12.27	1329700.0
2006-07-12	ABBC-DELISTED	Stock	14.68	14.73	14.46	14.5	8399.0
2006-07-12	ABC-DELISTED	Stock	20.88	21.01	20.86	20.88	1347400.0
2006-07-12	ABCB	Stock	22.2638	22.3708	21.7386	21.8844	11926.0
2006-07-12	ABCO-DELISTED	Stock	23.99	24.2	23.99	24.07	178681.0
2006-07-12	ABCW-DELISTED	Stock	30.16	30.29	29.05	29.14	41600.0
2006-07-12	ABD-DELISTED	Stock	20.83	20.86	20.4	20.54	473700.0
2006-07-12	ABE-DELISTED	Stock	12.25	12.35	12.25	12.29	7500.0
2006-07-12	ABFS-DELISTED	Stock	47.89	48.65	47.05	47.2	296737.0
2006-07-12	ABG	Stock	20.74	21.0	20.35	20.4	182000.0
2006-07-12	ABK-DELISTED	Stock	83.5	84.12	82.91	83.27	757500.0
2006-07-12	ABM	Stock	16.79	16.8	16.43	16.52	201000.0
2006-07-12	ABMD-DELISTED	Stock	13.51	13.75	13.48	13.52	78680.0
2006-07-12	ABP-DELISTED	Stock	4.45	4.59	4.38	4.38	120900.0
2006-07-12	ABR	Stock	25.18	25.22	24.91	25.0	79400.0
2006-07-12	ABT	Stock	21.3511	21.3799	21.1256	21.164	13533347.0
2006-07-12	ABTL-DELISTED	Stock	17.051	17.151	16.349	16.649	25138.0
2006-07-12	ABV-DELISTED	Stock	40.8	41.04	40.22	40.28	328700.0
2006-07-12	ABVA-DELISTED	Stock	16.35	16.35	16.29	16.29	699.0
2006-07-12	ABX-DELISTED	Stock	30.7	31.0	29.96	30.23	4589300.0
2006-07-12	ACAD	Stock	8.59	8.71	8.19	8.39	177800.0
2006-07-12	ACAP-DELISTED	Stock	50.61	50.79	49.96	50.07	26800.0
2006-07-12	ACAS-DELISTED	Stock	34.07	34.16	33.86	33.91	640718.0
2006-07-12	ACAT-DELISTED	Stock	18.11	18.11	17.05	17.1	51139.0
2006-07-12	ACC-DELISTED	Stock	26.05	26.05	25.2	25.31	61700.0
2006-07-12	ACCL-DELISTED	Stock	7.16	7.25	7.08	7.09	30092.0
2006-07-12	ACCO	Stock	20.83	20.86	20.4	20.54	474700.0

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

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