PREVIEW / stock_daily / 2010-07-08

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-08.parquet
  size:    188 KB
  rows:    5,923
  symbols: 3,484

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-07-08	AAPL	Stock	9.3743	9.3893	9.1032	9.2175	738144400.0
2010-07-08	MSFT	Stock	24.6	24.62	23.97	24.41	50758100.0
2010-07-08	NVDA	Stock	0.2675	0.2678	0.2545	0.2578	783272000.0
2010-07-08	AMZN	Stock	5.751	5.874	5.7035	5.811	135500000.0
2010-07-08	TSLA	Stock	1.076	1.168	1.038	1.164	115671000.0
2010-07-08	TLT	Stock	99.82	100.16	99.5501	99.79	6260593.0
2010-07-08	ES	Stock	26.98	27.33	26.74	27.05	2110900.0
2010-07-08	CL	Stock	40.635	41.035	40.56	40.98	4827200.0
2010-07-08	A	Stock	20.5794	20.7082	20.3004	20.608	5118078.0
2010-07-08	AABA-DELISTED	Stock	14.45	14.7745	14.4	14.59	16000891.0
2010-07-08	AACC-DELISTED	Stock	4.1	4.1	3.82	3.92	61594.0
2010-07-08	AACG	Stock	2.99	3.01	2.99	3.01	5400.0
2010-07-08	AAI-DELISTED	Stock	4.88	4.94	4.81	4.87	2548601.0
2010-07-08	AAIC-DELISTED	Stock	18.88	19.18	18.71	19.18	47625.0
2010-07-08	AAME	Stock	1.26	1.28	1.26	1.28	3200.0
2010-07-08	AAON	Stock	4.6657	4.6933	4.6242	4.6815	207056.0
2010-07-08	AAP	Stock	51.08	51.88	50.17	50.82	1154300.0
2010-07-08	AATI-DELISTED	Stock	3.11	3.15	3.01	3.05	125859.0
2010-07-08	AAU-DELISTED	Stock	0.91	0.95	0.91	0.94	154768.0
2010-07-08	AAUAF-DELISTED	Stock	0.91	0.95	0.91	0.94	155868.0
2010-07-08	AAV-DELISTED	Stock	6.0	6.17	5.95	6.13	593810.0
2010-07-08	AAWW-DELISTED	Stock	48.67	50.42	47.55	50.27	266557.0
2010-07-08	AAXJ	Stock	53.88	54.15	53.6	54.15	1715221.0
2010-07-08	AAXN-DELISTED	Stock	3.82	3.85	3.68	3.76	843123.0
2010-07-08	AB	Stock	26.08	27.21	26.08	26.94	249000.0
2010-07-08	ABAX-DELISTED	Stock	21.41	21.51	20.48	20.67	163854.0
2010-07-08	ABB-DELISTED	Stock	18.66	18.69	18.39	18.69	3098769.0
2010-07-08	ABBC-DELISTED	Stock	9.0	9.11	8.95	9.045	46043.0
2010-07-08	ABBNY-DELISTED	Stock	18.66	18.69	18.39	18.66	3103882.0
2010-07-08	ABC-DELISTED	Stock	31.97	32.07	31.725	31.92	2913199.0
2010-07-08	ABCB	Stock	10.12	10.24	9.84	9.98	56000.0
2010-07-08	ABCD-DELISTED	Stock	3.57	3.75	3.57	3.7	49454.0
2010-07-08	ABCO-DELISTED	Stock	21.29	21.39	20.96	20.99	103842.0
2010-07-08	ABCW-DELISTED	Stock	0.4894	0.4894	0.4502	0.46	33100.0
2010-07-08	ABD-DELISTED	Stock	5.13	5.43	5.11	5.33	442480.0
2010-07-08	ABE-DELISTED	Stock	16.44	16.47	16.37	16.45	6500.0
2010-07-08	ABEO	Stock	2350.0	2350.0	2250.0	2350.0	4.0
2010-07-08	ABFS-DELISTED	Stock	20.57	21.35	20.57	21.15	468954.0
2010-07-08	ABG	Stock	10.4	10.58	10.18	10.33	250100.0
2010-07-08	ABII-DELISTED	Stock	74.23	74.31	73.88	73.97	47031.0
2010-07-08	ABK-DELISTED	Stock	0.67	0.679	0.635	0.67	6885633.0
2010-07-08	ABM	Stock	21.05	21.55	20.88	21.52	330400.0
2010-07-08	ABMD-DELISTED	Stock	10.59	10.77	10.35	10.61	242437.0
2010-07-08	ABR	Stock	5.07	5.09	4.99	5.03	131500.0
2010-07-08	ABT	Stock	22.9824	23.1024	22.8769	23.0784	15291997.0
2010-07-08	ABTL-DELISTED	Stock	6.0	6.0	5.75	5.85	7948.0
2010-07-08	ABV-DELISTED	Stock	105.97	105.97	104.65	105.57	731649.0
2010-07-08	ABVA-DELISTED	Stock	2.79	2.79	2.51	2.51	487.0
2010-07-08	ABVT-DELISTED	Stock	48.0	48.22	47.12	47.92	83625.0
2010-07-08	ABX-DELISTED	Stock	44.28	44.29	42.01	42.55	13094641.0

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

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