PREVIEW / etf_daily / 2011-07-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-18.parquet
  size:    37 KB
  rows:    869

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-18	SPY	ETF	131.08	131.28	129.63	130.61	196872100.0
2011-07-18	QQQ	ETF	57.535	57.79	56.98	57.54	59512187.0
2011-07-18	IWM	ETF	82.44	82.63	81.0	81.48	56859700.0
2011-07-18	DIA	ETF	123.9	124.02	122.72	123.62	6150200.0
2011-07-18	GLD	ETF	155.76	156.58	155.67	156.57	17133400.0
2011-07-18	TLT	ETF	96.06	96.17	95.2	95.24	8206500.0
2011-07-18	AADR	ETF	30.46	30.58	30.3	30.3	2500.0
2011-07-18	AAXJ	ETF	61.0	61.21	60.58	60.86	257800.0
2011-07-18	ACTV	ETF	18.38	18.53	18.19	18.39	93832.0
2011-07-18	ACWI	ETF	47.22	47.22	46.64	46.95	409800.0
2011-07-18	ACWX	ETF	43.2	43.3	42.79	43.07	82228.0
2011-07-18	ADRE	ETF	44.89	45.0564	44.64	44.89	42708.0
2011-07-18	AFK	ETF	31.5	31.61	31.32	31.52	7458.0
2011-07-18	AGEM	ETF	25.35	25.532	25.28	25.532	2393.0
2011-07-18	AGG	ETF	107.57	107.65	107.38	107.43	641600.0
2011-07-18	AGQ	ETF	437.4	446.44	432.5	441.62	1085050.0
2011-07-18	AGZ	ETF	110.92	110.96	110.815	110.876	37041.0
2011-07-18	AIA	ETF	45.52	45.61	45.09	45.42	32517.0
2011-07-18	AIQ	ETF	17.95	18.0	17.55	17.6	12592.0
2011-07-18	AIS	ETF	2.34	2.34	2.19	2.25	1368959.0
2011-07-18	AIVI	ETF	44.24	44.37	43.86	44.28	30800.0
2011-07-18	AMJ	ETF	37.29	37.29	36.97	37.13	296335.0
2011-07-18	AMLP	ETF	80.3	80.35	79.9	80.1	65160.0
2011-07-18	AOA	ETF	35.45	35.49	35.11	35.22	8000.0
2011-07-18	AOK	ETF	29.41	29.41	29.2764	29.349	23493.0
2011-07-18	AOM	ETF	30.5101	30.5101	30.42	30.45	8001.0
2011-07-18	AOR	ETF	32.42	32.42	32.154	32.28	19493.0
2011-07-18	ARB	ETF	40.16	40.47	39.3	39.58	66857.0
2011-07-18	ARGT	ETF	29.24	29.34	29.24	29.28	300.0
2011-07-18	ASEA	ETF	16.82	16.82	16.67	16.77	7300.0
2011-07-18	AWAY	ETF	42.44	43.19	41.6728	42.0	109056.0
2011-07-18	BAB	ETF	26.58	26.64	26.5514	26.57	124945.0
2011-07-18	BAL	ETF	58.17	61.8292	57.72	60.32	177223.0
2011-07-18	BALT	ETF	4.9	4.91	4.71	4.76	201701.0
2011-07-18	BBH	ETF	34.66	34.7033	34.2567	34.5567	33300.0
2011-07-18	BCM	ETF	48.05	48.05	48.05	48.05	1776.0
2011-07-18	BIB	ETF	9.705	9.7075	9.3138	9.4635	243256.0
2011-07-18	BICK	ETF	31.28	31.28	30.894	31.1212	4746.0
2011-07-18	BIL	ETF	91.7	91.72	91.7	91.72	803350.0
2011-07-18	BIS	ETF	6080.0	6083.2	6048.0	6048.0	5.0
2011-07-18	BITS	ETF	22.0	23.88	22.0	23.32	1368.0
2011-07-18	BIV	ETF	85.22	85.24	84.93	85.0	300400.0
2011-07-18	BJK	ETF	34.95	35.04	34.48	34.77	10100.0
2011-07-18	BKF	ETF	46.17	46.17	45.71	45.9	65901.0
2011-07-18	BKLN	ETF	24.76	24.8	24.76	24.77	62600.0
2011-07-18	BLV	ETF	81.21	81.35	80.68	80.75	52100.0
2011-07-18	BMVP	ETF	15.3867	15.4271	15.3267	15.4271	10808.0
2011-07-18	BND	ETF	81.84	81.86	81.71	81.71	799100.0
2011-07-18	BNO	ETF	39.0	39.0	38.375	38.855	86600.0
2011-07-18	BOSS	ETF	73.5	73.5	72.97	72.97	100.0

> showing 50 of 869 rows — these rows as CSV

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