PREVIEW / stock_daily / 2006-05-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-05-18.parquet
  size:    147 KB
  rows:    4,415
  symbols: 2,787

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-05-18	AAPL	Stock	2.3457	2.3664	2.2543	2.2564	658442400.0
2006-05-18	MSFT	Stock	22.84	23.14	22.76	22.83	95476400.0
2006-05-18	NVDA	Stock	0.4193	0.4233	0.3967	0.3972	686730000.0
2006-05-18	AMZN	Stock	1.5855	1.682	1.576	1.6305	240544000.0
2006-05-18	CL	Stock	30.15	30.4	29.915	30.05	9518800.0
2006-05-18	A	Stock	25.0143	25.4292	24.8712	24.9213	4384827.0
2006-05-18	AABA-DELISTED	Stock	30.1000003814697	30.3600006103516	28.9300003051758	29.0	38254000.0
2006-05-18	AACC-DELISTED	Stock	18.42	18.71	18.04	18.23	190399.0
2006-05-18	AACQU-DELISTED	Stock	6.7	6.7	6.7	6.7	500.0
2006-05-18	AACQW-DELISTED	Stock	0.64	0.66	0.63	0.64	58500.0
2006-05-18	AAI-DELISTED	Stock	12.89	13.16	12.75	12.8	2212400.0
2006-05-18	AAIC-DELISTED	Stock	198.6	201.6	197.0	197.6	1097200.0
2006-05-18	AAME	Stock	2.74	2.94	2.74	2.94	16900.0
2006-05-18	AAON	Stock	3.2448	3.2593	3.2132	3.2342	143522.0
2006-05-18	AAP	Stock	37.4	38.97	36.99	38.3	5236400.0
2006-05-18	AATI-DELISTED	Stock	10.55	10.8	10.44	10.58	143670.0
2006-05-18	AAU-DELISTED	Stock	2.56	2.629	2.36	2.4	199200.0
2006-05-18	AAUAF-DELISTED	Stock	2.56	2.629	2.36	2.4	199200.0
2006-05-18	AAV-DELISTED	Stock	18.2	18.4	18.0	18.26	374300.0
2006-05-18	AAWW-DELISTED	Stock	51.0	51.0	45.0	50.0	13500.0
2006-05-18	AAXN-DELISTED	Stock	9.68000030517578	9.68000030517578	9.10000038146973	9.14999961853027	650600.0
2006-05-18	AB	Stock	64.26	64.6	63.08	63.16	379100.0
2006-05-18	ABAX-DELISTED	Stock	18.01	18.7248	18.01	18.56	396696.0
2006-05-18	ABB-DELISTED	Stock	12.67	12.73	12.46	12.53	3354900.0
2006-05-18	ABBC-DELISTED	Stock	13.828	13.848	13.76	13.8	5032.0
2006-05-18	ABC-DELISTED	Stock	21.9	22.1	21.8	21.82	2932800.0
2006-05-18	ABCB	Stock	19.8711	21.0286	19.8711	20.6103	23544.0
2006-05-18	ABCO-DELISTED	Stock	25.37	25.75	25.13	25.37	150427.0
2006-05-18	ABCW-DELISTED	Stock	29.11	29.25	28.85	28.85	34150.0
2006-05-18	ABD-DELISTED	Stock	22.95	23.26	22.95	23.21	309300.0
2006-05-18	ABE-DELISTED	Stock	12.77	12.8	12.49	12.59	24100.0
2006-05-18	ABFS-DELISTED	Stock	42.28	43.38	41.96	43.07	450795.0
2006-05-18	ABG	Stock	19.75	20.18	19.38	19.57	66800.0
2006-05-18	ABK-DELISTED	Stock	81.42	81.95	81.03	81.04	737600.0
2006-05-18	ABM	Stock	17.18	17.61	17.18	17.5	205900.0
2006-05-18	ABMD-DELISTED	Stock	11.79	11.98	11.66	11.67	46625.0
2006-05-18	ABP-DELISTED	Stock	4.86	4.86	4.5	4.62	525400.0
2006-05-18	ABR	Stock	24.2	24.47	23.72	23.9	192200.0
2006-05-18	ABT	Stock	19.9549	20.3099	19.8829	20.1324	10569404.0
2006-05-18	ABTL-DELISTED	Stock	18.0	18.8	18.0	18.0	24145.0
2006-05-18	ABV-DELISTED	Stock	42.49	44.14	41.75	42.98	738900.0
2006-05-18	ABVA-DELISTED	Stock	18.701	18.75	18.7	18.7	4974.0
2006-05-18	ABX-DELISTED	Stock	31.02	31.52	30.38	30.55	5816900.0
2006-05-18	ACAD	Stock	10.59	10.97	10.54	10.59	220500.0
2006-05-18	ACAP-DELISTED	Stock	46.64	47.09	45.3	45.4	48678.0
2006-05-18	ACAS-DELISTED	Stock	33.78	34.27	33.74	34.01	1403888.0
2006-05-18	ACAT-DELISTED	Stock	19.43	19.91	18.86	18.86	115654.0
2006-05-18	ACC-DELISTED	Stock	22.68	22.9	22.4	22.71	433000.0
2006-05-18	ACCL-DELISTED	Stock	6.75	6.88	6.7	6.78	84793.0
2006-05-18	ACCO	Stock	22.95	23.26	22.95	23.21	311100.0

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

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