PREVIEW / stock_daily / 2006-08-21

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-21.parquet
  size:    147 KB
  rows:    4,452
  symbols: 2,800

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-08-21	AAPL	Stock	2.4036	2.4039	2.3625	2.3771	526226400.0
2006-08-21	MSFT	Stock	25.66	26.13	25.56	26.12	88398300.0
2006-08-21	NVDA	Stock	0.4492	0.45	0.4382	0.4392	500220000.0
2006-08-21	AMZN	Stock	1.435	1.449	1.3985	1.4065	106698000.0
2006-08-21	CL	Stock	29.61	29.8	29.535	29.63	2532800.0
2006-08-21	A	Stock	22.6753	22.6824	22.3176	22.4034	1948113.0
2006-08-21	AABA-DELISTED	Stock	29.2199993133545	29.5200004577637	28.8299999237061	28.8999996185303	11575200.0
2006-08-21	AACC-DELISTED	Stock	16.05	16.07	15.25	15.41	279485.0
2006-08-21	AACQ-DELISTED	Stock	5.29	5.29	5.29	5.29	3784.0
2006-08-21	AACQU-DELISTED	Stock	6.02	6.02	6.02	6.02	1000.0
2006-08-21	AACQW-DELISTED	Stock	0.39	0.39	0.39	0.39	8000.0
2006-08-21	AAI-DELISTED	Stock	11.63	11.72	11.32	11.4	866300.0
2006-08-21	AAIC-DELISTED	Stock	182.8	182.8	179.6	179.8	695800.0
2006-08-21	AAME	Stock	2.69	2.7	2.69	2.7	700.0
2006-08-21	AAON	Stock	3.0288	3.0867	3.0262	3.0354	100237.0
2006-08-21	AAP	Stock	30.52	30.55	29.99	30.11	435600.0
2006-08-21	AATI-DELISTED	Stock	9.35	9.41	9.12	9.24	61553.0
2006-08-21	AAU-DELISTED	Stock	2.64	2.73	2.6301	2.7	55900.0
2006-08-21	AAUAF-DELISTED	Stock	2.64	2.73	2.6301	2.7	55900.0
2006-08-21	AAV-DELISTED	Stock	16.0	16.17	16.0	16.15	379600.0
2006-08-21	AAWW-DELISTED	Stock	41.47	42.0	40.87	41.0	52228.0
2006-08-21	AAXN-DELISTED	Stock	8.0	8.07999992370605	7.76000022888184	7.88000011444092	1092100.0
2006-08-21	AB	Stock	68.65	68.77	68.3	68.51	181000.0
2006-08-21	ABAX-DELISTED	Stock	23.275	23.75	23.16	23.21	132801.0
2006-08-21	ABB-DELISTED	Stock	13.67	13.68	13.5	13.53	2096900.0
2006-08-21	ABBC-DELISTED	Stock	14.75	14.76	14.36	14.45	25180.0
2006-08-21	ABC-DELISTED	Stock	21.85	21.92	21.76	21.86	1778200.0
2006-08-21	ABCB	Stock	25.3178	25.4929	24.7149	25.3471	12646.0
2006-08-21	ABCO-DELISTED	Stock	24.82	24.94	24.55	24.89	153398.0
2006-08-21	ABCW-DELISTED	Stock	29.16	29.17	28.6	28.85	20230.0
2006-08-21	ABD-DELISTED	Stock	20.0	21.58	19.95	21.03	682810.0
2006-08-21	ABE-DELISTED	Stock	13.5	13.51	13.22	13.22	13200.0
2006-08-21	ABFS-DELISTED	Stock	44.7	44.83	43.52	43.76	201641.0
2006-08-21	ABG	Stock	20.4	20.4	19.99	20.14	41800.0
2006-08-21	ABK-DELISTED	Stock	84.85	85.13	84.5	84.85	300900.0
2006-08-21	ABM	Stock	17.8	17.89	17.54	17.79	58500.0
2006-08-21	ABMD-DELISTED	Stock	13.65	13.75	13.35	13.49	39179.0
2006-08-21	ABP-DELISTED	Stock	4.19	4.25	4.17	4.2	111600.0
2006-08-21	ABR	Stock	24.76	25.15	24.76	25.05	88200.0
2006-08-21	ABT	Stock	23.3279	23.4766	23.1935	23.3519	9150063.0
2006-08-21	ABTL-DELISTED	Stock	14.85	14.95	14.551	14.9	21319.0
2006-08-21	ABV-DELISTED	Stock	43.25	43.98	43.25	43.85	198000.0
2006-08-21	ABVA-DELISTED	Stock	16.9	16.9	16.9	16.9	750.0
2006-08-21	ABX-DELISTED	Stock	32.03	33.01	32.03	32.99	4761535.0
2006-08-21	ACAD	Stock	7.56	7.61	7.22	7.3	325900.0
2006-08-21	ACAP-DELISTED	Stock	48.76	49.22	47.43	48.34	25867.0
2006-08-21	ACAS-DELISTED	Stock	38.39	38.53	37.81	37.95	1246830.0
2006-08-21	ACAT-DELISTED	Stock	18.17	18.22	17.8	17.98	15756.0
2006-08-21	ACC-DELISTED	Stock	25.0	25.3	24.95	25.27	48400.0
2006-08-21	ACCL-DELISTED	Stock	6.26	6.36	6.15	6.28	41796.0

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

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