PREVIEW / stock_daily / 2007-06-13

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-13.parquet
  size:    176 KB
  rows:    5,377
  symbols: 3,225

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-13	AAPL	Stock	4.3268	4.3282	4.1214	4.1964	1721353200.0
2007-06-13	MSFT	Stock	29.97	30.41	29.85	30.39	64435600.0
2007-06-13	NVDA	Stock	0.6117	0.6197	0.6038	0.6195	587232000.0
2007-06-13	AMZN	Stock	3.545	3.5945	3.4625	3.5445	238358000.0
2007-06-13	TLT	Stock	82.7	83.76	82.65	83.33	8751300.0
2007-06-13	CL	Stock	33.83	33.895	33.365	33.73	9809600.0
2007-06-13	A	Stock	27.0529	27.5179	26.9814	27.5179	2802291.0
2007-06-13	AABA-DELISTED	Stock	27.12	27.41	26.61	27.38	29722741.0
2007-06-13	AACC-DELISTED	Stock	18.85	18.85	17.65	17.77	258670.0
2007-06-13	AAI-DELISTED	Stock	11.1	11.34	10.91	11.24	2234400.0
2007-06-13	AAIC-DELISTED	Stock	121.8	124.2	120.4	123.4	2001200.0
2007-06-13	AAME	Stock	4.36	4.52	4.08	4.24	15900.0
2007-06-13	AAON	Stock	3.7992	3.8453	3.7926	3.8018	246037.0
2007-06-13	AAP	Stock	41.28	41.28	40.72	41.05	886200.0
2007-06-13	AATI-DELISTED	Stock	9.2	9.33	9.1	9.33	265278.0
2007-06-13	AAU-DELISTED	Stock	2.27	2.3	2.26	2.28	42700.0
2007-06-13	AAUAF-DELISTED	Stock	2.27	2.3	2.26	2.28	42700.0
2007-06-13	AAV-DELISTED	Stock	12.96	13.09	12.91	13.08	844800.0
2007-06-13	AAWW-DELISTED	Stock	56.77	56.78	56.1	56.54	88439.0
2007-06-13	AAXN-DELISTED	Stock	12.2	12.36	11.4	11.68	4160266.0
2007-06-13	AB	Stock	90.9	91.93	90.9	91.7	191800.0
2007-06-13	ABAX-DELISTED	Stock	22.21	22.95	22.07	22.71	94589.0
2007-06-13	ABB-DELISTED	Stock	21.26	21.74	21.2	21.67	3414300.0
2007-06-13	ABBC-DELISTED	Stock	17.53	17.75	17.25	17.4	30961.0
2007-06-13	ABBNY-DELISTED	Stock	21.26	21.74	21.2	21.67	3415600.0
2007-06-13	ABC-DELISTED	Stock	25.65	25.68	25.23	25.64	3612000.0
2007-06-13	ABCB	Stock	21.5148	22.4874	21.4954	22.2346	33003.0
2007-06-13	ABCO-DELISTED	Stock	26.78	27.1	26.59	26.99	170694.0
2007-06-13	ABCW-DELISTED	Stock	27.67	27.68	27.43	27.54	282810.0
2007-06-13	ABD-DELISTED	Stock	24.51	24.74	24.16	24.68	395590.0
2007-06-13	ABE-DELISTED	Stock	21.54	21.6	20.81	21.32	53100.0
2007-06-13	ABEO	Stock	6550.0	6550.0	6437.5	6550.0	2.0
2007-06-13	ABFS-DELISTED	Stock	39.22	39.45	38.94	39.17	472179.0
2007-06-13	ABG	Stock	24.29	24.45	24.13	24.36	705300.0
2007-06-13	ABK-DELISTED	Stock	87.81	87.81	86.32	87.6	1610100.0
2007-06-13	ABM	Stock	26.24	26.36	25.88	26.14	356100.0
2007-06-13	ABMD-DELISTED	Stock	11.08	11.39	11.08	11.2	165927.0
2007-06-13	ABP-DELISTED	Stock	4.06	4.1	3.9	3.96	282100.0
2007-06-13	ABR	Stock	27.2	27.49	27.11	27.28	92300.0
2007-06-13	ABT	Stock	25.7892	26.0435	25.5254	26.0004	11190704.0
2007-06-13	ABTL-DELISTED	Stock	20.95	21.1	20.8	21.0	101872.0
2007-06-13	ABV-DELISTED	Stock	69.71	71.61	69.71	71.34	551500.0
2007-06-13	ABVA-DELISTED	Stock	13.99	14.24	13.92	13.98	4700.0
2007-06-13	ABX-DELISTED	Stock	28.25	28.38	27.97	28.24	5246500.0
2007-06-13	ACAD	Stock	14.39	14.74	13.85	14.57	2542700.0
2007-06-13	ACAP-DELISTED	Stock	40.47	41.59	40.2	41.59	52590.0
2007-06-13	ACAS-DELISTED	Stock	44.5	44.79	44.36	44.76	2113558.0
2007-06-13	ACAT-DELISTED	Stock	19.24	19.38	19.21	19.26	55041.0
2007-06-13	ACC-DELISTED	Stock	28.5	29.0	28.35	28.79	670200.0
2007-06-13	ACCL-DELISTED	Stock	6.0	6.19	6.0	6.07	37102.0

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

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