PREVIEW / stock_daily / 2006-06-22

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-22.parquet
  size:    146 KB
  rows:    4,408
  symbols: 2,780

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-06-22	AAPL	Stock	2.0786	2.1339	2.0739	2.1279	965633200.0
2006-06-22	MSFT	Stock	23.06	23.17	22.78	22.88	76590600.0
2006-06-22	NVDA	Stock	0.3523	0.3533	0.336	0.3383	532338000.0
2006-06-22	AMZN	Stock	1.8275	1.8425	1.8055	1.8185	94640000.0
2006-06-22	CL	Stock	30.2	30.2	29.925	30.15	3118400.0
2006-06-22	A	Stock	23.2904	23.4049	22.9614	23.083	1848436.0
2006-06-22	AABA-DELISTED	Stock	30.8500003814697	31.1599998474121	30.4400005340576	30.6800003051758	11500300.0
2006-06-22	AACC-DELISTED	Stock	19.17	19.55	19.17	19.35	150234.0
2006-06-22	AACQU-DELISTED	Stock	6.2	6.25	6.2	6.25	5500.0
2006-06-22	AACQW-DELISTED	Stock	0.47	0.47	0.47	0.47	40000.0
2006-06-22	AAI-DELISTED	Stock	14.5	14.68	14.21	14.5	1267900.0
2006-06-22	AAIC-DELISTED	Stock	208.8	209.2	199.2	199.2	1269500.0
2006-06-22	AAME	Stock	3.11	3.18	3.06	3.06	7300.0
2006-06-22	AAON	Stock	2.83	2.8537	2.7786	2.8155	101756.0
2006-06-22	AAP	Stock	37.33	37.54	36.83	37.07	377700.0
2006-06-22	AATI-DELISTED	Stock	9.95	10.0	9.79	9.96	71162.0
2006-06-22	AAU-DELISTED	Stock	2.35	2.35	2.3	2.3	33500.0
2006-06-22	AAUAF-DELISTED	Stock	2.35	2.35	2.3	2.3	33500.0
2006-06-22	AAV-DELISTED	Stock	18.35	18.45	17.9	17.92	533700.0
2006-06-22	AAWW-DELISTED	Stock	50.0	50.0	49.79	49.9	84854.0
2006-06-22	AAXN-DELISTED	Stock	8.1899995803833	8.1899995803833	8.0	8.05000019073486	610500.0
2006-06-22	AB	Stock	59.35	59.35	58.53	58.92	112300.0
2006-06-22	ABAX-DELISTED	Stock	20.18	20.5	20.05	20.4	177539.0
2006-06-22	ABB-DELISTED	Stock	12.19	12.28	12.01	12.19	962300.0
2006-06-22	ABBC-DELISTED	Stock	15.28	15.43	15.013	15.38	24323.0
2006-06-22	ABC-DELISTED	Stock	20.52	20.72	20.34	20.38	3185200.0
2006-06-22	ABCB	Stock	20.4352	20.9409	20.0072	20.299	30124.0
2006-06-22	ABCO-DELISTED	Stock	23.65	24.13	23.65	23.69	206991.0
2006-06-22	ABCW-DELISTED	Stock	28.91	28.91	28.5	28.66	38250.0
2006-06-22	ABD-DELISTED	Stock	21.95	22.08	21.91	21.98	313240.0
2006-06-22	ABE-DELISTED	Stock	11.99	12.09	11.97	11.97	8300.0
2006-06-22	ABFS-DELISTED	Stock	44.16	45.96	44.16	45.89	1271749.0
2006-06-22	ABG	Stock	20.92	20.92	20.45	20.65	87900.0
2006-06-22	ABK-DELISTED	Stock	79.65	80.01	79.35	79.69	602300.0
2006-06-22	ABM	Stock	17.72	17.75	17.48	17.58	148500.0
2006-06-22	ABMD-DELISTED	Stock	12.41	12.45	11.9	12.07	41881.0
2006-06-22	ABP-DELISTED	Stock	4.56	4.6	4.45	4.47	133000.0
2006-06-22	ABR	Stock	23.78	24.05	23.72	23.98	99000.0
2006-06-22	ABT	Stock	20.2811	20.3675	20.0796	20.1708	7091705.0
2006-06-22	ABTL-DELISTED	Stock	15.701	15.801	15.049	15.049	27607.0
2006-06-22	ABV-DELISTED	Stock	38.54	38.96	37.94	38.6	496600.0
2006-06-22	ABVA-DELISTED	Stock	16.45	16.918	16.45	16.918	200.0
2006-06-22	ABVT-DELISTED	Stock	45.0	45.0	45.0	45.0	100.0
2006-06-22	ABX-DELISTED	Stock	28.18	28.24	27.57	27.88	3512400.0
2006-06-22	ACAD	Stock	8.4	8.44	8.1	8.12	146000.0
2006-06-22	ACAP-DELISTED	Stock	47.66	48.19	46.76	47.22	34442.0
2006-06-22	ACAS-DELISTED	Stock	32.95	33.06	32.6	32.79	583266.0
2006-06-22	ACAT-DELISTED	Stock	17.34	17.77	17.31	17.72	37270.0
2006-06-22	ACC-DELISTED	Stock	24.28	24.4	23.78	24.34	75600.0
2006-06-22	ACCL-DELISTED	Stock	7.01	7.15	7.0	7.13	39359.0

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

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