PREVIEW / stock_daily / 2007-02-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-27.parquet
  size:    162 KB
  rows:    4,855
  symbols: 3,051

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-02-27	AAPL	Stock	3.0821	3.11	2.9789	2.9975	1145813200.0
2007-02-27	MSFT	Stock	28.71	28.97	27.79	27.87	87143300.0
2007-02-27	NVDA	Stock	0.53	0.5425	0.5188	0.5197	714630000.0
2007-02-27	AMZN	Stock	2.0095	2.027	1.939	1.9415	177014000.0
2007-02-27	TLT	Stock	89.74	91.26	89.6	90.56	3243200.0
2007-02-27	CL	Stock	34.19	34.5	33.375	33.67	8682200.0
2007-02-27	A	Stock	23.5336	23.6409	22.6395	22.9685	6038381.0
2007-02-27	AABA-DELISTED	Stock	31.3799991607666	31.6399993896484	30.2399997711182	30.9500007629395	31505200.0
2007-02-27	AACC-DELISTED	Stock	15.1	15.14	14.78	14.85	63935.0
2007-02-27	AACQ-DELISTED	Stock	5.34	5.35	5.33	5.33	96807.0
2007-02-27	AACQU-DELISTED	Stock	6.87	6.87	6.86	6.86	1425.0
2007-02-27	AACQW-DELISTED	Stock	0.77	0.77	0.75	0.75	48500.0
2007-02-27	AAI-DELISTED	Stock	10.51	10.78	10.37	10.5	1860400.0
2007-02-27	AAIC-DELISTED	Stock	140.4	141.6	132.2	135.8	2056200.0
2007-02-27	AAME	Stock	3.59	3.66	3.41	3.44	17400.0
2007-02-27	AAON	Stock	3.703	3.7926	3.6543	3.6543	354628.0
2007-02-27	AAP	Stock	38.45	38.46	37.24	37.51	1140100.0
2007-02-27	AATI-DELISTED	Stock	6.73	6.74	6.16	6.3	270966.0
2007-02-27	AAU-DELISTED	Stock	2.47	2.47	2.24	2.26	71000.0
2007-02-27	AAUAF-DELISTED	Stock	2.47	2.47	2.24	2.26	71000.0
2007-02-27	AAV-DELISTED	Stock	10.74	10.74	10.45	10.57	452200.0
2007-02-27	AAWW-DELISTED	Stock	49.31	49.41	48.56	48.56	63086.0
2007-02-27	AAXN-DELISTED	Stock	8.30000019073486	8.31999969482422	8.0600004196167	8.10999965667725	2441100.0
2007-02-27	AB	Stock	81.25	86.84	80.23	84.68	903700.0
2007-02-27	ABAX-DELISTED	Stock	23.61	23.85	23.28	23.37	193235.0
2007-02-27	ABB-DELISTED	Stock	16.78	16.99	16.1	16.35	4135100.0
2007-02-27	ABBC-DELISTED	Stock	19.3844	19.56	19.25	19.35	14267.0
2007-02-27	ABC-DELISTED	Stock	26.89	26.98	26.0	26.16	1707097.0
2007-02-27	ABCB	Stock	23.5574	24.0048	23.4309	23.4991	49453.0
2007-02-27	ABCO-DELISTED	Stock	26.48	26.7	25.81	25.82	107193.0
2007-02-27	ABCW-DELISTED	Stock	28.75	28.85	28.25	28.25	60340.0
2007-02-27	ABD-DELISTED	Stock	22.14	22.41	21.76	22.05	379750.0
2007-02-27	ABE-DELISTED	Stock	19.02	19.02	17.85	17.87	88500.0
2007-02-27	ABFS-DELISTED	Stock	41.1	41.19	39.55	39.58	311116.0
2007-02-27	ABG	Stock	26.8	26.8	26.1	26.49	385700.0
2007-02-27	ABK-DELISTED	Stock	89.0	89.5	86.49	87.31	742800.0
2007-02-27	ABM	Stock	26.97	27.26	25.61	26.27	426700.0
2007-02-27	ABMD-DELISTED	Stock	14.37	14.4	13.65	13.71	99154.0
2007-02-27	ABP-DELISTED	Stock	3.12	3.15	3.04	3.06	132200.0
2007-02-27	ABR	Stock	31.25	31.41	30.0	31.0	343200.0
2007-02-27	ABT	Stock	25.9476	26.341	25.1415	25.8324	24714673.0
2007-02-27	ABTL-DELISTED	Stock	19.699	19.949	18.802	19.301	12927.0
2007-02-27	ABV-DELISTED	Stock	50.35	50.48	47.67	48.41	688600.0
2007-02-27	ABVA-DELISTED	Stock	15.95	15.95	15.9	15.9	10624.0
2007-02-27	ABX-DELISTED	Stock	30.98	31.07	29.45	30.02	5581800.0
2007-02-27	ACAD	Stock	7.5	7.54	7.1	7.18	369200.0
2007-02-27	ACAP-DELISTED	Stock	37.66	37.66	36.2	36.56	21487.0
2007-02-27	ACAS-DELISTED	Stock	46.05	46.1	44.07	44.77	1025665.0
2007-02-27	ACAT-DELISTED	Stock	18.57	18.77	18.4	18.58	67372.0
2007-02-27	ACC-DELISTED	Stock	30.81	31.05	29.85	30.14	87500.0

> showing 50 of 4,855 rows — these rows as CSV

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