PREVIEW / etf_daily / 2017-11-22

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-22.parquet
  size:    58 KB
  rows:    1,506

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-11-22	SPY	ETF	260.0	260.15	259.57	259.76	45033400.0
2017-11-22	QQQ	ETF	155.63	155.84	155.341	155.69	17299040.0
2017-11-22	IWM	ETF	151.28	151.77	150.86	150.89	14136600.0
2017-11-22	DIA	ETF	236.06	236.06	234.95	235.17	2860800.0
2017-11-22	GLD	ETF	122.26	122.95	122.17	122.63	5211800.0
2017-11-22	TLT	ETF	126.62	127.2	126.51	127.15	4140700.0
2017-11-22	AADR	ETF	57.35	57.5	57.17	57.34	20400.0
2017-11-22	AAXJ	ETF	78.31	78.44	78.11	78.36	1317300.0
2017-11-22	ACSI	ETF	29.9526	30.0	29.9526	30.0	1428.0
2017-11-22	ACTX	ETF	67.2606	84.9608	64.9006	79.6507	2575.0
2017-11-22	ACWF	ETF	30.705	30.705	30.445	30.4897	1430.0
2017-11-22	ACWI	ETF	71.15	71.24	71.01	71.15	1325800.0
2017-11-22	ACWV	ETF	83.47	83.5	83.23	83.43	86300.0
2017-11-22	ACWX	ETF	49.91	49.94	49.71	49.87	635122.0
2017-11-22	ADRE	ETF	43.61	43.94	43.61	43.85	4855.0
2017-11-22	AFK	ETF	24.42	24.5	24.21	24.32	22808.0
2017-11-22	AFTY	ETF	19.58	19.6	19.5	19.56	11000.0
2017-11-22	AGG	ETF	109.4	109.56	109.38	109.55	6104100.0
2017-11-22	AGGY	ETF	50.65	50.75	50.64	50.74	78800.0
2017-11-22	AGNG	ETF	19.666	19.666	19.61	19.61	2000.0
2017-11-22	AGQ	ETF	34.73	34.96	34.69	34.89	57500.0
2017-11-22	AGZ	ETF	113.4	113.57	113.4	113.57	12437.0
2017-11-22	AGZD	ETF	24.08	24.08	24.08	24.08	1200.0
2017-11-22	AIA	ETF	68.4	68.5	68.13	68.3	320129.0
2017-11-22	AIEQ	ETF	25.15	25.2	25.02	25.04	78100.0
2017-11-22	AIRR	ETF	26.51	26.527	26.28	26.3	38000.0
2017-11-22	AIVI	ETF	43.12	43.12	42.91	43.02	9600.0
2017-11-22	ALTY	ETF	15.45	15.49	15.45	15.482	2100.0
2017-11-22	AMJ	ETF	26.34	26.47	26.18	26.39	3783672.0
2017-11-22	AMLP	ETF	50.75	51.15	50.55	50.95	3075780.0
2017-11-22	AMZA	ETF	79.1	79.8	78.77	79.6	101030.0
2017-11-22	ANGL	ETF	30.02	30.11	30.0	30.1	2063600.0
2017-11-22	AOA	ETF	54.86	54.95	54.79	54.81	67300.0
2017-11-22	AOK	ETF	34.76	34.82	34.7405	34.82	186764.0
2017-11-22	AOM	ETF	38.42	38.44	38.36	38.44	137597.0
2017-11-22	AOR	ETF	45.62	45.66	45.56	45.66	226094.0
2017-11-22	ARGT	ETF	32.09	32.38	32.09	32.37	22800.0
2017-11-22	ARKG	ETF	25.14	25.49	25.07	25.44	74200.0
2017-11-22	ARKK	ETF	36.57	36.78	36.44	36.76	277400.0
2017-11-22	ARKQ	ETF	34.6	34.61	34.311	34.38	35900.0
2017-11-22	ARKW	ETF	45.44	45.44	45.1	45.36	139400.0
2017-11-22	ASEA	ETF	16.49	16.49	16.41	16.42	2000.0
2017-11-22	ASET	ETF	28.34	28.4	28.34	28.4	2472.0
2017-11-22	ASHR	ETF	32.42	32.45	32.38	32.42	887700.0
2017-11-22	ASHS	ETF	35.68	35.68	35.39	35.45	4700.0
2017-11-22	ASHX	ETF	23.91	23.91	23.91	23.91	264.0
2017-11-22	ATMP	ETF	19.8	19.92	19.74	19.89	247500.0
2017-11-22	BAB	ETF	30.65	30.67	30.5232	30.67	131867.0
2017-11-22	BAL	ETF	47.0	47.3	46.9004	46.9004	1529.0
2017-11-22	BAR	ETF	12.916	12.935	12.916	12.935	6380.0

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

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