PREVIEW / stock_daily / 2006-01-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-19.parquet
  size:    145 KB
  rows:    4,335
  symbols: 2,746

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
2006-01-19	AAPL	Stock	2.9018	2.9164	2.8121	2.8229	1695848000.0
2006-01-19	MSFT	Stock	26.87	27.24	26.85	27.02	60367600.0
2006-01-19	NVDA	Stock	0.3606	0.3805	0.3599	0.3756	914760000.0
2006-01-19	AMZN	Stock	2.2245	2.262	2.215	2.2225	103138000.0
2006-01-19	CL	Stock	27.375	27.55	27.25	27.505	5214600.0
2006-01-19	A	Stock	24.6781	25.2146	24.671	25.0358	4376159.0
2006-01-19	AABA-DELISTED	Stock	35.8199996948242	35.8400001525879	34.2400016784668	34.3300018310547	60913000.0
2006-01-19	AACC-DELISTED	Stock	23.66	23.75	23.29	23.36	58747.0
2006-01-19	AACQ-DELISTED	Stock	5.22	5.55	5.22	5.23	21500.0
2006-01-19	AACQW-DELISTED	Stock	0.62	0.63	0.62	0.63	12500.0
2006-01-19	AAI-DELISTED	Stock	14.22	14.45	14.03	14.24	1423500.0
2006-01-19	AAIC-DELISTED	Stock	214.0	221.6	214.0	221.4	795500.0
2006-01-19	AAME	Stock	2.66	2.66	2.66	2.66	2500.0
2006-01-19	AAON	Stock	2.4059	2.4691	2.4059	2.4652	129853.0
2006-01-19	AAP	Stock	43.22	43.34	41.87	42.18	1583100.0
2006-01-19	AATI-DELISTED	Stock	14.2	14.3	14.11	14.25	145407.0
2006-01-19	AAU-DELISTED	Stock	2.46	2.58	2.46	2.57	114689.0
2006-01-19	AAUAF-DELISTED	Stock	2.48	2.6	2.48	2.59	113800.0
2006-01-19	AAV-DELISTED	Stock	18.76	19.1	18.7	18.95	181800.0
2006-01-19	AAWW-DELISTED	Stock	44.83	44.9	44.7	44.9	37400.0
2006-01-19	AAXN-DELISTED	Stock	8.32999992370605	8.5	8.23999977111816	8.44999980926514	1548300.0
2006-01-19	ABAX-DELISTED	Stock	17.81	17.99	17.75	17.99	92756.0
2006-01-19	ABB-DELISTED	Stock	10.83	10.94	10.77	10.86	1640500.0
2006-01-19	ABBC-DELISTED	Stock	13.15	13.197	13.15	13.19	531.0
2006-01-19	ABC-DELISTED	Stock	20.54	20.62	20.4	20.48	3149000.0
2006-01-19	ABCB	Stock	19.6473	19.8322	19.4529	19.6765	7300.0
2006-01-19	ABCO-DELISTED	Stock	23.05	23.14	22.92	22.99	199060.0
2006-01-19	ABCW-DELISTED	Stock	31.78	31.94	31.29	31.89	29360.0
2006-01-19	ABD-DELISTED	Stock	24.26	24.6	24.26	24.46	229300.0
2006-01-19	ABE-DELISTED	Stock	12.43	12.67	12.37	12.67	33800.0
2006-01-19	ABFS-DELISTED	Stock	44.11	45.2	43.86	45.12	173119.0
2006-01-19	ABG	Stock	16.42	16.66	16.2	16.58	58800.0
2006-01-19	ABK-DELISTED	Stock	76.6	76.83	75.53	75.66	437200.0
2006-01-19	ABM	Stock	19.54	19.54	19.33	19.35	125700.0
2006-01-19	ABMD-DELISTED	Stock	10.29	10.3	10.02	10.3	54834.0
2006-01-19	ABP-DELISTED	Stock	6.32	6.66	6.1	6.56	979000.0
2006-01-19	ABR	Stock	26.57	26.7	26.22	26.45	93500.0
2006-01-19	ABT	Stock	19.6958	20.0221	19.3839	19.9309	10509379.0
2006-01-19	ABTL-DELISTED	Stock	25.22	25.43	24.87	25.33	26440.0
2006-01-19	ABV-DELISTED	Stock	40.34	40.789	40.3	40.53	508900.0
2006-01-19	ABVA-DELISTED	Stock	16.52	16.8	16.506	16.8	1700.0
2006-01-19	ABX-DELISTED	Stock	29.53	30.4002	29.38	30.34	5215751.0
2006-01-19	ACAD	Stock	10.86	11.0	10.77	10.86	87500.0
2006-01-19	ACAP-DELISTED	Stock	48.28	49.48	48.24	48.96	15485.0
2006-01-19	ACAS-DELISTED	Stock	35.04	35.1	34.42	34.48	1777517.0
2006-01-19	ACAT-DELISTED	Stock	22.83	22.83	22.45	22.65	40414.0
2006-01-19	ACC-DELISTED	Stock	24.63	25.12	24.59	24.85	420900.0
2006-01-19	ACCL-DELISTED	Stock	6.98	6.98	6.71	6.78	114135.0
2006-01-19	ACCO	Stock	24.26	24.6	24.26	24.46	229300.0
2006-01-19	ACE-DELISTED	Stock	55.03	55.28	54.5	54.52	845632.0

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

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