PREVIEW / stock_daily / 2005-06-27

all stock daily files

  file:    by_date/stock_daily/2005/2005-06-27.parquet
  size:    137 KB
  rows:    4,113
  symbols: 2,579

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
2005-06-27	AAPL	Stock	1.3157	1.3607	1.31	1.325	600171600.0
2005-06-27	MSFT	Stock	25.07	25.25	25.03	25.05	61636200.0
2005-06-27	NVDA	Stock	0.2243	0.2262	0.2219	0.2239	354588000.0
2005-06-27	AMZN	Stock	1.7455	1.7525	1.7085	1.725	91126000.0
2005-06-27	CL	Stock	25.345	25.345	24.98	25.075	5025600.0
2005-06-27	A	Stock	17.1316	17.1388	16.5951	16.6953	3339403.0
2005-06-27	AABA-DELISTED	Stock	35.8800010681152	36.1100006103516	35.2000007629395	35.6800003051758	12044700.0
2005-06-27	AACC-DELISTED	Stock	25.06	25.06	24.63	25.0	45560.0
2005-06-27	AACQ-DELISTED	Stock	5.05	5.05	5.0	5.03	74000.0
2005-06-27	AACQW-DELISTED	Stock	0.52	0.52	0.52	0.52	48116.0
2005-06-27	AAI-DELISTED	Stock	9.03	9.05	8.76	8.95	1133600.0
2005-06-27	AAIC-DELISTED	Stock	282.4	287.6	280.4	287.2	1690100.0
2005-06-27	AAME	Stock	3.01	3.01	3.0	3.0	1000.0
2005-06-27	AAON	Stock	2.3572	2.3928	2.3348	2.3361	89606.0
2005-06-27	AAP	Stock	42.2267	42.6933	42.2133	42.5933	778050.0
2005-06-27	AAV-DELISTED	Stock	14.37	14.5	14.24	14.37	114400.0
2005-06-27	AAXN-DELISTED	Stock	10.2399997711182	10.3400001525879	9.97999954223633	10.1700000762939	2052800.0
2005-06-27	ABAX-DELISTED	Stock	10.51	10.95	10.51	10.85	109841.0
2005-06-27	ABB-DELISTED	Stock	6.84	6.91	6.84	6.88	2521900.0
2005-06-27	ABBC-DELISTED	Stock	12.48	12.59	12.27	12.48	52567.0
2005-06-27	ABC-DELISTED	Stock	16.57	16.75	16.5	16.71	6919200.0
2005-06-27	ABCB	Stock	17.1282	17.3325	17.0699	17.1671	30741.0
2005-06-27	ABCO-DELISTED	Stock	23.68	23.68	23.01	23.32	324918.0
2005-06-27	ABCW-DELISTED	Stock	29.55	29.94	29.39	29.8	52300.0
2005-06-27	ABE-DELISTED	Stock	10.2	10.29	10.0	10.08	8900.0
2005-06-27	ABFS-DELISTED	Stock	30.81	31.23	30.78	30.9	157584.0
2005-06-27	ABG	Stock	15.27	15.98	15.22	15.57	50800.0
2005-06-27	ABK-DELISTED	Stock	69.75	69.75	68.98	69.37	404200.0
2005-06-27	ABM	Stock	18.87	19.06	18.8	18.94	110300.0
2005-06-27	ABMD-DELISTED	Stock	8.29	8.75	8.28	8.41	209277.0
2005-06-27	ABP-DELISTED	Stock	2.74	2.88	2.72	2.8	94300.0
2005-06-27	ABR	Stock	28.43	28.7	28.15	28.23	57600.0
2005-06-27	ABT	Stock	23.5102	23.5774	23.4046	23.5054	5900167.0
2005-06-27	ABTL-DELISTED	Stock	23.5	24.0	22.5	23.25	57675.0
2005-06-27	ABV-DELISTED	Stock	30.15	30.97	30.15	30.87	249800.0
2005-06-27	ABVA-DELISTED	Stock	14.5	14.74	14.4	14.5	4300.0
2005-06-27	ABVT-DELISTED	Stock	25.0	25.0	25.0	25.0	300.0
2005-06-27	ABX-DELISTED	Stock	24.95	24.95	24.58	24.59	1505900.0
2005-06-27	ACAD	Stock	9.21	9.21	8.66	8.8	42800.0
2005-06-27	ACAP-DELISTED	Stock	35.98	36.52	35.96	36.12	53877.0
2005-06-27	ACAS-DELISTED	Stock	36.11	36.27	35.57	35.75	604511.0
2005-06-27	ACAT-DELISTED	Stock	20.45	20.74	19.89	20.35	176481.0
2005-06-27	ACC-DELISTED	Stock	21.4	22.5	21.3	22.19	158700.0
2005-06-27	ACCL-DELISTED	Stock	4.91	4.95	4.78	4.84	249848.0
2005-06-27	ACE-DELISTED	Stock	43.71	44.24	43.71	44.08	1105400.0
2005-06-27	ACF-DELISTED	Stock	24.87	25.06	24.87	24.94	876100.0
2005-06-27	ACFC-DELISTED	Stock	63.19	63.95	62.42	62.68	16004.0
2005-06-27	ACG-DELISTED	Stock	8.3	8.32	8.27	8.27	570200.0
2005-06-27	ACGL	Stock	4.8667	4.9511	4.8667	4.9478	1381500.0
2005-06-27	ACGN-DELISTED	Stock	680.0	680.0	623.3288	646.0	81700.0

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

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