PREVIEW / stock_daily / 2007-08-07

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-07.parquet
  size:    178 KB
  rows:    5,490
  symbols: 3,312

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-07	AAPL	Stock	4.8193	4.9014	4.7368	4.8225	949936400.0
2007-08-07	MSFT	Stock	29.33	29.79	29.05	29.55	49163000.0
2007-08-07	NVDA	Stock	0.715	0.7382	0.7055	0.7263	565764000.0
2007-08-07	AMZN	Stock	3.9275	4.0	3.8945	3.957	161186000.0
2007-08-07	TLT	Stock	87.43	87.71	86.92	87.22	2573800.0
2007-08-07	CL	Stock	34.035	34.565	33.47	34.405	7487800.0
2007-08-07	A	Stock	27.0386	27.6753	27.0029	27.3963	4139059.0
2007-08-07	AABA-DELISTED	Stock	22.75	23.7	22.694	23.43	18794930.0
2007-08-07	AACC-DELISTED	Stock	10.26	10.26	9.03	9.299	541018.0
2007-08-07	AAI-DELISTED	Stock	9.54	10.21	9.51	9.84	2317000.0
2007-08-07	AAIC-DELISTED	Stock	91.0	99.4	88.8	96.6	3347035.0
2007-08-07	AAME	Stock	2.68	2.92	2.51	2.66	32500.0
2007-08-07	AAON	Stock	4.401	4.5695	4.2864	4.5445	1217278.0
2007-08-07	AAP	Stock	33.94	34.32	33.4	33.82	2190800.0
2007-08-07	AATI-DELISTED	Stock	7.95	8.09	7.4	7.68	744742.0
2007-08-07	AAU-DELISTED	Stock	2.59	2.67	2.57	2.66	44600.0
2007-08-07	AAUAF-DELISTED	Stock	2.59	2.67	2.57	2.66	44600.0
2007-08-07	AAV-DELISTED	Stock	11.45	11.82	11.45	11.76	891300.0
2007-08-07	AAWW-DELISTED	Stock	53.32	54.41	52.63	54.3	199980.0
2007-08-07	AAXN-DELISTED	Stock	13.9	14.57	13.48	14.57	2929780.0
2007-08-07	AB	Stock	85.15	86.59	84.48	85.88	318000.0
2007-08-07	ABAX-DELISTED	Stock	18.83	19.6	18.44	19.41	358586.0
2007-08-07	ABB-DELISTED	Stock	23.18	23.61	23.04	23.45	3242200.0
2007-08-07	ABBC-DELISTED	Stock	8.8	8.9	8.8	8.86	78911.0
2007-08-07	ABBNY-DELISTED	Stock	23.18	23.6074	23.04	23.4	3325900.0
2007-08-07	ABC-DELISTED	Stock	23.64	23.64	22.8	22.83	4392200.0
2007-08-07	ABCB	Stock	18.1106	18.2468	17.2839	17.9258	80811.0
2007-08-07	ABCO-DELISTED	Stock	27.22	27.75	27.16	27.75	426118.0
2007-08-07	ABCW-DELISTED	Stock	23.12	23.38	22.71	23.08	186140.0
2007-08-07	ABD-DELISTED	Stock	22.43	25.5	22.12	24.98	1291050.0
2007-08-07	ABE-DELISTED	Stock	20.66	21.09	20.39	20.65	36000.0
2007-08-07	ABEO	Stock	5312.5	5312.5	5062.5	5062.5	8.0
2007-08-07	ABFS-DELISTED	Stock	35.61	36.15	34.74	35.82	776321.0
2007-08-07	ABG	Stock	20.87	20.99	20.1	20.44	715700.0
2007-08-07	ABK-DELISTED	Stock	62.61	71.1	62.61	66.8	5677100.0
2007-08-07	ABM	Stock	22.44	22.73	20.98	21.3	588400.0
2007-08-07	ABMD-DELISTED	Stock	10.97	11.78	10.89	11.72	370862.0
2007-08-07	ABP-DELISTED	Stock	3.74	3.85	3.62	3.75	271900.0
2007-08-07	ABR	Stock	19.13	19.53	18.7	18.83	403900.0
2007-08-07	ABT	Stock	26.2259	26.4322	25.1895	26.0531	25201542.0
2007-08-07	ABTL-DELISTED	Stock	15.155	15.896	14.563	15.55	28429.0
2007-08-07	ABV-DELISTED	Stock	65.57	67.39	65.34	66.98	557900.0
2007-08-07	ABVA-DELISTED	Stock	9.85	10.45	9.85	10.01	13045.0
2007-08-07	ABVT-DELISTED	Stock	82.5	82.5	82.5	82.5	20077.0
2007-08-07	ABX-DELISTED	Stock	32.9	33.89	32.88	33.69	5379200.0
2007-08-07	ACAD	Stock	15.25	16.67	15.09	16.37	1671800.0
2007-08-07	ACAP-DELISTED	Stock	36.87	37.09	35.86	36.49	104278.0
2007-08-07	ACAS-DELISTED	Stock	40.32	42.01	40.01	41.4	4441534.0
2007-08-07	ACAT-DELISTED	Stock	17.5	17.78	17.25	17.64	239014.0
2007-08-07	ACC-DELISTED	Stock	25.93	27.14	25.63	26.47	178200.0

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

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