PREVIEW / stock_daily / 2011-07-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-06.parquet
  size:    197 KB
  rows:    6,106
  symbols: 3,548

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
2011-07-06	AAPL	Stock	12.4625	12.6464	12.3825	12.5629	444626000.0
2011-07-06	MSFT	Stock	25.97	26.37	25.96	26.33	48744200.0
2011-07-06	NVDA	Stock	0.3968	0.3975	0.387	0.3918	529580000.0
2011-07-06	AMZN	Stock	10.606	10.72	10.5505	10.7095	52152000.0
2011-07-06	TSLA	Stock	1.9427	1.9427	1.9033	1.9307	13903500.0
2011-07-06	TLT	Stock	94.19	94.45	93.8399	94.32	5653198.0
2011-07-06	ES	Stock	35.6	35.69	35.36	35.5	1524000.0
2011-07-06	CL	Stock	43.845	44.21	43.83	44.21	4055400.0
2011-07-06	A	Stock	36.8455	37.1102	36.6667	37.0672	3521282.0
2011-07-06	AABA-DELISTED	Stock	15.54	15.8088	15.52	15.715	17565885.0
2011-07-06	AACC-DELISTED	Stock	3.94	4.01	3.93	3.96	46571.0
2011-07-06	AACG	Stock	10.62	11.25	10.62	10.67	12800.0
2011-07-06	AAIC-DELISTED	Stock	31.11	31.14	30.8	31.03	47378.0
2011-07-06	AAME	Stock	2.04	2.11	2.0	2.05	3300.0
2011-07-06	AAON	Stock	6.6015	6.7319	6.6015	6.717	98550.0
2011-07-06	AAP	Stock	58.21	58.82	57.95	58.11	1002200.0
2011-07-06	AAT	Stock	22.54	22.95	22.54	22.9	218700.0
2011-07-06	AATI-DELISTED	Stock	6.08	6.08	6.06	6.07	159784.0
2011-07-06	AAU-DELISTED	Stock	3.47	3.76	3.47	3.7	372997.0
2011-07-06	AAUAF-DELISTED	Stock	3.46	3.75	3.46	3.71	374844.0
2011-07-06	AAV-DELISTED	Stock	8.02	8.11	7.85	7.95	303651.0
2011-07-06	AAWW-DELISTED	Stock	60.59	61.35	59.53	61.21	114306.0
2011-07-06	AAXJ	Stock	62.55	62.59	62.18	62.54	349793.0
2011-07-06	AAXN-DELISTED	Stock	4.48	4.53	4.43	4.49	183751.0
2011-07-06	AB	Stock	19.2	19.34	18.97	19.11	248000.0
2011-07-06	ABAC-DELISTED	Stock	2.45	2.49	2.32	2.44	17884.0
2011-07-06	ABAX-DELISTED	Stock	28.73	29.6498	28.73	29.59	73315.0
2011-07-06	ABB-DELISTED	Stock	26.14	26.2	25.86	25.93	3213109.0
2011-07-06	ABBC-DELISTED	Stock	10.37	10.54	10.37	10.54	16995.0
2011-07-06	ABBNY-DELISTED	Stock	26.14	26.2	25.86	25.91	3222422.0
2011-07-06	ABC-DELISTED	Stock	42.19	43.27	42.08	43.1	2465866.0
2011-07-06	ABCB	Stock	8.77	9.11	8.77	9.02	29900.0
2011-07-06	ABCD-DELISTED	Stock	3.37	3.38	3.35	3.36	22233.0
2011-07-06	ABCO-DELISTED	Stock	28.66	28.71	28.27	28.57	99212.0
2011-07-06	ABCW-DELISTED	Stock	0.69	0.74	0.69	0.71	23220.0
2011-07-06	ABD-DELISTED	Stock	8.24	8.51	8.17	8.18	116320.0
2011-07-06	ABE-DELISTED	Stock	18.98	19.0	18.9	18.97	19475.0
2011-07-06	ABEO	Stock	2350.0	2362.5	2087.5	2250.0	15.0
2011-07-06	ABFS-DELISTED	Stock	24.4	26.99	24.29	26.88	2450351.0
2011-07-06	ABG	Stock	18.71	19.04	18.63	18.82	230400.0
2011-07-06	ABH-DELISTED	Stock	20.64	20.72	19.98	20.51	304231.0
2011-07-06	ABM	Stock	23.45	23.54	23.28	23.5	474600.0
2011-07-06	ABMD-DELISTED	Stock	16.7	17.02	16.5	16.92	123114.0
2011-07-06	ABR	Stock	4.75	4.79	4.6	4.62	84900.0
2011-07-06	ABT	Stock	25.5589	25.6405	25.5062	25.5637	7447895.0
2011-07-06	ABTL-DELISTED	Stock	5.6	5.95	5.6	5.8	25141.0
2011-07-06	ABUS	Stock	2.47	2.47	2.47	2.47	700.0
2011-07-06	ABV-DELISTED	Stock	34.31	34.68	34.21	34.46	3164309.0
2011-07-06	ABVA-DELISTED	Stock	4.8	4.8	4.5	4.63	7800.0
2011-07-06	ABVT-DELISTED	Stock	69.99	70.25	69.72	69.87	136582.0

> showing 50 of 6,106 rows — these rows as CSV

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