PREVIEW / stock_daily / 2007-11-28

all stock daily files

  file:    by_date/stock_daily/2007/2007-11-28.parquet
  size:    181 KB
  rows:    5,618
  symbols: 3,403

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-28	AAPL	Stock	6.315	6.45	6.2625	6.4364	1150912000.0
2007-11-28	MSFT	Stock	33.38	33.89	32.9	33.7	88585000.0
2007-11-28	NVDA	Stock	0.794	0.8322	0.7902	0.8212	574548000.0
2007-11-28	AMZN	Stock	4.3775	4.5285	4.3375	4.515	228068000.0
2007-11-28	TLT	Stock	94.56	94.69	93.84	94.03	2088003.0
2007-11-28	CL	Stock	39.455	40.0	39.135	39.87	7651800.0
2007-11-28	A	Stock	26.4878	27.2318	26.3591	27.1459	3202119.0
2007-11-28	AABA-DELISTED	Stock	26.05	26.7	25.93	26.2	23289286.0
2007-11-28	AACC-DELISTED	Stock	11.64	12.0	11.47	12.0	256041.0
2007-11-28	AAI-DELISTED	Stock	8.18	8.53	8.18	8.49	1989270.0
2007-11-28	AAIC-DELISTED	Stock	57.0	60.8	55.6	57.8	2379700.0
2007-11-28	AAME	Stock	1.67	1.99	1.67	1.75	4000.0
2007-11-28	AAON	Stock	3.6681	3.7551	3.6207	3.7551	584212.0
2007-11-28	AAP	Stock	33.61	34.78	33.42	34.16	2229200.0
2007-11-28	AATI-DELISTED	Stock	10.02	10.84	10.01	10.82	447607.0
2007-11-28	AAU-DELISTED	Stock	2.36	2.47	2.27	2.42	108900.0
2007-11-28	AAUAF-DELISTED	Stock	2.36	2.47	2.27	2.42	109300.0
2007-11-28	AAV-DELISTED	Stock	10.65	10.76	10.41	10.46	836036.0
2007-11-28	AAWW-DELISTED	Stock	53.03	53.03	52.05	52.58	208024.0
2007-11-28	AAXN-DELISTED	Stock	13.34	14.51	13.15	14.14	2590829.0
2007-11-28	AB	Stock	79.25	82.5	79.25	81.67	481000.0
2007-11-28	ABAX-DELISTED	Stock	32.23	33.52	32.09	33.49	254624.0
2007-11-28	ABB-DELISTED	Stock	27.74	28.84	27.74	28.72	3676478.0
2007-11-28	ABBC-DELISTED	Stock	8.98	9.22	8.96	8.99	62205.0
2007-11-28	ABBNY-DELISTED	Stock	27.74	28.84	27.74	28.71	3676478.0
2007-11-28	ABC-DELISTED	Stock	21.81	22.21	21.55	22.19	2796014.0
2007-11-28	ABCB	Stock	14.9009	16.5154	14.9009	16.4668	98597.0
2007-11-28	ABCO-DELISTED	Stock	31.8	32.26	31.49	32.09	239855.0
2007-11-28	ABCW-DELISTED	Stock	24.79	25.51	24.58	25.5	101420.0
2007-11-28	ABD-DELISTED	Stock	16.79	17.25	16.72	17.2	462100.0
2007-11-28	ABE-DELISTED	Stock	24.0	25.45	24.0	25.2901	18595.0
2007-11-28	ABEO	Stock	3250.0	3750.0	3250.0	3750.0	17.0
2007-11-28	ABFS-DELISTED	Stock	22.13	23.11	21.79	23.04	933954.0
2007-11-28	ABG	Stock	16.45	17.16	16.37	17.01	651200.0
2007-11-28	ABII-DELISTED	Stock	55.95	57.99	55.0	56.75	74837.0
2007-11-28	ABK-DELISTED	Stock	24.45	24.45	20.71	22.25	14497055.0
2007-11-28	ABM	Stock	20.25	20.68	20.07	20.43	306600.0
2007-11-28	ABMD-DELISTED	Stock	12.07	12.42	12.0	12.4001	153344.0
2007-11-28	ABP-DELISTED	Stock	3.38	3.45	3.35	3.45	148900.0
2007-11-28	ABR	Stock	16.72	17.14	16.33	16.67	628300.0
2007-11-28	ABT	Stock	26.9024	27.1087	26.4994	27.0703	13582326.0
2007-11-28	ABTL-DELISTED	Stock	15.4	15.4	15.0	15.2	18816.0
2007-11-28	ABV-DELISTED	Stock	71.25	75.52	70.16	74.91	1366200.0
2007-11-28	ABVA-DELISTED	Stock	7.46	7.7599	7.42	7.42	1700.0
2007-11-28	ABVT-DELISTED	Stock	79.25	79.25	79.25	79.25	2500.0
2007-11-28	ABX-DELISTED	Stock	40.46	42.14	40.46	41.96	6164154.0
2007-11-28	ACAD	Stock	10.1	10.66	10.07	10.6	538300.0
2007-11-28	ACAP-DELISTED	Stock	43.2	44.02	41.44	42.0	95511.0
2007-11-28	ACAS-DELISTED	Stock	35.99	37.48	35.74	37.44	3344605.0
2007-11-28	ACAT-DELISTED	Stock	11.28	11.51	11.12	11.43	102650.0

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

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