PREVIEW / stock_daily / 2006-06-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-19.parquet
  size:    147 KB
  rows:    4,426
  symbols: 2,789

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-19	AAPL	Stock	2.0654	2.0779	2.0357	2.0429	704575200.0
2006-06-19	MSFT	Stock	22.14	22.6	22.12	22.55	129640900.0
2006-06-19	NVDA	Stock	0.365	0.3668	0.3493	0.3502	388044000.0
2006-06-19	AMZN	Stock	1.76	1.774	1.752	1.7535	84232000.0
2006-06-19	CL	Stock	30.345	30.445	30.005	30.18	3947800.0
2006-06-19	A	Stock	23.8913	23.9914	23.0687	23.1474	2779084.0
2006-06-19	AABA-DELISTED	Stock	30.5100002288818	30.75	30.0599994659424	30.3500003814697	12236700.0
2006-06-19	AACC-DELISTED	Stock	19.1	19.37	19.0	19.02	337019.0
2006-06-19	AACQU-DELISTED	Stock	6.25	6.25	6.25	6.25	2500.0
2006-06-19	AACQW-DELISTED	Stock	0.48	0.5	0.45	0.47	137600.0
2006-06-19	AAI-DELISTED	Stock	13.77	14.18	13.77	14.09	1634900.0
2006-06-19	AAIC-DELISTED	Stock	202.2	204.2	196.4	197.2	751200.0
2006-06-19	AAME	Stock	3.05	3.12	3.05	3.12	4400.0
2006-06-19	AAON	Stock	2.8958	2.9077	2.8379	2.876	84291.0
2006-06-19	AAP	Stock	37.56	37.75	36.92	37.26	801400.0
2006-06-19	AATI-DELISTED	Stock	10.41	10.57	9.88	9.98	109739.0
2006-06-19	AAU-DELISTED	Stock	2.35	2.41	2.3	2.3	15600.0
2006-06-19	AAUAF-DELISTED	Stock	2.35	2.41	2.3	2.3	15600.0
2006-06-19	AAV-DELISTED	Stock	18.75	18.75	18.15	18.2	283500.0
2006-06-19	AAWW-DELISTED	Stock	49.75	50.5	49.47	50.0	101026.0
2006-06-19	AAXN-DELISTED	Stock	8.22999954223633	8.25	8.0	8.02000045776367	665700.0
2006-06-19	AB	Stock	60.05	60.25	58.8	59.12	148500.0
2006-06-19	ABAX-DELISTED	Stock	19.46	19.66	19.16	19.4	300818.0
2006-06-19	ABB-DELISTED	Stock	11.93	11.94	11.54	11.59	2367400.0
2006-06-19	ABBC-DELISTED	Stock	15.49	15.49	14.63	14.75	56312.0
2006-06-19	ABC-DELISTED	Stock	20.74	20.83	20.52	20.54	1838200.0
2006-06-19	ABCB	Stock	20.6491	20.6491	20.0461	20.2212	23441.0
2006-06-19	ABCO-DELISTED	Stock	23.93	23.96	23.46	23.59	134430.0
2006-06-19	ABCW-DELISTED	Stock	29.05	29.24	28.37	28.43	121290.0
2006-06-19	ABD-DELISTED	Stock	21.97	22.16	21.93	22.03	178190.0
2006-06-19	ABE-DELISTED	Stock	12.4	12.46	12.1	12.1	21600.0
2006-06-19	ABFS-DELISTED	Stock	42.25	42.48	41.25	41.97	342184.0
2006-06-19	ABG	Stock	21.44	21.44	20.66	20.78	65700.0
2006-06-19	ABK-DELISTED	Stock	79.0	85.0	78.94	79.56	1000500.0
2006-06-19	ABM	Stock	17.54	17.86	17.42	17.5	167200.0
2006-06-19	ABMD-DELISTED	Stock	12.91	12.94	12.23	12.37	101418.0
2006-06-19	ABP-DELISTED	Stock	4.7	4.7	4.51	4.55	123300.0
2006-06-19	ABR	Stock	23.8	23.83	23.4	23.65	178100.0
2006-06-19	ABT	Stock	20.6122	20.6122	20.2668	20.3051	6850771.0
2006-06-19	ABTL-DELISTED	Stock	15.43	15.43	14.881	15.02	47320.0
2006-06-19	ABV-DELISTED	Stock	37.0	38.1	36.84	37.2	980800.0
2006-06-19	ABVA-DELISTED	Stock	16.77	16.77	16.58	16.65	27300.0
2006-06-19	ABX-DELISTED	Stock	27.4	27.72	27.1	27.27	4282500.0
2006-06-19	ACAD	Stock	8.89	8.92	8.57	8.58	170000.0
2006-06-19	ACAP-DELISTED	Stock	46.12	46.12	44.98	45.28	26577.0
2006-06-19	ACAS-DELISTED	Stock	33.19	33.19	32.69	32.82	676252.0
2006-06-19	ACAT-DELISTED	Stock	17.08	17.105	16.56	16.78	48171.0
2006-06-19	ACC-DELISTED	Stock	23.9	24.02	23.7	23.81	45000.0
2006-06-19	ACCL-DELISTED	Stock	6.92	7.23	6.92	7.08	78749.0
2006-06-19	ACCO	Stock	21.97	22.16	21.93	22.03	178200.0

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

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