PREVIEW / stock_daily / 2006-04-04

all stock daily files

  file:    by_date/stock_daily/2006/2006-04-04.parquet
  size:    147 KB
  rows:    4,392
  symbols: 2,779

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-04-04	AAPL	Stock	2.2179	2.2221	2.1804	2.1846	931924000.0
2006-04-04	MSFT	Stock	27.6	27.8	27.47	27.64	45470000.0
2006-04-04	NVDA	Stock	0.4832	0.5058	0.4827	0.5051	1200612000.0
2006-04-04	AMZN	Stock	1.807	1.855	1.801	1.8385	74356000.0
2006-04-04	CL	Stock	29.05	29.065	28.795	28.935	3564400.0
2006-04-04	A	Stock	27.2031	27.3247	27.0672	27.2175	2554565.0
2006-04-04	AABA-DELISTED	Stock	31.6900005340576	32.25	31.6599998474121	32.0999984741211	16232700.0
2006-04-04	AACC-DELISTED	Stock	19.66	19.94	19.47	19.5	170172.0
2006-04-04	AACQ-DELISTED	Stock	5.44	5.45	5.44	5.45	2250.0
2006-04-04	AACQW-DELISTED	Stock	0.74	0.74	0.74	0.74	6000.0
2006-04-04	AAI-DELISTED	Stock	18.2	18.2	17.75	18.05	1069100.0
2006-04-04	AAIC-DELISTED	Stock	183.4	185.0	181.68	184.8	611800.0
2006-04-04	AAME	Stock	2.75	2.99	2.75	2.89	11300.0
2006-04-04	AAON	Stock	3.146	3.1763	3.121	3.1605	193641.0
2006-04-04	AAP	Stock	41.47	41.5	40.94	40.95	1068000.0
2006-04-04	AATI-DELISTED	Stock	11.12	11.25	11.0	11.07	132712.0
2006-04-04	AAU-DELISTED	Stock	2.85	2.95	2.81	2.89	139900.0
2006-04-04	AAUAF-DELISTED	Stock	2.85	2.95	2.81	2.89	139900.0
2006-04-04	AAV-DELISTED	Stock	19.01	19.14	18.85	19.12	204100.0
2006-04-04	AAWW-DELISTED	Stock	45.5	46.5	42.0	45.01	1137800.0
2006-04-04	AAXN-DELISTED	Stock	10.3800001144409	10.8000001907349	10.289999961853	10.7200002670288	1206600.0
2006-04-04	AB	Stock	66.61	67.6	66.3	67.56	192300.0
2006-04-04	ABAX-DELISTED	Stock	22.79	22.99	22.03	22.36	431673.0
2006-04-04	ABB-DELISTED	Stock	13.03	13.11	13.03	13.06	1058800.0
2006-04-04	ABBC-DELISTED	Stock	13.5	13.57	13.5	13.57	1800.0
2006-04-04	ABC-DELISTED	Stock	24.29	24.29	23.8	23.95	3130800.0
2006-04-04	ABCB	Stock	21.8844	22.2735	21.5148	22.0304	17787.0
2006-04-04	ABCO-DELISTED	Stock	27.5	27.84	27.23	27.67	172682.0
2006-04-04	ABCW-DELISTED	Stock	30.12	30.16	29.67	29.8	40270.0
2006-04-04	ABD-DELISTED	Stock	22.2	22.29	21.94	21.94	282680.0
2006-04-04	ABE-DELISTED	Stock	12.86	13.21	12.86	13.18	37000.0
2006-04-04	ABFS-DELISTED	Stock	39.84	40.58	39.65	40.28	408790.0
2006-04-04	ABG	Stock	19.17	19.32	18.89	19.06	99600.0
2006-04-04	ABK-DELISTED	Stock	79.7	79.85	78.64	78.7	785300.0
2006-04-04	ABM	Stock	18.75	18.78	18.43	18.48	177100.0
2006-04-04	ABMD-DELISTED	Stock	12.91	13.23	12.85	13.15	167586.0
2006-04-04	ABP-DELISTED	Stock	5.63	5.75	5.28	5.41	701700.0
2006-04-04	ABR	Stock	26.89	27.05	26.8	26.82	119800.0
2006-04-04	ABT	Stock	20.6074	20.6266	20.3483	20.4347	7880992.0
2006-04-04	ABTL-DELISTED	Stock	23.3	23.9	23.16	23.25	25026.0
2006-04-04	ABV-DELISTED	Stock	45.52	46.35	45.22	45.93	635400.0
2006-04-04	ABVT-DELISTED	Stock	38.5	40.0	35.0	40.0	1500.0
2006-04-04	ABX-DELISTED	Stock	27.9	28.38	27.76	27.94	5919964.0
2006-04-04	ACAD	Stock	15.57	15.94	15.32	15.93	391100.0
2006-04-04	ACAP-DELISTED	Stock	47.71	48.27	47.52	47.56	38334.0
2006-04-04	ACAS-DELISTED	Stock	35.27	35.27	35.05	35.23	1072230.0
2006-04-04	ACAT-DELISTED	Stock	24.07	24.1	23.76	23.96	59381.0
2006-04-04	ACC-DELISTED	Stock	25.15	25.46	25.06	25.24	47447.0
2006-04-04	ACCL-DELISTED	Stock	7.26	7.4	7.18	7.28	97330.0
2006-04-04	ACCO	Stock	22.19	22.28	21.94	21.95	284300.0

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

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