PREVIEW / stock_daily / 2006-07-17

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-17.parquet
  size:    148 KB
  rows:    4,472
  symbols: 2,824

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-07-17	AAPL	Stock	1.8475	1.8968	1.8446	1.8704	1024542400.0
2006-07-17	MSFT	Stock	22.29	22.61	22.26	22.48	37053500.0
2006-07-17	NVDA	Stock	0.2932	0.3002	0.2917	0.2968	502806000.0
2006-07-17	AMZN	Stock	1.6395	1.6965	1.6395	1.6835	143946000.0
2006-07-17	CL	Stock	30.475	30.655	30.365	30.44	3821400.0
2006-07-17	A	Stock	20.4936	20.6652	20.4077	20.6295	3440478.0
2006-07-17	AABA-DELISTED	Stock	31.9799995422363	32.4000015258789	31.6900005340576	31.8400001525879	16369600.0
2006-07-17	AACC-DELISTED	Stock	17.62	18.32	17.59	17.77	414797.0
2006-07-17	AACQ-DELISTED	Stock	5.32	5.34	5.32	5.34	3000.0
2006-07-17	AACQU-DELISTED	Stock	6.15	6.15	6.15	6.15	2500.0
2006-07-17	AACQW-DELISTED	Stock	0.42	0.42	0.39	0.39	94055.0
2006-07-17	AAI-DELISTED	Stock	12.77	13.15	12.61	12.71	1229700.0
2006-07-17	AAIC-DELISTED	Stock	196.8	201.6	195.2	198.4	1937300.0
2006-07-17	AAME	Stock	2.8	2.87	2.8	2.82	5000.0
2006-07-17	AAON	Stock	2.8945	3.0064	2.8945	2.959	106312.0
2006-07-17	AAP	Stock	28.92	29.25	28.74	28.96	1357600.0
2006-07-17	AATI-DELISTED	Stock	8.44	8.73	8.44	8.52	91737.0
2006-07-17	AAU-DELISTED	Stock	2.55	2.55	2.34	2.36	61000.0
2006-07-17	AAUAF-DELISTED	Stock	2.55	2.55	2.34	2.36	61000.0
2006-07-17	AAV-DELISTED	Stock	16.3	16.3	15.75	15.8	668600.0
2006-07-17	AAWW-DELISTED	Stock	41.69	41.69	40.05	41.0	115279.0
2006-07-17	AAXN-DELISTED	Stock	7.63000011444092	7.94000005722046	7.59000015258789	7.59999990463257	469400.0
2006-07-17	AB	Stock	57.4	58.29	57.32	57.83	165600.0
2006-07-17	ABAX-DELISTED	Stock	18.99	19.13	18.81	19.04	168273.0
2006-07-17	ABB-DELISTED	Stock	11.42	11.55	11.36	11.53	1632000.0
2006-07-17	ABBC-DELISTED	Stock	14.34	14.34	14.14	14.16	32104.0
2006-07-17	ABC-DELISTED	Stock	20.84	21.01	20.68	20.72	2240000.0
2006-07-17	ABCB	Stock	20.5714	20.9312	20.4741	20.62	18095.0
2006-07-17	ABCO-DELISTED	Stock	23.74	24.26	23.7	24.14	145467.0
2006-07-17	ABCW-DELISTED	Stock	28.5	28.84	28.41	28.57	24560.0
2006-07-17	ABD-DELISTED	Stock	20.16	20.18	19.54	19.7	275800.0
2006-07-17	ABE-DELISTED	Stock	11.41	12.33	11.41	11.98	15600.0
2006-07-17	ABFS-DELISTED	Stock	45.67	46.92	45.67	46.18	311864.0
2006-07-17	ABG	Stock	19.83	20.23	19.77	19.86	125900.0
2006-07-17	ABK-DELISTED	Stock	81.1	81.45	80.64	81.16	1070000.0
2006-07-17	ABM	Stock	16.4	16.72	16.34	16.42	112200.0
2006-07-17	ABMD-DELISTED	Stock	12.66	12.8	12.41	12.47	65484.0
2006-07-17	ABP-DELISTED	Stock	4.5	4.65	4.31	4.32	362000.0
2006-07-17	ABR	Stock	25.29	25.31	24.85	25.3	62600.0
2006-07-17	ABT	Stock	21.0632	21.3847	21.0632	21.3415	9870988.0
2006-07-17	ABTL-DELISTED	Stock	16.85	17.25	16.3	16.6	29368.0
2006-07-17	ABV-DELISTED	Stock	38.7	39.08	37.93	38.85	839900.0
2006-07-17	ABVA-DELISTED	Stock	15.98	16.068	15.96	16.046	4765.0
2006-07-17	ABX-DELISTED	Stock	29.9	30.46	29.44	29.47	4548800.0
2006-07-17	ACAD	Stock	7.47	7.6	6.77	6.77	452500.0
2006-07-17	ACAP-DELISTED	Stock	48.15	48.44	46.79	46.91	28483.0
2006-07-17	ACAS-DELISTED	Stock	33.49	33.68	33.31	33.42	724581.0
2006-07-17	ACAT-DELISTED	Stock	16.96	17.18	16.52	16.6	26093.0
2006-07-17	ACC-DELISTED	Stock	24.03	24.71	24.03	24.6	59730.0
2006-07-17	ACCL-DELISTED	Stock	6.73	6.86	6.73	6.86	29836.0

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

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