PREVIEW / stock_daily / 2005-01-18

all stock daily files

  file:    by_date/stock_daily/2005/2005-01-18.parquet
  size:    134 KB
  rows:    3,992
  symbols: 2,507

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-01-18	AAPL	Stock	1.2473	1.2625	1.2098	1.2616	1006460000.0
2005-01-18	MSFT	Stock	26.03	26.35	25.84	26.32	69146400.0
2005-01-18	NVDA	Stock	0.1772	0.1825	0.1768	0.1821	464556000.0
2005-01-18	AMZN	Stock	2.2145	2.25	2.2075	2.229	142632000.0
2005-01-18	CL	Stock	24.875	25.15	24.765	25.07	3426000.0
2005-01-18	A	Stock	15.6724	16.0944	15.5222	16.0443	3523519.0
2005-01-18	AABA-DELISTED	Stock	37.0999984741211	37.4599990844727	36.5999984741211	37.1800003051758	42709600.0
2005-01-18	AACC-DELISTED	Stock	21.27	21.83	21.27	21.72	38215.0
2005-01-18	AAI-DELISTED	Stock	8.59	8.69	8.41	8.55	1949100.0
2005-01-18	AAIC-DELISTED	Stock	398.4	399.2	392.4	393.6	1276700.0
2005-01-18	AAME	Stock	3.16	3.16	3.0	3.05	2000.0
2005-01-18	AAON	Stock	1.8436	1.9345	1.8015	1.916	228572.0
2005-01-18	AAP	Stock	28.8667	30.2	28.8267	29.7133	680100.0
2005-01-18	AAV-DELISTED	Stock	17.99	18.02	17.79	17.99	47900.0
2005-01-18	AAXN-DELISTED	Stock	19.75	20.3700008392334	19.1499996185303	19.7600002288818	12570800.0
2005-01-18	ABAX-DELISTED	Stock	12.21	12.94	12.2	12.79	103592.0
2005-01-18	ABB-DELISTED	Stock	5.71	5.82	5.68	5.76	963300.0
2005-01-18	ABBC-DELISTED	Stock	12.9	12.99	12.85	12.95	59807.0
2005-01-18	ABC-DELISTED	Stock	14.32	14.51	14.27	14.48	6166000.0
2005-01-18	ABCB	Stock	15.4407	15.8216	15.4407	15.6758	3331.0
2005-01-18	ABCO-DELISTED	Stock	18.907	19.012	18.733	18.858	163737.0
2005-01-18	ABCW-DELISTED	Stock	27.61	27.93	27.5	27.83	49210.0
2005-01-18	ABE-DELISTED	Stock	9.67	9.76	9.62	9.67	13200.0
2005-01-18	ABFS-DELISTED	Stock	40.21	41.26	40.21	41.11	238202.0
2005-01-18	ABG	Stock	14.8	15.15	14.7	15.08	41500.0
2005-01-18	ABK-DELISTED	Stock	79.95	82.62	79.62	81.95	549400.0
2005-01-18	ABM	Stock	18.1	18.7	18.1	18.66	145700.0
2005-01-18	ABMD-DELISTED	Stock	11.97	12.08	11.55	11.9	208079.0
2005-01-18	ABP-DELISTED	Stock	2.49	2.5	2.43	2.47	113100.0
2005-01-18	ABR	Stock	24.0	24.06	23.71	23.81	110000.0
2005-01-18	ABT	Stock	22.0948	22.2579	21.8309	22.09	10155690.0
2005-01-18	ABTL-DELISTED	Stock	28.5	29.4	28.5	28.9	50400.0
2005-01-18	ABV-DELISTED	Stock	26.15	26.16	25.4	25.63	639500.0
2005-01-18	ABVA-DELISTED	Stock	16.0	16.0	15.55	15.55	400.0
2005-01-18	ABVT-DELISTED	Stock	32.0	32.5	32.0	32.5	1500.0
2005-01-18	ABX-DELISTED	Stock	22.0	22.531	21.96	22.36	1930100.0
2005-01-18	ACAD	Stock	7.24	7.24	6.61	6.8	28000.0
2005-01-18	ACAP-DELISTED	Stock	34.91	35.44	34.62	35.15	34969.0
2005-01-18	ACAS-DELISTED	Stock	32.81	33.0	32.5	33.0	572396.0
2005-01-18	ACAT-DELISTED	Stock	24.51	24.94	24.42	24.68	158908.0
2005-01-18	ACC-DELISTED	Stock	21.5	21.9	21.4	21.9	53100.0
2005-01-18	ACCL-DELISTED	Stock	5.8	6.19	5.75	6.14	134631.0
2005-01-18	ACE-DELISTED	Stock	42.4	43.6	42.17	43.57	2278009.0
2005-01-18	ACF-DELISTED	Stock	24.4	24.8	24.22	24.74	1140700.0
2005-01-18	ACFC-DELISTED	Stock	65.26	65.26	62.55	64.29	8899.0
2005-01-18	ACG-DELISTED	Stock	8.14	8.16	8.12	8.16	379900.0
2005-01-18	ACGL	Stock	4.1667	4.2667	4.1344	4.2078	949500.0
2005-01-18	ACGN-DELISTED	Stock	532.6712	566.6712	521.3288	566.6712	353100.0
2005-01-18	ACH	Stock	18.2067	18.88	18.1133	18.7467	350700.0
2005-01-18	ACH-DELISTED	Stock	13.87	14.17	13.87	14.14	617008.0

> showing 50 of 3,992 rows — these rows as CSV

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