PREVIEW / stock_daily / 2011-06-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-16.parquet
  size:    198 KB
  rows:    6,128
  symbols: 3,565

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-06-16	AAPL	Stock	11.675	11.7386	11.3689	11.6129	510591200.0
2011-06-16	MSFT	Stock	23.75	24.1	23.65	24.0	57184100.0
2011-06-16	NVDA	Stock	0.4195	0.426	0.3988	0.4048	1024908000.0
2011-06-16	AMZN	Stock	9.287	9.35	9.0795	9.1825	120642000.0
2011-06-16	TSLA	Stock	1.8447	1.8667	1.716	1.7667	27633000.0
2011-06-16	TLT	Stock	97.1	97.53	96.8	97.36	10961212.0
2011-06-16	ES	Stock	33.95	34.31	33.91	34.27	1680600.0
2011-06-16	CL	Stock	43.03	43.365	42.895	43.285	5717000.0
2011-06-16	A	Stock	33.7983	34.1631	33.176	33.6624	4245027.0
2011-06-16	AABA-DELISTED	Stock	15.01	15.09	14.65	14.78	24324349.0
2011-06-16	AACC-DELISTED	Stock	3.23	3.37	3.13	3.36	42432.0
2011-06-16	AACG	Stock	10.75	10.76	10.39	10.39	16900.0
2011-06-16	AAIC-DELISTED	Stock	28.98	29.2	28.61	28.78	88625.0
2011-06-16	AAME	Stock	1.98	2.05	1.98	2.04	500.0
2011-06-16	AAON	Stock	6.3111	6.5393	6.3111	6.5007	216000.0
2011-06-16	AAP	Stock	57.18	58.74	57.07	58.59	1705200.0
2011-06-16	AAT	Stock	21.63	22.07	21.46	21.5	135900.0
2011-06-16	AATI-DELISTED	Stock	6.05	6.05	6.04	6.04	235801.0
2011-06-16	AAU-DELISTED	Stock	3.05	3.11	2.934	2.95	360621.0
2011-06-16	AAUAF-DELISTED	Stock	3.05	3.11	2.934	2.95	360821.0
2011-06-16	AAV-DELISTED	Stock	7.81	7.9	7.69	7.74	420053.0
2011-06-16	AAWW-DELISTED	Stock	56.39	57.3	55.66	56.4	141150.0
2011-06-16	AAXJ	Stock	60.19	60.47	59.77	60.16	401029.0
2011-06-16	AAXN-DELISTED	Stock	4.23	4.32	4.15	4.26	352642.0
2011-06-16	AB	Stock	19.2	19.29	18.82	18.84	416200.0
2011-06-16	ABAC-DELISTED	Stock	2.07	2.18	2.05	2.13	41982.0
2011-06-16	ABAX-DELISTED	Stock	28.43	28.45	27.51	28.03	51709.0
2011-06-16	ABB-DELISTED	Stock	24.71	24.91	24.57	24.79	2548580.0
2011-06-16	ABBC-DELISTED	Stock	10.23	10.69	10.23	10.66	38750.0
2011-06-16	ABBNY-DELISTED	Stock	24.71	24.91	24.57	24.78	2789480.0
2011-06-16	ABC-DELISTED	Stock	41.11	41.11	40.47	41.06	2474970.0
2011-06-16	ABCB	Stock	8.58	9.26	8.52	9.13	124000.0
2011-06-16	ABCD-DELISTED	Stock	3.16	3.2	3.14	3.19	12502.0
2011-06-16	ABCO-DELISTED	Stock	24.35	25.22	24.3	25.2	142402.0
2011-06-16	ABCW-DELISTED	Stock	0.76	0.78	0.66	0.72	29790.0
2011-06-16	ABD-DELISTED	Stock	7.38	7.59	7.3	7.54	200880.0
2011-06-16	ABE-DELISTED	Stock	18.27	18.35	18.1538	18.23	13289.0
2011-06-16	ABEO	Stock	2250.0	2375.0	2237.5	2337.5	20.0
2011-06-16	ABFS-DELISTED	Stock	21.91	22.7	21.91	22.24	348766.0
2011-06-16	ABG	Stock	15.47	15.86	15.28	15.64	356700.0
2011-06-16	ABH-DELISTED	Stock	21.79	21.92	21.19	21.46	676609.0
2011-06-16	ABM	Stock	22.22	22.65	22.08	22.17	386600.0
2011-06-16	ABMD-DELISTED	Stock	15.99	16.34	15.85	16.26	155684.0
2011-06-16	ABR	Stock	4.46	4.53	4.3	4.35	98700.0
2011-06-16	ABT	Stock	24.6185	24.6761	24.513	24.6185	13556273.0
2011-06-16	ABTL-DELISTED	Stock	4.9524	5.2495	4.7048	5.2	27573.0
2011-06-16	ABUS	Stock	2.75	2.76	2.75	2.75	6200.0
2011-06-16	ABV-DELISTED	Stock	31.25	31.4	30.7	31.04	2080212.0
2011-06-16	ABVA-DELISTED	Stock	4.99	5.0501	4.99	5.05	12900.0
2011-06-16	ABVT-DELISTED	Stock	71.5	71.99	70.24	71.34	216061.0

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

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