PREVIEW / etf_daily / 2015-03-18

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-18.parquet
  size:    48 KB
  rows:    1,170

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-03-18	SPY	ETF	207.39	211.27	206.62	210.46	228808500.0
2015-03-18	QQQ	ETF	106.58	108.41	106.03	107.92	40622188.0
2015-03-18	IWM	ETF	123.4	125.12	122.85	124.65	40292600.0
2015-03-18	DIA	ETF	177.91	181.01	176.97	180.73	11294400.0
2015-03-18	GLD	ETF	110.33	112.87	110.09	112.37	12448000.0
2015-03-18	TLT	ETF	129.91	131.53	128.61	131.49	13981900.0
2015-03-18	AAXJ	ETF	62.56	63.89	62.37	63.66	991200.0
2015-03-18	ACWI	ETF	59.7	60.93	59.6	60.74	797900.0
2015-03-18	ACWV	ETF	70.9	72.17	70.61	71.8	180900.0
2015-03-18	ACWX	ETF	44.01	45.11	43.9701	45.04	297831.0
2015-03-18	ADRE	ETF	34.55	35.37	34.5072	35.2601	9954.0
2015-03-18	AFK	ETF	24.32	24.73	24.09	24.7299	31389.0
2015-03-18	AFTY	ETF	18.86	18.97	18.68	18.92	137900.0
2015-03-18	AGG	ETF	110.79	111.39	110.58	111.37	1997800.0
2015-03-18	AGQ	ETF	36.55	39.04	36.24	39.04	420800.0
2015-03-18	AGZ	ETF	113.86	114.3	113.67	114.3	17454.0
2015-03-18	AGZD	ETF	24.525	24.565	24.425	24.465	6000.0
2015-03-18	AIA	ETF	49.13	49.77	48.86	49.72	51460.0
2015-03-18	AIQ	ETF	23.84	23.99	23.7401	23.84	9636.0
2015-03-18	AIRR	ETF	18.234	18.44	18.17	18.43	13400.0
2015-03-18	AIVI	ETF	43.43	44.54	43.39	44.42	33600.0
2015-03-18	AMJ	ETF	41.4	42.9	41.19	42.57	1257167.0
2015-03-18	AMLP	ETF	80.65	82.75	80.5	82.4	1184240.0
2015-03-18	AMZA	ETF	206.0	212.2	205.2	211.5	500.0
2015-03-18	ANGL	ETF	27.06	27.25	27.06	27.24	1800.0
2015-03-18	AOA	ETF	47.14	47.9	47.06	47.78	24400.0
2015-03-18	AOK	ETF	32.69	33.09	32.68	33.07	36652.0
2015-03-18	AOM	ETF	35.34	35.8199	35.34	35.81	78292.0
2015-03-18	AOR	ETF	40.52	41.188	40.52	41.13	42087.0
2015-03-18	ARGT	ETF	21.41	21.85	21.28	21.77	16800.0
2015-03-18	ARKG	ETF	23.375	23.5	23.3	23.5	1900.0
2015-03-18	ARKK	ETF	20.8	20.8	20.8	20.8	1400.0
2015-03-18	ARKQ	ETF	20.2	20.339	20.2	20.339	1700.0
2015-03-18	ARKW	ETF	21.66	21.74	21.66	21.74	1500.0
2015-03-18	ASEA	ETF	15.18	15.53	15.17	15.49	37900.0
2015-03-18	ASHR	ETF	39.6	39.98	39.2	39.93	1518700.0
2015-03-18	ASHS	ETF	44.51	45.06	44.5	44.89	21700.0
2015-03-18	ATMP	ETF	28.36	29.29	28.36	29.18	20200.0
2015-03-18	AVIV	ETF	35.38	36.23	34.85	36.1	470661.0
2015-03-18	AWAY	ETF	30.44	31.01	30.1	30.92	722325.0
2015-03-18	BAB	ETF	30.04	30.25	29.9794	30.19	144157.0
2015-03-18	BAL	ETF	40.69	42.47	40.58	42.26	17505.0
2015-03-18	BALT	ETF	1.31	1.32	1.21	1.27	555826.0
2015-03-18	BAR	ETF	2.452	2.5125	2.452	2.5125	5590.0
2015-03-18	BBC	ETF	34.57	34.72	33.94	34.4	55674.0
2015-03-18	BBH	ETF	134.06	135.73	132.89	134.94	215200.0
2015-03-18	BBP	ETF	32.05	32.26	31.52	32.194	20100.0
2015-03-18	BCM	ETF	29.59	30.45	29.59	30.443	324331.0
2015-03-18	BFOR	ETF	8.19	8.31	8.1625	8.2875	520400.0
2015-03-18	BIB	ETF	85.315	87.55	83.705	86.47	983894.0

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

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