PREVIEW / stock_daily / 2010-02-03

all stock daily files

  file:    by_date/stock_daily/2010/2010-02-03.parquet
  size:    188 KB
  rows:    5,880
  symbols: 3,477

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
2010-02-03	AAPL	Stock	6.9704	7.15	6.9436	7.1154	615328000.0
2010-02-03	MSFT	Stock	28.26	28.79	28.12	28.63	61397900.0
2010-02-03	NVDA	Stock	0.4148	0.4238	0.4128	0.422	562296000.0
2010-02-03	AMZN	Stock	5.856	5.9805	5.828	5.955	248118000.0
2010-02-03	TLT	Stock	90.81	90.97	90.27	90.35	5343606.0
2010-02-03	ES	Stock	25.76	26.0	25.73	25.94	1407500.0
2010-02-03	CL	Stock	40.475	40.615	40.22	40.41	5777600.0
2010-02-03	A	Stock	21.0229	21.3805	21.0014	21.1302	6085634.0
2010-02-03	AABA-DELISTED	Stock	15.14	15.6	15.12	15.46	24583619.0
2010-02-03	AACC-DELISTED	Stock	5.77	5.83	5.52	5.54	22061.0
2010-02-03	AACG	Stock	3.42	3.63	3.3	3.53	10100.0
2010-02-03	AAI-DELISTED	Stock	4.93	4.93	4.83	4.9	2904001.0
2010-02-03	AAIC-DELISTED	Stock	15.25	15.25	14.76	15.11	15336.0
2010-02-03	AAME	Stock	1.39	1.39	1.39	1.39	2500.0
2010-02-03	AAON	Stock	4.1304	4.1304	4.0119	4.0691	243506.0
2010-02-03	AAP	Stock	41.19	41.38	40.93	41.19	1147600.0
2010-02-03	AATI-DELISTED	Stock	3.39	3.58	3.35	3.48	404432.0
2010-02-03	AAU-DELISTED	Stock	1.0	1.0	0.92	0.93	173852.0
2010-02-03	AAUAF-DELISTED	Stock	1.0	1.0	0.92	0.93	174452.0
2010-02-03	AAV-DELISTED	Stock	6.59	6.66	6.54	6.6599	323807.0
2010-02-03	AAWW-DELISTED	Stock	38.2	38.33	37.17	37.63	115233.0
2010-02-03	AAXJ	Stock	53.77	53.81	53.12	53.55	180410.0
2010-02-03	AAXN-DELISTED	Stock	5.93	6.0	5.81	5.85	767651.0
2010-02-03	AB	Stock	27.11	27.4	26.82	27.12	237500.0
2010-02-03	ABAX-DELISTED	Stock	24.0	24.4475	23.6	24.19	131441.0
2010-02-03	ABB-DELISTED	Stock	18.82	18.91	18.61	18.68	2926761.0
2010-02-03	ABBC-DELISTED	Stock	7.06	7.24	7.05	7.11	60780.0
2010-02-03	ABBNY-DELISTED	Stock	18.82	18.91	18.61	18.66	2977411.0
2010-02-03	ABC-DELISTED	Stock	28.51	28.59	28.03	28.35	3786992.0
2010-02-03	ABCB	Stock	9.0964	9.1556	9.047	9.1359	37665.0
2010-02-03	ABCD-DELISTED	Stock	3.75	3.75	3.611	3.67	24450.0
2010-02-03	ABCO-DELISTED	Stock	16.19	16.26	15.9	15.99	171162.0
2010-02-03	ABCW-DELISTED	Stock	1.13	1.16	1.1	1.1	94780.0
2010-02-03	ABD-DELISTED	Stock	7.72	7.86	7.46	7.83	425920.0
2010-02-03	ABE-DELISTED	Stock	16.33	16.364	16.23	16.245	4948.0
2010-02-03	ABEO	Stock	3375.0	3487.5	3312.5	3487.5	15.0
2010-02-03	ABFS-DELISTED	Stock	22.41	22.67	22.05	22.52	462279.0
2010-02-03	ABG	Stock	11.98	12.08	11.75	11.91	266600.0
2010-02-03	ABII-DELISTED	Stock	41.27	41.27	40.64	41.04	49179.0
2010-02-03	ABK-DELISTED	Stock	0.72	0.7295	0.68	0.6925	6892615.0
2010-02-03	ABM	Stock	19.4	19.79	19.38	19.55	89200.0
2010-02-03	ABMD-DELISTED	Stock	7.98	8.08	7.87	8.01	240619.0
2010-02-03	ABR	Stock	2.14	2.37	2.09	2.31	271000.0
2010-02-03	ABT	Stock	26.0867	26.2834	25.9572	26.2211	14158816.0
2010-02-03	ABTL-DELISTED	Stock	5.4	5.5	5.4	5.45	6740.0
2010-02-03	ABV-DELISTED	Stock	98.29	98.29	96.25	97.14	377378.0
2010-02-03	ABVT-DELISTED	Stock	59.04	59.87	59.0	59.295	56890.0
2010-02-03	ABX-DELISTED	Stock	36.13	36.67	35.86	35.87	7858516.0
2010-02-03	ACAD	Stock	1.42	1.53	1.39	1.46	1643900.0
2010-02-03	ACAP-DELISTED	Stock	27.43	28.06	27.05	27.6	29599.0

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

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