PREVIEW / etf_daily / 2015-06-12

all etf daily files

  file:    by_date/etf_daily/2015/2015-06-12.parquet
  size:    47 KB
  rows:    1,175

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
2015-06-12	SPY	ETF	210.64	211.48	209.68	210.01	135382400.0
2015-06-12	QQQ	ETF	109.07	109.3	108.6	108.75	27201768.0
2015-06-12	IWM	ETF	125.92	126.15	125.43	125.93	23578600.0
2015-06-12	DIA	ETF	179.86	180.06	178.72	179.13	4566800.0
2015-06-12	GLD	ETF	113.06	113.5	112.96	113.23	2998500.0
2015-06-12	TLT	ETF	117.59	119.07	117.55	117.95	7863100.0
2015-06-12	AAXJ	ETF	64.61	64.79	64.47	64.66	2041300.0
2015-06-12	ACTX	ETF	2.95	2.95	2.891	2.95	562.0
2015-06-12	ACWI	ETF	61.3	61.45	61.12	61.31	797300.0
2015-06-12	ACWV	ETF	71.02	71.22	70.95	71.09	81600.0
2015-06-12	ACWX	ETF	45.8	45.99	45.6699	45.85	4391526.0
2015-06-12	ADRE	ETF	35.69	35.71	35.66	35.67	5555.0
2015-06-12	AFK	ETF	24.85	25.0972	24.8	24.93	5902.0
2015-06-12	AFTY	ETF	23.71	23.75	23.64	23.69	363900.0
2015-06-12	AGG	ETF	108.68	108.9	108.52	108.58	1365900.0
2015-06-12	AGQ	ETF	37.44	37.98	37.36	37.76	171400.0
2015-06-12	AGZ	ETF	112.86	113.0299	112.684	112.82	32219.0
2015-06-12	AGZD	ETF	24.46	24.46	24.345	24.37	5800.0
2015-06-12	AIA	ETF	51.64	51.7	51.59	51.65	9420.0
2015-06-12	AIQ	ETF	18.4	18.88	18.4	18.55	14380.0
2015-06-12	AIRR	ETF	18.6	18.73	18.6	18.68	74900.0
2015-06-12	AIVI	ETF	44.71	44.97	44.62	44.8	17100.0
2015-06-12	ALTL	ETF	36.75	36.76	36.75	36.752	4791.0
2015-06-12	AMJ	ETF	41.51	41.6699	41.34	41.6699	1004190.0
2015-06-12	AMLP	ETF	80.5	80.75	80.2	80.55	725220.0
2015-06-12	AMZA	ETF	205.4	205.4	203.0	205.3	900.0
2015-06-12	ANGL	ETF	27.33	27.66	27.31	27.34	18400.0
2015-06-12	AOA	ETF	48.19	48.19	47.94	48.04	33200.0
2015-06-12	AOK	ETF	32.54	32.7122	32.53	32.53	14323.0
2015-06-12	AOM	ETF	35.42	35.515	35.4	35.42	65392.0
2015-06-12	AOR	ETF	41.05	41.05	40.88	40.9599	36856.0
2015-06-12	ARGT	ETF	21.25	21.33	21.23	21.27	3000.0
2015-06-12	ARKG	ETF	23.69	23.69	23.34	23.34	1000.0
2015-06-12	ARKK	ETF	21.7	21.7	21.65	21.65	500.0
2015-06-12	ARKQ	ETF	20.12	20.12	20.082	20.092	900.0
2015-06-12	ARKW	ETF	23.43	23.43	23.381	23.381	500.0
2015-06-12	ASEA	ETF	15.18	15.18	15.11	15.17	4400.0
2015-06-12	ASHR	ETF	54.9	55.19	54.85	55.17	1317000.0
2015-06-12	ASHS	ETF	75.75	76.61	75.75	76.39	159800.0
2015-06-12	ATMP	ETF	27.93	28.18	27.93	28.17	57600.0
2015-06-12	AWAY	ETF	30.71	30.94	30.51	30.68	514298.0
2015-06-12	BAB	ETF	28.79	29.03	28.7801	28.85	111524.0
2015-06-12	BAL	ETF	43.47	43.665	43.3783	43.39	2834.0
2015-06-12	BALT	ETF	1.5	1.55	1.49	1.54	238333.0
2015-06-12	BAR	ETF	2.574	2.5958	2.5665	2.5958	21230.0
2015-06-12	BBC	ETF	36.37	36.37	35.59	35.72	8527.0
2015-06-12	BBH	ETF	134.56	134.92	132.86	133.53	153300.0
2015-06-12	BBP	ETF	34.25	34.25	33.7	33.84	5700.0
2015-06-12	BCHP	ETF	20.289	20.289	20.236	20.236	627.0
2015-06-12	BCM	ETF	31.459	31.46	31.2984	31.2984	24870.0

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

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