PREVIEW / stock_daily / 2007-10-17

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-17.parquet
  size:    179 KB
  rows:    5,545
  symbols: 3,358

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-17	AAPL	Stock	6.1675	6.18	6.0421	6.1696	1127613200.0
2007-10-17	MSFT	Stock	30.75	31.23	30.65	31.08	86092400.0
2007-10-17	NVDA	Stock	0.9538	0.9912	0.9528	0.9885	717944000.0
2007-10-17	AMZN	Stock	4.595	4.595	4.453	4.5275	153574000.0
2007-10-17	TLT	Stock	87.77	88.95	87.77	88.64	2377000.0
2007-10-17	CL	Stock	36.675	36.795	36.335	36.425	4859800.0
2007-10-17	A	Stock	27.5751	27.7897	27.1602	27.4464	3214841.0
2007-10-17	AABA-DELISTED	Stock	29.1	29.2	28.0	28.83	75193083.0
2007-10-17	AACC-DELISTED	Stock	10.85	10.9	10.5	10.87	214073.0
2007-10-17	AAI-DELISTED	Stock	9.76	9.82	9.59	9.66	1466600.0
2007-10-17	AAIC-DELISTED	Stock	94.0	94.4	90.4	91.8	1991800.0
2007-10-17	AAME	Stock	2.46	2.57	2.46	2.57	5200.0
2007-10-17	AAON	Stock	3.9012	3.9052	3.6701	3.757	292612.0
2007-10-17	AAP	Stock	33.75	33.85	32.46	33.12	1370000.0
2007-10-17	AATI-DELISTED	Stock	11.94	12.02	11.8	11.97	278797.0
2007-10-17	AAU-DELISTED	Stock	3.01	3.05	2.85	2.87	173100.0
2007-10-17	AAUAF-DELISTED	Stock	3.01	3.05	2.85	2.87	173100.0
2007-10-17	AAV-DELISTED	Stock	12.35	12.57	12.3	12.51	905400.0
2007-10-17	AAWW-DELISTED	Stock	56.48	56.75	56.1	56.59	100863.0
2007-10-17	AAXN-DELISTED	Stock	17.25	17.45	16.21	16.69	2273828.0
2007-10-17	AB	Stock	87.7	89.96	87.38	88.3	300600.0
2007-10-17	ABAX-DELISTED	Stock	25.1	25.42	24.42	24.8	171670.0
2007-10-17	ABB-DELISTED	Stock	28.03	28.14	27.64	27.95	2885300.0
2007-10-17	ABBC-DELISTED	Stock	9.66	9.74	9.53	9.69	21809.0
2007-10-17	ABBNY-DELISTED	Stock	28.03	28.14	27.64	27.93	2887400.0
2007-10-17	ABC-DELISTED	Stock	22.2	22.99	22.2	22.33	2071600.0
2007-10-17	ABCB	Stock	18.2857	18.2857	17.5757	18.0619	49144.0
2007-10-17	ABCO-DELISTED	Stock	30.5	30.6	29.8	30.08	131636.0
2007-10-17	ABCW-DELISTED	Stock	25.76	25.88	25.1	25.49	99000.0
2007-10-17	ABD-DELISTED	Stock	20.92	20.97	20.24	20.64	426100.0
2007-10-17	ABE-DELISTED	Stock	27.65	29.2	26.15	26.15	70340.0
2007-10-17	ABEO	Stock	4637.5	4812.5	4625.0	4750.0	4.0
2007-10-17	ABFS-DELISTED	Stock	32.66	33.17	31.75	32.02	381463.0
2007-10-17	ABG	Stock	19.9	19.9	19.01	19.41	771000.0
2007-10-17	ABK-DELISTED	Stock	64.38	65.49	61.5	63.0	3503700.0
2007-10-17	ABM	Stock	23.45	23.75	22.86	23.25	452700.0
2007-10-17	ABMD-DELISTED	Stock	12.93	13.08	12.44	12.82	173530.0
2007-10-17	ABP-DELISTED	Stock	4.32	4.55	4.25	4.33	174400.0
2007-10-17	ABR	Stock	18.65	19.01	18.1	18.54	155200.0
2007-10-17	ABT	Stock	24.9976	25.4678	24.4794	24.5658	28645477.0
2007-10-17	ABTL-DELISTED	Stock	14.195	14.205	13.355	13.505	34690.0
2007-10-17	ABV-DELISTED	Stock	76.95	77.51	75.51	77.18	662500.0
2007-10-17	ABVA-DELISTED	Stock	9.7697	9.7697	9.7697	9.7697	100.0
2007-10-17	ABVT-DELISTED	Stock	82.0	82.5	79.0	82.5	21834.0
2007-10-17	ABX-DELISTED	Stock	42.52	42.75	40.62	40.73	9090056.0
2007-10-17	ACAD	Stock	15.0	15.53	14.91	15.24	267700.0
2007-10-17	ACAP-DELISTED	Stock	41.8	42.16	41.42	41.92	59108.0
2007-10-17	ACAS-DELISTED	Stock	43.56	43.68	42.31	43.17	1262342.0
2007-10-17	ACAT-DELISTED	Stock	16.52	16.57	15.8	16.09	95373.0
2007-10-17	ACC-DELISTED	Stock	29.0	29.0	27.89	28.69	244300.0

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

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