PREVIEW / stock_daily / 2007-11-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-19.parquet
  size:    180 KB
  rows:    5,607
  symbols: 3,398

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-19	AAPL	Stock	5.9321	6.0071	5.7893	5.8554	1154428800.0
2007-11-19	MSFT	Stock	33.96	34.24	33.87	33.96	63026200.0
2007-11-19	NVDA	Stock	0.7998	0.8038	0.7523	0.7565	568412000.0
2007-11-19	AMZN	Stock	3.9415	3.9875	3.897	3.959	172996000.0
2007-11-19	TLT	Stock	92.54	93.42	92.41	93.01	1346726.0
2007-11-19	CL	Stock	39.43	39.43	38.655	38.745	8075000.0
2007-11-19	A	Stock	26.0515	26.309	25.5579	25.608	4901528.0
2007-11-19	AABA-DELISTED	Stock	27.11	27.35	26.35	26.79	33254480.0
2007-11-19	AACC-DELISTED	Stock	10.82	10.88	10.44	10.49	173663.0
2007-11-19	AAI-DELISTED	Stock	9.13	9.13	8.75	8.75	1102300.0
2007-11-19	AAIC-DELISTED	Stock	66.8	66.8	60.4	61.8	2074775.0
2007-11-19	AAME	Stock	2.23	2.25	1.93	2.12	9300.0
2007-11-19	AAON	Stock	3.5911	3.7491	3.4864	3.5477	438919.0
2007-11-19	AAP	Stock	34.48	35.17	34.34	34.71	1568000.0
2007-11-19	AATI-DELISTED	Stock	10.62	10.68	10.28	10.41	644029.0
2007-11-19	AAU-DELISTED	Stock	2.75	2.8	2.7	2.73	23200.0
2007-11-19	AAUAF-DELISTED	Stock	2.75	2.8	2.7	2.73	23300.0
2007-11-19	AAV-DELISTED	Stock	10.98	10.98	10.7	10.75	755903.0
2007-11-19	AAWW-DELISTED	Stock	55.32	55.32	53.66	53.88	136207.0
2007-11-19	AAXN-DELISTED	Stock	13.33	13.57	13.09	13.13	2305286.0
2007-11-19	AB	Stock	75.5	75.5	73.0	73.96	446800.0
2007-11-19	ABAX-DELISTED	Stock	33.32	34.6	32.33	32.44	670540.0
2007-11-19	ABB-DELISTED	Stock	26.83	26.94	25.84	26.03	7760815.0
2007-11-19	ABBC-DELISTED	Stock	8.93	8.97	8.8	8.81	27839.0
2007-11-19	ABBNY-DELISTED	Stock	26.92	26.94	25.84	26.06	7760815.0
2007-11-19	ABC-DELISTED	Stock	22.36	22.36	21.72	21.88	2896200.0
2007-11-19	ABCB	Stock	14.2589	14.3465	13.4905	13.7337	40919.0
2007-11-19	ABCO-DELISTED	Stock	31.52	31.56	31.11	31.4	146850.0
2007-11-19	ABCW-DELISTED	Stock	24.49	24.49	23.41	23.96	75150.0
2007-11-19	ABD-DELISTED	Stock	19.12	19.12	18.32	18.68	378720.0
2007-11-19	ABE-DELISTED	Stock	24.76	25.07	23.66	23.66	23480.0
2007-11-19	ABEO	Stock	3750.0	3787.5	3625.0	3662.5	32.0
2007-11-19	ABFS-DELISTED	Stock	23.26	23.3	22.55	22.68	850836.0
2007-11-19	ABG	Stock	17.44	17.7	17.35	17.5	374400.0
2007-11-19	ABII-DELISTED	Stock	59.45	59.45	55.7601	57.5	71910.0
2007-11-19	ABK-DELISTED	Stock	26.2	26.75	23.7	25.54	9067926.0
2007-11-19	ABM	Stock	20.86	21.14	20.8	20.94	275100.0
2007-11-19	ABMD-DELISTED	Stock	12.15	12.21	11.68	12.06	141115.0
2007-11-19	ABP-DELISTED	Stock	3.55	3.69	3.43	3.52	261200.0
2007-11-19	ABR	Stock	17.53	17.57	17.01	17.33	212900.0
2007-11-19	ABT	Stock	26.3218	26.509	26.2211	26.3026	10269487.0
2007-11-19	ABTL-DELISTED	Stock	15.904	15.904	15.147	15.5	14324.0
2007-11-19	ABV-DELISTED	Stock	75.26	75.26	71.23	71.9	629649.0
2007-11-19	ABVA-DELISTED	Stock	7.99	7.99	7.63	7.63	1700.0
2007-11-19	ABVT-DELISTED	Stock	80.5	81.0	80.5	81.0	2305.0
2007-11-19	ABX-DELISTED	Stock	40.85	40.85	38.6	38.95	9448649.0
2007-11-19	ACAD	Stock	11.23	11.31	10.94	10.96	454300.0
2007-11-19	ACAP-DELISTED	Stock	41.58	42.43	40.02	40.14	74647.0
2007-11-19	ACAS-DELISTED	Stock	39.03	39.06	37.42	37.58	2572344.0
2007-11-19	ACAT-DELISTED	Stock	12.45	12.45	11.75	12.12	263366.0

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

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