PREVIEW / stock_daily / 2007-06-06

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-06.parquet
  size:    176 KB
  rows:    5,375
  symbols: 3,216

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-06	AAPL	Stock	4.3679	4.4304	4.3554	4.4157	1112241200.0
2007-06-06	MSFT	Stock	30.37	30.53	30.25	30.29	38217500.0
2007-06-06	NVDA	Stock	0.5977	0.616	0.5952	0.6063	950736000.0
2007-06-06	AMZN	Stock	3.657	3.6875	3.593	3.6145	311820000.0
2007-06-06	TLT	Stock	85.36	85.54	85.26	85.4	1129152.0
2007-06-06	CL	Stock	33.325	33.525	33.15	33.205	4361600.0
2007-06-06	A	Stock	27.3104	27.5393	27.289	27.4464	2975224.0
2007-06-06	AABA-DELISTED	Stock	28.05	28.11	27.3	27.39	32959530.0
2007-06-06	AACC-DELISTED	Stock	18.94	19.0	18.85	18.89	80548.0
2007-06-06	AAI-DELISTED	Stock	11.9	12.01	11.79	11.97	1893700.0
2007-06-06	AAIC-DELISTED	Stock	124.8	125.0	121.6	125.0	1745100.0
2007-06-06	AAME	Stock	4.61	4.88	4.61	4.75	12200.0
2007-06-06	AAON	Stock	3.9124	3.9124	3.8281	3.8571	281728.0
2007-06-06	AAP	Stock	41.7	41.7	40.88	41.25	778100.0
2007-06-06	AATI-DELISTED	Stock	9.85	9.85	9.42	9.49	554715.0
2007-06-06	AAU-DELISTED	Stock	2.51	2.51	2.45	2.48	78400.0
2007-06-06	AAUAF-DELISTED	Stock	2.51	2.51	2.45	2.48	78400.0
2007-06-06	AAV-DELISTED	Stock	12.94	13.0	12.73	12.85	519701.0
2007-06-06	AAWW-DELISTED	Stock	57.23	57.62	56.41	57.28	121982.0
2007-06-06	AAXN-DELISTED	Stock	10.32	10.75	10.09	10.6	2650307.0
2007-06-06	AB	Stock	89.36	89.59	88.95	89.1	234600.0
2007-06-06	ABAX-DELISTED	Stock	23.45	23.56	23.0	23.2	153372.0
2007-06-06	ABB-DELISTED	Stock	21.67	21.68	21.17	21.3	1911086.0
2007-06-06	ABBC-DELISTED	Stock	17.9	18.15	17.9	18.09	5894.0
2007-06-06	ABBNY-DELISTED	Stock	21.67	21.68	21.17	21.31	1911286.0
2007-06-06	ABC-DELISTED	Stock	25.72	25.74	25.5	25.54	2759644.0
2007-06-06	ABCB	Stock	22.5848	22.5848	21.9428	22.0401	38863.0
2007-06-06	ABCO-DELISTED	Stock	26.5	26.87	26.2	26.48	370827.0
2007-06-06	ABCW-DELISTED	Stock	28.4	28.71	28.17	28.59	96800.0
2007-06-06	ABD-DELISTED	Stock	25.2	25.2	24.85	25.13	238200.0
2007-06-06	ABE-DELISTED	Stock	21.2	21.44	20.44	21.05	52300.0
2007-06-06	ABEO	Stock	6550.0	6550.0	6000.0	6500.0	7.0
2007-06-06	ABFS-DELISTED	Stock	40.72	41.66	40.1	41.61	881734.0
2007-06-06	ABG	Stock	26.93	26.99	25.95	26.01	602900.0
2007-06-06	ABK-DELISTED	Stock	87.83	88.42	87.51	88.18	1116050.0
2007-06-06	ABM	Stock	31.2	31.2	27.51	27.91	906400.0
2007-06-06	ABMD-DELISTED	Stock	11.66	11.7	11.53	11.69	110274.0
2007-06-06	ABP-DELISTED	Stock	3.88	3.88	3.81	3.88	193400.0
2007-06-06	ABR	Stock	28.33	28.72	28.05	28.69	200100.0
2007-06-06	ABT	Stock	26.4514	26.4802	26.1395	26.2643	15430596.0
2007-06-06	ABTL-DELISTED	Stock	21.5	21.5	21.3	21.4	8219.0
2007-06-06	ABV-DELISTED	Stock	69.4	69.4	68.14	68.93	705580.0
2007-06-06	ABVA-DELISTED	Stock	14.2	14.36	14.2	14.25	1898.0
2007-06-06	ABX-DELISTED	Stock	29.01	29.14	28.67	28.72	6738020.0
2007-06-06	ACAD	Stock	14.1	14.4	13.65	13.82	7506500.0
2007-06-06	ACAP-DELISTED	Stock	40.83	41.17	40.56	41.05	32311.0
2007-06-06	ACAS-DELISTED	Stock	47.94	47.95	47.11	47.4	1126244.0
2007-06-06	ACAT-DELISTED	Stock	19.0	19.57	18.9	19.26	66328.0
2007-06-06	ACC-DELISTED	Stock	29.56	29.63	29.29	29.58	162176.0
2007-06-06	ACCL-DELISTED	Stock	6.26	6.26	6.12	6.14	34508.0

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

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