PREVIEW / etf_daily / 2012-07-02

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-02.parquet
  size:    38 KB
  rows:    920

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
2012-07-02	SPY	ETF	136.48	136.65	135.52	136.51	129524500.0
2012-07-02	QQQ	ETF	64.23	64.38	63.87	64.35	33432708.0
2012-07-02	IWM	ETF	79.92	80.51	79.28	80.48	53370400.0
2012-07-02	DIA	ETF	128.62	128.77	127.69	128.36	3837000.0
2012-07-02	GLD	ETF	154.67	155.55	154.34	155.09	3654200.0
2012-07-02	TLT	ETF	125.45	127.21	125.37	126.22	7818500.0
2012-07-02	AAXJ	ETF	52.51	52.65	52.2	52.58	200700.0
2012-07-02	ACTV	ETF	15.52	15.52	15.13	15.46	205261.0
2012-07-02	ACWI	ETF	44.01	44.16	43.72	44.13	1440200.0
2012-07-02	ACWV	ETF	54.54	55.37	54.37	54.84	252600.0
2012-07-02	ACWX	ETF	37.23	37.41	37.11	37.4	214828.0
2012-07-02	ADRE	ETF	37.66	37.81	37.5	37.81	66048.0
2012-07-02	AFK	ETF	27.77	28.1	27.69	28.02	28021.0
2012-07-02	AGEM	ETF	21.17	21.17	21.17	21.17	308.0
2012-07-02	AGG	ETF	111.17	111.32	111.08	111.29	1994500.0
2012-07-02	AGQ	ETF	152.52	154.16	151.0	152.96	202100.0
2012-07-02	AGZ	ETF	113.38	113.66	113.35	113.56	74013.0
2012-07-02	AIA	ETF	41.45	41.5399	41.18	41.3	81623.0
2012-07-02	AIQ	ETF	5.05	5.45	4.75	4.75	6473.0
2012-07-02	AIVI	ETF	38.05	38.58	37.88	38.29	35800.0
2012-07-02	AMJ	ETF	38.64	41.12	38.4868	39.22	4032737.0
2012-07-02	AMLP	ETF	79.95	80.55	79.7	80.5	575040.0
2012-07-02	ANGL	ETF	25.45	25.45	25.45	25.45	400.0
2012-07-02	AOA	ETF	35.08	35.1	34.94	35.1	21200.0
2012-07-02	AOK	ETF	29.97	30.1599	29.91	30.05	22718.0
2012-07-02	AOM	ETF	30.74	30.779	30.67	30.7684	82454.0
2012-07-02	AOR	ETF	32.55	32.57	32.4401	32.554	79983.0
2012-07-02	ARB	ETF	35.0	35.86	34.91	35.86	139045.0
2012-07-02	ASEA	ETF	15.51	15.64	15.51	15.59	7200.0
2012-07-02	AWAY	ETF	23.28	23.57	21.64	21.87	554611.0
2012-07-02	BAB	ETF	29.89	29.9791	29.79	29.89	210444.0
2012-07-02	BAL	ETF	47.01	47.68	46.46	47.67	14851.0
2012-07-02	BALT	ETF	3.44	3.54	3.4	3.46	65427.0
2012-07-02	BBH	ETF	47.29	48.36	47.29	48.36	53200.0
2012-07-02	BCM	ETF	41.66	41.709	41.546	41.6	52185.0
2012-07-02	BIB	ETF	13.0325	13.7207	13.0325	13.7207	49240.0
2012-07-02	BICK	ETF	22.49	22.59	22.45	22.45	3462.0
2012-07-02	BIL	ETF	91.62	91.64	91.62	91.62	873900.0
2012-07-02	BIS	ETF	3288.0	3291.2	3009.6	3009.6	77.5
2012-07-02	BIV	ETF	88.8	89.12	88.75	89.0	250600.0
2012-07-02	BJK	ETF	32.06	32.06	31.85	31.88	3700.0
2012-07-02	BKF	ETF	35.78	36.09	35.66	36.05	143067.0
2012-07-02	BKLN	ETF	24.32	24.45	24.32	24.42	221400.0
2012-07-02	BLV	ETF	94.94	96.03	94.86	95.52	58100.0
2012-07-02	BMVP	ETF	15.3567	15.3867	15.2867	15.3661	50501.0
2012-07-02	BND	ETF	84.26	84.45	84.23	84.37	1244100.0
2012-07-02	BNO	ETF	34.205	34.595	33.875	34.495	90400.0
2012-07-02	BOIL	ETF	876800.0	931400.0	868600.0	916600.0	9.4
2012-07-02	BOND	ETF	105.64	105.94	105.5801	105.76	568573.0
2012-07-02	BRF	ETF	36.72	37.0	36.68	36.97	63883.0

> showing 50 of 920 rows — these rows as CSV

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