PREVIEW / stock_daily / 2006-06-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-09.parquet
  size:    147 KB
  rows:    4,410
  symbols: 2,775

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-09	AAPL	Stock	2.185	2.1986	2.1107	2.1157	775838000.0
2006-06-09	MSFT	Stock	22.15	22.19	21.89	21.92	52573800.0
2006-06-09	NVDA	Stock	0.3617	0.3678	0.3528	0.3558	433824000.0
2006-06-09	AMZN	Stock	1.675	1.7175	1.6725	1.689	104652000.0
2006-06-09	CL	Stock	30.535	30.86	30.5	30.755	5932800.0
2006-06-09	A	Stock	23.97	24.3562	23.7911	24.1273	3288935.0
2006-06-09	AABA-DELISTED	Stock	30.7000007629395	30.7999992370605	30.2299995422363	30.3700008392334	10044700.0
2006-06-09	AACC-DELISTED	Stock	17.43	18.14	17.43	18.0	167519.0
2006-06-09	AACQ-DELISTED	Stock	5.37	5.37	5.37	5.37	500.0
2006-06-09	AACQW-DELISTED	Stock	0.5	0.5	0.5	0.5	4300.0
2006-06-09	AAI-DELISTED	Stock	12.45	12.72	12.2	12.26	861900.0
2006-06-09	AAIC-DELISTED	Stock	205.8	211.2	204.4	210.8	708000.0
2006-06-09	AAME	Stock	3.05	3.05	3.05	3.05	800.0
2006-06-09	AAON	Stock	2.9485	3.0538	2.93	2.9393	166303.0
2006-06-09	AAP	Stock	37.81	38.01	37.52	37.83	585500.0
2006-06-09	AATI-DELISTED	Stock	10.71	11.18	10.54	11.12	90777.0
2006-06-09	AAU-DELISTED	Stock	2.38	2.47	2.35	2.45	37600.0
2006-06-09	AAUAF-DELISTED	Stock	2.38	2.47	2.35	2.45	37600.0
2006-06-09	AAV-DELISTED	Stock	18.08	18.18	17.98	18.16	172900.0
2006-06-09	AAWW-DELISTED	Stock	49.7	49.9	48.96	49.15	13888.0
2006-06-09	AAXN-DELISTED	Stock	9.3100004196167	9.38000011444092	9.01000022888184	9.0600004196167	524700.0
2006-06-09	AB	Stock	62.95	63.68	62.67	62.81	115800.0
2006-06-09	ABAX-DELISTED	Stock	17.75	18.21	17.57	17.7	257031.0
2006-06-09	ABB-DELISTED	Stock	11.41	11.43	11.17	11.2	2107500.0
2006-06-09	ABBC-DELISTED	Stock	14.55	14.59	14.53	14.56	21998.0
2006-06-09	ABC-DELISTED	Stock	21.28	21.31	20.86	20.88	2485800.0
2006-06-09	ABCB	Stock	20.7562	21.1063	20.4838	20.6589	12646.0
2006-06-09	ABCO-DELISTED	Stock	24.61	25.11	24.32	24.77	204454.0
2006-06-09	ABCW-DELISTED	Stock	29.18	29.85	29.05	29.09	45020.0
2006-06-09	ABD-DELISTED	Stock	22.37	22.38	22.12	22.25	311800.0
2006-06-09	ABE-DELISTED	Stock	11.9	12.17	11.88	11.9899	17300.0
2006-06-09	ABFS-DELISTED	Stock	42.75	43.83	42.51	43.05	387720.0
2006-06-09	ABG	Stock	21.39	21.7	21.31	21.35	146600.0
2006-06-09	ABK-DELISTED	Stock	79.42	79.95	79.07	79.5	548700.0
2006-06-09	ABM	Stock	18.15	18.16	17.51	17.54	224500.0
2006-06-09	ABMD-DELISTED	Stock	13.22	13.49	12.86	12.93	131525.0
2006-06-09	ABP-DELISTED	Stock	4.56	4.56	4.35	4.4	203300.0
2006-06-09	ABR	Stock	24.45	24.6	23.91	24.01	176600.0
2006-06-09	ABT	Stock	20.737	20.8473	20.6266	20.6314	9043768.0
2006-06-09	ABTL-DELISTED	Stock	15.15	15.5	14.8	15.1	205233.0
2006-06-09	ABV-DELISTED	Stock	40.4	40.58	39.04	39.04	557300.0
2006-06-09	ABVA-DELISTED	Stock	16.5	16.6	16.5	16.6	1263.0
2006-06-09	ABX-DELISTED	Stock	28.55	28.91	27.89	28.1	3647100.0
2006-06-09	ACAD	Stock	9.22	9.43	9.02	9.15	175600.0
2006-06-09	ACAP-DELISTED	Stock	46.55	46.68	45.05	45.13	34668.0
2006-06-09	ACAS-DELISTED	Stock	33.79	33.81	33.58	33.63	739089.0
2006-06-09	ACAT-DELISTED	Stock	18.37	18.37	17.75	17.8	49755.0
2006-06-09	ACC-DELISTED	Stock	24.82	25.61	24.77	25.42	69200.0
2006-06-09	ACCL-DELISTED	Stock	7.35	7.35	7.15	7.25	71213.0
2006-06-09	ACCO	Stock	22.37	22.38	22.12	22.25	318000.0

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

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