PREVIEW / etf_daily / 2017-08-08

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-08.parquet
  size:    56 KB
  rows:    1,434

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
2017-08-08	SPY	ETF	247.51	248.91	246.83	247.26	61719400.0
2017-08-08	QQQ	ETF	144.27	145.47	143.9	144.31	30810364.0
2017-08-08	IWM	ETF	140.41	141.79	139.69	140.0	27248700.0
2017-08-08	DIA	ETF	220.8	221.68	220.44	220.69	3623900.0
2017-08-08	GLD	ETF	120.02	120.12	118.97	119.86	7227200.0
2017-08-08	TLT	ETF	124.87	124.98	124.15	124.62	6197400.0
2017-08-08	AADR	ETF	50.72	50.79	50.25	50.25	14700.0
2017-08-08	AAXJ	ETF	71.62	71.96	71.44	71.61	895400.0
2017-08-08	ACSI	ETF	29.44	29.5399	29.37	29.37	13108.0
2017-08-08	ACTX	ETF	88.5008	88.5008	76.7007	80.2407	275.0
2017-08-08	ACWF	ETF	28.13	28.29	28.06	28.06	2554.0
2017-08-08	ACWI	ETF	67.53	67.78	67.34	67.4	859400.0
2017-08-08	ACWV	ETF	80.73	80.75	80.45	80.54	115300.0
2017-08-08	ACWX	ETF	47.5	47.58	47.3544	47.4	502995.0
2017-08-08	ADRE	ETF	41.84	42.4	41.84	42.06	13086.0
2017-08-08	AFK	ETF	23.18	23.35	23.15	23.152	4951.0
2017-08-08	AFTY	ETF	16.1	16.18	16.1	16.18	1200.0
2017-08-08	AGG	ETF	109.67	109.69	109.5	109.57	2570800.0
2017-08-08	AGGY	ETF	50.67	50.73	50.619	50.65	8500.0
2017-08-08	AGNG	ETF	18.66	18.75	18.66	18.67	900.0
2017-08-08	AGQ	ETF	32.52	32.84	31.96	32.74	151800.0
2017-08-08	AGZ	ETF	113.81	113.83	113.74	113.76	27415.0
2017-08-08	AGZD	ETF	23.97	24.09	23.965	23.98	17200.0
2017-08-08	AIA	ETF	61.1	61.3401	61.01	61.07	82539.0
2017-08-08	AIQ	ETF	13.15	13.15	13.05	13.15	32110.0
2017-08-08	AIRR	ETF	23.74	24.01	23.653	23.76	20700.0
2017-08-08	AIVI	ETF	41.99	42.01	41.83	41.85	5900.0
2017-08-08	AMJ	ETF	29.05	29.14	28.42	28.56	2680643.0
2017-08-08	AMLP	ETF	57.9	58.45	56.8	56.95	3476640.0
2017-08-08	AMZA	ETF	94.6	95.0	91.5	92.1	235840.0
2017-08-08	ANGL	ETF	29.93	29.93	29.79	29.81	179900.0
2017-08-08	AOA	ETF	52.71	52.88	52.55	52.62	69700.0
2017-08-08	AOK	ETF	34.24	34.2819	34.2001	34.23	112168.0
2017-08-08	AOM	ETF	37.62	37.665	37.545	37.57	98590.0
2017-08-08	AOR	ETF	44.24	44.325	44.12	44.12	58800.0
2017-08-08	ARCM	ETF	100.0	100.0	100.0	100.0	22000.0
2017-08-08	ARGT	ETF	28.64	28.64	28.31	28.36	91100.0
2017-08-08	ARKG	ETF	23.12	23.12	22.72	22.72	11600.0
2017-08-08	ARKK	ETF	31.0	31.23	30.789	30.92	80600.0
2017-08-08	ARKQ	ETF	29.6	29.969	29.6	29.67	23300.0
2017-08-08	ARKW	ETF	38.24	38.43	38.03	38.128	72500.0
2017-08-08	ASET	ETF	27.98	27.98	27.97	27.97	1834.0
2017-08-08	ASHR	ETF	28.15	28.24	28.05	28.22	623400.0
2017-08-08	ASHS	ETF	34.15	34.37	34.15	34.3	7000.0
2017-08-08	ATMP	ETF	22.08	22.08	21.41	21.55	217200.0
2017-08-08	BAB	ETF	30.3	30.3399	30.21	30.24	101575.0
2017-08-08	BAL	ETF	46.8668	47.05	46.8668	47.05	707.0
2017-08-08	BBC	ETF	24.95	25.25	24.6636	24.76	9471.0
2017-08-08	BBH	ETF	129.92	129.94	128.37	128.57	22100.0
2017-08-08	BBP	ETF	39.7	39.7	38.952	38.99	3100.0

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

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