PREVIEW / stock_daily / 2010-09-07

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-07.parquet
  size:    190 KB
  rows:    5,947
  symbols: 3,487

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-09-07	AAPL	Stock	9.1657	9.2689	9.1518	9.2075	342557600.0
2010-09-07	MSFT	Stock	24.1	24.3	23.92	23.96	51928700.0
2010-09-07	NVDA	Stock	0.2468	0.2555	0.2462	0.2498	899820000.0
2010-09-07	AMZN	Stock	6.878	6.93	6.8445	6.861	77660000.0
2010-09-07	TSLA	Stock	1.374	1.4	1.3667	1.3693	3651000.0
2010-09-07	TLT	Stock	105.09	105.78	104.81	105.7	6018384.0
2010-09-07	ES	Stock	29.4	29.43	29.21	29.23	1015800.0
2010-09-07	CL	Stock	37.35	37.875	37.255	37.38	7220000.0
2010-09-07	A	Stock	21.2375	21.2518	20.7082	20.7368	3085805.0
2010-09-07	AABA-DELISTED	Stock	13.56	13.62	13.5	13.54	10193131.0
2010-09-07	AACC-DELISTED	Stock	4.01	4.01	3.76	3.79	16260.0
2010-09-07	AACG	Stock	2.91	2.99	2.85	2.97	70200.0
2010-09-07	AAI-DELISTED	Stock	4.74	4.75	4.59	4.6	914133.0
2010-09-07	AAIC-DELISTED	Stock	21.23	21.23	20.63	20.74	36177.0
2010-09-07	AAME	Stock	1.44	1.44	1.34	1.43	26200.0
2010-09-07	AAON	Stock	4.4425	4.4464	4.3457	4.3595	205537.0
2010-09-07	AAP	Stock	56.38	56.88	56.04	56.28	562600.0
2010-09-07	AATI-DELISTED	Stock	3.4	3.42	3.29	3.3	79997.0
2010-09-07	AAU-DELISTED	Stock	2.6	2.96	2.52	2.86	2042182.0
2010-09-07	AAUAF-DELISTED	Stock	2.6	2.96	2.52	2.87	2051175.0
2010-09-07	AAV-DELISTED	Stock	6.23	6.37	6.185	6.34	356021.0
2010-09-07	AAWW-DELISTED	Stock	48.98	49.54	47.35	47.92	302029.0
2010-09-07	AAXJ	Stock	56.8	56.81	56.11	56.17	146382.0
2010-09-07	AAXN-DELISTED	Stock	3.99	4.0	3.92	3.92	236795.0
2010-09-07	AB	Stock	25.04	25.1	24.43	24.51	473800.0
2010-09-07	ABAC-DELISTED	Stock	3.96	3.97	3.765	3.81	10815.0
2010-09-07	ABAX-DELISTED	Stock	19.45	19.96	19.26	19.56	208382.0
2010-09-07	ABB-DELISTED	Stock	20.27	20.28	20.11	20.15	1476605.0
2010-09-07	ABBC-DELISTED	Stock	10.31	10.31	10.17	10.25	63822.0
2010-09-07	ABBNY-DELISTED	Stock	20.27	20.28	20.11	20.17	1478448.0
2010-09-07	ABC-DELISTED	Stock	27.99	28.2	27.74	28.04	2114179.0
2010-09-07	ABCB	Stock	8.57	8.57	8.34	8.36	43400.0
2010-09-07	ABCD-DELISTED	Stock	3.1	3.1	2.96	3.02	39412.0
2010-09-07	ABCO-DELISTED	Stock	21.49	21.49	21.16	21.24	60357.0
2010-09-07	ABCW-DELISTED	Stock	0.65	0.65	0.63	0.64	93590.0
2010-09-07	ABD-DELISTED	Stock	6.17	6.24	5.9415	5.97	264120.0
2010-09-07	ABE-DELISTED	Stock	17.3	17.3	17.26	17.26	4103.0
2010-09-07	ABEO	Stock	2500.0	2500.0	2437.5	2500.0	3.0
2010-09-07	ABFS-DELISTED	Stock	22.31	22.65	21.6	22.15	353379.0
2010-09-07	ABG	Stock	13.54	13.56	13.02	13.08	140500.0
2010-09-07	ABII-DELISTED	Stock	73.94	74.11	73.81	74.03	36533.0
2010-09-07	ABK-DELISTED	Stock	0.5568	0.58	0.537	0.54	3726684.0
2010-09-07	ABM	Stock	21.31	21.47	21.01	21.22	323200.0
2010-09-07	ABMD-DELISTED	Stock	9.66	9.71	9.41	9.5	218113.0
2010-09-07	ABR	Stock	4.71	4.71	4.57	4.57	26900.0
2010-09-07	ABT	Stock	24.2299	24.369	24.1627	24.2251	9685702.0
2010-09-07	ABTL-DELISTED	Stock	4.25	4.25	4.1	4.25	14867.0
2010-09-07	ABV-DELISTED	Stock	111.73	114.37	111.73	113.25	328637.0
2010-09-07	ABVT-DELISTED	Stock	52.99	52.99	51.495	51.57	71167.0
2010-09-07	ABX-DELISTED	Stock	45.88	46.342	45.5	45.74	6179335.0

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

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