PREVIEW / stock_daily / 2006-09-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-19.parquet
  size:    150 KB
  rows:    4,504
  symbols: 2,848

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-09-19	AAPL	Stock	2.6464	2.6557	2.6	2.6346	710049200.0
2006-09-19	MSFT	Stock	26.74	26.94	26.72	26.86	43039100.0
2006-09-19	NVDA	Stock	0.508	0.5117	0.4938	0.498	708054000.0
2006-09-19	AMZN	Stock	1.612	1.615	1.541	1.579	171440000.0
2006-09-19	CL	Stock	30.875	31.0	30.75	30.92	1842400.0
2006-09-19	A	Stock	22.3176	22.5107	22.0601	22.4964	3791935.0
2006-09-19	AABA-DELISTED	Stock	29.0900001525879	29.1299991607666	25.1000003814697	25.75	127718600.0
2006-09-19	AACC-DELISTED	Stock	15.05	15.05	14.03	14.5	194188.0
2006-09-19	AACQ-DELISTED	Stock	5.35	5.37	5.35	5.37	580500.0
2006-09-19	AAI-DELISTED	Stock	9.77	10.2	9.77	10.12	2901400.0
2006-09-19	AAIC-DELISTED	Stock	167.2	170.0	164.8	168.4	835300.0
2006-09-19	AAME	Stock	2.64	2.75	2.32	2.47	35200.0
2006-09-19	AAON	Stock	2.9643	3.0288	2.905	2.9959	129094.0
2006-09-19	AAP	Stock	31.99	33.18	31.97	32.48	1350800.0
2006-09-19	AATI-DELISTED	Stock	7.88	8.0	7.5	7.74	346816.0
2006-09-19	AAU-DELISTED	Stock	2.4	2.4	2.3099	2.3103	24200.0
2006-09-19	AAUAF-DELISTED	Stock	2.4	2.4001	2.3101	2.3105	24200.0
2006-09-19	AAV-DELISTED	Stock	14.2	14.25	14.0	14.0	386700.0
2006-09-19	AAWW-DELISTED	Stock	43.98	44.03	43.65	43.91	223968.0
2006-09-19	AAXN-DELISTED	Stock	7.3899998664856	7.51999998092651	7.32999992370605	7.40999984741211	526600.0
2006-09-19	AB	Stock	68.62	68.63	66.68	66.84	451100.0
2006-09-19	ABAX-DELISTED	Stock	23.2	23.59	23.01	23.56	138262.0
2006-09-19	ABB-DELISTED	Stock	13.42	13.42	13.24	13.31	1536600.0
2006-09-19	ABBC-DELISTED	Stock	15.21	15.21	14.88	14.98	6818.0
2006-09-19	ABC-DELISTED	Stock	23.2	23.46	23.12	23.12	2457600.0
2006-09-19	ABCB	Stock	26.2516	26.31	25.0553	25.454	22927.0
2006-09-19	ABCO-DELISTED	Stock	25.32	25.4	24.65	24.98	132544.0
2006-09-19	ABCW-DELISTED	Stock	28.88	29.47	28.55	29.06	20480.0
2006-09-19	ABD-DELISTED	Stock	20.3	20.38	19.75	20.0	294200.0
2006-09-19	ABE-DELISTED	Stock	14.25	14.35	14.15	14.19	33000.0
2006-09-19	ABFS-DELISTED	Stock	43.58	43.58	42.12	43.52	848331.0
2006-09-19	ABG	Stock	18.95	18.96	18.43	18.55	4162900.0
2006-09-19	ABK-DELISTED	Stock	83.2	83.25	82.43	82.85	1048100.0
2006-09-19	ABM	Stock	18.75	18.87	18.6	18.77	273000.0
2006-09-19	ABMD-DELISTED	Stock	15.14	15.2	14.59	14.99	86078.0
2006-09-19	ABP-DELISTED	Stock	3.56	3.75	3.36	3.73	637500.0
2006-09-19	ABR	Stock	25.75	25.75	25.37	25.58	54400.0
2006-09-19	ABT	Stock	23.2319	23.6158	23.1791	23.587	10486661.0
2006-09-19	ABTL-DELISTED	Stock	15.7	16.2	15.45	15.5	17362.0
2006-09-19	ABV-DELISTED	Stock	45.56	45.56	44.6	44.9	518400.0
2006-09-19	ABVA-DELISTED	Stock	16.9	16.9	16.9	16.9	800.0
2006-09-19	ABVT-DELISTED	Stock	48.55	48.55	48.5	48.5	500.0
2006-09-19	ABX-DELISTED	Stock	29.7	30.0	28.7208	28.77	5851600.0
2006-09-19	ACAD	Stock	8.41	8.73	7.89	8.02	325000.0
2006-09-19	ACAP-DELISTED	Stock	51.49	51.49	49.95	50.77	23728.0
2006-09-19	ACAS-DELISTED	Stock	38.37	38.55	38.27	38.5	589085.0
2006-09-19	ACAT-DELISTED	Stock	16.75	16.82	15.52	16.18	142038.0
2006-09-19	ACC-DELISTED	Stock	25.55	25.66	25.4	25.62	208000.0
2006-09-19	ACCL-DELISTED	Stock	5.55	5.55	5.46	5.5	28564.0
2006-09-19	ACCO	Stock	20.3	20.38	19.75	20.0	312200.0

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

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