PREVIEW / stock_daily / 2007-08-15

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-15.parquet
  size:    178 KB
  rows:    5,512
  symbols: 3,321

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-08-15	AAPL	Stock	4.3836	4.4593	4.2732	4.2821	992852000.0
2007-08-15	MSFT	Stock	28.24	28.99	28.05	28.1	48117700.0
2007-08-15	NVDA	Stock	0.7493	0.76	0.7205	0.7215	695142000.0
2007-08-15	AMZN	Stock	3.651	3.7575	3.613	3.619	127518000.0
2007-08-15	TLT	Stock	86.65	86.75	86.25	86.25	1101700.0
2007-08-15	CL	Stock	32.655	33.195	32.365	32.455	6438000.0
2007-08-15	A	Stock	22.4893	23.6552	22.2818	23.1688	11039307.0
2007-08-15	AABA-DELISTED	Stock	23.56	24.0	23.25	23.35	17522636.0
2007-08-15	AACC-DELISTED	Stock	8.83	9.156	8.76	8.76	402096.0
2007-08-15	AAI-DELISTED	Stock	10.35	10.51	9.82	9.86	1497700.0
2007-08-15	AAIC-DELISTED	Stock	88.2	92.8	85.0	86.6	3032152.0
2007-08-15	AAME	Stock	3.08	3.14	3.07	3.14	2100.0
2007-08-15	AAON	Stock	4.0007	4.1679	4.0007	4.0244	410062.0
2007-08-15	AAP	Stock	32.67	33.19	31.46	31.6	1972600.0
2007-08-15	AATI-DELISTED	Stock	8.31	8.86	8.31	8.56	272662.0
2007-08-15	AAU-DELISTED	Stock	2.44	2.45	2.38	2.4	114100.0
2007-08-15	AAUAF-DELISTED	Stock	2.44	2.45	2.38	2.4	114100.0
2007-08-15	AAV-DELISTED	Stock	12.05	12.18	11.6	11.63	753000.0
2007-08-15	AAWW-DELISTED	Stock	51.86	53.39	50.76	50.98	130586.0
2007-08-15	AAXN-DELISTED	Stock	14.1	14.43	13.71	13.79	2429589.0
2007-08-15	AB	Stock	77.27	79.8	76.55	76.94	760500.0
2007-08-15	ABAX-DELISTED	Stock	19.87	20.32	19.14	19.16	170708.0
2007-08-15	ABB-DELISTED	Stock	22.09	22.52	21.76	21.8	3768955.0
2007-08-15	ABBC-DELISTED	Stock	9.03	9.27	8.97	9.01	175274.0
2007-08-15	ABBNY-DELISTED	Stock	22.09	22.52	21.76	21.84	3833355.0
2007-08-15	ABC-DELISTED	Stock	22.72	23.0	22.17	22.36	5719018.0
2007-08-15	ABCB	Stock	18.9665	20.0169	18.7428	18.7428	37835.0
2007-08-15	ABCO-DELISTED	Stock	28.12	28.79	28.05	28.05	212269.0
2007-08-15	ABCW-DELISTED	Stock	23.82	24.65	23.38	23.9	280740.0
2007-08-15	ABD-DELISTED	Stock	22.79	23.95	22.74	23.23	473400.0
2007-08-15	ABE-DELISTED	Stock	19.15	19.52	18.06	18.44	53300.0
2007-08-15	ABEO	Stock	4125.0	4125.0	3825.0	4112.5	10.0
2007-08-15	ABFS-DELISTED	Stock	34.4	35.46	34.32	34.52	389466.0
2007-08-15	ABG	Stock	21.24	21.89	20.42	20.48	500000.0
2007-08-15	ABK-DELISTED	Stock	60.1	61.4	55.79	55.9	7623511.0
2007-08-15	ABM	Stock	22.39	22.77	21.57	21.7	328300.0
2007-08-15	ABMD-DELISTED	Stock	10.8	11.17	10.66	10.94	288135.0
2007-08-15	ABP-DELISTED	Stock	3.95	3.97	3.72	3.74	128500.0
2007-08-15	ABR	Stock	15.79	17.47	13.91	16.85	1354200.0
2007-08-15	ABT	Stock	25.1271	25.7317	24.9496	25.1175	11348479.0
2007-08-15	ABTL-DELISTED	Stock	14.909	15.212	13.949	14.05	24267.0
2007-08-15	ABV-DELISTED	Stock	63.24	64.58	59.6	59.75	889000.0
2007-08-15	ABVA-DELISTED	Stock	9.79	9.99	9.56	9.57	16488.0
2007-08-15	ABVT-DELISTED	Stock	80.0	80.125	80.0	80.0	1312.0
2007-08-15	ABX-DELISTED	Stock	32.25	32.9	31.59	31.7	5085817.0
2007-08-15	ACAD	Stock	15.73	16.02	15.11	15.16	322100.0
2007-08-15	ACAP-DELISTED	Stock	36.33	37.98	36.0	37.42	89930.0
2007-08-15	ACAS-DELISTED	Stock	39.55	39.9	37.45	37.45	3110309.0
2007-08-15	ACAT-DELISTED	Stock	17.21	17.68	16.43	17.22	212456.0
2007-08-15	ACC-DELISTED	Stock	25.96	27.12	25.76	26.03	90578.0

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

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