PREVIEW / stock_daily / 2007-02-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-20.parquet
  size:    162 KB
  rows:    4,879
  symbols: 3,069

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-20	AAPL	Stock	3.0232	3.0771	3.0057	3.0679	617702400.0
2007-02-20	MSFT	Stock	28.63	28.86	28.47	28.83	53978200.0
2007-02-20	NVDA	Stock	0.5462	0.5532	0.5423	0.5502	625578000.0
2007-02-20	AMZN	Stock	2.0065	2.087	2.0	2.0755	178068000.0
2007-02-20	TLT	Stock	88.5	88.85	88.5	88.84	847400.0
2007-02-20	CL	Stock	34.225	34.495	34.02	34.435	3328400.0
2007-02-20	A	Stock	23.2332	23.3906	23.0114	23.2403	5680214.0
2007-02-20	AABA-DELISTED	Stock	31.7999992370605	32.2099990844727	31.3899993896484	32.0099983215332	20026500.0
2007-02-20	AACC-DELISTED	Stock	15.48	15.75	15.43	15.64	67535.0
2007-02-20	AACQ-DELISTED	Stock	5.6	5.6	5.57	5.59	160604.0
2007-02-20	AACQW-DELISTED	Stock	0.8	0.8	0.76	0.76	741270.0
2007-02-20	AAI-DELISTED	Stock	11.47	11.6	11.3	11.47	1483600.0
2007-02-20	AAIC-DELISTED	Stock	140.6	143.4	139.0	141.2	2279200.0
2007-02-20	AAME	Stock	3.9	4.01	3.82	3.86	4500.0
2007-02-20	AAON	Stock	3.736	3.9111	3.6938	3.8848	400191.0
2007-02-20	AAP	Stock	38.46	38.76	37.88	38.03	1054300.0
2007-02-20	AATI-DELISTED	Stock	6.0	6.42	5.99	6.37	760819.0
2007-02-20	AAU-DELISTED	Stock	2.42	2.42	2.27	2.27	95400.0
2007-02-20	AAUAF-DELISTED	Stock	2.42	2.42	2.27	2.27	95400.0
2007-02-20	AAV-DELISTED	Stock	10.66	10.66	10.5	10.5	1016400.0
2007-02-20	AAWW-DELISTED	Stock	49.79	50.38	49.71	50.2	125137.0
2007-02-20	AAXN-DELISTED	Stock	8.1899995803833	8.39999961853027	8.05000019073486	8.31999969482422	1960800.0
2007-02-20	AB	Stock	91.5	92.9	91.1	92.5	152400.0
2007-02-20	ABAX-DELISTED	Stock	23.45	23.98	23.3	23.59	292830.0
2007-02-20	ABB-DELISTED	Stock	18.01	18.05	17.86	18.04	1867100.0
2007-02-20	ABBC-DELISTED	Stock	19.35	19.81	19.35	19.6	5340.0
2007-02-20	ABC-DELISTED	Stock	27.44	27.6	27.4	27.51	1201400.0
2007-02-20	ABCB	Stock	22.9738	23.3628	22.9738	23.3045	28068.0
2007-02-20	ABCO-DELISTED	Stock	27.09	27.12	26.75	26.98	165621.0
2007-02-20	ABCW-DELISTED	Stock	28.95	29.21	28.66	29.17	39830.0
2007-02-20	ABD-DELISTED	Stock	22.97	23.51	22.43	22.87	801240.0
2007-02-20	ABE-DELISTED	Stock	19.19	19.5	18.9	19.24	30000.0
2007-02-20	ABFS-DELISTED	Stock	40.52	40.8	40.15	40.77	368559.0
2007-02-20	ABG	Stock	26.7	27.11	26.6	26.92	336300.0
2007-02-20	ABK-DELISTED	Stock	90.95	91.83	90.27	91.57	493700.0
2007-02-20	ABM	Stock	27.39	27.39	27.01	27.25	363500.0
2007-02-20	ABMD-DELISTED	Stock	14.73	14.88	14.42	14.85	90495.0
2007-02-20	ABP-DELISTED	Stock	3.03	3.08	3.0	3.03	152200.0
2007-02-20	ABR	Stock	34.0	34.45	33.66	34.03	452100.0
2007-02-20	ABT	Stock	25.1847	25.2711	25.0839	25.2279	9511463.0
2007-02-20	ABTL-DELISTED	Stock	19.074	20.03	18.624	19.98	62331.0
2007-02-20	ABV-DELISTED	Stock	52.71	53.05	52.23	52.45	254700.0
2007-02-20	ABVA-DELISTED	Stock	16.15	16.15	16.05	16.1	2000.0
2007-02-20	ABX-DELISTED	Stock	31.0	31.0	30.6	30.96	4591400.0
2007-02-20	ACAD	Stock	7.18	7.22	7.05	7.18	95500.0
2007-02-20	ACAP-DELISTED	Stock	36.64	39.31	36.4	38.8	89214.0
2007-02-20	ACAS-DELISTED	Stock	48.06	48.07	47.44	47.93	1256780.0
2007-02-20	ACAT-DELISTED	Stock	18.42	18.42	17.79	18.15	93673.0
2007-02-20	ACC-DELISTED	Stock	31.86	32.12	31.33	32.12	95510.0
2007-02-20	ACCL-DELISTED	Stock	6.21	6.48	6.21	6.33	137629.0

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

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