PREVIEW / stock_daily / 2007-07-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-23.parquet
  size:    178 KB
  rows:    5,461
  symbols: 3,290

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-07-23	AAPL	Stock	5.1182	5.1864	5.0332	5.1321	1036490000.0
2007-07-23	MSFT	Stock	31.36	31.52	31.12	31.19	48910600.0
2007-07-23	NVDA	Stock	0.749	0.7747	0.7473	0.7592	360474000.0
2007-07-23	AMZN	Stock	3.589	3.6335	3.5425	3.587	185356000.0
2007-07-23	TLT	Stock	85.69	85.97	85.69	85.82	777900.0
2007-07-23	CL	Stock	33.955	34.485	33.905	34.34	4834600.0
2007-07-23	A	Stock	28.6123	28.8054	28.1688	28.4907	3477665.0
2007-07-23	AABA-DELISTED	Stock	25.43	25.46	24.98	24.99	19979494.0
2007-07-23	AACC-DELISTED	Stock	14.97	15.15	14.95	15.02	194713.0
2007-07-23	AAI-DELISTED	Stock	10.27	10.39	10.18	10.29	1600880.0
2007-07-23	AAIC-DELISTED	Stock	98.8	100.6	97.4	98.8	2152097.0
2007-07-23	AAME	Stock	3.7	3.9	3.7	3.81	9100.0
2007-07-23	AAON	Stock	4.322	4.3707	4.2851	4.318	299194.0
2007-07-23	AAP	Stock	39.02	39.28	38.67	38.89	494300.0
2007-07-23	AATI-DELISTED	Stock	10.0	10.03	9.76	9.8	332485.0
2007-07-23	AAU-DELISTED	Stock	2.74	2.75	2.67	2.75	181600.0
2007-07-23	AAUAF-DELISTED	Stock	2.74	2.75	2.6701	2.75	181600.0
2007-07-23	AAV-DELISTED	Stock	13.8	13.87	13.48	13.54	927200.0
2007-07-23	AAWW-DELISTED	Stock	59.23	60.01	58.34	58.83	147103.0
2007-07-23	AAXN-DELISTED	Stock	19.16	19.36	16.52	16.59	17240345.0
2007-07-23	AB	Stock	86.3	89.12	86.3	87.35	185800.0
2007-07-23	ABAX-DELISTED	Stock	18.6	18.72	18.4	18.62	590033.0
2007-07-23	ABB-DELISTED	Stock	24.26	24.29	24.08	24.15	2155200.0
2007-07-23	ABBC-DELISTED	Stock	9.53	9.64	9.49	9.56	133764.0
2007-07-23	ABBNY-DELISTED	Stock	24.26	24.29	24.08	24.16	2157900.0
2007-07-23	ABC-DELISTED	Stock	24.34	24.7	24.3	24.52	1316600.0
2007-07-23	ABCB	Stock	20.0656	20.1629	19.6862	19.7933	59734.0
2007-07-23	ABCO-DELISTED	Stock	27.66	27.81	27.42	27.42	225570.0
2007-07-23	ABCW-DELISTED	Stock	23.36	23.84	23.05	23.18	134620.0
2007-07-23	ABD-DELISTED	Stock	21.97	22.1	21.64	21.76	204800.0
2007-07-23	ABE-DELISTED	Stock	23.06	23.1199	22.85	22.85	18500.0
2007-07-23	ABEO	Stock	5375.0	5500.0	5375.0	5387.5	4.0
2007-07-23	ABFS-DELISTED	Stock	40.22	40.22	38.27	38.5	797210.0
2007-07-23	ABG	Stock	23.79	23.79	23.36	23.6	588400.0
2007-07-23	ABK-DELISTED	Stock	81.05	81.53	80.08	80.32	1631000.0
2007-07-23	ABM	Stock	24.44	25.01	24.26	24.28	242000.0
2007-07-23	ABMD-DELISTED	Stock	10.86	10.93	10.51	10.8	123155.0
2007-07-23	ABP-DELISTED	Stock	4.4	4.5	4.12	4.16	222900.0
2007-07-23	ABR	Stock	24.4	24.66	23.69	24.02	235600.0
2007-07-23	ABT	Stock	25.5973	26.341	25.5398	25.8708	13106086.0
2007-07-23	ABTL-DELISTED	Stock	20.54	21.04	19.94	20.108	33833.0
2007-07-23	ABV-DELISTED	Stock	76.01	77.12	75.39	76.75	476200.0
2007-07-23	ABVA-DELISTED	Stock	12.43	12.52	12.4	12.52	7230.0
2007-07-23	ABVT-DELISTED	Stock	73.5	73.5	73.5	73.5	25000.0
2007-07-23	ABX-DELISTED	Stock	34.31	34.65	34.15	34.59	4783496.0
2007-07-23	ACAD	Stock	13.7	13.98	13.65	13.68	194500.0
2007-07-23	ACAP-DELISTED	Stock	36.87	38.48	36.61	38.33	336545.0
2007-07-23	ACAS-DELISTED	Stock	43.48	44.33	43.31	43.34	2297242.0
2007-07-23	ACAT-DELISTED	Stock	19.75	19.89	19.4	19.42	77246.0
2007-07-23	ACC-DELISTED	Stock	27.77	27.8	27.04	27.07	73881.0

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

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