PREVIEW / stock_daily / 2005-11-18

all stock daily files

  file:    by_date/stock_daily/2005/2005-11-18.parquet
  size:    143 KB
  rows:    4,261
  symbols: 2,686

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-11-18	AAPL	Stock	2.3325	2.3368	2.2989	2.3057	524960800.0
2005-11-18	MSFT	Stock	28.12	28.25	27.9	28.07	75431200.0
2005-11-18	NVDA	Stock	0.3032	0.3057	0.2957	0.3016	465768000.0
2005-11-18	AMZN	Stock	2.345	2.4	2.333	2.399	1186656000.0
2005-11-18	CL	Stock	27.295	27.295	26.735	26.93	5701200.0
2005-11-18	A	Stock	24.8856	25.0	24.7353	24.9714	6885150.0
2005-11-18	AABA-DELISTED	Stock	42.0400009155273	42.4099998474121	41.2900009155273	41.5400009155273	30747600.0
2005-11-18	AACC-DELISTED	Stock	19.99	20.58	19.84	20.5	352193.0
2005-11-18	AACQ-DELISTED	Stock	5.08	5.08	5.08	5.08	500.0
2005-11-18	AACQW-DELISTED	Stock	0.42	0.43	0.42	0.43	19000.0
2005-11-18	AAI-DELISTED	Stock	16.62	16.7	15.53	15.94	1950400.0
2005-11-18	AAIC-DELISTED	Stock	180.2	185.4	180.0	185.2	1592000.0
2005-11-18	AAON	Stock	2.1821	2.2347	2.1755	2.2281	34172.0
2005-11-18	AAP	Stock	40.71	41.1	40.12	41.02	660000.0
2005-11-18	AATI-DELISTED	Stock	12.4	12.86	12.16	12.81	78689.0
2005-11-18	AAV-DELISTED	Stock	16.96	17.0	16.73	16.96	27100.0
2005-11-18	AAWW-DELISTED	Stock	31.25	31.3	31.0	31.3	40700.0
2005-11-18	AAXN-DELISTED	Stock	7.44999980926514	7.44999980926514	7.13000011444092	7.15999984741211	1300600.0
2005-11-18	ABAX-DELISTED	Stock	18.09	18.11	17.54	17.86	158895.0
2005-11-18	ABB-DELISTED	Stock	8.345	8.42	8.34	8.41	2698700.0
2005-11-18	ABBC-DELISTED	Stock	12.15	12.24	12.15	12.24	13357.0
2005-11-18	ABC-DELISTED	Stock	19.57	19.62	19.38	19.5	1851200.0
2005-11-18	ABCB	Stock	19.9003	19.9003	19.4626	19.5793	7814.0
2005-11-18	ABCO-DELISTED	Stock	24.21	24.21	23.91	24.02	150470.0
2005-11-18	ABCW-DELISTED	Stock	30.29	30.49	30.1	30.28	138870.0
2005-11-18	ABD-DELISTED	Stock	23.69	24.0	23.23	23.81	231330.0
2005-11-18	ABE-DELISTED	Stock	11.42	11.48	11.4001	11.47	21300.0
2005-11-18	ABFS-DELISTED	Stock	42.33	42.37	41.5	42.0	308175.0
2005-11-18	ABG	Stock	16.25	16.55	16.08	16.49	36000.0
2005-11-18	ABK-DELISTED	Stock	76.81	77.0	76.3	76.9	377000.0
2005-11-18	ABM	Stock	20.63	20.91	20.41	20.9	146100.0
2005-11-18	ABMD-DELISTED	Stock	9.08	9.08	8.89	8.99	68963.0
2005-11-18	ABP-DELISTED	Stock	6.45	6.52	6.29	6.33	205300.0
2005-11-18	ABR	Stock	27.6	27.6	27.25	27.37	56700.0
2005-11-18	ABT	Stock	19.9117	19.9117	19.4895	19.6238	8543977.0
2005-11-18	ABTL-DELISTED	Stock	24.73	25.77	24.48	25.62	62606.0
2005-11-18	ABV-DELISTED	Stock	37.88	37.88	37.24	37.38	164700.0
2005-11-18	ABVA-DELISTED	Stock	16.75	16.75	16.5	16.5	2640.0
2005-11-18	ABX-DELISTED	Stock	26.93	26.93	26.4	26.77	2366708.0
2005-11-18	ACAD	Stock	9.89	9.89	9.4	9.49	81400.0
2005-11-18	ACAP-DELISTED	Stock	45.13	45.14	44.28	44.39	21183.0
2005-11-18	ACAS-DELISTED	Stock	38.46	38.58	37.85	38.21	3741640.0
2005-11-18	ACAT-DELISTED	Stock	19.395	19.535	19.205	19.225	64692.0
2005-11-18	ACC-DELISTED	Stock	25.52	25.52	25.18	25.39	38500.0
2005-11-18	ACCL-DELISTED	Stock	7.9	8.08	7.73	7.99	167887.0
2005-11-18	ACCO	Stock	23.69	24.0	23.23	23.81	235000.0
2005-11-18	ACE-DELISTED	Stock	55.66	55.89	55.12	55.75	981500.0
2005-11-18	ACF-DELISTED	Stock	23.95	24.09	23.71	24.03	1011200.0
2005-11-18	ACFC-DELISTED	Stock	73.32	74.49	73.32	74.29	1470.0
2005-11-18	ACG-DELISTED	Stock	8.19	8.23	8.17	8.23	305600.0

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

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