PREVIEW / etf_daily / 2016-08-12

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-12.parquet
  size:    51 KB
  rows:    1,287

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
2016-08-12	SPY	ETF	218.29	218.71	217.99	218.46	61313500.0
2016-08-12	QQQ	ETF	116.91	117.21	116.79	117.2	19379036.0
2016-08-12	IWM	ETF	121.83	122.46	121.63	122.19	12251200.0
2016-08-12	DIA	ETF	186.14	186.25	185.52	185.9	2514300.0
2016-08-12	GLD	ETF	127.67	129.26	127.2	127.4	15395800.0
2016-08-12	TLT	ETF	140.41	140.86	139.87	140.08	7989600.0
2016-08-12	AADR	ETF	40.88	40.88	40.88	40.88	100.0
2016-08-12	AAXJ	ETF	59.33	59.46	59.22	59.43	1214100.0
2016-08-12	ACTX	ETF	2.95	3.54	2.891	3.54	1055.0
2016-08-12	ACWF	ETF	24.024	24.024	24.024	24.024	150.0
2016-08-12	ACWI	ETF	59.14	59.24	59.0	59.12	868200.0
2016-08-12	ACWV	ETF	78.07	78.24	77.95	78.05	128200.0
2016-08-12	ACWX	ETF	41.47	41.53	41.31	41.37	235898.0
2016-08-12	ADRE	ETF	34.19	34.53	34.19	34.53	5683.0
2016-08-12	AFK	ETF	21.27	21.3646	20.9301	20.97	36350.0
2016-08-12	AFTY	ETF	13.54	13.56	13.49	13.5	6400.0
2016-08-12	AGG	ETF	112.72	112.83	112.63	112.63	1889600.0
2016-08-12	AGGY	ETF	52.24	52.37	52.205	52.22	26700.0
2016-08-12	AGNG	ETF	16.85	16.85	16.85	16.85	200.0
2016-08-12	AGQ	ETF	53.79	54.01	51.22	51.5	305300.0
2016-08-12	AGZ	ETF	115.97	115.97	115.542	115.72	14232.0
2016-08-12	AGZD	ETF	23.925	23.925	23.865	23.865	1200.0
2016-08-12	AIA	ETF	48.34	48.4	48.03	48.1	708713.0
2016-08-12	AIQ	ETF	6.15	6.17	6.11	6.15	13512.0
2016-08-12	AIRR	ETF	19.49	19.52	19.345	19.433	2400.0
2016-08-12	AIVI	ETF	39.4	39.4	39.12	39.22	26800.0
2016-08-12	ALTY	ETF	15.696	15.7	15.667	15.667	1600.0
2016-08-12	AMJ	ETF	31.97	32.34	31.7175	32.05	1144693.0
2016-08-12	AMLP	ETF	63.55	63.8	63.3	63.45	2194480.0
2016-08-12	AMZA	ETF	115.6	115.99	114.5	115.0	8760.0
2016-08-12	ANGL	ETF	28.53	28.53	28.45	28.5	165300.0
2016-08-12	AOA	ETF	47.56	47.58	47.32	47.53	28600.0
2016-08-12	AOK	ETF	33.51	33.51	33.35	33.42	68755.0
2016-08-12	AOM	ETF	36.1	36.1281	35.9	36.05	49196.0
2016-08-12	AOR	ETF	41.09	41.1599	41.0	41.05	241661.0
2016-08-12	ARGT	ETF	23.39	23.39	23.1	23.11	9600.0
2016-08-12	ARKG	ETF	18.912	19.07	18.912	19.03	2400.0
2016-08-12	ARKK	ETF	21.181	21.181	21.18	21.18	400.0
2016-08-12	ARKQ	ETF	21.46	21.46	21.37	21.37	600.0
2016-08-12	ARKW	ETF	24.68	24.783	24.68	24.783	300.0
2016-08-12	ASEA	ETF	14.2	14.2	14.2	14.2	1000.0
2016-08-12	ASET	ETF	27.3	27.3	27.3	27.3	100.0
2016-08-12	ASHR	ETF	25.02	25.09	24.97	25.03	1068200.0
2016-08-12	ASHS	ETF	34.62	34.7	34.58	34.67	5000.0
2016-08-12	ATMP	ETF	22.83	23.34	22.83	23.11	32400.0
2016-08-12	BAB	ETF	31.69	31.82	31.69	31.76	682875.0
2016-08-12	BAL	ETF	48.0	48.31	46.64	47.07	26562.0
2016-08-12	BBC	ETF	20.43	20.6694	20.32	20.6694	3855.0
2016-08-12	BBH	ETF	115.72	115.87	114.89	115.79	27300.0
2016-08-12	BBP	ETF	30.66	30.885	30.581	30.86	9600.0

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

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