PREVIEW / stock_daily / 2007-08-01

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-01.parquet
  size:    179 KB
  rows:    5,496
  symbols: 3,301

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-01	AAPL	Stock	4.7729	4.835	4.5632	4.8214	1750156800.0
2007-08-01	MSFT	Stock	28.95	29.55	28.82	29.3	80006300.0
2007-08-01	NVDA	Stock	0.7517	0.7702	0.7217	0.757	705828000.0
2007-08-01	AMZN	Stock	3.905	3.9075	3.753	3.8655	338360000.0
2007-08-01	TLT	Stock	87.26	87.54	87.09	87.13	2154651.0
2007-08-01	CL	Stock	33.38	33.775	33.075	33.645	7164400.0
2007-08-01	A	Stock	27.2175	27.7468	27.0529	27.2961	7229058.0
2007-08-01	AABA-DELISTED	Stock	23.17	23.4	22.85	23.26	20378542.0
2007-08-01	AACC-DELISTED	Stock	13.88	13.88	13.37	13.5	235149.0
2007-08-01	AAI-DELISTED	Stock	9.75	9.92	9.53	9.7	2209400.0
2007-08-01	AAIC-DELISTED	Stock	98.0	98.0	87.6	91.6	6284719.0
2007-08-01	AAME	Stock	3.14	3.28	3.14	3.24	5600.0
2007-08-01	AAON	Stock	3.9045	4.1363	3.8874	4.1192	735834.0
2007-08-01	AAP	Stock	34.67	35.14	33.87	34.4	2446200.0
2007-08-01	AATI-DELISTED	Stock	8.93	8.93	8.35	8.58	632690.0
2007-08-01	AAU-DELISTED	Stock	2.51	2.54	2.48	2.5	37200.0
2007-08-01	AAUAF-DELISTED	Stock	2.51	2.54	2.48	2.5	37000.0
2007-08-01	AAV-DELISTED	Stock	12.69	12.75	12.3	12.52	667500.0
2007-08-01	AAWW-DELISTED	Stock	54.23	55.1999	53.15	55.06	83384.0
2007-08-01	AAXN-DELISTED	Stock	14.95	15.17	14.365	14.55	3586444.0
2007-08-01	AB	Stock	83.99	84.39	80.59	83.74	602900.0
2007-08-01	ABAX-DELISTED	Stock	18.12	18.53	17.85	18.29	289226.0
2007-08-01	ABB-DELISTED	Stock	23.93	24.08	23.29	23.75	5336090.0
2007-08-01	ABBC-DELISTED	Stock	9.35	9.35	9.0	9.04	282386.0
2007-08-01	ABBNY-DELISTED	Stock	23.93	24.08	23.29	23.8	5474490.0
2007-08-01	ABC-DELISTED	Stock	23.5	24.0	22.75	23.04	2780646.0
2007-08-01	ABCB	Stock	17.3422	18.0133	17.1379	17.809	108879.0
2007-08-01	ABCO-DELISTED	Stock	25.7	26.25	25.51	26.25	305889.0
2007-08-01	ABCW-DELISTED	Stock	22.26	22.56	21.85	22.35	287750.0
2007-08-01	ABD-DELISTED	Stock	19.79	21.6	19.79	21.05	591980.0
2007-08-01	ABE-DELISTED	Stock	21.31	21.31	20.59	21.15	30600.0
2007-08-01	ABEO	Stock	5375.0	5500.0	5312.5	5437.5	6.0
2007-08-01	ABFS-DELISTED	Stock	36.18	36.7899	35.11	36.72	634392.0
2007-08-01	ABG	Stock	22.12	22.37	21.74	22.14	700200.0
2007-08-01	ABK-DELISTED	Stock	67.15	67.55	58.41	65.44	11039337.0
2007-08-01	ABM	Stock	25.14	25.72	24.54	25.12	493400.0
2007-08-01	ABMD-DELISTED	Stock	10.28	10.38	10.01	10.25	405539.0
2007-08-01	ABP-DELISTED	Stock	3.81	4.01	3.75	3.98	155900.0
2007-08-01	ABR	Stock	19.25	19.45	16.76	18.52	1391400.0
2007-08-01	ABT	Stock	24.2155	24.6473	24.0284	24.4458	16760317.0
2007-08-01	ABTL-DELISTED	Stock	17.853	17.953	15.897	15.997	29349.0
2007-08-01	ABV-DELISTED	Stock	67.84	68.3	66.22	67.49	958100.0
2007-08-01	ABVA-DELISTED	Stock	11.66	11.96	11.66	11.92	1500.0
2007-08-01	ABX-DELISTED	Stock	32.57	33.19	32.26	32.73	5666896.0
2007-08-01	ACAD	Stock	13.92	14.24	13.89	14.22	298900.0
2007-08-01	ACAP-DELISTED	Stock	37.65	38.4	37.56	38.11	106369.0
2007-08-01	ACAS-DELISTED	Stock	38.5	39.28	35.95	37.14	7935607.0
2007-08-01	ACAT-DELISTED	Stock	18.12	18.5	17.86	18.04	186028.0
2007-08-01	ACC-DELISTED	Stock	25.57	25.91	24.76	25.5	390100.0
2007-08-01	ACCL-DELISTED	Stock	6.57	7.01	6.57	6.77	64109.0

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

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