PREVIEW / stock_daily / 2007-11-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-16.parquet
  size:    179 KB
  rows:    5,577
  symbols: 3,369

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-11-16	AAPL	Stock	5.9036	5.965	5.6904	5.9425	1383494000.0
2007-11-16	MSFT	Stock	33.86	34.26	33.71	34.09	71113800.0
2007-11-16	NVDA	Stock	0.8	0.8135	0.7935	0.8113	423592000.0
2007-11-16	AMZN	Stock	3.8505	3.9495	3.8315	3.93	142282000.0
2007-11-16	TLT	Stock	92.27	92.7	92.21	92.41	1333749.0
2007-11-16	CL	Stock	39.16	39.525	38.95	39.4	7075000.0
2007-11-16	A	Stock	25.0286	26.4378	24.9857	26.2661	8877440.0
2007-11-16	AABA-DELISTED	Stock	25.66	27.13	25.1	26.82	53064129.0
2007-11-16	AACC-DELISTED	Stock	10.36	10.99	10.36	10.91	215210.0
2007-11-16	AAI-DELISTED	Stock	9.21	9.26	8.88	9.2	1151200.0
2007-11-16	AAIC-DELISTED	Stock	71.8	72.6	67.0	67.4	1652101.0
2007-11-16	AAME	Stock	2.19	2.24	2.19	2.23	5600.0
2007-11-16	AAON	Stock	3.6168	3.6701	3.5556	3.6168	645469.0
2007-11-16	AAP	Stock	35.42	35.65	34.53	34.8	1456200.0
2007-11-16	AATI-DELISTED	Stock	11.14	11.1899	10.72	10.84	398890.0
2007-11-16	AAU-DELISTED	Stock	2.75	2.9	2.74	2.76	117800.0
2007-11-16	AAUAF-DELISTED	Stock	2.75	2.9	2.74	2.7601	117900.0
2007-11-16	AAV-DELISTED	Stock	10.8	11.08	10.7	10.88	672802.0
2007-11-16	AAWW-DELISTED	Stock	55.96	55.96	55.4	55.75	168703.0
2007-11-16	AAXN-DELISTED	Stock	14.13	14.19	13.42	13.66	1879236.0
2007-11-16	AB	Stock	77.0	78.03	75.3	76.49	316500.0
2007-11-16	ABAX-DELISTED	Stock	32.3	33.99	32.25	33.45	659031.0
2007-11-16	ABB-DELISTED	Stock	27.7	27.95	27.24	27.9	5005491.0
2007-11-16	ABBC-DELISTED	Stock	9.05	9.07	8.92	8.99	35148.0
2007-11-16	ABBNY-DELISTED	Stock	27.7	27.97	27.24	27.97	5005491.0
2007-11-16	ABC-DELISTED	Stock	22.24	22.56	22.18	22.54	3025800.0
2007-11-16	ABCB	Stock	14.434	14.473	13.8115	14.4145	48116.0
2007-11-16	ABCO-DELISTED	Stock	31.46	31.9	31.16	31.81	282602.0
2007-11-16	ABCW-DELISTED	Stock	25.08	25.22	24.24	24.81	110610.0
2007-11-16	ABD-DELISTED	Stock	19.41	19.701	18.889	19.32	274640.0
2007-11-16	ABE-DELISTED	Stock	25.0	25.0	23.998	24.76	25700.0
2007-11-16	ABEO	Stock	3750.0	3750.0	3750.0	3750.0	9.0
2007-11-16	ABFS-DELISTED	Stock	24.99	24.99	23.19	23.55	1000363.0
2007-11-16	ABG	Stock	17.6	17.92	17.45	17.6	407900.0
2007-11-16	ABII-DELISTED	Stock	59.01	59.01	56.0	58.0	148166.0
2007-11-16	ABK-DELISTED	Stock	28.78	29.0	27.15	27.47	6207655.0
2007-11-16	ABM	Stock	21.43	21.47	20.4	21.1	373100.0
2007-11-16	ABMD-DELISTED	Stock	12.11	12.37	11.82	12.28	236342.0
2007-11-16	ABP-DELISTED	Stock	3.76	3.84	3.65	3.67	210300.0
2007-11-16	ABR	Stock	17.65	17.94	17.0	17.52	262600.0
2007-11-16	ABT	Stock	26.3026	26.4946	26.1299	26.4898	13482493.0
2007-11-16	ABTL-DELISTED	Stock	15.503	16.094	15.405	15.7	16022.0
2007-11-16	ABV-DELISTED	Stock	74.73	75.24	73.53	74.75	758880.0
2007-11-16	ABVA-DELISTED	Stock	7.76	7.76	7.5	7.5	13988.0
2007-11-16	ABVT-DELISTED	Stock	81.5	82.25	81.25	82.25	6000.0
2007-11-16	ABX-DELISTED	Stock	40.91	41.25	40.27	40.96	8160267.0
2007-11-16	ACAD	Stock	11.24	11.44	11.0	11.28	514700.0
2007-11-16	ACAP-DELISTED	Stock	41.18	42.8	40.75	42.0	79708.0
2007-11-16	ACAS-DELISTED	Stock	38.78	39.15	38.27	38.98	4311443.0
2007-11-16	ACAT-DELISTED	Stock	12.96	12.99	12.53	12.58	143171.0

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

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