PREVIEW / stock_daily / 2007-11-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-27.parquet
  size:    181 KB
  rows:    5,627
  symbols: 3,412

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-11-27	AAPL	Stock	6.2579	6.2782	6.0718	6.2432	1317030400.0
2007-11-27	MSFT	Stock	33.27	33.6	32.68	33.06	84178400.0
2007-11-27	NVDA	Stock	0.7485	0.772	0.7428	0.7698	458856000.0
2007-11-27	AMZN	Stock	4.146	4.2825	4.1105	4.2795	172684000.0
2007-11-27	TLT	Stock	94.96	95.25	93.99	94.67	3100232.0
2007-11-27	CL	Stock	39.35	39.65	39.115	39.575	6445600.0
2007-11-27	A	Stock	26.0873	26.5808	26.0372	26.3448	3491924.0
2007-11-27	AABA-DELISTED	Stock	25.24	26.0	25.17	25.6	19486385.0
2007-11-27	AACC-DELISTED	Stock	11.24	11.55	11.15	11.51	207357.0
2007-11-27	AAI-DELISTED	Stock	8.25	8.44	8.21	8.23	2279100.0
2007-11-27	AAIC-DELISTED	Stock	55.8	58.8	52.0	56.4	3244655.0
2007-11-27	AAME	Stock	1.72	1.86	1.67	1.67	2700.0
2007-11-27	AAON	Stock	3.5358	3.7432	3.4252	3.6207	1019081.0
2007-11-27	AAP	Stock	33.46	33.86	33.06	33.42	779900.0
2007-11-27	AATI-DELISTED	Stock	10.12	10.27	9.86	10.04	506817.0
2007-11-27	AAU-DELISTED	Stock	2.61	2.61	2.37	2.4	177114.0
2007-11-27	AAUAF-DELISTED	Stock	2.61	2.61	2.37	2.4	177421.0
2007-11-27	AAV-DELISTED	Stock	11.0	11.0	10.62	10.82	888580.0
2007-11-27	AAWW-DELISTED	Stock	52.32	52.51	51.32	52.07	177615.0
2007-11-27	AAXN-DELISTED	Stock	12.73	13.04	12.66	12.89	1821556.0
2007-11-27	AB	Stock	78.18	78.91	76.72	78.82	401400.0
2007-11-27	ABAX-DELISTED	Stock	31.01	32.28	30.91	31.99	413103.0
2007-11-27	ABB-DELISTED	Stock	26.75	27.21	26.51	27.2	4378938.0
2007-11-27	ABBC-DELISTED	Stock	9.07	9.07	8.92	8.96	70251.0
2007-11-27	ABBNY-DELISTED	Stock	26.75	27.21	26.51	27.2	4378938.0
2007-11-27	ABC-DELISTED	Stock	21.78	21.8	21.28	21.58	4556282.0
2007-11-27	ABCB	Stock	13.831	14.7648	13.6656	14.7063	62304.0
2007-11-27	ABCO-DELISTED	Stock	31.33	31.68	31.13	31.44	157586.0
2007-11-27	ABCW-DELISTED	Stock	24.18	24.79	23.77	24.54	155010.0
2007-11-27	ABD-DELISTED	Stock	16.97	17.33	16.49	16.79	572750.0
2007-11-27	ABE-DELISTED	Stock	24.52	24.52	23.5	23.94	20900.0
2007-11-27	ABEO	Stock	3550.0	3550.0	3550.0	3550.0	1.0
2007-11-27	ABFS-DELISTED	Stock	22.08	22.31	21.54	22.04	1091512.0
2007-11-27	ABG	Stock	16.47	16.58	16.04	16.37	602300.0
2007-11-27	ABII-DELISTED	Stock	55.86	57.55	55.86	56.52	37092.0
2007-11-27	ABK-DELISTED	Stock	24.19	25.19	21.11	21.75	12260998.0
2007-11-27	ABM	Stock	19.42	20.21	19.36	20.07	298400.0
2007-11-27	ABMD-DELISTED	Stock	11.99	12.08	11.77	11.97	110447.0
2007-11-27	ABP-DELISTED	Stock	3.48	3.48	3.31	3.35	109315.0
2007-11-27	ABR	Stock	16.91	17.2	16.02	16.25	341100.0
2007-11-27	ABT	Stock	26.1011	26.8688	26.0292	26.8256	16489787.0
2007-11-27	ABTL-DELISTED	Stock	15.55	15.55	14.497	15.4	13817.0
2007-11-27	ABV-DELISTED	Stock	66.99	70.01	65.86	69.49	1363100.0
2007-11-27	ABVA-DELISTED	Stock	7.7	7.77	7.7	7.77	900.0
2007-11-27	ABX-DELISTED	Stock	40.97	41.62	40.43	41.25	7538727.0
2007-11-27	ACAD	Stock	10.02	10.26	9.95	10.03	686000.0
2007-11-27	ACAP-DELISTED	Stock	41.4	43.46	41.4	43.11	82200.0
2007-11-27	ACAS-DELISTED	Stock	35.42	36.2	34.63	35.28	4805671.0
2007-11-27	ACAT-DELISTED	Stock	11.53	11.59	10.88	11.18	130625.0
2007-11-27	ACC-DELISTED	Stock	24.48	24.64	23.18	24.26	311700.0

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

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