PREVIEW / etf_daily / 2017-07-17

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-17.parquet
  size:    56 KB
  rows:    1,438

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-07-17	SPY	ETF	245.47	245.91	245.33	245.53	33531900.0
2017-07-17	QQQ	ETF	142.25	142.69	141.92	142.19	25343155.0
2017-07-17	IWM	ETF	141.6	142.46	141.26	142.06	15374600.0
2017-07-17	DIA	ETF	216.32	216.49	216.04	216.22	2291000.0
2017-07-17	GLD	ETF	117.42	117.53	117.23	117.29	5170800.0
2017-07-17	TLT	ETF	123.33	123.99	123.27	123.67	4737300.0
2017-07-17	AADR	ETF	48.79	49.14	48.78	48.92	13500.0
2017-07-17	AAXJ	ETF	69.99	69.99	69.73	69.85	1305500.0
2017-07-17	ACSI	ETF	28.83	28.87	28.83	28.83	16275.0
2017-07-17	ACTX	ETF	77.2907	82.6007	74.3407	82.6007	317.0
2017-07-17	ACWF	ETF	27.9	27.995	27.9	27.91	3619.0
2017-07-17	ACWI	ETF	66.74	66.76	66.61	66.64	1197800.0
2017-07-17	ACWV	ETF	79.5	79.5	79.32	79.42	68700.0
2017-07-17	ACWX	ETF	46.65	46.68	46.56	46.61	145835.0
2017-07-17	ADRE	ETF	40.44	40.44	40.1508	40.1822	6770.0
2017-07-17	AFK	ETF	22.7	22.75	22.5661	22.63	9402.0
2017-07-17	AFTY	ETF	15.98	16.004	15.98	15.987	2400.0
2017-07-17	AGG	ETF	109.4	109.48	109.32	109.42	4078500.0
2017-07-17	AGGY	ETF	50.51	50.63	50.51	50.62	8100.0
2017-07-17	AGNG	ETF	19.06	19.089	19.05	19.08	2000.0
2017-07-17	AGQ	ETF	31.8	31.94	31.61	31.66	152000.0
2017-07-17	AGZ	ETF	113.58	113.74	113.55	113.67	50563.0
2017-07-17	AGZD	ETF	24.075	24.075	24.01	24.03	14200.0
2017-07-17	AIA	ETF	59.31	59.31	59.0905	59.22	38172.0
2017-07-17	AIQ	ETF	13.2	13.3	13.2	13.25	187707.0
2017-07-17	AIRR	ETF	23.84	24.083	23.831	24.03	115900.0
2017-07-17	AIVI	ETF	41.53	41.63	41.5	41.58	9700.0
2017-07-17	ALTY	ETF	15.648	15.65	15.635	15.635	7200.0
2017-07-17	AMJ	ETF	30.19	30.37	30.18	30.22	1130837.0
2017-07-17	AMLP	ETF	60.3	60.6	60.25	60.35	1176780.0
2017-07-17	AMZA	ETF	97.5	98.0	97.4	97.6	81910.0
2017-07-17	ANGL	ETF	29.65	29.67	29.58	29.67	916700.0
2017-07-17	AOA	ETF	52.13	52.17	52.03	52.03	21400.0
2017-07-17	AOK	ETF	34.05	34.11	33.99	34.05	44969.0
2017-07-17	AOM	ETF	37.3	37.3299	37.2201	37.31	63681.0
2017-07-17	AOR	ETF	43.83	43.85	43.77	43.83	53907.0
2017-07-17	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-17	ARGT	ETF	30.0	30.2	29.84	29.92	57700.0
2017-07-17	ARKG	ETF	22.37	22.56	22.306	22.306	10200.0
2017-07-17	ARKK	ETF	29.38	29.38	29.023	29.11	44700.0
2017-07-17	ARKQ	ETF	29.31	29.31	28.97	29.04	22200.0
2017-07-17	ARKW	ETF	36.34	36.47	36.18	36.24	34800.0
2017-07-17	ASEA	ETF	15.33	15.33	15.29	15.29	4500.0
2017-07-17	ASET	ETF	27.4999	27.4999	27.465	27.465	991.0
2017-07-17	ASHR	ETF	27.49	27.54	27.35	27.35	980400.0
2017-07-17	ASHS	ETF	31.96	31.96	31.63	31.72	29700.0
2017-07-17	ATMP	ETF	22.72	22.9	22.68	22.71	66900.0
2017-07-17	BAB	ETF	29.94	29.97	29.9	29.96	66030.0
2017-07-17	BAL	ETF	43.99	44.85	43.99	44.66	6629.0
2017-07-17	BBC	ETF	24.93	25.5999	24.88	24.88	15352.0

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

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