PREVIEW / stock_daily / 2006-07-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-18.parquet
  size:    147 KB
  rows:    4,442
  symbols: 2,797

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-18	AAPL	Stock	1.8986	1.9232	1.8518	1.8893	1000448400.0
2006-07-18	MSFT	Stock	22.59	22.76	22.48	22.74	65047300.0
2006-07-18	NVDA	Stock	0.307	0.3162	0.296	0.313	979332000.0
2006-07-18	AMZN	Stock	1.6825	1.7145	1.648	1.6745	104300000.0
2006-07-18	CL	Stock	30.54	30.54	30.16	30.435	3346400.0
2006-07-18	A	Stock	20.6223	20.7439	19.7997	20.2432	3659824.0
2006-07-18	AABA-DELISTED	Stock	32.0800018310547	32.2599983215332	31.25	32.2400016784668	39767700.0
2006-07-18	AACC-DELISTED	Stock	17.91	18.01	17.22	17.87	261501.0
2006-07-18	AACQ-DELISTED	Stock	5.32	5.32	5.32	5.32	2000.0
2006-07-18	AACQW-DELISTED	Stock	0.39	0.39	0.38	0.38	23000.0
2006-07-18	AAI-DELISTED	Stock	12.69	13.22	12.61	13.15	1024700.0
2006-07-18	AAIC-DELISTED	Stock	199.6	201.0	195.6	197.4	977200.0
2006-07-18	AAME	Stock	2.8	2.95	2.8	2.8	2800.0
2006-07-18	AAON	Stock	2.9959	3.1118	2.9393	3.0907	294637.0
2006-07-18	AAP	Stock	28.92	29.05	28.67	28.7	1966800.0
2006-07-18	AATI-DELISTED	Stock	8.57	8.68	8.5	8.63	53315.0
2006-07-18	AAU-DELISTED	Stock	2.44	2.44	2.32	2.35	28400.0
2006-07-18	AAUAF-DELISTED	Stock	2.44	2.44	2.32	2.35	28400.0
2006-07-18	AAV-DELISTED	Stock	15.9	16.06	15.77	15.85	403500.0
2006-07-18	AAWW-DELISTED	Stock	41.67	41.98	40.88	41.11	189437.0
2006-07-18	AAXN-DELISTED	Stock	7.67000007629395	7.73999977111816	7.44999980926514	7.55000019073486	706100.0
2006-07-18	AB	Stock	58.03	58.94	57.7	58.77	272800.0
2006-07-18	ABAX-DELISTED	Stock	19.26	19.55	18.93	19.11	204402.0
2006-07-18	ABB-DELISTED	Stock	11.47	11.55	11.29	11.49	3331600.0
2006-07-18	ABBC-DELISTED	Stock	14.3	14.57	14.23	14.4	18540.0
2006-07-18	ABC-DELISTED	Stock	20.71	20.77	20.44	20.6	1682600.0
2006-07-18	ABCB	Stock	20.62	21.2522	20.4352	20.9604	22002.0
2006-07-18	ABCO-DELISTED	Stock	24.34	24.67	23.79	24.02	322536.0
2006-07-18	ABCW-DELISTED	Stock	28.83	29.35	28.44	29.34	33860.0
2006-07-18	ABD-DELISTED	Stock	19.82	19.97	19.38	19.66	231300.0
2006-07-18	ABE-DELISTED	Stock	11.98	11.98	11.3	11.63	7200.0
2006-07-18	ABFS-DELISTED	Stock	46.2	47.05	46.2	46.81	300617.0
2006-07-18	ABG	Stock	19.7	19.95	19.39	19.76	79800.0
2006-07-18	ABK-DELISTED	Stock	81.15	81.58	80.89	81.09	928600.0
2006-07-18	ABM	Stock	16.52	16.67	16.25	16.6	246700.0
2006-07-18	ABMD-DELISTED	Stock	12.59	13.0	12.25	13.0	74236.0
2006-07-18	ABP-DELISTED	Stock	4.34	4.47	4.2	4.22	127700.0
2006-07-18	ABR	Stock	25.4	25.59	25.04	25.59	58100.0
2006-07-18	ABT	Stock	21.3511	21.5574	21.1592	21.4471	15181951.0
2006-07-18	ABTL-DELISTED	Stock	16.894	17.552	16.439	17.4	55341.0
2006-07-18	ABV-DELISTED	Stock	39.27	39.69	37.94	39.27	1178700.0
2006-07-18	ABVA-DELISTED	Stock	15.9933	15.9933	15.9933	15.9933	400.0
2006-07-18	ABX-DELISTED	Stock	29.5	29.73	28.75	29.05	4138300.0
2006-07-18	ACAD	Stock	6.83	6.94	6.35	6.46	330100.0
2006-07-18	ACAP-DELISTED	Stock	47.11	48.55	47.1	47.45	101491.0
2006-07-18	ACAS-DELISTED	Stock	33.51	33.83	33.07	33.78	1382824.0
2006-07-18	ACAT-DELISTED	Stock	16.88	16.88	16.44	16.54	56194.0
2006-07-18	ACC-DELISTED	Stock	24.84	25.04	24.31	24.93	27973.0
2006-07-18	ACCL-DELISTED	Stock	6.83	6.83	6.49	6.57	66555.0
2006-07-18	ACCO	Stock	19.82	19.97	19.38	19.66	251600.0

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

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