PREVIEW / stock_daily / 2006-05-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-05-19.parquet
  size:    149 KB
  rows:    4,431
  symbols: 2,796

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-19	AAPL	Stock	2.2593	2.3171	2.2436	2.3039	985866000.0
2006-05-19	MSFT	Stock	22.79	22.9	22.52	22.56	100071200.0
2006-05-19	NVDA	Stock	0.4008	0.415	0.3968	0.4055	932808000.0
2006-05-19	AMZN	Stock	1.633	1.7	1.6015	1.697	196344000.0
2006-05-19	CL	Stock	30.035	30.06	29.525	29.735	6841200.0
2006-05-19	A	Stock	25.0	25.1288	24.7139	25.0215	5709152.0
2006-05-19	AABA-DELISTED	Stock	29.0499992370605	29.75	28.6000003814697	29.5300006866455	33121900.0
2006-05-19	AACC-DELISTED	Stock	18.2	18.74	17.99	18.5	226880.0
2006-05-19	AACQU-DELISTED	Stock	6.65	6.65	6.61	6.61	5000.0
2006-05-19	AACQW-DELISTED	Stock	0.63	0.63	0.61	0.61	47500.0
2006-05-19	AAI-DELISTED	Stock	12.75	13.0	12.55	12.84	1550100.0
2006-05-19	AAIC-DELISTED	Stock	200.0	200.0	193.8	198.6	880700.0
2006-05-19	AAME	Stock	3.06	3.06	3.06	3.06	300.0
2006-05-19	AAON	Stock	3.1908	3.1921	3.1552	3.1671	132131.0
2006-05-19	AAP	Stock	39.07	39.95	38.8	39.05	1574300.0
2006-05-19	AATI-DELISTED	Stock	10.63	11.07	10.58	11.05	767558.0
2006-05-19	AAU-DELISTED	Stock	2.37	2.45	2.1	2.32	216400.0
2006-05-19	AAUAF-DELISTED	Stock	2.37	2.45	2.1	2.32	216400.0
2006-05-19	AAV-DELISTED	Stock	18.0	18.15	17.85	18.12	501100.0
2006-05-19	AAWW-DELISTED	Stock	49.0	49.0	49.0	49.0	7500.0
2006-05-19	AAXN-DELISTED	Stock	9.19999980926514	9.51000022888184	8.71000003814697	9.25	1632900.0
2006-05-19	AB	Stock	63.4	64.71	63.1	64.32	235800.0
2006-05-19	ABAX-DELISTED	Stock	18.78	18.81	18.09	18.39	479540.0
2006-05-19	ABB-DELISTED	Stock	12.65	13.02	12.65	12.93	3547900.0
2006-05-19	ABBC-DELISTED	Stock	13.81	14.0	13.81	14.0	6870.0
2006-05-19	ABC-DELISTED	Stock	21.91	21.92	21.64	21.72	3245800.0
2006-05-19	ABCB	Stock	20.4741	21.0091	20.3574	20.8923	34648.0
2006-05-19	ABCO-DELISTED	Stock	25.25	25.63	24.61	25.12	238009.0
2006-05-19	ABCW-DELISTED	Stock	28.57	29.28	28.34	29.09	44210.0
2006-05-19	ABD-DELISTED	Stock	23.15	23.31	22.9	22.95	315800.0
2006-05-19	ABE-DELISTED	Stock	12.61	13.23	12.61	12.78	36000.0
2006-05-19	ABFS-DELISTED	Stock	42.97	43.6	42.13	43.08	430456.0
2006-05-19	ABG	Stock	19.57	19.8	19.24	19.5	46000.0
2006-05-19	ABK-DELISTED	Stock	81.31	81.48	80.74	81.16	867100.0
2006-05-19	ABM	Stock	17.46	17.58	17.2	17.54	238000.0
2006-05-19	ABMD-DELISTED	Stock	11.68	12.14	11.48	12.0	107823.0
2006-05-19	ABP-DELISTED	Stock	4.58	4.64	4.01	4.42	973800.0
2006-05-19	ABR	Stock	24.0	24.14	23.8	23.92	129200.0
2006-05-19	ABT	Stock	20.2716	20.2716	19.7342	20.0652	13160484.0
2006-05-19	ABTL-DELISTED	Stock	17.927	18.327	17.328	17.523	43763.0
2006-05-19	ABV-DELISTED	Stock	43.6	43.83	41.99	43.15	844000.0
2006-05-19	ABVA-DELISTED	Stock	18.89	18.95	18.45	18.61	4758.0
2006-05-19	ABX-DELISTED	Stock	30.0	30.68	29.41	30.51	8536800.0
2006-05-19	ACAD	Stock	10.64	10.75	10.01	10.24	858800.0
2006-05-19	ACAP-DELISTED	Stock	45.21	46.2	45.0	45.09	34609.0
2006-05-19	ACAS-DELISTED	Stock	34.02	34.44	34.02	34.2	2372018.0
2006-05-19	ACAT-DELISTED	Stock	18.85	19.61	18.85	19.34	61305.0
2006-05-19	ACC-DELISTED	Stock	22.71	23.29	22.59	23.05	124900.0
2006-05-19	ACCL-DELISTED	Stock	6.7	7.48	6.57	6.58	327383.0
2006-05-19	ACCO	Stock	23.15	23.31	22.9	22.95	354000.0

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

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