PREVIEW / stock_daily / 2007-11-06

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-06.parquet
  size:    180 KB
  rows:    5,587
  symbols: 3,380

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-06	AAPL	Stock	6.6804	6.8571	6.6168	6.8496	954727200.0
2007-11-06	MSFT	Stock	36.59	36.66	35.87	36.41	100966700.0
2007-11-06	NVDA	Stock	0.9273	0.955	0.923	0.9475	554620000.0
2007-11-06	AMZN	Stock	4.2305	4.375	4.2185	4.3635	158680000.0
2007-11-06	TLT	Stock	90.6	91.15	90.48	90.56	575800.0
2007-11-06	CL	Stock	37.72	37.93	37.525	37.76	4752400.0
2007-11-06	A	Stock	25.5866	25.9299	25.3147	25.8441	3101463.0
2007-11-06	AABA-DELISTED	Stock	31.78	31.8	29.0	29.89	63966497.0
2007-11-06	AACC-DELISTED	Stock	10.2	10.5	9.9	10.43	233650.0
2007-11-06	AAI-DELISTED	Stock	9.8	9.85	9.48	9.64	1316800.0
2007-11-06	AAIC-DELISTED	Stock	80.0	82.2	78.0	81.2	1357200.0
2007-11-06	AAME	Stock	2.28	2.32	2.1	2.27	1500.0
2007-11-06	AAON	Stock	3.2672	3.4489	3.2612	3.441	268819.0
2007-11-06	AAP	Stock	35.18	36.54	34.8	36.48	2417200.0
2007-11-06	AATI-DELISTED	Stock	11.66	11.73	11.4	11.71	398873.0
2007-11-06	AAU-DELISTED	Stock	3.22	3.32	3.16	3.28	102500.0
2007-11-06	AAUAF-DELISTED	Stock	3.22	3.32	3.16	3.28	103500.0
2007-11-06	AAV-DELISTED	Stock	12.45	12.57	12.42	12.54	489520.0
2007-11-06	AAWW-DELISTED	Stock	57.53	58.68	56.77	57.4	82982.0
2007-11-06	AAXN-DELISTED	Stock	15.65	15.9699	15.4	15.75	1404969.0
2007-11-06	AB	Stock	78.1	79.0	77.05	77.83	420600.0
2007-11-06	ABAX-DELISTED	Stock	29.34	31.71	28.72	31.71	595072.0
2007-11-06	ABB-DELISTED	Stock	31.99	32.04	31.57	31.83	7646165.0
2007-11-06	ABBC-DELISTED	Stock	8.92	8.97	8.82	8.96	61907.0
2007-11-06	ABBNY-DELISTED	Stock	31.99	32.04	31.57	31.81	7646165.0
2007-11-06	ABC-DELISTED	Stock	21.65	21.98	21.48	21.96	2679661.0
2007-11-06	ABCB	Stock	14.8036	14.8328	14.0158	14.473	72277.0
2007-11-06	ABCO-DELISTED	Stock	31.89	32.8	31.7	32.77	399675.0
2007-11-06	ABCW-DELISTED	Stock	22.44	23.19	22.29	23.17	73850.0
2007-11-06	ABD-DELISTED	Stock	19.67	20.35	19.48	20.2	396750.0
2007-11-06	ABE-DELISTED	Stock	28.38	28.38	25.95	26.63	39300.0
2007-11-06	ABEO	Stock	3625.0	4000.0	3625.0	4000.0	5.0
2007-11-06	ABFS-DELISTED	Stock	26.01	26.09	25.5	26.04	990754.0
2007-11-06	ABG	Stock	16.84	16.95	16.38	16.88	721900.0
2007-11-06	ABK-DELISTED	Stock	26.5	29.96	25.73	28.0	21102508.0
2007-11-06	ABM	Stock	22.32	22.48	21.93	22.4	306200.0
2007-11-06	ABMD-DELISTED	Stock	13.18	13.32	12.7	13.3	172885.0
2007-11-06	ABP-DELISTED	Stock	4.57	4.65	4.46	4.55	311285.0
2007-11-06	ABR	Stock	16.7	18.36	16.52	17.85	466400.0
2007-11-06	ABT	Stock	25.938	26.1491	25.8804	26.0723	7353897.0
2007-11-06	ABTL-DELISTED	Stock	11.125	11.973	10.726	11.225	14946.0
2007-11-06	ABV-DELISTED	Stock	82.51	83.96	81.43	81.6	562123.0
2007-11-06	ABVA-DELISTED	Stock	8.13	8.2	8.108	8.108	1300.0
2007-11-06	ABVT-DELISTED	Stock	88.05	90.5	88.05	90.0	74153.0
2007-11-06	ABX-DELISTED	Stock	47.02	47.35	46.66	46.96	7398850.0
2007-11-06	ACAD	Stock	13.8	14.38	12.75	13.32	1516400.0
2007-11-06	ACAP-DELISTED	Stock	42.66	42.66	40.99	42.59	44418.0
2007-11-06	ACAS-DELISTED	Stock	41.56	41.87	40.92	41.61	1843098.0
2007-11-06	ACAT-DELISTED	Stock	13.38	13.52	12.71	13.27	80153.0
2007-11-06	ACC-DELISTED	Stock	26.55	27.13	26.18	26.94	296000.0

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

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