PREVIEW / etf_daily / 2014-10-28

all etf daily files

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

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-28	SPY	ETF	196.82	198.42	196.73	198.41	106736000.0
2014-10-28	QQQ	ETF	99.1	100.2	99.08	100.18	34495077.0
2014-10-28	IWM	ETF	111.51	114.21	111.3	114.17	84912900.0
2014-10-28	DIA	ETF	168.48	169.69	168.14	169.66	5438900.0
2014-10-28	GLD	ETF	118.48	118.48	118.01	118.1	3260100.0
2014-10-28	TLT	ETF	119.48	119.65	119.08	119.19	5141300.0
2014-10-28	AADR	ETF	37.18	37.18	37.18	37.18	200.0
2014-10-28	AAXJ	ETF	61.82	62.18	61.49	62.11	359400.0
2014-10-28	ACWI	ETF	58.33	58.66	58.23	58.65	951400.0
2014-10-28	ACWV	ETF	67.89	68.25	67.89	68.25	71300.0
2014-10-28	ACWX	ETF	44.4399	44.659	44.37	44.63	398070.0
2014-10-28	ADRE	ETF	38.13	38.8845	38.13	38.865	9840.0
2014-10-28	AFK	ETF	29.43	29.66	29.3303	29.56	45017.0
2014-10-28	AGG	ETF	110.21	110.25	110.1	110.14	1128600.0
2014-10-28	AGQ	ETF	47.34	47.46	46.55	46.65	106100.0
2014-10-28	AGZ	ETF	113.22	113.34	112.93	113.3	7619.0
2014-10-28	AGZD	ETF	24.735	24.78	24.735	24.775	6600.0
2014-10-28	AIA	ETF	46.98	47.3095	46.96	47.25	7429.0
2014-10-28	AIQ	ETF	23.25	25.1399	23.25	25.08	29178.0
2014-10-28	AIRR	ETF	18.21	18.92	18.21	18.87	50000.0
2014-10-28	AIVI	ETF	45.37	45.69	45.36	45.63	25300.0
2014-10-28	ALTL	ETF	35.419	35.419	35.419	35.419	142.0
2014-10-28	AMJ	ETF	50.97	51.3	50.59	51.13	1242574.0
2014-10-28	AMLP	ETF	93.8	94.05	93.25	93.75	686420.0
2014-10-28	AMZA	ETF	244.0	244.61	242.8	243.8	710.0
2014-10-28	ANGL	ETF	27.87	27.87	27.53	27.53	500.0
2014-10-28	AOA	ETF	45.4	45.79	45.4	45.77	32200.0
2014-10-28	AOK	ETF	32.45	32.58	32.45	32.56	53217.0
2014-10-28	AOM	ETF	34.89	35.04	34.86	35.04	62253.0
2014-10-28	AOR	ETF	39.49	39.69	39.426	39.69	26893.0
2014-10-28	ARGT	ETF	19.95	20.13	19.91	20.11	2900.0
2014-10-28	ARKQ	ETF	19.5	19.918	19.49	19.918	20300.0
2014-10-28	ARKW	ETF	19.71	20.08	19.71	20.08	6000.0
2014-10-28	ASEA	ETF	16.47	16.56	16.47	16.56	5900.0
2014-10-28	ASHR	ETF	25.56	25.65	25.47	25.63	263700.0
2014-10-28	ASHS	ETF	33.57	33.92	33.57	33.86	111400.0
2014-10-28	ATMP	ETF	31.39	31.55	31.25	31.53	10700.0
2014-10-28	AVIV	ETF	29.55	29.89	29.37	29.89	285267.0
2014-10-28	AWAY	ETF	34.29	34.94	34.29	34.63	627275.0
2014-10-28	BAB	ETF	29.86	29.96	29.8	29.93	116039.0
2014-10-28	BAL	ETF	42.93	43.1799	42.84	43.04	11125.0
2014-10-28	BALT	ETF	3.76	4.06	3.6201	3.93	1158129.0
2014-10-28	BAR	ETF	3.141	3.1612	3.141	3.1612	10280.0
2014-10-28	BBH	ETF	114.06	114.82	113.83	114.55	124800.0
2014-10-28	BCM	ETF	36.228	36.302	36.21	36.302	1498.0
2014-10-28	BFOR	ETF	7.565	7.7175	7.565	7.7175	110000.0
2014-10-28	BIB	ETF	59.485	59.8599	58.845	59.62	725196.0
2014-10-28	BICK	ETF	24.66	24.66	24.45	24.66	500.0
2014-10-28	BIL	ETF	91.5	91.5	91.48	91.48	2536000.0
2014-10-28	BIS	ETF	410.8	414.8	406.64	408.0	12870.5

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

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