PREVIEW / stock_daily / 2006-08-23

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-23.parquet
  size:    148 KB
  rows:    4,453
  symbols: 2,801

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-08-23	AAPL	Stock	2.4286	2.4518	2.3907	2.4039	536258800.0
2006-08-23	MSFT	Stock	25.65	25.95	25.52	25.67	44648500.0
2006-08-23	NVDA	Stock	0.4418	0.4463	0.4285	0.4382	485412000.0
2006-08-23	AMZN	Stock	1.428	1.4445	1.3885	1.407	94528000.0
2006-08-23	CL	Stock	29.43	29.72	29.4	29.61	2196400.0
2006-08-23	A	Stock	22.0315	22.289	21.8312	21.8455	1795451.0
2006-08-23	AABA-DELISTED	Stock	29.3400001525879	29.4699993133545	28.6800003051758	28.7000007629395	8837400.0
2006-08-23	AACC-DELISTED	Stock	15.38	15.57	15.18	15.23	145354.0
2006-08-23	AACQ-DELISTED	Stock	5.3	5.31	5.3	5.3	29200.0
2006-08-23	AAI-DELISTED	Stock	11.72	11.87	11.36	11.56	715000.0
2006-08-23	AAIC-DELISTED	Stock	177.0	178.2	172.8	173.0	1022100.0
2006-08-23	AAON	Stock	3.1078	3.1078	2.9564	2.9564	108591.0
2006-08-23	AAP	Stock	29.8	29.8	29.45	29.6	611300.0
2006-08-23	AATI-DELISTED	Stock	9.38	9.5	9.25	9.25	88129.0
2006-08-23	AAU-DELISTED	Stock	2.74	2.8	2.74	2.77	45600.0
2006-08-23	AAUAF-DELISTED	Stock	2.74	2.8	2.74	2.77	45600.0
2006-08-23	AAV-DELISTED	Stock	16.1	16.25	16.03	16.03	429000.0
2006-08-23	AAWW-DELISTED	Stock	42.12	42.12	40.98	41.39	43533.0
2006-08-23	AAXN-DELISTED	Stock	7.8600001335144	7.86999988555908	7.5	7.53000020980835	828900.0
2006-08-23	AB	Stock	67.2	67.44	66.17	66.4	182200.0
2006-08-23	ABAX-DELISTED	Stock	23.14	23.44	22.23	22.36	81097.0
2006-08-23	ABB-DELISTED	Stock	13.36	13.37	13.2	13.27	1136700.0
2006-08-23	ABBC-DELISTED	Stock	14.52	14.52	14.228	14.228	4700.0
2006-08-23	ABC-DELISTED	Stock	22.18	22.2	21.88	22.04	2149000.0
2006-08-23	ABCB	Stock	24.8316	25.3081	24.6662	24.7927	19534.0
2006-08-23	ABCO-DELISTED	Stock	24.51	24.78	24.17	24.27	126382.0
2006-08-23	ABCW-DELISTED	Stock	28.89	29.1	28.61	28.77	48710.0
2006-08-23	ABD-DELISTED	Stock	21.52	21.8	20.82	20.96	244300.0
2006-08-23	ABE-DELISTED	Stock	13.05	13.24	13.0	13.11	21100.0
2006-08-23	ABFS-DELISTED	Stock	43.2	43.66	42.37	43.08	282352.0
2006-08-23	ABG	Stock	20.0	20.15	19.65	19.69	37300.0
2006-08-23	ABK-DELISTED	Stock	85.58	85.82	85.21	85.3	826300.0
2006-08-23	ABM	Stock	17.72	17.82	17.51	17.71	184500.0
2006-08-23	ABMD-DELISTED	Stock	13.33	13.39	12.92	12.95	74839.0
2006-08-23	ABP-DELISTED	Stock	4.23	4.24	4.12	4.21	156000.0
2006-08-23	ABR	Stock	25.27	25.27	24.68	24.7	73600.0
2006-08-23	ABT	Stock	23.5006	23.587	23.395	23.5102	9183618.0
2006-08-23	ABTL-DELISTED	Stock	14.799	15.115	14.451	14.451	33116.0
2006-08-23	ABV-DELISTED	Stock	43.33	43.63	42.54	42.54	396700.0
2006-08-23	ABVA-DELISTED	Stock	16.5	16.76	16.5	16.76	2504.0
2006-08-23	ABX-DELISTED	Stock	33.58	34.1	33.28	33.44	4294600.0
2006-08-23	ACAD	Stock	7.42	7.83	7.37	7.71	211700.0
2006-08-23	ACAP-DELISTED	Stock	49.5	49.5	48.56	48.91	18207.0
2006-08-23	ACAS-DELISTED	Stock	37.95	38.1	37.55	37.65	726733.0
2006-08-23	ACAT-DELISTED	Stock	18.26	18.4	17.52	17.84	97508.0
2006-08-23	ACC-DELISTED	Stock	25.3	25.43	25.11	25.18	76300.0
2006-08-23	ACCL-DELISTED	Stock	6.16	6.23	6.03	6.04	21926.0
2006-08-23	ACCO	Stock	21.52	21.8	20.83	20.96	268000.0
2006-08-23	ACCP-DELISTED	Stock	0.5	0.75	0.5	0.7	88500.0
2006-08-23	ACE-DELISTED	Stock	51.96	52.36	51.94	52.28	528981.0

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

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