PREVIEW / stock_daily / 2006-11-06

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-06.parquet
  size:    153 KB
  rows:    4,569
  symbols: 2,896

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-11-06	AAPL	Stock	2.8196	2.8593	2.8011	2.8468	434576800.0
2006-11-06	MSFT	Stock	28.77	29.05	28.76	28.84	60446200.0
2006-11-06	NVDA	Stock	0.5448	0.5673	0.538	0.5598	739602000.0
2006-11-06	AMZN	Stock	1.882	1.9175	1.8765	1.9105	90818000.0
2006-11-06	CL	Stock	31.9	32.1	31.855	32.03	3409400.0
2006-11-06	A	Stock	23.5551	24.3991	23.5336	24.3419	5054189.0
2006-11-06	AABA-DELISTED	Stock	26.3400001525879	26.7000007629395	26.1000003814697	26.5900001525879	22563600.0
2006-11-06	AACC-DELISTED	Stock	16.35	16.7	16.35	16.59	107073.0
2006-11-06	AACQ-DELISTED	Stock	5.46	5.46	5.4	5.43	20600.0
2006-11-06	AACQU-DELISTED	Stock	6.52	6.52	6.52	6.52	5000.0
2006-11-06	AACQW-DELISTED	Stock	0.57	0.57	0.57	0.57	65000.0
2006-11-06	AAI-DELISTED	Stock	9.92	10.15	9.88	10.06	1802100.0
2006-11-06	AAIC-DELISTED	Stock	154.2	156.2	152.6	152.8	980300.0
2006-11-06	AAME	Stock	2.24	2.45	2.24	2.45	8000.0
2006-11-06	AAON	Stock	3.1026	3.1026	2.7681	2.8431	535359.0
2006-11-06	AAP	Stock	36.04	36.4	35.96	36.2	1313800.0
2006-11-06	AATI-DELISTED	Stock	5.74	5.87	5.61	5.72	361949.0
2006-11-06	AAU-DELISTED	Stock	2.69	2.7	2.65	2.66	73000.0
2006-11-06	AAUAF-DELISTED	Stock	2.69	2.7	2.65	2.66	73000.0
2006-11-06	AAV-DELISTED	Stock	12.2	12.4	11.91	11.95	1130200.0
2006-11-06	AAWW-DELISTED	Stock	43.4	43.93	43.2	43.48	183632.0
2006-11-06	AAXN-DELISTED	Stock	8.92000007629395	9.4399995803833	8.80000019073486	9.15999984741211	3433600.0
2006-11-06	AB	Stock	75.99	77.56	75.98	77.22	257700.0
2006-11-06	ABAX-DELISTED	Stock	20.09	20.34	19.7	20.24	205907.0
2006-11-06	ABB-DELISTED	Stock	14.89	15.16	14.89	15.14	1412100.0
2006-11-06	ABBC-DELISTED	Stock	15.9	16.19	15.79	16.15	7162.0
2006-11-06	ABC-DELISTED	Stock	22.7	23.11	22.63	22.9	4580400.0
2006-11-06	ABCB	Stock	26.3489	26.7185	26.3489	26.4267	20563.0
2006-11-06	ABCO-DELISTED	Stock	26.98	28.03	26.98	27.91	260916.0
2006-11-06	ABCW-DELISTED	Stock	28.95	29.15	28.68	29.08	35070.0
2006-11-06	ABD-DELISTED	Stock	24.46	24.93	24.4	24.8	390030.0
2006-11-06	ABE-DELISTED	Stock	16.7	16.8	16.6	16.79	39800.0
2006-11-06	ABFS-DELISTED	Stock	39.32	40.18	39.28	39.7	844605.0
2006-11-06	ABG	Stock	23.27	23.9	23.27	23.68	363700.0
2006-11-06	ABK-DELISTED	Stock	85.0	85.4	84.87	85.31	530700.0
2006-11-06	ABM	Stock	19.95	20.09	19.78	20.03	226800.0
2006-11-06	ABMD-DELISTED	Stock	13.4	13.76	13.37	13.51	107109.0
2006-11-06	ABP-DELISTED	Stock	3.42	3.55	3.35	3.46	216000.0
2006-11-06	ABR	Stock	27.55	27.57	27.19	27.21	100900.0
2006-11-06	ABT	Stock	22.5602	22.8577	22.5506	22.7761	12892664.0
2006-11-06	ABTL-DELISTED	Stock	16.849	16.951	16.44	16.9	21204.0
2006-11-06	ABV-DELISTED	Stock	44.23	44.72	44.21	44.46	646200.0
2006-11-06	ABVA-DELISTED	Stock	16.14	16.38	15.9663	15.9766	2798.0
2006-11-06	ABX-DELISTED	Stock	30.83	30.83	29.96	30.0	5020048.0
2006-11-06	ACAD	Stock	9.98	10.44	9.85	10.4	235000.0
2006-11-06	ACAP-DELISTED	Stock	36.71	36.99	36.2	36.35	35430.0
2006-11-06	ACAS-DELISTED	Stock	41.98	42.57	41.67	42.38	851894.0
2006-11-06	ACAT-DELISTED	Stock	17.22	17.69	17.04	17.57	192205.0
2006-11-06	ACC-DELISTED	Stock	26.65	27.26	26.6	27.24	225100.0
2006-11-06	ACCL-DELISTED	Stock	6.37	6.41	6.32	6.41	34280.0

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

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