PREVIEW / etf_daily / 2014-10-30

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-30.parquet
  size:    46 KB
  rows:    1,134

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
2014-10-30	SPY	ETF	197.58	199.95	197.4	199.38	113330000.0
2014-10-30	QQQ	ETF	99.37	100.26	99.14	100.02	35935794.0
2014-10-30	IWM	ETF	113.49	115.38	113.14	114.87	59046200.0
2014-10-30	DIA	ETF	169.63	171.94	169.6	171.6	7449200.0
2014-10-30	GLD	ETF	115.8	115.83	114.94	115.19	7852200.0
2014-10-30	TLT	ETF	120.32	120.46	119.51	119.56	7024400.0
2014-10-30	AAXJ	ETF	62.11	62.72	62.08	62.57	994800.0
2014-10-30	ACWI	ETF	58.19	58.98	58.19	58.83	1028700.0
2014-10-30	ACWV	ETF	67.95	68.73	67.95	68.61	71400.0
2014-10-30	ACWX	ETF	44.3571	44.84	44.28	44.7	104717.0
2014-10-30	ADRE	ETF	39.01	39.22	38.907	39.15	28569.0
2014-10-30	AFK	ETF	29.55	29.69	29.4001	29.63	10458.0
2014-10-30	AGG	ETF	110.05	110.19	110.03	110.08	2479500.0
2014-10-30	AGQ	ETF	43.86	43.86	42.1	42.85	473500.0
2014-10-30	AGZ	ETF	113.1425	113.17	112.72	112.99	4479.0
2014-10-30	AGZD	ETF	24.8	24.84	24.755	24.835	9400.0
2014-10-30	AIA	ETF	47.57	47.8184	47.55	47.79	32380.0
2014-10-30	AIQ	ETF	25.04	25.2697	24.85	25.12	12321.0
2014-10-30	AIRR	ETF	18.84	18.98	18.54	18.84	25700.0
2014-10-30	AIVI	ETF	45.14	45.78	45.11	45.61	16200.0
2014-10-30	AMJ	ETF	50.99	51.21	50.32	50.4	465937.0
2014-10-30	AMLP	ETF	93.85	93.85	92.7	92.8	686920.0
2014-10-30	AMZA	ETF	244.9	244.9	242.5	242.5	210.0
2014-10-30	ANGL	ETF	27.87	27.89	27.53	27.53	3300.0
2014-10-30	AOA	ETF	45.64	46.03	45.56	45.9	59300.0
2014-10-30	AOK	ETF	32.55	32.64	32.46	32.62	36518.0
2014-10-30	AOM	ETF	34.89	35.1299	34.89	35.06	47148.0
2014-10-30	AOR	ETF	39.59	39.85	39.5635	39.8	44115.0
2014-10-30	ARGT	ETF	19.73	20.19	19.73	20.14	10500.0
2014-10-30	ARKQ	ETF	19.54	19.54	19.54	19.54	2600.0
2014-10-30	ARKW	ETF	19.77	19.81	19.58	19.81	5300.0
2014-10-30	ASEA	ETF	16.7	16.8	16.65	16.65	5400.0
2014-10-30	ASHR	ETF	25.97	26.1	25.95	26.09	135200.0
2014-10-30	ASHS	ETF	34.28	34.3	34.05	34.26	8000.0
2014-10-30	ATMP	ETF	31.48	31.64	31.22	31.33	16600.0
2014-10-30	AVIV	ETF	29.74	30.1	29.62	30.1	201622.0
2014-10-30	AWAY	ETF	34.02	34.35	33.56	34.055	950237.0
2014-10-30	BAB	ETF	29.91	29.98	29.82	29.8799	145927.0
2014-10-30	BAL	ETF	43.67	44.13	43.06	43.06	7884.0
2014-10-30	BALT	ETF	3.91	3.95	3.775	3.85	670350.0
2014-10-30	BAR	ETF	2.959	2.962	2.931	2.935	35210.0
2014-10-30	BBH	ETF	113.16	115.98	113.16	115.85	72100.0
2014-10-30	BCM	ETF	37.02	37.02	36.1	36.1	743.0
2014-10-30	BFOR	ETF	7.6825	7.75	7.6575	7.7225	49200.0
2014-10-30	BIB	ETF	58.25	60.875	57.8	60.685	586058.0
2014-10-30	BICK	ETF	25.1179	25.15	24.82	25.15	1075.0
2014-10-30	BIL	ETF	91.48	91.5	91.48	91.48	284950.0
2014-10-30	BIS	ETF	422.0	422.0	398.808	400.4	13619.5
2014-10-30	BIV	ETF	85.12	85.18	84.94	85.11	378900.0
2014-10-30	BIZD	ETF	19.19	19.24	19.14	19.2	8200.0

> showing 50 of 1,134 rows — these rows as CSV

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