PREVIEW / stock_daily / 2005-01-19

all stock daily files

  file:    by_date/stock_daily/2005/2005-01-19.parquet
  size:    134 KB
  rows:    3,970
  symbols: 2,484

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-19	AAPL	Stock	1.2588	1.2761	1.2455	1.2479	751895200.0
2005-01-19	MSFT	Stock	26.21	26.26	25.92	25.98	58114100.0
2005-01-19	NVDA	Stock	0.1829	0.1833	0.1772	0.1779	336492000.0
2005-01-19	AMZN	Stock	2.2235	2.237	2.1715	2.198	147934000.0
2005-01-19	CL	Stock	25.07	25.24	24.95	25.035	2423600.0
2005-01-19	A	Stock	15.9871	16.0944	15.7511	15.7797	3640811.0
2005-01-19	AABA-DELISTED	Stock	38.0800018310547	38.2000007629395	36.4199981689453	36.4500007629395	44303200.0
2005-01-19	AACC-DELISTED	Stock	21.6	21.85	20.55	20.81	72826.0
2005-01-19	AAI-DELISTED	Stock	8.54	8.54	8.13	8.2	1204000.0
2005-01-19	AAIC-DELISTED	Stock	397.0	400.2	393.2	396.0	1184500.0
2005-01-19	AAME	Stock	3.05	3.07	3.0	3.05	6700.0
2005-01-19	AAON	Stock	1.8502	1.9398	1.8318	1.8318	92644.0
2005-01-19	AAP	Stock	29.62	29.66	29.0333	29.0333	638550.0
2005-01-19	AAV-DELISTED	Stock	17.91	18.05	17.83	17.91	26600.0
2005-01-19	AAXN-DELISTED	Stock	19.3299999237061	19.3999996185303	17.2600002288818	17.4699993133545	17228100.0
2005-01-19	ABAX-DELISTED	Stock	12.91	13.0	12.68	12.73	319434.0
2005-01-19	ABB-DELISTED	Stock	5.72	5.74	5.67	5.67	101700.0
2005-01-19	ABBC-DELISTED	Stock	12.88	13.0	12.88	13.0	62585.0
2005-01-19	ABC-DELISTED	Stock	14.52	14.6	14.36	14.37	5121200.0
2005-01-19	ABCB	Stock	15.9757	16.2107	15.7163	15.8946	15545.0
2005-01-19	ABCO-DELISTED	Stock	19.035	19.035	18.46	18.53	191978.0
2005-01-19	ABCW-DELISTED	Stock	27.51	27.79	27.51	27.55	53080.0
2005-01-19	ABE-DELISTED	Stock	9.63	9.66	9.58	9.58	10300.0
2005-01-19	ABFS-DELISTED	Stock	41.29	41.63	40.7	40.89	369748.0
2005-01-19	ABG	Stock	15.08	15.36	15.07	15.31	54700.0
2005-01-19	ABK-DELISTED	Stock	81.9	82.23	81.18	81.35	351700.0
2005-01-19	ABM	Stock	18.59	18.7	18.2	18.26	105100.0
2005-01-19	ABMD-DELISTED	Stock	12.02	12.09	11.65	11.87	127161.0
2005-01-19	ABP-DELISTED	Stock	2.45	2.5	2.31	2.4	119300.0
2005-01-19	ABR	Stock	24.08	24.08	23.64	23.75	130300.0
2005-01-19	ABT	Stock	22.0948	22.3059	22.0228	22.0948	8540017.0
2005-01-19	ABTL-DELISTED	Stock	29.9	29.9	28.45	28.6	45300.0
2005-01-19	ABV-DELISTED	Stock	25.76	25.84	25.26	25.35	459200.0
2005-01-19	ABVA-DELISTED	Stock	15.751	15.94	15.71	15.71	1300.0
2005-01-19	ABVT-DELISTED	Stock	32.25	32.25	32.25	32.25	200.0
2005-01-19	ABX-DELISTED	Stock	22.49	22.53	22.19	22.3	1069900.0
2005-01-19	ACAD	Stock	6.75	6.76	6.61	6.62	10500.0
2005-01-19	ACAP-DELISTED	Stock	35.34	35.44	34.32	34.67	35669.0
2005-01-19	ACAS-DELISTED	Stock	33.11	33.17	32.73	32.83	547109.0
2005-01-19	ACAT-DELISTED	Stock	24.89	24.89	23.84	23.84	98931.0
2005-01-19	ACC-DELISTED	Stock	21.9	22.0	21.62	21.99	37900.0
2005-01-19	ACCL-DELISTED	Stock	6.15	6.19	5.77	5.81	123005.0
2005-01-19	ACE-DELISTED	Stock	43.69	44.21	43.31	43.83	2810200.0
2005-01-19	ACF-DELISTED	Stock	24.5	24.68	23.99	24.12	747700.0
2005-01-19	ACFC-DELISTED	Stock	64.28	64.28	62.55	63.27	15668.0
2005-01-19	ACG-DELISTED	Stock	8.16	8.17	8.14	8.15	394300.0
2005-01-19	ACGL	Stock	4.2078	4.2489	4.2078	4.2211	747900.0
2005-01-19	ACGN-DELISTED	Stock	555.3288	566.6712	544.0	555.3288	105000.0
2005-01-19	ACH	Stock	18.7467	18.8333	18.4267	18.5067	356250.0
2005-01-19	ACH-DELISTED	Stock	13.999	13.999	13.672	13.689	318004.0

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

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