PREVIEW / etf_daily / 2017-10-25

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-25.parquet
  size:    58 KB
  rows:    1,485

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-10-25	SPY	ETF	256.18	256.31	254.0	255.29	103715300.0
2017-10-25	QQQ	ETF	147.7	148.18	146.33	147.43	36179124.0
2017-10-25	IWM	ETF	148.94	149.0	147.22	148.45	27235300.0
2017-10-25	DIA	ETF	234.45	234.45	232.35	233.16	3813300.0
2017-10-25	GLD	ETF	121.31	121.59	120.84	121.35	4282400.0
2017-10-25	TLT	ETF	122.53	122.98	122.42	122.84	9961400.0
2017-10-25	AADR	ETF	58.62	58.72	57.31	57.8	31600.0
2017-10-25	AAXJ	ETF	74.74	74.81	73.83	74.24	2812900.0
2017-10-25	ACSI	ETF	29.44	29.44	29.28	29.44	3283.0
2017-10-25	ACTX	ETF	48.9704	50.7405	44.2504	48.3804	920.0
2017-10-25	ACWF	ETF	29.739	29.739	29.68	29.69	2031.0
2017-10-25	ACWI	ETF	70.04	70.07	69.43	69.77	920000.0
2017-10-25	ACWV	ETF	82.48	82.48	82.0	82.27	233300.0
2017-10-25	ACWX	ETF	49.14	49.15	48.69	48.9	1026489.0
2017-10-25	ADRE	ETF	42.85	42.9999	42.231	42.4935	6447.0
2017-10-25	AFK	ETF	23.81	23.81	23.4	23.4	6310.0
2017-10-25	AFTY	ETF	17.54	17.565	17.51	17.565	4800.0
2017-10-25	AGG	ETF	108.96	109.13	108.95	109.12	2945400.0
2017-10-25	AGGY	ETF	50.37	50.47	50.37	50.47	16300.0
2017-10-25	AGNG	ETF	19.58	19.58	19.339	19.385	7700.0
2017-10-25	AGQ	ETF	34.31	34.41	33.92	34.21	61100.0
2017-10-25	AGZ	ETF	113.14	113.31	113.14	113.23	12107.0
2017-10-25	AGZD	ETF	24.145	24.145	24.02	24.075	14400.0
2017-10-25	AIA	ETF	63.75	63.75	63.17	63.43	23285.0
2017-10-25	AIEQ	ETF	25.2	25.24	24.7	24.91	440000.0
2017-10-25	AIRR	ETF	26.2	26.28	26.03	26.24	477500.0
2017-10-25	AIVI	ETF	42.71	42.71	42.48	42.62	8400.0
2017-10-25	ALTY	ETF	15.54	15.63	15.392	15.436	5500.0
2017-10-25	AMJ	ETF	26.69	26.76	25.89	26.07	4853423.0
2017-10-25	AMLP	ETF	52.65	52.95	51.2	51.6	3505020.0
2017-10-25	AMZA	ETF	82.5	82.6	78.7	79.9	362110.0
2017-10-25	ANGL	ETF	30.34	30.36	30.2	30.27	361100.0
2017-10-25	AOA	ETF	54.1	54.13	53.76	53.95	49700.0
2017-10-25	AOK	ETF	34.54	34.56	34.42	34.52	89080.0
2017-10-25	AOM	ETF	38.05	38.07	37.9	37.96	79700.0
2017-10-25	AOR	ETF	45.11	45.11	44.84	44.98	61483.0
2017-10-25	ARGT	ETF	32.16	32.31	31.53	31.79	90500.0
2017-10-25	ARKG	ETF	25.69	25.77	25.24	25.335	52100.0
2017-10-25	ARKK	ETF	34.37	34.381	33.57	33.73	157200.0
2017-10-25	ARKQ	ETF	32.86	32.86	32.19	32.42	27200.0
2017-10-25	ARKW	ETF	41.5	41.569	40.801	41.0	73100.0
2017-10-25	ASEA	ETF	15.65	15.65	15.65	15.65	300.0
2017-10-25	ASET	ETF	27.98	27.999	27.949	27.949	1181.0
2017-10-25	ASHR	ETF	30.35	30.4	30.23	30.29	969400.0
2017-10-25	ASHS	ETF	36.52	36.52	36.35	36.35	8400.0
2017-10-25	ASHX	ETF	22.52	22.52	22.4177	22.5	947.0
2017-10-25	ATMP	ETF	20.4	20.4	19.65	19.73	43700.0
2017-10-25	BAB	ETF	30.23	30.2576	30.13	30.17	252616.0
2017-10-25	BAL	ETF	46.11	46.22	46.02	46.03	10339.0
2017-10-25	BAR	ETF	12.749	12.75	12.749	12.75	10000.0

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

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