PREVIEW / stock_daily / 2007-06-22

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-22.parquet
  size:    178 KB
  rows:    5,401
  symbols: 3,241

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-06-22	AAPL	Stock	4.4232	4.4446	4.3707	4.3929	631876000.0
2007-06-22	MSFT	Stock	30.0	30.1	29.45	29.49	86219900.0
2007-06-22	NVDA	Stock	0.7167	0.7312	0.7058	0.727	882618000.0
2007-06-22	AMZN	Stock	3.4775	3.494	3.421	3.443	167652000.0
2007-06-22	TLT	Stock	83.05	83.77	82.95	83.76	2119200.0
2007-06-22	CL	Stock	32.99	33.02	32.53	32.635	8913800.0
2007-06-22	A	Stock	27.8398	27.9256	27.2031	27.6466	3550221.0
2007-06-22	AABA-DELISTED	Stock	27.68	27.79	27.31	27.39	27271526.0
2007-06-22	AACC-DELISTED	Stock	16.8	17.06	16.76	16.76	475711.0
2007-06-22	AAI-DELISTED	Stock	11.33	11.34	11.11	11.19	2079700.0
2007-06-22	AAIC-DELISTED	Stock	120.0	120.0	114.6	115.6	3503000.0
2007-06-22	AAME	Stock	4.1	4.16	3.93	4.0	14600.0
2007-06-22	AAON	Stock	4.0823	4.0863	3.9914	4.0626	656859.0
2007-06-22	AAP	Stock	40.43	40.84	39.87	40.09	1046600.0
2007-06-22	AATI-DELISTED	Stock	9.65	9.65	9.15	9.24	440833.0
2007-06-22	AAU-DELISTED	Stock	2.38	2.39	2.26	2.31	31300.0
2007-06-22	AAUAF-DELISTED	Stock	2.38	2.39	2.26	2.31	31200.0
2007-06-22	AAV-DELISTED	Stock	14.89	14.89	14.4	14.61	1237200.0
2007-06-22	AAWW-DELISTED	Stock	58.6	58.87	57.49	58.3	1001113.0
2007-06-22	AAXN-DELISTED	Stock	13.42	13.63	13.15	13.49	6097751.0
2007-06-22	AB	Stock	86.17	87.91	85.03	85.3	224000.0
2007-06-22	ABAX-DELISTED	Stock	21.08	21.35	20.85	20.97	248588.0
2007-06-22	ABB-DELISTED	Stock	22.56	22.6	22.25	22.38	1382500.0
2007-06-22	ABBC-DELISTED	Stock	16.75	17.03	16.65	16.73	124264.0
2007-06-22	ABBNY-DELISTED	Stock	22.56	22.6	22.25	22.39	1384700.0
2007-06-22	ABC-DELISTED	Stock	24.9	25.02	24.67	24.7	2764454.0
2007-06-22	ABCB	Stock	22.3416	22.3416	21.758	21.9817	124403.0
2007-06-22	ABCO-DELISTED	Stock	26.92	27.29	26.81	27.15	723455.0
2007-06-22	ABCW-DELISTED	Stock	27.27	27.48	27.14	27.29	264290.0
2007-06-22	ABD-DELISTED	Stock	24.64	24.64	23.92	24.18	493900.0
2007-06-22	ABE-DELISTED	Stock	21.63	21.6399	21.1	21.36	22200.0
2007-06-22	ABEO	Stock	6250.0	6375.0	6250.0	6312.5	3.0
2007-06-22	ABFS-DELISTED	Stock	39.25	39.56	38.94	39.16	817153.0
2007-06-22	ABG	Stock	26.09	26.23	25.8	25.8	864300.0
2007-06-22	ABK-DELISTED	Stock	85.84	86.74	85.61	86.04	1361707.0
2007-06-22	ABM	Stock	25.91	25.98	25.46	25.74	359300.0
2007-06-22	ABMD-DELISTED	Stock	11.17	11.35	10.84	10.96	362364.0
2007-06-22	ABP-DELISTED	Stock	4.27	4.38	4.15	4.31	199100.0
2007-06-22	ABR	Stock	25.86	26.39	25.76	26.14	296500.0
2007-06-22	ABT	Stock	25.7605	25.914	25.3334	25.3622	17315548.0
2007-06-22	ABTL-DELISTED	Stock	20.65	21.04	20.25	20.4	80331.0
2007-06-22	ABV-DELISTED	Stock	69.72	69.73	68.44	68.9	726100.0
2007-06-22	ABVA-DELISTED	Stock	13.2	13.26	13.2	13.2	775.0
2007-06-22	ABX-DELISTED	Stock	29.7	29.75	29.23	29.75	6101327.0
2007-06-22	ACAD	Stock	14.55	14.84	14.01	14.32	965900.0
2007-06-22	ACAP-DELISTED	Stock	40.01	40.7	39.51	39.65	202106.0
2007-06-22	ACAS-DELISTED	Stock	44.0	44.05	43.49	43.5	2601824.0
2007-06-22	ACAT-DELISTED	Stock	19.545	19.545	19.145	19.155	267192.0
2007-06-22	ACC-DELISTED	Stock	28.19	28.45	27.8	27.95	282891.0
2007-06-22	ACCL-DELISTED	Stock	5.85	5.91	5.8	5.9	35520.0

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

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