PREVIEW / stock_daily / 2005-01-20

all stock daily files

  file:    by_date/stock_daily/2005/2005-01-20.parquet
  size:    133 KB
  rows:    3,960
  symbols: 2,471

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-20	AAPL	Stock	1.2438	1.2727	1.2405	1.2582	914922400.0
2005-01-20	MSFT	Stock	25.84	26.1	25.74	25.86	58380100.0
2005-01-20	NVDA	Stock	0.1743	0.1827	0.1743	0.1783	640080000.0
2005-01-20	AMZN	Stock	2.0855	2.198	2.082	2.118	256612000.0
2005-01-20	CL	Stock	25.06	25.23	24.94	25.06	3227800.0
2005-01-20	A	Stock	15.7797	16.1373	15.7725	15.9156	5632961.0
2005-01-20	AABA-DELISTED	Stock	35.3899993896484	36.4199981689453	35.0499992370605	35.7799987792969	30239100.0
2005-01-20	AACC-DELISTED	Stock	20.62	20.95	20.11	20.53	67322.0
2005-01-20	AAI-DELISTED	Stock	8.19	8.27	7.9	7.9	1274300.0
2005-01-20	AAIC-DELISTED	Stock	395.6	397.8	393.2	396.0	966400.0
2005-01-20	AAME	Stock	3.22	3.22	3.09	3.14	8100.0
2005-01-20	AAON	Stock	1.8305	1.8726	1.8305	1.8449	88847.0
2005-01-20	AAP	Stock	29.0333	29.3067	28.5267	28.6267	1112100.0
2005-01-20	AAV-DELISTED	Stock	17.73	17.79	17.58	17.73	37500.0
2005-01-20	AAXN-DELISTED	Stock	16.5400009155273	18.3500003814697	15.8999996185303	17.5699996948242	13517300.0
2005-01-20	ABAX-DELISTED	Stock	12.54	13.15	12.53	13.0	124130.0
2005-01-20	ABB-DELISTED	Stock	5.54	5.54	5.46	5.46	300500.0
2005-01-20	ABBC-DELISTED	Stock	12.95	13.0	12.95	13.0	71222.0
2005-01-20	ABC-DELISTED	Stock	14.4	14.56	14.37	14.5	3094800.0
2005-01-20	ABCB	Stock	15.4974	15.9595	14.8004	15.4407	30475.0
2005-01-20	ABCO-DELISTED	Stock	18.332	18.692	18.213	18.258	76313.0
2005-01-20	ABCW-DELISTED	Stock	27.5	27.6	27.19	27.24	45930.0
2005-01-20	ABE-DELISTED	Stock	9.58	9.58	9.41	9.41	10000.0
2005-01-20	ABFS-DELISTED	Stock	40.86	41.05	39.85	40.02	459420.0
2005-01-20	ABG	Stock	16.5	17.16	16.1	16.68	372200.0
2005-01-20	ABK-DELISTED	Stock	81.45	81.5	80.75	80.93	384200.0
2005-01-20	ABM	Stock	18.2	18.34	18.04	18.15	103700.0
2005-01-20	ABMD-DELISTED	Stock	11.75	11.97	11.25	11.33	128590.0
2005-01-20	ABP-DELISTED	Stock	2.25	2.34	2.21	2.23	174300.0
2005-01-20	ABR	Stock	23.8	23.94	23.59	23.75	108400.0
2005-01-20	ABT	Stock	22.0948	22.2387	21.8309	21.9508	9509796.0
2005-01-20	ABTL-DELISTED	Stock	28.45	28.65	25.8	26.0	172300.0
2005-01-20	ABV-DELISTED	Stock	24.8	24.9	24.28	24.3	819500.0
2005-01-20	ABVA-DELISTED	Stock	16.1	16.16	15.81	15.81	800.0
2005-01-20	ABX-DELISTED	Stock	22.1	22.21	21.98	22.15	1010909.0
2005-01-20	ACAD	Stock	6.61	6.66	6.61	6.65	2600.0
2005-01-20	ACAP-DELISTED	Stock	34.2	34.84	34.13	34.28	31814.0
2005-01-20	ACAS-DELISTED	Stock	32.95	33.1	32.74	32.76	627069.0
2005-01-20	ACAT-DELISTED	Stock	24.19	25.68	24.01	25.06	173049.0
2005-01-20	ACC-DELISTED	Stock	21.9	21.9	21.4	21.42	53800.0
2005-01-20	ACCL-DELISTED	Stock	5.79	5.88	5.1	5.25	407150.0
2005-01-20	ACE-DELISTED	Stock	43.63	43.91	43.03	43.67	2108300.0
2005-01-20	ACF-DELISTED	Stock	24.0	24.0	23.35	23.72	1609600.0
2005-01-20	ACFC-DELISTED	Stock	63.01	63.88	62.81	63.52	3889.0
2005-01-20	ACG-DELISTED	Stock	8.14	8.16	8.12	8.15	283200.0
2005-01-20	ACGL	Stock	4.21	4.21	4.1667	4.1667	1070100.0
2005-01-20	ACGN-DELISTED	Stock	555.3288	566.6712	544.0	566.6712	315200.0
2005-01-20	ACH	Stock	18.3733	18.7733	18.3067	18.4667	260400.0
2005-01-20	ACH-DELISTED	Stock	13.578	13.578	13.396	13.458	159579.0
2005-01-20	ACLS	Stock	28.48	29.04	27.96	28.2	282000.0

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

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