PREVIEW / stock_daily / 2007-11-14

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-14.parquet
  size:    180 KB
  rows:    5,591
  symbols: 3,397

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-14	AAPL	Stock	6.3271	6.3418	5.8479	5.9325	1449168000.0
2007-11-14	MSFT	Stock	34.62	34.75	33.75	33.93	84063100.0
2007-11-14	NVDA	Stock	0.8378	0.8458	0.8	0.8043	666720000.0
2007-11-14	AMZN	Stock	4.02	4.0575	3.9075	3.9255	168548000.0
2007-11-14	TLT	Stock	90.95	91.51	90.92	91.42	692274.0
2007-11-14	CL	Stock	39.0	39.51	38.525	39.06	8137800.0
2007-11-14	A	Stock	24.3562	24.671	24.1702	24.4635	2569524.0
2007-11-14	AABA-DELISTED	Stock	26.4	26.44	25.0	25.07	38248996.0
2007-11-14	AACC-DELISTED	Stock	10.9	11.1	10.5	10.94	154470.0
2007-11-14	AAI-DELISTED	Stock	9.6	9.75	9.29	9.47	2162200.0
2007-11-14	AAIC-DELISTED	Stock	77.4	77.8	74.2	74.8	1001500.0
2007-11-14	AAME	Stock	2.1	2.2	1.89	2.19	4900.0
2007-11-14	AAON	Stock	3.6919	3.6919	3.5951	3.6583	739125.0
2007-11-14	AAP	Stock	35.89	37.0	35.75	35.83	2167800.0
2007-11-14	AATI-DELISTED	Stock	11.15	11.37	11.13	11.25	552047.0
2007-11-14	AAU-DELISTED	Stock	2.76	2.93	2.76	2.83	71900.0
2007-11-14	AAUAF-DELISTED	Stock	2.76	2.93	2.76	2.83	72100.0
2007-11-14	AAV-DELISTED	Stock	11.1	11.25	11.0	11.12	743645.0
2007-11-14	AAWW-DELISTED	Stock	56.0	57.38	56.0	56.69	72791.0
2007-11-14	AAXN-DELISTED	Stock	15.1	15.1	14.3	14.42	2244891.0
2007-11-14	AB	Stock	82.0	82.09	79.71	79.86	261900.0
2007-11-14	ABAX-DELISTED	Stock	33.0	33.24	32.42	32.99	291147.0
2007-11-14	ABB-DELISTED	Stock	29.22	29.38	28.79	28.82	5731440.0
2007-11-14	ABBC-DELISTED	Stock	9.11	9.14	9.04	9.06	57959.0
2007-11-14	ABBNY-DELISTED	Stock	29.22	29.38	28.79	28.79	5731440.0
2007-11-14	ABC-DELISTED	Stock	22.27	22.35	21.96	22.05	3212200.0
2007-11-14	ABCB	Stock	15.2316	15.3094	14.6771	14.8717	32694.0
2007-11-14	ABCO-DELISTED	Stock	32.34	32.43	31.98	32.05	346762.0
2007-11-14	ABCW-DELISTED	Stock	25.39	25.45	24.95	25.37	149040.0
2007-11-14	ABD-DELISTED	Stock	20.52	20.52	19.62	19.78	205370.0
2007-11-14	ABE-DELISTED	Stock	25.9	26.3499	25.14	25.33	37500.0
2007-11-14	ABEO	Stock	3750.0	3750.0	3750.0	3750.0	3.0
2007-11-14	ABFS-DELISTED	Stock	26.03	26.36	25.52	25.92	646486.0
2007-11-14	ABG	Stock	18.09	18.09	17.46	17.79	360200.0
2007-11-14	ABII-DELISTED	Stock	35.0	41.0	33.0	38.15	484753.0
2007-11-14	ABK-DELISTED	Stock	30.6	34.42	30.09	30.46	13296457.0
2007-11-14	ABM	Stock	21.98	22.02	21.5	21.77	236000.0
2007-11-14	ABMD-DELISTED	Stock	12.66	12.67	12.01	12.22	150126.0
2007-11-14	ABP-DELISTED	Stock	3.8	3.97	3.8	3.94	176500.0
2007-11-14	ABR	Stock	18.54	18.63	17.63	17.9	435300.0
2007-11-14	ABT	Stock	26.6145	26.6145	26.0148	26.0579	11921842.0
2007-11-14	ABTL-DELISTED	Stock	15.139	16.3	14.736	16.3	33693.0
2007-11-14	ABV-DELISTED	Stock	74.41	77.01	73.76	74.89	1596493.0
2007-11-14	ABVA-DELISTED	Stock	7.41	8.44	7.4	7.84	18105.0
2007-11-14	ABVT-DELISTED	Stock	86.0	86.0	86.0	86.0	1946.0
2007-11-14	ABX-DELISTED	Stock	43.33	43.57	42.51	42.54	5471006.0
2007-11-14	ACAD	Stock	11.31	11.49	10.92	10.99	441500.0
2007-11-14	ACAP-DELISTED	Stock	40.51	42.44	40.0	41.98	51793.0
2007-11-14	ACAS-DELISTED	Stock	40.88	41.34	40.12	40.35	2077198.0
2007-11-14	ACAT-DELISTED	Stock	13.33	13.33	12.71	12.82	86862.0

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

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