PREVIEW / etf_daily / 2016-08-10

all etf daily files

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

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-10	SPY	ETF	218.31	218.4	217.23	217.64	57941100.0
2016-08-10	QQQ	ETF	116.96	117.02	116.31	116.62	14688405.0
2016-08-10	IWM	ETF	122.38	122.6	121.15	121.49	19138100.0
2016-08-10	DIA	ETF	185.4	185.78	184.84	185.12	1618300.0
2016-08-10	GLD	ETF	129.12	129.2	128.15	128.56	6196200.0
2016-08-10	TLT	ETF	139.9	140.51	139.47	140.16	5843500.0
2016-08-10	AADR	ETF	40.56	40.86	40.39	40.39	3300.0
2016-08-10	AAXJ	ETF	59.04	59.08	58.75	58.92	508000.0
2016-08-10	ACTX	ETF	3.54	3.54	2.95	2.95	473.0
2016-08-10	ACWI	ETF	59.0	59.04	58.76	58.83	1568200.0
2016-08-10	ACWV	ETF	77.83	77.92	77.68	77.84	200400.0
2016-08-10	ACWX	ETF	41.21	41.32	41.12	41.14	310408.0
2016-08-10	ADRE	ETF	33.8	33.86	33.677	33.7377	3578.0
2016-08-10	AFK	ETF	20.99	21.45	20.7501	20.815	30435.0
2016-08-10	AFTY	ETF	13.24	13.24	13.24	13.24	200.0
2016-08-10	AGG	ETF	112.61	112.73	112.54	112.66	3185800.0
2016-08-10	AGGY	ETF	52.07	52.775	52.07	52.206	36700.0
2016-08-10	AGNG	ETF	16.8	16.8	16.766	16.766	400.0
2016-08-10	AGQ	ETF	54.68	54.86	53.75	53.95	206100.0
2016-08-10	AGZ	ETF	115.77	115.78	115.46	115.65	36807.0
2016-08-10	AGZD	ETF	23.835	23.835	23.835	23.835	600.0
2016-08-10	AIA	ETF	48.22	48.24	48.01	48.05	134862.0
2016-08-10	AIQ	ETF	6.05	6.15	6.03	6.11	10859.0
2016-08-10	AIRR	ETF	19.63	19.63	19.42	19.44	1900.0
2016-08-10	AIVI	ETF	39.07	39.17	38.92	39.03	6600.0
2016-08-10	ALTY	ETF	15.6	15.607	15.552	15.552	1500.0
2016-08-10	AMJ	ETF	32.0	32.09	31.49	31.6	879239.0
2016-08-10	AMLP	ETF	63.85	63.85	62.6	62.75	1800040.0
2016-08-10	AMZA	ETF	115.5	115.5	113.2	113.4	14400.0
2016-08-10	ANGL	ETF	28.44	28.46	28.36	28.4	81800.0
2016-08-10	AOA	ETF	47.39	47.42	47.26	47.27	14700.0
2016-08-10	AOK	ETF	33.44	33.45	33.3201	33.4	63625.0
2016-08-10	AOM	ETF	36.0	36.0599	35.925	36.01	125208.0
2016-08-10	AOR	ETF	41.11	41.11	40.9101	40.97	49916.0
2016-08-10	ARGT	ETF	23.03	23.26	22.82	23.0	20900.0
2016-08-10	ARKG	ETF	18.92	18.92	18.66	18.715	1000.0
2016-08-10	ARKK	ETF	20.944	20.955	20.93	20.931	15300.0
2016-08-10	ARKQ	ETF	21.18	21.18	21.028	21.07	4000.0
2016-08-10	ARKW	ETF	24.4	24.4	24.286	24.38	2000.0
2016-08-10	ASEA	ETF	14.34	14.34	14.14	14.23	1400.0
2016-08-10	ASHR	ETF	24.63	24.66	24.52	24.55	512200.0
2016-08-10	ASHS	ETF	34.74	34.74	34.61	34.63	3600.0
2016-08-10	ASHX	ETF	22.351	22.3599	22.351	22.3599	1500.0
2016-08-10	ATMP	ETF	22.91	22.97	22.62	22.69	33400.0
2016-08-10	BAB	ETF	31.69	31.75	31.64	31.75	124028.0
2016-08-10	BAL	ETF	47.8	47.85	47.267	47.4	103787.0
2016-08-10	BBC	ETF	20.5	20.5	20.0001	20.02	12970.0
2016-08-10	BBH	ETF	116.06	116.32	114.42	114.72	70800.0
2016-08-10	BBP	ETF	31.53	31.53	30.495	30.495	18900.0
2016-08-10	BCM	ETF	26.02	26.13	25.698	25.738	14085.0

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

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