PREVIEW / etf_daily / 2011-06-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-15.parquet
  size:    36 KB
  rows:    856

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-15	SPY	ETF	128.24	129.3	126.68	127.02	300958000.0
2011-06-15	QQQ	ETF	54.83	55.15	54.18	54.29	59022345.0
2011-06-15	IWM	ETF	78.6	79.21	77.72	78.03	89262000.0
2011-06-15	DIA	ETF	119.65	120.06	118.55	118.88	20958800.0
2011-06-15	GLD	ETF	148.16	149.55	147.92	149.12	14550700.0
2011-06-15	TLT	ETF	95.38	96.94	95.37	96.92	12979100.0
2011-06-15	AADR	ETF	30.45	30.45	30.45	30.45	300.0
2011-06-15	AAXJ	ETF	61.01	61.15	60.36	60.56	523500.0
2011-06-15	ACTV	ETF	18.93	19.11	18.5325	18.99	98908.0
2011-06-15	ACWI	ETF	47.15	47.34	46.54	46.76	463800.0
2011-06-15	ACWX	ETF	44.19	44.34	43.56	43.61	677922.0
2011-06-15	ADRE	ETF	45.1	45.28	44.76	44.98	41442.0
2011-06-15	AFK	ETF	32.25	32.3	31.7126	31.89	25404.0
2011-06-15	AGG	ETF	107.08	107.47	107.06	107.32	1395500.0
2011-06-15	AGQ	ETF	342.04	355.92	338.9	352.14	811850.0
2011-06-15	AGZ	ETF	110.68	110.9	110.66	110.83	40638.0
2011-06-15	AIA	ETF	46.59	46.6001	46.11	46.1934	19237.0
2011-06-15	AIQ	ETF	18.9	19.3	18.75	19.2	21344.0
2011-06-15	AIS	ETF	2.0	2.02	1.92	1.92	790141.0
2011-06-15	AIVI	ETF	46.71	46.83	45.82	46.06	39700.0
2011-06-15	AMJ	ETF	36.1	36.24	35.63	35.96	335289.0
2011-06-15	AMLP	ETF	78.6	79.0	78.2	78.75	113680.0
2011-06-15	AOA	ETF	34.91	35.02	34.52	34.62	16100.0
2011-06-15	AOK	ETF	29.1552	29.1552	29.1001	29.12	47565.0
2011-06-15	AOM	ETF	30.45	30.47	30.33	30.3357	24323.0
2011-06-15	AOR	ETF	32.12	32.13	31.91	31.9599	26634.0
2011-06-15	ARB	ETF	38.74	38.87	37.51	38.14	174214.0
2011-06-15	ARGT	ETF	28.8	28.82	28.34	28.4	2650.0
2011-06-15	ASEA	ETF	15.94	15.94	15.84	15.94	1200.0
2011-06-15	BAB	ETF	26.52	26.7	26.46	26.65	109125.0
2011-06-15	BAL	ETF	80.24	80.8	78.0	78.49	112640.0
2011-06-15	BALT	ETF	6.01	6.14	5.84	5.86	109665.0
2011-06-15	BBH	ETF	33.9767	34.3533	33.95	33.95	29400.0
2011-06-15	BCM	ETF	46.98	46.98	46.98	46.98	820.0
2011-06-15	BIB	ETF	9.1788	9.2415	8.9038	8.9437	116392.0
2011-06-15	BICK	ETF	31.44	31.44	30.933	31.05	31295.0
2011-06-15	BIL	ETF	91.72	91.72	91.7	91.72	113650.0
2011-06-15	BIS	ETF	6388.8	6471.2	6235.2	6471.2	21.6
2011-06-15	BITS	ETF	21.64	21.84	21.08	21.6	3118.0
2011-06-15	BIV	ETF	84.28	84.89	84.27	84.81	98600.0
2011-06-15	BJK	ETF	32.64	32.69	32.15	32.24	9300.0
2011-06-15	BKF	ETF	46.89	47.01	46.3	46.48	239794.0
2011-06-15	BKLN	ETF	24.85	24.86	24.8	24.84	66200.0
2011-06-15	BLNG	ETF	48.34	48.34	48.34	48.34	1000.0
2011-06-15	BLV	ETF	81.05	81.85	80.82	81.72	33600.0
2011-06-15	BMVP	ETF	15.05	15.1	14.86	14.87	22198.0
2011-06-15	BND	ETF	81.45	81.78	81.41	81.7	1002500.0
2011-06-15	BNO	ETF	39.175	39.365	37.5	37.93	487600.0
2011-06-15	BRF	ETF	56.65	56.78	55.25	55.8	414994.0
2011-06-15	BSCE	ETF	21.14	21.28	21.14	21.2	35590.0

> showing 50 of 856 rows — these rows as CSV

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