PREVIEW / stock_daily / 2006-06-21

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-21.parquet
  size:    147 KB
  rows:    4,427
  symbols: 2,786

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-21	AAPL	Stock	2.0621	2.0968	2.0464	2.0664	863296000.0
2006-06-21	MSFT	Stock	22.61	23.15	22.53	23.08	91660300.0
2006-06-21	NVDA	Stock	0.3432	0.354	0.3432	0.3485	441174000.0
2006-06-21	AMZN	Stock	1.767	1.8525	1.767	1.8325	157306000.0
2006-06-21	CL	Stock	30.235	30.315	30.06	30.17	4772200.0
2006-06-21	A	Stock	23.0114	23.5193	23.0114	23.3619	1933714.0
2006-06-21	AABA-DELISTED	Stock	30.7700004577637	31.5400009155273	30.6499996185303	31.0599994659424	18252900.0
2006-06-21	AACC-DELISTED	Stock	18.85	19.26	18.8348	19.25	242500.0
2006-06-21	AACQW-DELISTED	Stock	0.43	0.43	0.43	0.43	1500.0
2006-06-21	AAI-DELISTED	Stock	14.14	14.73	14.09	14.44	1749200.0
2006-06-21	AAIC-DELISTED	Stock	202.2	209.2	202.2	208.2	664500.0
2006-06-21	AAME	Stock	3.12	3.25	3.12	3.12	6300.0
2006-06-21	AAON	Stock	2.7984	2.884	2.7984	2.8589	100997.0
2006-06-21	AAP	Stock	36.95	37.61	36.75	37.41	374900.0
2006-06-21	AATI-DELISTED	Stock	9.84	10.04	9.51	9.94	252977.0
2006-06-21	AAU-DELISTED	Stock	2.4	2.43	2.3	2.3501	21700.0
2006-06-21	AAUAF-DELISTED	Stock	2.4	2.43	2.3	2.3501	21700.0
2006-06-21	AAV-DELISTED	Stock	18.29	18.5	18.28	18.39	279200.0
2006-06-21	AAWW-DELISTED	Stock	50.03	50.03	49.95	50.0	46569.0
2006-06-21	AAXN-DELISTED	Stock	8.14999961853027	8.31999969482422	8.0600004196167	8.22999954223633	728200.0
2006-06-21	AB	Stock	58.95	59.67	58.61	59.12	166300.0
2006-06-21	ABAX-DELISTED	Stock	19.5	20.62	19.5	20.25	314983.0
2006-06-21	ABB-DELISTED	Stock	12.05	12.45	12.03	12.31	4053000.0
2006-06-21	ABBC-DELISTED	Stock	14.96	15.41	14.88	15.13	23150.0
2006-06-21	ABC-DELISTED	Stock	20.34	20.72	20.31	20.58	2873800.0
2006-06-21	ABCB	Stock	20.0851	20.8534	20.0851	20.6589	15422.0
2006-06-21	ABCO-DELISTED	Stock	23.28	24.39	23.28	23.77	193182.0
2006-06-21	ABCW-DELISTED	Stock	28.5	29.25	28.5	28.93	51700.0
2006-06-21	ABD-DELISTED	Stock	22.1	22.28	21.94	21.99	213700.0
2006-06-21	ABE-DELISTED	Stock	12.0	12.18	11.85	11.96	23400.0
2006-06-21	ABFS-DELISTED	Stock	41.68	43.29	41.66	43.14	469217.0
2006-06-21	ABG	Stock	20.8	21.14	20.8	21.03	55700.0
2006-06-21	ABK-DELISTED	Stock	79.61	80.16	79.39	79.79	691000.0
2006-06-21	ABM	Stock	17.64	17.93	17.58	17.82	180800.0
2006-06-21	ABMD-DELISTED	Stock	12.0	12.5	11.97	12.46	44640.0
2006-06-21	ABP-DELISTED	Stock	4.4	4.64	4.37	4.55	211900.0
2006-06-21	ABR	Stock	23.6	23.9	23.6	23.78	78700.0
2006-06-21	ABT	Stock	20.2716	20.4203	20.2428	20.2811	7060442.0
2006-06-21	ABTL-DELISTED	Stock	14.85	15.85	14.85	15.8	61244.0
2006-06-21	ABV-DELISTED	Stock	37.85	38.77	37.65	38.53	555400.0
2006-06-21	ABVA-DELISTED	Stock	16.78	16.88	16.454	16.83	2000.0
2006-06-21	ABX-DELISTED	Stock	27.64	28.48	27.62	28.32	4279700.0
2006-06-21	ACAD	Stock	8.38	8.66	8.32	8.41	297900.0
2006-06-21	ACAP-DELISTED	Stock	45.63	47.76	45.63	47.46	56442.0
2006-06-21	ACAS-DELISTED	Stock	32.9	32.97	32.65	32.85	680714.0
2006-06-21	ACAT-DELISTED	Stock	17.27	17.46	17.07	17.44	33299.0
2006-06-21	ACC-DELISTED	Stock	23.96	24.9	23.96	24.28	65600.0
2006-06-21	ACCL-DELISTED	Stock	7.07	7.14	7.03	7.05	67886.0
2006-06-21	ACCO	Stock	22.1	22.28	21.94	21.99	226800.0
2006-06-21	ACCP-DELISTED	Stock	1.05	1.05	0.9	0.9	5600.0

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

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