PREVIEW / stock_daily / 2005-04-27

all stock daily files

  file:    by_date/stock_daily/2005/2005-04-27.parquet
  size:    134 KB
  rows:    4,031
  symbols: 2,525

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-04-27	AAPL	Stock	1.2818	1.2986	1.2682	1.2839	613888800.0
2005-04-27	MSFT	Stock	24.66	25.15	24.63	24.99	47732800.0
2005-04-27	NVDA	Stock	0.1825	0.1832	0.1765	0.1802	609348000.0
2005-04-27	AMZN	Stock	1.542	1.587	1.53	1.586	586258000.0
2005-04-27	CL	Stock	25.325	25.44	24.25	25.365	7670000.0
2005-04-27	A	Stock	15.2217	15.3433	14.9857	15.186	2429724.0
2005-04-27	AABA-DELISTED	Stock	34.7000007629395	35.1399993896484	34.5900001525879	34.9500007629395	14861300.0
2005-04-27	AACC-DELISTED	Stock	20.5	21.07	20.48	20.51	103760.0
2005-04-27	AACQ-DELISTED	Stock	5.14	5.15	5.14	5.15	4000.0
2005-04-27	AACQU-DELISTED	Stock	6.15	6.15	6.15	6.15	6000.0
2005-04-27	AACQW-DELISTED	Stock	0.54	0.63	0.54	0.63	202700.0
2005-04-27	AAI-DELISTED	Stock	8.0	8.24	7.85	8.18	1546700.0
2005-04-27	AAIC-DELISTED	Stock	253.0	255.4	243.0	252.6	5222200.0
2005-04-27	AAME	Stock	3.09	3.09	3.0	3.04	8600.0
2005-04-27	AAON	Stock	2.3809	2.3941	2.3019	2.3941	129853.0
2005-04-27	AAP	Stock	35.1333	35.8467	35.1333	35.68	1458150.0
2005-04-27	AAV-DELISTED	Stock	15.5	15.81	15.38	15.5	32100.0
2005-04-27	AAXN-DELISTED	Stock	9.18000030517578	9.48999977111816	9.06999969482422	9.15999984741211	3624300.0
2005-04-27	ABAX-DELISTED	Stock	7.87	7.87	7.61	7.74	73368.0
2005-04-27	ABB-DELISTED	Stock	6.13	6.14	6.02	6.11	314500.0
2005-04-27	ABBC-DELISTED	Stock	11.02	11.3	11.02	11.2	27480.0
2005-04-27	ABC-DELISTED	Stock	14.98	15.11	14.95	15.1	4805200.0
2005-04-27	ABCB	Stock	16.7003	17.8285	16.7003	17.5562	30124.0
2005-04-27	ABCO-DELISTED	Stock	21.09	21.12	20.7	20.98	263080.0
2005-04-27	ABCW-DELISTED	Stock	26.45	27.22	26.45	26.89	24200.0
2005-04-27	ABE-DELISTED	Stock	9.4	9.45	9.34	9.44	8000.0
2005-04-27	ABFS-DELISTED	Stock	31.79	32.53	31.06	31.93	438412.0
2005-04-27	ABG	Stock	14.16	14.17	13.88	13.99	45900.0
2005-04-27	ABK-DELISTED	Stock	65.9	67.49	65.54	66.76	1113900.0
2005-04-27	ABM	Stock	18.44	18.76	18.35	18.36	104300.0
2005-04-27	ABMD-DELISTED	Stock	10.57	10.88	10.03	10.75	71855.0
2005-04-27	ABP-DELISTED	Stock	2.51	2.55	2.43	2.45	152500.0
2005-04-27	ABR	Stock	25.85	25.85	25.34	25.44	42500.0
2005-04-27	ABT	Stock	22.9968	23.2943	22.8433	23.2559	9021259.0
2005-04-27	ABTL-DELISTED	Stock	23.7	24.1	23.45	23.7	26600.0
2005-04-27	ABV-DELISTED	Stock	27.9	28.1	27.39	28.09	507300.0
2005-04-27	ABVT-DELISTED	Stock	29.0	29.0	29.0	29.0	2900.0
2005-04-27	ABX-DELISTED	Stock	22.44	22.47	21.68	21.9	3282609.0
2005-04-27	ACAD	Stock	7.95	7.95	7.66	7.74	10400.0
2005-04-27	ACAP-DELISTED	Stock	31.49	31.49	30.73	30.94	34719.0
2005-04-27	ACAS-DELISTED	Stock	32.15	32.2	31.62	32.19	629275.0
2005-04-27	ACAT-DELISTED	Stock	23.72	24.36	23.57	24.25	106183.0
2005-04-27	ACC-DELISTED	Stock	20.25	20.88	20.03	20.77	12900.0
2005-04-27	ACCL-DELISTED	Stock	5.43	5.48	5.32	5.32	103932.0
2005-04-27	ACE-DELISTED	Stock	40.12	42.2	40.04	41.62	2388066.0
2005-04-27	ACF-DELISTED	Stock	23.38	23.97	23.3	23.52	2351000.0
2005-04-27	ACFC-DELISTED	Stock	55.87	57.3	55.41	57.3	3553.0
2005-04-27	ACG-DELISTED	Stock	8.09	8.14	8.0	8.12	1038000.0
2005-04-27	ACGL	Stock	4.4944	4.5	4.3944	4.4689	1769400.0
2005-04-27	ACGN-DELISTED	Stock	646.0	646.0	600.6712	623.3288	29400.0

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

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