PREVIEW / stock_daily / 2007-06-29

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-29.parquet
  size:    177 KB
  rows:    5,446
  symbols: 3,279

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-29	AAPL	Stock	4.3561	4.4286	4.3246	4.3586	1137841600.0
2007-06-29	MSFT	Stock	29.87	29.93	29.04	29.47	71193900.0
2007-06-29	NVDA	Stock	0.7045	0.7047	0.6882	0.6885	516570000.0
2007-06-29	AMZN	Stock	3.4515	3.4595	3.4075	3.4205	106332000.0
2007-06-29	TLT	Stock	84.85	85.3	84.64	85.17	1962104.0
2007-06-29	CL	Stock	32.685	32.885	32.23	32.425	4606600.0
2007-06-29	A	Stock	27.6609	27.8827	27.2818	27.4964	2614260.0
2007-06-29	AABA-DELISTED	Stock	27.21	27.38	26.93	27.13	13286368.0
2007-06-29	AACC-DELISTED	Stock	17.92	18.18	17.67	17.7	187938.0
2007-06-29	AAI-DELISTED	Stock	10.97	11.09	10.87	10.93	1137300.0
2007-06-29	AAIC-DELISTED	Stock	112.4	115.4	108.4	109.2	1845500.0
2007-06-29	AAME	Stock	4.05	4.09	3.88	4.05	13100.0
2007-06-29	AAON	Stock	4.2245	4.2548	4.1732	4.1942	402469.0
2007-06-29	AAP	Stock	40.88	41.0	40.25	40.53	660500.0
2007-06-29	AATI-DELISTED	Stock	9.73	10.02	9.67	9.7	814026.0
2007-06-29	AAU-DELISTED	Stock	2.25	2.25	2.22	2.25	41700.0
2007-06-29	AAUAF-DELISTED	Stock	2.25	2.25	2.22	2.25	41700.0
2007-06-29	AAV-DELISTED	Stock	13.91	14.1	13.7	14.07	524700.0
2007-06-29	AAWW-DELISTED	Stock	59.93	59.94	58.33	58.8	137061.0
2007-06-29	AAXN-DELISTED	Stock	14.15	14.25	13.7018	13.96	5078552.0
2007-06-29	AB	Stock	87.79	88.2	86.08	87.09	300900.0
2007-06-29	ABAX-DELISTED	Stock	21.09	21.2	20.78	20.86	191553.0
2007-06-29	ABB-DELISTED	Stock	22.56	22.79	22.43	22.61	1535200.0
2007-06-29	ABBC-DELISTED	Stock	9.64	9.74	9.5	9.55	552292.0
2007-06-29	ABBNY-DELISTED	Stock	22.56	22.79	22.43	22.6	1536600.0
2007-06-29	ABC-DELISTED	Stock	24.87	25.0	24.54	24.72	2581400.0
2007-06-29	ABCB	Stock	23.1587	23.1587	21.6413	21.8552	56547.0
2007-06-29	ABCO-DELISTED	Stock	28.45	28.54	27.78	27.78	302855.0
2007-06-29	ABCW-DELISTED	Stock	26.77	26.77	26.16	26.19	176930.0
2007-06-29	ABD-DELISTED	Stock	24.0	24.0	22.84	23.05	529950.0
2007-06-29	ABE-DELISTED	Stock	21.09	21.34	21.02	21.29	33500.0
2007-06-29	ABEO	Stock	6362.5	6375.0	6000.0	6250.0	13.0
2007-06-29	ABFS-DELISTED	Stock	39.75	39.75	38.9	38.96	338242.0
2007-06-29	ABG	Stock	25.3	25.32	24.2	24.95	245400.0
2007-06-29	ABK-DELISTED	Stock	87.64	88.05	86.83	87.1	1630900.0
2007-06-29	ABM	Stock	25.95	26.18	25.78	25.81	277700.0
2007-06-29	ABMD-DELISTED	Stock	11.08	11.08	10.5	10.76	742809.0
2007-06-29	ABP-DELISTED	Stock	4.5	4.6	4.4	4.48	309700.0
2007-06-29	ABR	Stock	26.39	26.39	25.8	25.81	166000.0
2007-06-29	ABT	Stock	25.7605	26.4466	25.5494	25.6933	11347645.0
2007-06-29	ABTL-DELISTED	Stock	21.22	21.22	20.87	21.22	16227.0
2007-06-29	ABV-DELISTED	Stock	69.58	70.25	69.44	70.0	642600.0
2007-06-29	ABVA-DELISTED	Stock	13.0	13.25	13.0	13.25	3350.0
2007-06-29	ABX-DELISTED	Stock	29.0	29.13	28.65	29.05	4700800.0
2007-06-29	ACAD	Stock	14.02	14.02	13.52	13.67	472800.0
2007-06-29	ACAP-DELISTED	Stock	40.9	41.21	40.44	40.52	42178.0
2007-06-29	ACAS-DELISTED	Stock	43.04	43.34	42.28	42.52	1885313.0
2007-06-29	ACAT-DELISTED	Stock	20.23	20.23	19.61	19.8	74919.0
2007-06-29	ACC-DELISTED	Stock	28.31	28.43	28.16	28.22	218312.0
2007-06-29	ACCL-DELISTED	Stock	6.09	6.29	6.09	6.2799	65836.0

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

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