PREVIEW / stock_daily / 2007-10-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-23.parquet
  size:    179 KB
  rows:    5,529
  symbols: 3,347

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
2007-10-23	AAPL	Stock	6.7343	6.7357	6.5271	6.6486	1795164000.0
2007-10-23	MSFT	Stock	30.71	31.12	30.71	30.9	49956200.0
2007-10-23	NVDA	Stock	0.9918	0.9918	0.957	0.9838	294292000.0
2007-10-23	AMZN	Stock	4.764	5.0545	4.7105	5.041	835236000.0
2007-10-23	TLT	Stock	90.26	90.5225	90.1	90.29	1046516.0
2007-10-23	CL	Stock	36.515	36.71	36.255	36.605	3991600.0
2007-10-23	A	Stock	26.4235	26.7382	26.2518	26.7024	1994946.0
2007-10-23	AABA-DELISTED	Stock	30.16	30.88	30.03	30.66	46336829.0
2007-10-23	AACC-DELISTED	Stock	11.0	11.1	10.85	10.98	134350.0
2007-10-23	AAI-DELISTED	Stock	9.64	9.84	9.55	9.73	1719800.0
2007-10-23	AAIC-DELISTED	Stock	91.0	92.4	88.6	89.6	1518000.0
2007-10-23	AAME	Stock	2.53	2.54	2.34	2.44	4600.0
2007-10-23	AAON	Stock	3.3462	3.4015	3.3067	3.36	743681.0
2007-10-23	AAP	Stock	32.23	32.26	31.69	31.85	753800.0
2007-10-23	AATI-DELISTED	Stock	11.25	12.15	11.22	12.12	595104.0
2007-10-23	AAU-DELISTED	Stock	2.83	2.87	2.75	2.87	51900.0
2007-10-23	AAUAF-DELISTED	Stock	2.83	2.87	2.75	2.87	51700.0
2007-10-23	AAV-DELISTED	Stock	12.49	12.7	12.49	12.7	837500.0
2007-10-23	AAWW-DELISTED	Stock	57.22	57.55	56.87	57.4	170204.0
2007-10-23	AAXN-DELISTED	Stock	16.92	17.27	16.35	17.2401	3111226.0
2007-10-23	AB	Stock	86.89	88.77	86.48	88.77	193700.0
2007-10-23	ABAX-DELISTED	Stock	24.26	24.75	24.17	24.61	276527.0
2007-10-23	ABB-DELISTED	Stock	27.79	27.99	27.61	27.98	3134500.0
2007-10-23	ABBC-DELISTED	Stock	9.4	9.47	9.36	9.43	31728.0
2007-10-23	ABBNY-DELISTED	Stock	27.79	27.99	27.61	27.95	3138300.0
2007-10-23	ABC-DELISTED	Stock	21.96	22.38	21.89	22.38	2177200.0
2007-10-23	ABCB	Stock	16.9824	17.0602	16.1848	16.8072	48014.0
2007-10-23	ABCO-DELISTED	Stock	30.6	31.21	30.08	30.74	112161.0
2007-10-23	ABCW-DELISTED	Stock	25.02	25.02	24.19	24.92	105400.0
2007-10-23	ABD-DELISTED	Stock	21.17	21.25	20.76	21.06	402100.0
2007-10-23	ABE-DELISTED	Stock	25.27	26.46	25.12	26.46	34300.0
2007-10-23	ABEO	Stock	4875.0	4875.0	4575.0	4687.5	4.0
2007-10-23	ABFS-DELISTED	Stock	31.94	32.09	31.14	31.71	249006.0
2007-10-23	ABG	Stock	19.95	19.95	19.2	19.42	355000.0
2007-10-23	ABK-DELISTED	Stock	58.92	59.21	55.0	55.99	5491048.0
2007-10-23	ABM	Stock	23.34	23.46	22.58	22.85	260100.0
2007-10-23	ABMD-DELISTED	Stock	13.25	13.25	12.79	13.0	106538.0
2007-10-23	ABP-DELISTED	Stock	4.24	4.25	4.11	4.23	120900.0
2007-10-23	ABR	Stock	18.9	19.19	18.37	18.56	207900.0
2007-10-23	ABT	Stock	24.3594	25.1175	24.3594	24.8632	8735932.0
2007-10-23	ABTL-DELISTED	Stock	13.236	14.204	13.084	14.0	7035.0
2007-10-23	ABV-DELISTED	Stock	78.23	80.17	77.55	79.68	564900.0
2007-10-23	ABVA-DELISTED	Stock	9.66	9.66	9.51	9.51	700.0
2007-10-23	ABVT-DELISTED	Stock	83.0	85.0	83.0	85.0	19745.0
2007-10-23	ABX-DELISTED	Stock	40.96	41.88	40.77	41.8	6348600.0
2007-10-23	ACAD	Stock	15.44	15.44	15.0	15.14	134300.0
2007-10-23	ACAP-DELISTED	Stock	39.47	40.54	39.31	40.24	74689.0
2007-10-23	ACAS-DELISTED	Stock	41.95	42.59	41.57	42.56	887057.0
2007-10-23	ACAT-DELISTED	Stock	16.55	16.61	16.1	16.57	69732.0
2007-10-23	ACC-DELISTED	Stock	28.3	28.34	27.53	28.12	96200.0

> showing 50 of 5,529 rows — these rows as CSV

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