PREVIEW / stock_daily / 2007-10-22

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-22.parquet
  size:    178 KB
  rows:    5,550
  symbols: 3,356

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-22	AAPL	Stock	6.0839	6.2464	6.07	6.2271	1649499600.0
2007-10-22	MSFT	Stock	30.12	30.7	30.12	30.51	58785100.0
2007-10-22	NVDA	Stock	0.9288	0.981	0.9213	0.979	537656000.0
2007-10-22	AMZN	Stock	4.4625	4.5845	4.451	4.5645	197368000.0
2007-10-22	TLT	Stock	90.58	90.65	90.07	90.47	1866500.0
2007-10-22	CL	Stock	35.65	36.445	35.635	36.395	3668000.0
2007-10-22	A	Stock	26.402	26.5308	25.8727	26.1803	1901979.0
2007-10-22	AABA-DELISTED	Stock	28.93	30.0	28.8	29.85	27760469.0
2007-10-22	AACC-DELISTED	Stock	10.5	11.0	10.5	10.92	231559.0
2007-10-22	AAI-DELISTED	Stock	9.46	9.97	9.45	9.76	1375500.0
2007-10-22	AAIC-DELISTED	Stock	84.6	91.2	84.0	90.2	1792566.0
2007-10-22	AAME	Stock	2.6	2.6	2.34	2.42	6700.0
2007-10-22	AAON	Stock	3.3896	3.4726	3.2691	3.3264	972000.0
2007-10-22	AAP	Stock	31.95	33.1	31.69	32.0	1494600.0
2007-10-22	AATI-DELISTED	Stock	11.5	11.5	10.99	11.24	1147061.0
2007-10-22	AAU-DELISTED	Stock	2.6	2.74	2.47	2.68	196900.0
2007-10-22	AAUAF-DELISTED	Stock	2.6	2.74	2.47	2.68	196900.0
2007-10-22	AAV-DELISTED	Stock	12.45	12.5	12.3	12.46	714300.0
2007-10-22	AAWW-DELISTED	Stock	55.98	57.32	55.21	57.2	326783.0
2007-10-22	AAXN-DELISTED	Stock	15.46	17.16	15.05	16.72	3858901.0
2007-10-22	AB	Stock	85.77	87.05	85.0	86.98	174000.0
2007-10-22	ABAX-DELISTED	Stock	23.3	24.14	22.9	24.02	240612.0
2007-10-22	ABB-DELISTED	Stock	26.69	27.14	26.64	27.12	3312955.0
2007-10-22	ABBC-DELISTED	Stock	9.25	9.44	9.2	9.35	51902.0
2007-10-22	ABBNY-DELISTED	Stock	26.69	27.14	26.64	27.09	3209555.0
2007-10-22	ABC-DELISTED	Stock	22.16	22.2	21.64	21.92	2464800.0
2007-10-22	ABCB	Stock	16.9142	17.3811	16.2236	16.9142	72689.0
2007-10-22	ABCO-DELISTED	Stock	29.87	30.47	29.42	30.32	142968.0
2007-10-22	ABCW-DELISTED	Stock	23.74	24.83	23.67	24.83	77430.0
2007-10-22	ABD-DELISTED	Stock	19.98	21.13	19.9	21.01	573810.0
2007-10-22	ABE-DELISTED	Stock	24.27	25.2	23.5	25.2	92300.0
2007-10-22	ABEO	Stock	4750.0	4875.0	4750.0	4875.0	1.0
2007-10-22	ABFS-DELISTED	Stock	30.26	32.04	30.09	31.57	715433.0
2007-10-22	ABG	Stock	18.5	19.9	18.44	19.84	646500.0
2007-10-22	ABK-DELISTED	Stock	56.98	59.23	56.13	58.08	2881500.0
2007-10-22	ABM	Stock	22.16	23.21	21.76	23.09	401800.0
2007-10-22	ABMD-DELISTED	Stock	12.34	13.3	12.26	13.14	213063.0
2007-10-22	ABP-DELISTED	Stock	4.39	4.39	4.06	4.19	271000.0
2007-10-22	ABR	Stock	17.97	18.94	17.81	18.75	160200.0
2007-10-22	ABT	Stock	24.4218	24.8632	24.2347	24.7769	15767403.0
2007-10-22	ABTL-DELISTED	Stock	13.05	13.75	12.7	12.9	15396.0
2007-10-22	ABV-DELISTED	Stock	74.86	76.94	73.36	76.34	720800.0
2007-10-22	ABVT-DELISTED	Stock	82.5	83.0	82.5	83.0	7861.0
2007-10-22	ABX-DELISTED	Stock	40.29	40.92	39.84	40.34	7520472.0
2007-10-22	ACAD	Stock	15.19	15.49	14.74	15.36	225000.0
2007-10-22	ACAP-DELISTED	Stock	38.92	39.36	38.01	39.31	71817.0
2007-10-22	ACAS-DELISTED	Stock	41.25	42.15	40.17	41.85	1162773.0
2007-10-22	ACAT-DELISTED	Stock	15.46	16.49	15.34	16.34	114145.0
2007-10-22	ACC-DELISTED	Stock	27.16	28.16	26.98	28.04	132200.0
2007-10-22	ACCL-DELISTED	Stock	7.04	7.1	6.81	7.09	68031.0

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

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